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
