Hello, I'm still getting "Communications link failure" on my sequoia cluster nodes after being idle for sometimes. I have already increased the interactive_timeout in /etc/my.cnf to 50000 (should I increase it to a higher number?) and have restarted the MySQL server. I also added "autoReconnect=true" to the database backend definition, but still get this error. I need to have this fixed right away permanently. Can someone please help me resolve this issue. Thanks very much.
AK -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Olivier Fambon Sent: Tuesday, October 03, 2006 9:29 AM To: Sequoia general mailing list Subject: Re: [Sequoia] com.mysql.jdbc.CommunicationsException Ashraful Karim wrote [10/02/2006 03:44 PM]: > Hello, Hi Karim, > I'm seeing the following error when I try to do an insert into one of the > backend db's in a RAIDb1 config. > The backends were working before the weekend and when I came in this morning > and try to do an insert, > it gave me the following errors. > What does it mean "No operations allowed after connection closed."? It means that once a connection is closed, be it explicitly by the user or implicitly in case of error as is the case here, it can no longer be used. Are you using persistent connections ? > Why was the connection closed? Looks like the connection (the backend/pool sequoia connection) was closed because the underlying mysql driver connection to the mysql server timed-out. There is an option in the mysql jdbc driver to allow automatic reconnection: try to add "autoReconnect=true" in the backend jdbc url. You may also want configure your mysql server and add the following to your my.cnf: set-variable = interactive_timeout=50000 (the default is 28800, 8hr). > 2006-10-02 09:07:01,694 ERROR controller.loadbalancer.RAIDb1 write request > 1688849860266292 failed: > Backend FRDB - BackendWorkerThread for backend 'db-alpha.frny-test' with > RAIDb level:1 failed > (No operations allowed after connection closed. > Connection was implicitly closed due to underlying exception/error: ... > com.mysql.jdbc.CommunicationsException > MESSAGE: Communications link failure due to underlying exception: _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
