Hi Olivier,
I'm still seeing this error "Communications link failure" even after making the
changes as you suggested. Any other suggestions I should try. Attached, is the
full error messages from the log file and also a copy of my vdb config. Please
check and let me know if you see anything on the config that I should change to
get it to work properly. Thanks.
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
2006-10-10 08:47:20,231 INFO controller.loadbalancer.RAIDb1 Request 568
failed (Request SELECT * FROM autoIncTable failed
on backend db-alpha.frny-test (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.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(Abstrac
tLoadBalancer.java:813)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:436)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:9
6)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQ
uery(DistributedRequestManager.java:1347)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(Dist
ributedRequestManager.java:1371)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:544)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteQuery(VirtualDataba
seWorkerThread.java:2104)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.jav
a:418)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.))
2006-10-10 08:47:20,233 WARN sequoia.controller.cache Unable to remove pending
query user,SELECT * FROM autoIncTable
2006-10-10 08:47:20,234 WARN controller.RequestManager.FRDB Failed to execute
request SELECT * FROM autoIncTable because of
(Request SELECT * FROM autoIncTable failed on backend db-alpha.frny-test
(Communications link failure due to underlying exc
eption:
** 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.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(Abstrac
tLoadBalancer.java:813)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:436)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:9
6)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQ
uery(DistributedRequestManager.java:1347)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(Dist
ributedRequestManager.java:1371)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:544)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteQuery(VirtualDataba
seWorkerThread.java:2104)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.jav
a:418)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.))
2006-10-10 08:47:20,235 WARN controller.virtualdatabase.FRDB Request '568'
failed (Request SELECT * FROM autoIncTable faile
d on backend db-alpha.frny-test (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.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(Abstrac
tLoadBalancer.java:813)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:436)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:9
6)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQ
uery(DistributedRequestManager.java:1347)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(Dist
ributedRequestManager.java:1371)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:544)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteQuery(VirtualDataba
seWorkerThread.java:2104)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.jav
a:418)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.))
2006-10-10 08:47:20,236 WARN virtualdatabase.VirtualDatabaseWorkerThread.FRDB
Error during command execution (Request SELEC
T * FROM autoIncTable failed on backend db-alpha.frny-test (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.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at
org.continuent.sequoia.controller.loadbalancer.AbstractLoadBalancer.executeStatementExecuteQueryOnBackend(Abstrac
tLoadBalancer.java:813)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:436)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:9
6)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQ
uery(DistributedRequestManager.java:1347)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteQuery(Dist
ributedRequestManager.java:1371)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteQuery(VirtualDatabase.java:544)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteQuery(VirtualDataba
seWorkerThread.java:2104)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.jav
a:418)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.))
2006-10-10 08:47:43,921 DEBUG controller.jmx.AuthenticatingMBeanServer no
authentication required
2006-10-10 08:47:43,950 DEBUG controller.jmx.AuthenticatingMBeanServer no
authentication required
2006-10-10 08:47:43,950 DEBUG controller.jmx.AuthenticatingMBeanServer
Authentication with principal was successfull
2006-10-10 08:48:05,636 DEBUG controller.jmx.AuthenticatingMBeanServer no
authentication required
2006-10-10 08:48:05,645 DEBUG controller.jmx.AuthenticatingMBeanServer no
authentication required
2006-10-10 08:48:05,646 DEBUG controller.jmx.AuthenticatingMBeanServer
Authentication with principal was successfull
2006-10-10 08:48:05,750 DEBUG controller.virtualdatabase.FRDB
handleMessageSingleThreaded (class org.continuent.sequoia.cont
roller.virtualdatabase.protocol.SuspendActivity):
org.continuent.sequoia.controller.virtualdatabase.protocol.SuspendActivity
@1d0eb0b
2006-10-10 08:48:05,751 DEBUG controller.virtualdatabase.FRDB
handleMessageMultiThreaded (class org.continuent.sequoia.contr
oller.virtualdatabase.protocol.SuspendActivity):
org.continuent.sequoia.controller.virtualdatabase.protocol.SuspendActivity@
1d0eb0b
2006-10-10 08:48:05,865 INFO controller.RequestManager.FRDB All activity is
suspended for FRDB
2006-10-10 08:48:05,915 DEBUG controller.virtualdatabase.FRDB
handleMessageSingleThreaded (class org.continuent.sequoia.cont
roller.virtualdatabase.protocol.DisableBackendsAndSetCheckpoint):
org.continuent.sequoia.controller.virtualdatabase.protocol
[EMAIL PROTECTED]
2006-10-10 08:48:05,916 DEBUG controller.virtualdatabase.FRDB
handleMessageMultiThreaded (class org.continuent.sequoia.contr
oller.virtualdatabase.protocol.DisableBackendsAndSetCheckpoint):
org.continuent.sequoia.controller.virtualdatabase.protocol.
[EMAIL PROTECTED]
2006-10-10 08:48:06,084 DEBUG controller.virtualdatabase.FRDB
handleMessageSingleThreaded (class org.continuent.sequoia.cont
roller.virtualdatabase.protocol.ResumeActivity): [EMAIL PROTECTED]
a4e31
2006-10-10 08:48:06,085 DEBUG controller.virtualdatabase.FRDB
handleMessageMultiThreaded (class org.continuent.sequoia.contr
oller.virtualdatabase.protocol.ResumeActivity): [EMAIL PROTECTED]
4e31
<?xml version="1.0" encoding="UTF8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.dtd";>
<SEQUOIA>
<VirtualDatabase name="FRDB">
<Distribution hederaPropertiesFile="/hedera_jgroups_frdb.properties">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="mysqlbackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword=""/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="db-alpha.frny-test" driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://db-alpha.frny:3306/test?autoRe
connect=true" connectionTestStatement="select 1">
<!--
<DatabaseSchema dynamicPrecision="all"/>
<RewritingRule queryPattern="?1 LIMIT ?2,?3" rewrite="?1 LIMIT ?3,?2"
matchingType="pattern"/>
-->
<ConnectionManager vLogin="user" rLogin="dba" rPassword="">
<VariablePoolConnectionManager initPoolSize="40" maxPoolSize="80"
idleTimeout="14400"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
<ResultCache granularity="table"/>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost/recoverytest" login="dba" password="">
<RecoveryLogTable tableName="testRECOVERY"
vloginColumnType="VARCHAR(20) NOT NULL"
sqlColumnType="TEXT NOT NULL"
logIdColumnType="BIGINT NOT NULL"
sqlParamColumnType="VARCHAR(20)"
transactionIdColumnType="BIGINT NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="testCHECKPOINT"
checkpointNameColumnType="VARCHAR(127) NOT NULL"
logIdColumnType="BIGINT"
extraStatementDefinition=",PRIMARY KEY (name)"/>
<BackendTable tableName="testBACKEND"
databaseNameColumnType="VARCHAR(50) NOT NULL"
backendNameColumnType="VARCHAR(50) NOT NULL"
checkpointNameColumnType="VARCHAR(127) NOT NULL"/>
<DumpTable tableName="testDUMP"
tablesColumnName="table_dump"
dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="TEXT NOT NULL"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
