Hi,
Got one more error when trying to run the sample code.
Error message
Statement: [EMAIL PROTECTED]
Error message: Message of cause: Request 'insert into test.species (id,
species) values (2, "chk");' failed on all controllers
org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of
cause: Request 'insert into test.species (id, species) values (2, "chk");'
failed on all controllers
at
org.continuent.sequoia.driver.Connection.statementExecuteUpdate(Connection.java:2909)
at
org.continuent.sequoia.driver.Statement.executeUpdateWithSkeleton(Statement.java:527)
at
org.continuent.sequoia.driver.Statement.executeUpdate(Statement.java:492)
at sequoiatest.Main.main(Main.java:58)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Request 'insert into test.species (id, species) values (2, "chk");' failed on
all controllers
SerializableStackTrace of each cause:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Request 'insert into test.species (id, species) values (2, "chk");' failed on
all controllers
At:
org.continuent.sequoia.controller.requestmanager.distributed.RAIDb1DistributedRequestManager.executeRequestReturningInt(RAIDb1DistributedRequestManager.java:741)
At:
org.continuent.sequoia.controller.requestmanager.distributed.RAIDb1DistributedRequestManager.distributedStatementExecuteUpdate(RAIDb1DistributedRequestManager.java:193)
At:
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.statementExecuteUpdate(DistributedRequestManager.java:1409)
At:
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecuteUpdate(VirtualDatabase.java:610)
At:
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecuteUpdate(VirtualDatabaseWorkerThread.java:2219)
At:
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:443)
BUILD SUCCESSFUL (total time: 0 seconds)
I am able to create the object of the database from the sequoia driver with
mysql database backend. When i tried to run the query using the db object, i
received the above error.
Pl help to sort this problem.
Thanks
Regards,
Rakesh Deshmukh
On Mon, 02 Apr 2007 Schnabl, Sebastian wrote :
> >It is not able to sysnc automatically between the two
> > controller.
>
> In case of a controller-failure you must manually
> restore the controller
> from a dump and manually restore the log. Following
> this procedure
> explained in the documentation:
> http://sequoia.continuent.org/doc/infocenter/index.jsp?t-
> opic=/org.contin
> uent.sequoia.doc/html/Recover_from_a_controller_node_fai-
> lure.html
>
> Regards,
>
> Sebastian
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
