Anyone has any ideas what is causing this error or how to debug it; it seems to
happen after some hours of inactivity. Looks like the controllers some how
lose contact with each other; here's the error message I got again this
morning. Thanks.
AK
500 Servlet Exception
org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message
of cause: write request 844424930132001 failed:
Backend FRDB - BackendWorkerThread for backend 'db-omega.frny-test' with
RAIDb level:1 failed (No operations allowed after connection closed.Connection
was implicitly closed due to underlying exception/error:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
Last packet sent to the server was 3 ms ago.
STACKTRACE:
com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ashraful
Karim
Sent: Monday, October 02, 2006 9:45 AM
To: Sequoia general mailing list
Subject: [Sequoia] com.mysql.jdbc.CommunicationsException
Hello,
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."? Why was the connection closed? Can you please shed some light onto
this. Thanks.
AK
2006-10-02 09:07:01,688 DEBUG controller.virtualdatabase.FRDB
handleMessageSingleThreaded (class
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdateWithKeys):
W 1688849860266292 0 INSERT INTO autoIncTable (dataField) values ('Testing
inserts, time: 1159794421575')
2006-10-02 09:07:01,688 DEBUG controller.virtualdatabase.FRDB
10.10.0.150:25322: Scheduling distributedRequest 1688849860266292 from
Member(address=/10.10.0.150:34195:34195, uid=FRDB)
2006-10-02 09:07:01,689 DEBUG controller.virtualdatabase.FRDB
handleMessageMultiThreaded (class
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdateWithKeys):
W 1688849860266292 0 INSERT INTO autoIncTable (dataField) values ('Testing
inserts, time: 1159794421575')
2006-10-02 09:07:01,689 DEBUG controller.virtualdatabase.FRDB
10.10.0.150:25322: Executing distributedRequest 1688849860266292 from
Member(address=/10.10.0.150:34195:34195, uid=FRDB)
2006-10-02 09:07:01,690 DEBUG sequoia.controller.recoverylog Logging request
5339
2006-10-02 09:07:01,690 DEBUG DatabaseBackend.db-alpha.frny-test Scheduling
request INSERT INTO autoIncTable (dataField) values ('Testing inserts, time:
1159794421575') in non conflicting queue
2006-10-02 09:07:01,690 DEBUG DatabaseBackend.db-alpha.frny-test Adding task
Autocommit StatementExecuteUpdateWithKeysTask (INSERT INTO autoIncTable
(dataField) values ('Testing inserts, time: 1159794421575')) to pending request
queue
2006-10-02 09:07:01,690 DEBUG DatabaseBackend.db-alpha.frny-test Executing task
Autocommit StatementExecuteUpdateWithKeysTask (INSERT INTO autoIncTable
(dataField) values ('Testing inserts, time: 1159794421575'))
2006-10-02 09:07:01,690 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[1] - INSERT INTO testRECOVERY
VALUES(5339,'user','INSERT INTO autoIncTable (dataField) values (\'Testing
inserts, time: 1159794421575\')',null,'A',0,1688849860266292,'E',1,0)
2006-10-02 09:07:01,693 DEBUG DatabaseBackend.db-alpha.frny-test Task
Autocommit StatementExecuteUpdateWithKeysTask (INSERT INTO autoIncTable
(dataField) values ('Testing inserts, time: 1159794421575')) completed
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:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
@40000000452113f916422c6c 09:28:15,373 WARN
sequoia.controller.scheduler Waiting for 1 pending
writesutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.
STACKTRACE:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2592)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
)
2006-10-02 09:07:01,697 WARN controller.RequestManager.FRDB SQLException while
executing distributed write request 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:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.
STACKTRACE:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1071)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1005)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1120)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteUpdateWithKeysOnBackend(AbstractLoadBalancer.java:947)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeInAutoCommit(StatementExecuteUpdateWithKeysTask.java:211)
at
org.continuent.sequoia.controller.loadbalancer.tasks.StatementExecuteUpdateWithKeysTask.executeTask(StatementExecuteUpdateWithKeysTask.java:114)
at
org.continuent.sequoia.controller.loadbalancer.tasks.AbstractTask.execute(AbstractTask.java:140)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:194)
** END NESTED 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
