subsonic - mysql too many connections - too many sleeping threads? -


i getting error mysql database

error connecting: timeout expired.  timeout period elapsed prior obtaining connection pool.  may have occurred because pooled connections in use , max pool size reached. 

i have website , console application talking database dont have 100 concurrent connections! did showprocesslist query , found 10 connections command of sleep , time of 16000 seconds. there wasn't 100 connections.

i using subsonic data provider talk database , believe closes database connections , doesnt leave them hanging isn't culprit.

i restarted mysql server , console application talks database , seems working ok naturally can't have either console/website application crashing this. looking @ error log error seems coming

please advice on can find out going on , how can fix it

edit: have looked more , appears subsonic/mysql issue. have tried recommended fix in link below closing connection in block nothing closes connection...

   dim sp storedprocedure = sps.getlastgpsdataforallvehicles(customerid)             dim reader idatareader             try                 reader = sp.getreader                 mybase.load(reader)             catch ex exception                             reader.dispose()                 reader = nothing                 sp.command.todbcommand().connection.close()              end try 

i have no idea how force connection close.

thanks lot


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -