Hi Adam,
It looks as if you are getting broken connections to the MySQL server. Is
there a network issue or are you purging idle connections quickly on MySQL?
Cheers, Robert
On 7/10/08 11:00 AM, "Adam Purkiss" <[EMAIL PROTECTED]> wrote:
I am using the console on a windows box to interact with a linux box but I
sometime see the following - notice how the command failed the first time and
worked fine the second time:
Launching the Sequoia controller console
Cannot connect to the administration port of the controller. Is a controller
running at localhost:1090 ?
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v2.10.10) successfully loaded.
not connected > connect controller XXXX 1090
Connected to Sequoia controller on XXXX:1090
XXXX:1090 > admin XXXX
Virtual database Administrator Login > root
Virtual database Administrator Password >
Ready to administrate virtual database XXXX
XXXX(root) > disable *
Disabling all backends with automatic checkpoint.
Error while disabling backends [EMAIL
PROTECTED](org.continuent.sequoia.common.exceptions.VirtualDat
abaseException: Unable to check for duplicate checkpoint name
(com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying e
xception:
** 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:2744)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.validCheckpointName(RecoveryLog.java:3309)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.storeCheckpoint(RecoveryLog.java:2704)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DisableBackendsAndSetCheckpoint.handleMessageMultiThreaded(DisableBackendsAndSet
Checkpoint.java:139)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:375
)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
** END NESTED EXCEPTION **
Last packet sent to the server was 4 ms ago.))
XXXX(root) > disable *
Disabling all backends with automatic checkpoint.
XXXX(root) >
________________________________
--
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
