#15 Error closing Connection

closed
nobody
None
5
2004-04-20
2004-02-19
mad charon
No

Hi, i'm using this driver in ASP.NET ver. 1.1,Windows 2K,
and
after few days(from 2 till 3) of perfect run,I get following
error:
System.NullReferenceException: Object reference not set
to an instance of an object.
at MySQLDriverCS.CPrototypes.mysql_close(Void*
handle)
at MySQLDriverCS.MySQLConnection.Close().
And after that error, whole aspnet_wp hangs up, and the
process is recycled. After this, the application wont start
up again, so i need to restart it manually.

Discussion

  • Matthew Cantillon

    Logged In: YES
    user_id=173537

    Hi,

    I have noticed a similar thing.

    When useing my asp.net app heaverly for a day the MySQL
    server process list is full of dead connections and the app
    starts saying "Object reference not set to an instance of an
    object." and stops working.

    If you kill the aspnet_wp.exe task then all the processes
    disapeare and everything is fine again.

    I am making sure to call .close when finished with my
    connection.

     
  • Manuel Lucas Viñas Livschitz

    Logged In: YES
    user_id=406263

    It looks like mysql connection was killed while you were
    working. MySQL has an internal time-out, this must be the
    problem. While we'll trying to fix it (throwing the proper
    exception) try to use MySQLConnections for an small time
    (don't use pools).

     
  • mad charon

    mad charon - 2004-02-27

    Logged In: YES
    user_id=979227

    I dont thing that in this is problem. Every hit gets new
    connection to database, and the connection timeout is set to
    more than 5 minutes, which should be enough for every
    request which is made. Request could take less 1 second. But
    the exception arrives when the user is performing his request.

     
  • Manuel Lucas Viñas Livschitz

    • status: open --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks