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
Post a Comment