Hi,
It is likely that the connection has been closed by a timeout on the
MySQL server. Try to browse the Sequoia mailing list archive for a
solution or check the MySQL documentation to disable or set a higher
idle connection timeout.
If you set your idle connection timeout to a lower value in your Sequoia
config (along with a min pool size to 0), that should also solve the
problem.
Thanks for you interest in Sequoia,
Emmanuel
My sequoia setup is working fine, but I have come across a a problem
as below.
on with server)
2008-12-06 16:08:14,599 WARN
virtualdatabase.VirtualDatabaseWorkerThread.ems Client
(login:ems,host:dbserver closed connection with server)
2008-12-06 16:49:00,503 WARN
virtualdatabase.VirtualDatabaseWorkerThread.ems Client
(login:ems,host:dbserver closed connection with server)
2008-12-06 18:34:41,346 WARN
virtualdatabase.VirtualDatabaseWorkerThread.ems Client
(login:ems,host:dbserver closed connection with server)
2008-12-06 18:36:42,348 WARN
virtualdatabase.VirtualDatabaseWorkerThread.ems Client
(login:ems,host:dbserver closed connection with server)
2008-12-07 07:01:42,014 ERROR sequoia.controller.connection Failed to
get a connection on backend 'ems1_main' but an idle connection was
expected
2008-12-07 07:01:42,023 WARN sequoia.controller.recoverylog Failed to
store backend recovery info
com.mysql.jdbc.CommunicationsException: Communications link failure
due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2689)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2618)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1551)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
Starting with error
"Failed to get a connection on backend 'ems1_main' but an idle
connection was expected" sequoia is unable to update any status in the
recovery log. Iam using MySQL backuper, and my recovery log database
is in backend "ems1_main" itself but its giving error as "idle
connection was expected and could not update my recovery log. I myself
could understand only that connectio was staying idle from 2008-12-06
18:36:42,348 to 2008-12-07 07:01:42,014 as in the above error.
Please somebody let me know why this error can occur and a possible
solution. Thanks in advance.
------------------------------------------------------------------------
_______________________________________________
Community mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/community
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [email protected]
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
