some times aborting connections or interrupting process lead to another problem to server from stop giving connections to client. that is server do not allow any more connections to client.probable causes would be. client is idle more than wait_timeout or due to long queries getting aborted from client orclient makes mistake in authentications while connecting to database.all these lead to
Thursday, 24 September 2009
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
Posted on 07:13 by Unknown
I have noticed this error in my MySql Outage, suddenly going down due to overload.after my observation I found that this kind of error mostly will cause because of system variables settings of wait_timeout and interactive_timeout on mysql server is set lower than datasourceidle timeout period.my datasource pooling property for conection time out is set to 1 minon server variable wait_timeout is
Subscribe to:
Comments (Atom)