El Thursday 22 March 2007 15:56:37 Emmanuel Cecchet escribió:
> You can look at http://sequoia.continuent.org/Sequoia210to30
> Basically, you just have to declare a <EmbeddedRecoveryLog/> element
> instead of your current recovery log definition.
Ok, it worked! Thanks :)
Now, following almost literally the documentation that I mentioned, I have
- initialized 1 backend
- made a dump
- restored the dump on the second backend
- enabled the two backends
everything goes fine, no error messages, eveerything enabled as it should be.
Now I try to test the controller doing, as the documentation tell
localhost:1090 > sql client jdbc:sequoia://sequoia/MySQL5
Login > wwwagent
Password >
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > create table test(i integer);
17:51:36,660 WARN controller.RequestManager.MySQL5 Failed to execute request
create table test(i integer);/ because of (null)
java.lang.ClassCastException
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:849)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecute(RAIDb1.java:280)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecute(RequestManager.java:971)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecute(RequestManager.java:766)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecute(VirtualDatabase.java:738)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2397)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:507)
17:51:36,664 WARN controller.virtualdatabase.MySQL5 Stored procedure 0 failed
(Failed to execute request create table test(i integer);/ because of (null))
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message
of cause: Failed to execute request create table test(i integer);/ because of
(null))
what's happening? from the full_cluster log I have
2007-03-22 17:51:54,161 WARN controller.RequestManager.MySQL5 Failed to
execute request use atrapalo;/ because of (null)
java.lang.ClassCastException
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:849)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecute(RAIDb1.java:280)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecute(RequestManager.java:971)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecute(RequestManager.java:766)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecute(VirtualDatabase.java:738)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2397)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:507)
2007-03-22 17:51:54,162 WARN controller.virtualdatabase.MySQL5 Stored
procedure 1 failed (Failed to execute request use atrapalo;/ because of
(null))
it seems it cannot even execute the "use $databasename" statement... how can I
debug this?
--
Davide Ferrari
System Administrator
http://www.atrapalo.com
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
