no idea,
all I know is that the MySQL server and Controller are on the same box. Might
be something to do with using the * notation as well.
From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 10 Jul 2008 11:12:59
-0700Subject: Re: [Sequoia] Broken pipe errors
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, RobertOn 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 consoleCannot
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 1090Connected to Sequoia controller on
XXXX:1090XXXX:1090 > admin XXXXVirtual database Administrator Login >
rootVirtual database Administrator Password >Ready to administrate virtual
database XXXXXXXX(root) > disable *Disabling all backends with automatic
checkpoint.Error while disabling backends [EMAIL
PROTECTED](org.continuent.sequoia.common.exceptions.VirtualDatabaseException:
Unable to check for duplicate checkpoint name
(com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:** BEGIN NESTED EXCEPTION
**java.net.SocketExceptionMESSAGE: Broken
pipeSTACKTRACE: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(DisableBackendsAndSetCheckpoint.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]:
+1-510-501-3728 Skype: hodgesrm
_________________________________________________________________
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
