User has already more than 'max_user_connections' active connections

C

carpe-diem

Perch
Hi, today I noticed the error mentioned in the title.

Us and our client have been using a custom CMS and of course the ticket response was to properly close my connections.

I just went through all the instances of connecting to database in our code and found them all being closed and disposed of.

Connections stay in the "Processes" list of phpmyadmin for several minutes in the state of "Sleep". Should that state not be "open" if they were not being closed properly?
 
i dont know what those two functions translate to in asp.net, but this cms is working ok on other sites which are hosted elswhere
 
i added pooling=false into connection string and the problem went away.

don't know yet, what this will do to performance though...
 
That means you were indeed using persistant connections that is not a way to go in shared hosting. Also FYI, sleep mode means that connection is still open.
 
You must log in or register to reply here.
Back
Top