chanders

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.

Friends -- I am getting 503 (service unavailable!) when accessing servlet at: http://citisnet.heliohost.org/citisnetsql3/#/ appreciate your attention. ... regards.

please re-deploy user: citisnet file: citisnetsql3.war

Krydos, Thanks for work on it -- But now I get HTTP Status 404 - /citisnet_citisnetsql3/could you please redeploy. warm regards.

Hello Krydos -- the server seems to be still holding on to the previous servlet -- please clear the cache of older servlet from the server. regards.

please re-deploy user: citisnet file: citisnetsql3.war

Thank you Krydos -- most wonderful folks you are! It seems the servlet is still showing the old stuff -- wondering if server cache needs clearing. regards.

Not sure why this request has been escalated to root admin? I was under the impression that re-deployment takes much shorter time! Also, I was wondering if it is possible to self deploy a war file? warm regards.

please re-deploy user: citisnet file: citisnetsql3.war

please re-deploy user: citisnet file: citisnetsql3.war

please re-deploy user: citisnet file: citisnetsql3.war

please re-deploy user: citisnet file: citisnetsql3.war

please re-deploy user: citisnet file: citisnetsql3.war

Please deploy war file: user: citisnet file: citisnetsql3.war

Thanks Krydos, I would certainly appreciate if it is possible to temporarily increase it so I can do some benchmarking without butting into system queue delays. I can assure you that I am very carefully with regards to monitoring, and ensure that the pooled connection is closed immediately after operation is completed. Thanks again and warm regards.

Thanks krydos - good point and again a good suggestion! My guess is that there may be system delay in closing a pooled connection (due to pooled connection queue delays), which makes the connection count Temporarily exceed 4 (max allowed) rather too quickly. Regards.

Dear Krydos, Thank you for the great suggestion -- apparently the current global variable: max_user_connections is set to 4 -- which might just be too low!. Also, I checked my code and it seems that: I open the pooled connection instance -- process sql-- and then immediately close it right after the operation. So, most of the time it seems to work, but annoying stops or slows down causing data access errors. Most people suggest changing the global max_user_connections first, before changing the pooling scheme or anything else. So temporarily changing this global variable higher will prove this hypothesis. Besides this global variable change does not affect the system resources much, since the top limit is already set to 75. at: /home/citisnet warm regards.

Please change variable: max_user_connections in mysql to 40. user: citisnet mysql database: citisnet_citisnetdb warm regards.

please deploy -- User: citisnet file: citisnetsql3.war regards

Please deploy: username: citisnet war file: citisnetsql3.war

After reading a few posts, I get the impression that deploying war and enabling java servlet on 'johnny' server could take a lot longer. If so -- please move my implementation to 'tommy' or other server that is more readily available and supports mysql/jdbc. My user and war file info is: user: chanders war file: citisnetsql3.war regards.

user: chanders warfile: citisnetsql3.war please deploy this war files that contains a java servlet accessing mysql database using jdbc.