Hi, I tried to debug from the logs of controller but couldnt get success. I am attaching logs below:
07:28:36,190 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.test Login accepted for test from /172.16.12.213 07:28:36,236 DEBUG virtualdatabase.VirtualDatabaseWorkerThread.test StatementExecuteUpdate command 07:28:36,237 DEBUG controller.RequestManager.test Broadcasting request insert into test.species (id, species) v... to all controllers (Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776)->[Member(address=/172.16.12.140:53503, uid=172.16.12.140:53503), Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776)]) 07:28:36,320 DEBUG controller.virtualdatabase.test handleMessageSingleThreaded (class org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W 19 0 insert into test.species (id, species) values (2, "chk"); 07:28:36,320 DEBUG controller.virtualdatabase.test 172.16.12.213:25322: Scheduling distributedRequest 19 from Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776) 07:28:36,321 DEBUG controller.virtualdatabase.test handleMessageMultiThreaded (class org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W 19 0 insert into test.species (id, species) values (2, "chk"); 07:28:36,321 DEBUG controller.virtualdatabase.test 172.16.12.213:25322: Executing distributedRequest 19 from Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776) 07:28:36,322 DEBUG controller.RequestManager.test Scheduling write request (19): insert into test.species (id, species) v... 07:28:36,323 DEBUG controller.RequestManager.test Load balancing write request (19,14): insert into test.species (id, species) v... 07:28:36,323 DEBUG sequoia.controller.recoverylog Logging request 22 07:28:36,324 DEBUG sequoia.controller.recoverylog com.mysql.jdbc.ServerPreparedStatement[12] - INSERT INTO logtable VALUES(22,'test','insert into test.species (id, species) values (2, "chk");',null,'A',0,19,'E',2,0) 07:28:36,325 DEBUG controller.RequestManager.test No backend available to execute request insert into test.species (id, species) v..., updating recovery log. 07:28:36,339 DEBUG controller.RequestManager.test Request insert into test.species (id, species) v... completed. 07:28:36,339 DEBUG controller.RequestManager.test Controller Member(address=/172.16.12.140:53503, uid=172.16.12.140:53503) has no more backends to execute query (org.continuent.sequoia.common.exceptions.NoMoreBackendException: No backend to execute the request.) 07:28:36,339 DEBUG controller.RequestManager.test Controller Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776) has no more backends to execute query (org.continuent.sequoia.common.exceptions.NoMoreBackendException: No backend to execute the request.) 07:28:36,366 DEBUG controller.virtualdatabase.test handleMessageSingleThreaded (class org.continuent.sequoia.controller.virtualdatabase.protocol.NotifyCompletion): Notify failure of request: insert into test.species (id, species) values (2, "chk"); 07:28:36,366 DEBUG controller.virtualdatabase.test 172.16.12.213:25322: Scheduling distributedRequest 19 from Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776) 07:28:36,366 DEBUG controller.virtualdatabase.test handleMessageMultiThreaded (class org.continuent.sequoia.controller.virtualdatabase.protocol.NotifyCompletion): Notify failure of request: insert into test.species (id, species) values (2, "chk"); 07:28:36,366 DEBUG controller.virtualdatabase.test 172.16.12.213:25322: Executing distributedRequest 19 from Member(address=/172.16.12.213:32776, uid=172.16.12.213:32776) 07:28:36,367 DEBUG sequoia.controller.recoverylog Logging request 22 07:28:36,368 DEBUG sequoia.controller.recoverylog com.mysql.jdbc.ServerPreparedStatement[13] - UPDATE logtable SET exec_status='F',update_count=-1,exec_time=1 WHERE log_id=22 07:28:36,412 WARN controller.RequestManager.test Request 'insert into test.species (id, species) values (2, "chk");' failed on all controllers 07:28:36,412 WARN controller.RequestManager.test Request insert into test.species (id, species) v... failed (Request 'insert into test.species (id, species) values (2, "chk");' failed on all controllers) 07:28:36,412 WARN controller.virtualdatabase.test Request '19' failed (Request 'insert into test.species (id, species) values (2, "chk");' failed on all controllers) 07:28:36,416 WARN virtualdatabase.VirtualDatabaseWorkerThread.test Error during command execution (Request 'insert into test.species (id, species) values (2, "chk");' failed on all controllers) 07:28:37,169 WARN virtualdatabase.VirtualDatabaseWorkerThread.test Client (login:test,host:172.16.12.213 closed connection with server) 07:29:37, Pl help to pinpoint the exact problem. Thanks, Regards, Rakesh Deshmukh On Mon, 02 Apr 2007 Emmanuel Cecchet wrote : > Rakesh, > > > Got one more error when trying to run the sample code. > > > > Error message > > > > Statement: [EMAIL PROTECTED] > 7676 > > Error message: Message of cause: Request 'insert into > test.species (id, species) values (2, "chk");' failed > on all controllers > > > You should get the complete error message in the > controller log. That > should help you diagnose the root cause of the failure. > Might be a > duplicate key exception or something like that. > > Thanks for your interest in Sequoia, > Emmanuel > > -- > Emmanuel Cecchet > Chief Scientific Officer, Continuent > > Blog: http://emanux.blogspot.com/ > Open source: http://www.continuent.org > Corporate: http://www.continuent.com > Skype: emmanuel_cecchet > Cell: +33 687 342 685 > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
