Search the Community
Showing results for tags 'mysql jdbc'.
Found 1 result
-
Dear Support, I am re-experiencing "already has more than 'max_user_connections' active connections" when I attempt to connect to mySql. When it occurred before, the root cause seemed to point to the fact that the system was not immediately closing the connection when requested by the servlet, and therefore was exceeding max connections (which are currently set to 4) -- I believe increasing it to ~40 fixed the issue! The code still opens a connection, processes an sql and closes right after (as before). It does seem to work most of the time, but annoying stops or slows down causing data access errors. Just an observation: ever since the last solution (back in June, I think) I did not experience this error! Thanks and appreciate for help. at: /home/citisnet warm regards.
