Re: [Carob] Re: carob-0.6 refuses to compile on amd64 but compiles on i386

Wed, 18 Oct 2006 01:32:16 -0700 

Hi,
I am currently installing a 64 bits machine so I can do some testing.
I must say that I don't really understand the results of your tests. There must be a bug in carob (looks like a recursive BackendException) but I don't see where it comes from. 
I'll get back to you once tested on a 64bits machine, hopefully this week...
Gilles

Dr. Volker Jaenisch a écrit :

Hello Gilles!
What I recommend to you as a first step (just to test carob), is to launch this demo. It works out of the box and has everything in to make carob tests work correcly (just cd to sequoia dir and issue ./demo/demo-distributed-raidb1.sh 
Followed your advise:
* startet sequoia demo on server ctrl1 (controller configs slightly modified "localhost" -> "ip of ctrl1") 
* started carob driver test on server hydra2 addressing "ctrl1:25332"

Looks not too bad:

Test Results:
Run:  50   Failures: 3   Errors: 8

Attached the corresponing logs of sequoia demo-server and carob-client.
Please give me advice to proceed further.

Best Regards,

Volker

==========================================================
==========================================================

Log on carob-client:

==========================================================
==========================================================

hydra2:~/mcluster/carob-0.6_patched# cd test
hydra2:~/mcluster/carob-0.6_patched/test# ./carobTestLauncher
TestConnect::testConnectBadAddress. : OK
TestConnect::testConnectBadPort. : OK
TestConnect::testConnectBadDBBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: CarobException: SQL state: HY000 
CarobException: remote stack:
. : errorE
TestConnect::testConnectBadUserBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: CarobException: SQL state: HY000 
CarobException: remote stack:
. : errorE
TestConnect::testConnectBadPassBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: CarobException: SQL state: HY000 
CarobException: remote stack:
. : errorE
TestConnect::testConnectGoodBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: CarobException: SQL state: HY000 
CarobException: remote stack:
. : errorE
TestExecWriteRequest::testWriteBadRequest. : OK
TestExecWriteRequest::testWriteBadTable. : OK
TestExecWriteRequest::testWriteGood. : OK
TestExecReadRequest::testReadBadRequest. : OK
TestExecReadRequest::testReadBadTable. : OK
TestExecReadRequest::testReadGoodBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: SQL state: 
BackendException: remote stack:
BackendException: at org.continuent.sequoia.controller.backend.result.ControllerResultSet.fetchData(ControllerResultSet.java:275) BackendException: at org.continuent.sequoia.controller.backend.result.ControllerResultSet.fetchData(ControllerResultSet.java:247) BackendException: at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.fetchNextResultSetRows(VirtualDatabaseWorkerThread.java:3441) BackendException: at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:568) 
. : errorE
TestExecReadRequest::testReadWithMaxRows. : OK
TestExec::testExecuteBadRequests. : OK
TestExec::testExecuteWithSelect. : OK
TestExec::testExecuteWithUpdate. : OK
TestExec::testExecuteWithSelectStreamed. : OK
TestBeginCommitRollback::testReadRequestAndCommit. : OK
TestBeginCommitRollback::testReadRequestAndRollback. : OK
TestBeginCommitRollback::testWriteRequestAndCommit. : OK
TestBeginCommitRollback::testWriteRequestAndRollback. : OK
TestBigDecimal::testGetAsStringUsingCLocale. : OK
TestBigDecimal::testGetAsStringUsingUserLocale. : OK
TestBigDecimal::testGetAsStringUsingFrLocale. : OK
TestBigDecimal::testGetAsStringUsingUSLocale. : OK
TestBigDecimal::testGetAsInt. : assertionF
TestBigDecimal::testGetAsInt64. : OK
TestBigDecimal::testGetAsUInt64. : OK
TestBigDecimal::testGetAsFloat. : assertionF
TestBigDecimal::testGetAsDouble. : assertionF
TestDriverResultSet::testNullValueRetrieval. : OK
TestDriverResultSet::testGetAsIntOnString. : OK
TestStringCodecs::encode_decodeBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: ControllerException: SQL state: 22018 
ControllerException: remote stack:
. : errorE
TestSimpleUnicode::testBasic. : OK
TestParameterStatement::testExecuteQueryLessParams. : OK
TestParameterStatement::testExecuteQueryGoodBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: SQL state: 
BackendException: remote stack:
BackendException: at org.continuent.sequoia.controller.backend.result.ControllerResultSet.fetchData(ControllerResultSet.java:275) BackendException: at org.continuent.sequoia.controller.backend.result.ControllerResultSet.fetchData(ControllerResultSet.java:247) BackendException: at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.fetchNextResultSetRows(VirtualDatabaseWorkerThread.java:3441) BackendException: at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:568) 
. : errorE
TestParameterStatement::testExecuteUpdateBadParams. : OK
TestParameterStatement::testExecuteUpdateGood. : OK
TestParameterStatement::testExecuteWithSelect. : OK
TestParameterStatement::testExecuteWithUpdate. : OK
TestParameterStatement::testBoolean. : OK
TestParameterStatement::testStrings. : OK
TestParameterStatement::testBigDecimal. : OK
TestParameterStatement::testSetNull. : OK
TestIEEE754::testBasic. : OK
TestIEEE754::testInfNaN. : OK
TestControllerPool::testRoundRobinSequence. : OK
TestControllerPool::testNoMoreController. : OK
TestFailOver::testReconnectNoControllers. : OK
TestFailOver::testConnectOnlyOneControllerUpBackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: BackendException: CarobException: SQL state: HY000 
CarobException: remote stack:
. : errorE



!!!FAILURES!!!
Test Results:
Run:  50   Failures: 3   Errors: 8


1) test: TestConnect::testConnectBadDB (E)
CarobException:All 1 controllers down (SQL State=HY000)


2) test: TestConnect::testConnectBadUser (E)
CarobException:All 1 controllers down (SQL State=HY000)


3) test: TestConnect::testConnectBadPass (E)
CarobException:All 1 controllers down (SQL State=HY000)


4) test: TestConnect::testConnectGood (E)
CarobException:All 1 controllers down (SQL State=HY000)


5) test: TestExecReadRequest::testReadGood (E)
BackendException:Backend ResultSet is closed (SQL State=)
6) test: TestBigDecimal::testGetAsInt (F) line: 234 30-ResultSet/TestBigDecimal.cpp 
assertion failed
- Expression: false
7) test: TestBigDecimal::testGetAsFloat (F) line: 450 30-ResultSet/TestBigDecimal.cpp 
assertion failed
- Expression: drsPtr->getAsFloat(3) == numeric_limits<float>::min()
8) test: TestBigDecimal::testGetAsDouble (F) line: 491 30-ResultSet/TestBigDecimal.cpp 
assertion failed
- Expression: drsPtr->getAsDouble(3) == numeric_limits<float>::min()


9) test: TestStringCodecs::encode_decode (E)
CodecException:locale::facet::_S_create_c_locale name not valid, locale name was: [EMAIL PROTECTED] (SQL State=22018) 


10) test: TestParameterStatement::testExecuteQueryGood (E)
BackendException:Backend ResultSet is closed (SQL State=)


11) test: TestFailOver::testConnectOnlyOneControllerUp (E)
CarobException:All 4 controllers down (SQL State=HY000)

==========================================================
==========================================================

Log an Demo-Machine:

==========================================================
==========================================================
09:46:40,510 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (SQL statement does not match a query returning an update count (dummy request)) 09:46:40,746 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0' java.sql.SQLException: Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0' at org.continuent.sequoia.controller.requests.UpdateRequest.parse(UpdateRequest.java:273) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:40,751 WARN controller.virtualdatabase.myDB Distributed request update dummy set name='gotit' where id=0 did not remove itself from the total order queue 09:46:40,825 WARN controller.RequestManager.myDB Request 562949953421313 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0') 09:46:41,061 WARN controller.RequestManager.myDB Request update dummy set name='gotit' where id=0... failed (Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0') 09:46:41,062 WARN controller.virtualdatabase.myDB Request '562949953421313' failed (Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0') 09:46:41,062 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'dummy' in this UPDATE statement: 'update dummy set name='gotit' where id=0') 09:46:41,869 INFO controller.loadbalancer.RAIDb1 Request 562949953421315 failed (Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy])) 09:46:41,869 WARN controller.RequestManager.myDB Failed to execute request dummy request because of (Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy])) 09:46:41,870 WARN controller.RequestManager.myDB SQLException while executing remote read request. java.sql.SQLException: Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:41,907 WARN controller.RequestManager.myDB An error occured while executing remote select request 562949953421315 java.sql.SQLException: Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:41,952 WARN controller.virtualdatabase.myDB Request '562949953421315' failed (Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy])) 09:46:41,952 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Request dummy request failed on backend localhost1 (Unexpected token: DUMMY in statement [dummy])) 09:46:42,172 INFO controller.loadbalancer.RAIDb1 Request 562949953421316 failed (Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy])) 09:46:42,172 WARN controller.RequestManager.myDB Failed to execute request select * from dummy because of (Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy])) 09:46:42,172 WARN controller.RequestManager.myDB SQLException while executing remote read request. java.sql.SQLException: Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:42,207 WARN controller.RequestManager.myDB An error occured while executing remote select request 562949953421316 java.sql.SQLException: Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:42,210 WARN controller.virtualdatabase.myDB Request '562949953421316' failed (Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy])) 09:46:42,210 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Request select * from dummy failed on backend localhost1 (Table not found in statement [select * from dummy])) 09:46:42,512 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Backend ResultSet is closed) 09:46:43,105 ERROR controller.loadbalancer.RAIDb1 write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy])
09:46:43,106 WARN controller.RequestManager.myDB SQLException while executing distributed write request write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) 

java.sql.SQLException: write request 562949953421319 failed:
Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy])
at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:938) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.execWriteRequest(RAIDb1.java:343) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteUpdate(RAIDb1.java:249) at org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecuteUpdate(RequestManager.java:913) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:87) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:43,144 WARN controller.RequestManager.myDB Request 562949953421319 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) 
)
09:46:43,386 WARN controller.RequestManager.myDB Request dummy failed (write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) 
)
09:46:43,386 WARN controller.virtualdatabase.myDB Request '562949953421319' failed (write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) 
)
09:46:43,386 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (write request 562949953421319 failed: Backend myDB - BackendWorkerThread for backend 'localhost1' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) Backend myDB - BackendWorkerThread for backend 'localhost2' with RAIDb level:1 failed (Unexpected token: DUMMY in statement [dummy]) 
)
09:46:43,498 INFO controller.loadbalancer.RAIDb1 Request 562949953421320 failed (Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy])) 09:46:43,498 WARN controller.RequestManager.myDB Failed to execute request SELECT * FROM dummy because of (Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy])) 09:46:43,499 WARN controller.RequestManager.myDB SQLException while executing remote read request. java.sql.SQLException: Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:43,533 WARN controller.RequestManager.myDB An error occured while executing remote select request 562949953421320 java.sql.SQLException: Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy]) at org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:48) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.executeRequestOnBackend(RAIDb1.java:443) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:216) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) at org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) at org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:595) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1347) at org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:46:43,534 WARN controller.virtualdatabase.myDB Request '562949953421320' failed (Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy])) 09:46:43,534 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Request SELECT * FROM dummy failed on backend localhost1 (Table not found in statement [SELECT * FROM dummy])) 09:47:41,299 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic' java.sql.SQLException: Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:41,301 WARN controller.virtualdatabase.myDB Distributed request drop table unicodebasic did not remove itself from the total order queue 09:47:41,337 WARN controller.RequestManager.myDB Request 562949953421527 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic') 09:47:41,561 WARN controller.RequestManager.myDB Request drop table unicodebasic failed (Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic') 09:47:41,561 WARN controller.virtualdatabase.myDB Request '562949953421527' failed (Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic') 09:47:41,561 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'unicodebasic' in this DROP statement 'drop table unicodebasic') 09:47:46,368 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Backend ResultSet is closed) 09:47:47,776 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'booltable' in this DROP statement 'drop table booltable' java.sql.SQLException: Unknown table 'booltable' in this DROP statement 'drop table booltable' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:47,776 WARN controller.virtualdatabase.myDB Distributed request drop table booltable did not remove itself from the total order queue 09:47:47,810 WARN controller.RequestManager.myDB Request 562949953421536 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'booltable' in this DROP statement 'drop table booltable') 09:47:48,035 WARN controller.RequestManager.myDB Request drop table booltable failed (Unknown table 'booltable' in this DROP statement 'drop table booltable') 09:47:48,035 WARN controller.virtualdatabase.myDB Request '562949953421536' failed (Unknown table 'booltable' in this DROP statement 'drop table booltable') 09:47:48,036 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'booltable' in this DROP statement 'drop table booltable') 09:47:49,523 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'stringtable' in this DROP statement 'drop table stringtable' java.sql.SQLException: Unknown table 'stringtable' in this DROP statement 'drop table stringtable' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:49,524 WARN controller.virtualdatabase.myDB Distributed request drop table stringtable did not remove itself from the total order queue 09:47:49,558 WARN controller.RequestManager.myDB Request 562949953421541 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'stringtable' in this DROP statement 'drop table stringtable') 09:47:49,788 WARN controller.RequestManager.myDB Request drop table stringtable failed (Unknown table 'stringtable' in this DROP statement 'drop table stringtable') 09:47:49,788 WARN controller.virtualdatabase.myDB Request '562949953421541' failed (Unknown table 'stringtable' in this DROP statement 'drop table stringtable') 09:47:49,788 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'stringtable' in this DROP statement 'drop table stringtable') 09:47:50,976 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest' java.sql.SQLException: Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:50,976 WARN controller.virtualdatabase.myDB Distributed request drop table bigdecimaltest did not remove itself from the total order queue 09:47:51,011 WARN controller.RequestManager.myDB Request 562949953421545 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest') 09:47:51,238 WARN controller.RequestManager.myDB Request drop table bigdecimaltest failed (Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest') 09:47:51,238 WARN controller.virtualdatabase.myDB Request '562949953421545' failed (Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest') 09:47:51,238 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'bigdecimaltest' in this DROP statement 'drop table bigdecimaltest') 09:47:54,867 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull' java.sql.SQLException: Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:54,868 WARN controller.virtualdatabase.myDB Distributed request drop table testSetNull did not remove itself from the total order queue 09:47:54,902 WARN controller.RequestManager.myDB Request 562949953421558 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull') 09:47:55,132 WARN controller.RequestManager.myDB Request drop table testSetNull failed (Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull') 09:47:55,132 WARN controller.virtualdatabase.myDB Request '562949953421558' failed (Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull') 09:47:55,132 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'testsetnull' in this DROP statement 'drop table testSetNull') 09:47:56,280 WARN controller.RequestManager.myDB SQLException while executing distributed write request Unknown table 'realdouble' in this DROP statement 'drop table realdouble' java.sql.SQLException: Unknown table 'realdouble' in this DROP statement 'drop table realdouble' at org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:260) at org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:365) at org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:807) at org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(DistributedRequestManager.java:1460) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(DistributedStatementExecuteUpdate.java:84) at org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) at org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) at org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) 09:47:56,281 WARN controller.virtualdatabase.myDB Distributed request drop table realdouble did not remove itself from the total order queue 09:47:56,316 WARN controller.RequestManager.myDB Request 562949953421562 failed on controller Member(address=/10.3.0.16:32781:32781, uid=myDB) (java.sql.SQLException: Unknown table 'realdouble' in this DROP statement 'drop table realdouble') 09:47:56,543 WARN controller.RequestManager.myDB Request drop table realdouble failed (Unknown table 'realdouble' in this DROP statement 'drop table realdouble') 09:47:56,543 WARN controller.virtualdatabase.myDB Request '562949953421562' failed (Unknown table 'realdouble' in this DROP statement 'drop table realdouble') 09:47:56,543 WARN virtualdatabase.VirtualDatabaseWorkerThread.myDB Error during command execution (Unknown table 'realdouble' in this DROP statement 'drop table realdouble') 

_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob

Reply via email to