There are of course many things that could cause this issue, but I would like to bring up an interesting case I encountered. The system was running ES2 on Jboss/MySQL. The issue presented itself as rights enabled documents taking 30-40 seconds to open. Upon examining the logs we found several recurring errors, the following being the most noteworthy:
WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@178c7cf[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1b9c3be handles=0 .....
The last packet successfully received from the server was XXXXX milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
...
When we restarted the server, the logs were clean for 10 minutes or so when connection errors started appearing at increasing rates. This of course pointed to a database connectivity issue, but the connectors appeared to be in good order, and more importantly, we were able to login to the adminUI with no delays. We then disabled security software, reviewed permissions and redeployed all components to Jboss yet the issue persisted.
Upon closer inspection of the clients MySQL installation I found that several .ini files were missing. How these files went missing aside, my expectation is that MySQL would fail to start in such a scenario (which would have generated very different errors). Based on this, it would be safe to assume that this error could also be caused by damaged/corrupted .ini files.
From there it was just a matter of backing up the clients
tables through the command prompt, reinstalling, and then restoring the tables.
Leave a comment