chanders Posted August 29, 2017 Posted August 29, 2017 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/citisnetwarm regards.
Bailey Posted August 29, 2017 Posted August 29, 2017 I know you are probably told this all the time but if you are connecting to it through a program that you have coded yourself make sure that you close the connection even if there is an error within the program. That's what people tend to miss, the connection is still open if the program is closed.
chanders Posted September 2, 2017 Author Posted September 2, 2017 Dear Support,I have thoroughly checked my logic -- and determined that all threads are closed. ProcessList shows nothing active or suspended. I believe the system delaying in actually releasing a pooled connection. Since the maximum user connections allowed is 4 -- it is easy to exceed this limit, sometimes (especially when the system is slow to process clear requests). Appreciate if you can please check this or may be temporarily increase connections allowed. I donot believe there is no danger of run away connections, as the system limits them to 75. Thanks and warm regardsat: /home/citisnet
Krydos Posted September 2, 2017 Posted September 2, 2017 Your account does not currently have any open mysql connections.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now