Strange Error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jeff

    #1

    Strange Error


    Okay, I'm still new to vb.net 2005 - throught this was a hardware problem,
    but now I don't know.
    (I'm having some problem with my newgroup provider, so hopefully this will
    go through)

    This problem just started about a week ago, before all was fine. I'm using
    the code below to access a mysql database. On the line indicated when the
    connection is opened, the application has been sporatically drawing an
    error. It doesn't occur very often - so I don't understand what's going on.
    The app reports

    "Attempted to read or write protected memory. This is often an indication
    that other memory is corrupt."

    Okay - so perhaps a bad stick of memory - so I pulled one of the two sticks
    temporarily and the problem seemed to go away. Nothing for about a week.
    ....but now I got the same error. I get similar errors in the event log of
    the server (W2K3 IIS6).

    I can't see how this has anything to do with my code since the problem is
    only periodic. I don't know if it is due to the underlying visual studio,
    but if I understand correctly, w3wp.exe refers to IIS. there is nothing in
    any error messages referring to mysql, so I can't see that the database is
    the problem.

    Can anyone tell me what might be going on?

    Jeff


    Try
    Dim MyCommand As New OdbcCommand(sb. ToString, MyConn)
    MyCommand.Comma ndType = CommandType.Tex t
    MyConn.Open() ' drawing the
    bad memory error here also.
    Dim dr As OdbcDataReader =
    MyCommand.Execu teReader(Comman dBehavior.Singl eRow)
    Using (dr)


    Event Type: Error
    Event Source: COM+
    Event Category: Unknown
    Event ID: 4786
    Date: 5/25/2007
    Time: 8:45:16 PM
    User: N/A
    Description:
    The system has called a custom component and that component has failed and
    generated an exception. This indicates a problem with the custom component.
    Notify the developer of this component that a failure has occurred and
    provide them with the information below.
    Component Prog ID: 0[ODBC][Env e6f14e8]
    Method Name: IDispenserDrive r::DestroyResou rce
    Process Name: w3wp.exe
    Exception: C0000005
    Address: 0x7C82F583
    Call Stack:
    ntdll!RtlGetLas tWin32Error + 0xc0
    ntdll!RtlAlloca teHeap + 0x58d
    myodbc3!LoadByO rdinal + 0x560
    myodbc3!SQLTran sact + 0x9018


    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.

    Event Type: Error
    Event Source: Application Error
    Event Category: (100)
    Event ID: 1000
    Date: 5/25/2007
    Time: 8:45:16 PM
    User: N/A
    Description:
    Faulting application w3wp.exe, version 6.0.3790.1830, faulting module
    ntdll.dll, version 5.2.3790.1830, fault address 0x0002f583.


    --
    Posted via a free Usenet account from http://www.teranews.com

  • Stephany Young

    #2
    Re: Strange Error

    Firstly, a word of advice.

    You are using Microsoft Windows Mail as your news reader so I recommend that
    you connect directly to msnews.mocrosof t.com to access this and other MS
    provided newsgroups. If you do then you won't have to worry about 'some
    problem with your newgroup provider'.

    Now to the issue at hand.

    The message, "Attempted to read or write protected memory. This is often an
    indication
    that other memory is corrupt.", is a message associated with an
    AccessViolation Exception which is defined as follows:

    An access violation occurs in unmanaged or unsafe code
    when the code attempts to read or write to memory that
    has not been allocated, or to which it does not have
    access. This usually occurs because a pointer has a bad
    value. Not all reads or writes through bad pointers lead
    to access violations, so an access violation usually
    indicates that several reads or writes have occurred
    through bad pointers, and that memory might be corrupted.
    Thus, access violations almost always indicate serious
    programming errors. In the .NET Framework version 2.0, an
    AccessViolation Exception clearly identifies these serious
    errors.

    In programs consisting entirely of verifiable managed code,
    all references are either valid or null, and access
    violations are impossible. An AccessViolation Exception
    occurs only when verifiable managed code interacts with
    unmanaged code or with unsafe managed code.

    I don't know where you got the impression that the memory chips might be at
    fault but that is well wide of the mark. If your memory chips started
    playing up then I suspect that you would probably not even be able to boot
    the computer in question.

    While the database it self might not be the problem, the ODBC driver you are
    using certainly is and it certainly will contain some unmanaged code. This
    is clearly indicated in the extract from the event log, so that is where you
    need to start.

    We can't really be of anymore help at this stage because we have no idea
    what ODBC driver you are using.


    "Jeff" <none@nothingX. comwrote in message
    news:46578ca3$0 $16396$88260bb3 @free.teranews. com...
    >
    Okay, I'm still new to vb.net 2005 - throught this was a hardware problem,
    but now I don't know.
    (I'm having some problem with my newgroup provider, so hopefully this will
    go through)
    >
    This problem just started about a week ago, before all was fine. I'm using
    the code below to access a mysql database. On the line indicated when the
    connection is opened, the application has been sporatically drawing an
    error. It doesn't occur very often - so I don't understand what's going
    on. The app reports
    >
    "Attempted to read or write protected memory. This is often an indication
    that other memory is corrupt."
    >
    Okay - so perhaps a bad stick of memory - so I pulled one of the two
    sticks temporarily and the problem seemed to go away. Nothing for about a
    week. ...but now I got the same error. I get similar errors in the event
    log of the server (W2K3 IIS6).
    >
    I can't see how this has anything to do with my code since the problem is
    only periodic. I don't know if it is due to the underlying visual studio,
    but if I understand correctly, w3wp.exe refers to IIS. there is nothing in
    any error messages referring to mysql, so I can't see that the database is
    the problem.
    >
    Can anyone tell me what might be going on?
    >
    Jeff
    >
    >
    Try
    Dim MyCommand As New OdbcCommand(sb. ToString, MyConn)
    MyCommand.Comma ndType = CommandType.Tex t
    MyConn.Open() ' drawing the
    bad memory error here also.
    Dim dr As OdbcDataReader =
    MyCommand.Execu teReader(Comman dBehavior.Singl eRow)
    Using (dr)
    >
    >
    Event Type: Error
    Event Source: COM+
    Event Category: Unknown
    Event ID: 4786
    Date: 5/25/2007
    Time: 8:45:16 PM
    User: N/A
    Description:
    The system has called a custom component and that component has failed and
    generated an exception. This indicates a problem with the custom
    component. Notify the developer of this component that a failure has
    occurred and provide them with the information below.
    Component Prog ID: 0[ODBC][Env e6f14e8]
    Method Name: IDispenserDrive r::DestroyResou rce
    Process Name: w3wp.exe
    Exception: C0000005
    Address: 0x7C82F583
    Call Stack:
    ntdll!RtlGetLas tWin32Error + 0xc0
    ntdll!RtlAlloca teHeap + 0x58d
    myodbc3!LoadByO rdinal + 0x560
    myodbc3!SQLTran sact + 0x9018
    >
    >
    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.
    >
    Event Type: Error
    Event Source: Application Error
    Event Category: (100)
    Event ID: 1000
    Date: 5/25/2007
    Time: 8:45:16 PM
    User: N/A
    Description:
    Faulting application w3wp.exe, version 6.0.3790.1830, faulting module
    ntdll.dll, version 5.2.3790.1830, fault address 0x0002f583.
    >
    >
    --
    Posted via a free Usenet account from http://www.teranews.com
    >

    Comment

    • Jeff

      #3
      Re: Strange Error


      "Stephany Young" <noone@localhos twrote in message
      news:ueE9jN0nHH A.3548@TK2MSFTN GP06.phx.gbl...
      >
      I recommend that you connect directly to msnews.mocrosof t.com to access
      this and other MS provided newsgroups.
      Done. Thanks
      In programs consisting entirely of verifiable managed code,
      all references are either valid or null, and access
      violations are impossible.
      While the database it self might not be the problem, the ODBC driver you
      are using certainly is and it certainly will contain some unmanaged code.
      This is clearly indicated in the extract from the event log, so that is
      where you need to start.
      >
      We can't really be of anymore help at this stage because we have no idea
      what ODBC driver you are using.
      I believe that I have MySql 3.51.12 ODBC driver. I just checked their site
      and see that they have a 3.51.15 driver out and perhaps changing might help?

      I get the general idea of your helpful comments, but I'm a bit new and some
      of the specifics/implications are a bit over my head.

      Are you suggesting that the entire driver is written incorrectly, there
      might be a bug in the particular version I have, or it is hard to tell?

      Jeff

      Comment

      • Stephany Young

        #4
        Re: Strange Error

        It's not a matter of believing if you have such annd such a driver. You
        should know for absolute sure what it is. If you don't know then check!

        I was suggesting nothing about their driver because I don't know anything
        about it. All I was pointing out was what was recorded in the event log.



        "Jeff" <none@nothingX. comwrote in message
        news:uoGZCh0nHH A.4196@TK2MSFTN GP06.phx.gbl...
        >
        "Stephany Young" <noone@localhos twrote in message
        news:ueE9jN0nHH A.3548@TK2MSFTN GP06.phx.gbl...
        >>
        > I recommend that you connect directly to msnews.mocrosof t.com to access
        >this and other MS provided newsgroups.
        >
        Done. Thanks
        >
        > In programs consisting entirely of verifiable managed code,
        > all references are either valid or null, and access
        > violations are impossible.
        >
        >While the database it self might not be the problem, the ODBC driver you
        >are using certainly is and it certainly will contain some unmanaged code.
        >This is clearly indicated in the extract from the event log, so that is
        >where you need to start.
        >>
        >We can't really be of anymore help at this stage because we have no idea
        >what ODBC driver you are using.
        >
        I believe that I have MySql 3.51.12 ODBC driver. I just checked their
        site and see that they have a 3.51.15 driver out and perhaps changing
        might help?
        >
        I get the general idea of your helpful comments, but I'm a bit new and
        some of the specifics/implications are a bit over my head.
        >
        Are you suggesting that the entire driver is written incorrectly, there
        might be a bug in the particular version I have, or it is hard to tell?
        >
        Jeff
        >

        Comment

        • Jeff

          #5
          Re: Strange Error


          "Stephany Young" <noone@localhos twrote in message
          news:uLHzkW1nHH A.4212@TK2MSFTN GP04.phx.gbl...
          It's not a matter of believing if you have such annd such a driver. You
          should know for absolute sure what it is. If you don't know then check!
          >
          I was suggesting nothing about their driver because I don't know anything
          about it. All I was pointing out was what was recorded in the event log.

          Okay then, it is most definitely mysql 3.15.12 dated 10/15/2005

          I must admit that I don't do this full time and I'm largely self-taught. If
          someone gets me started and I can figure out what to read I can usually go
          from there. But when I see an error message that says something about memory
          possibly being corrupt, I assume that this means a hardware problem. There
          are memory testing programs available, but I haven't yet used the one that I
          have as it would require me to take the server down for a few hours while
          the thing ran, and I have people accessing it right now.

          In reading more on the web, others are reporting some problems with that
          driver version, but I suspect that they will report problems with all
          drivers sooner or later. I'll probably update to the newest driver and see
          if that solves the problem. If you or anyone can see any way that this might
          be an issue caused by my code or by asp.net I would appreciate a hint to
          point me in the right direction.

          Jeff

          Comment

          • Jeff

            #6
            Re: Strange Error


            "Jeff" <none@nothingX. comwrote in message
            news:O9zCrc4nHH A.1476@TK2MSFTN GP03.phx.gbl...
            >
            Okay then, it is most definitely mysql 3.15.12 dated 10/15/2005
            Oops, that was supposed to be 3.51.12



            --
            Posted via a free Usenet account from http://www.teranews.com

            Comment

            Working...