I just downloaded sequoia 2.10.10 for trial. I setup a 2-controller distribution and I would like to see how the shutdown controller recovery from graceful shutdown. During the startup of the shutdown controller, it was trying to replay the recovery log from the other controller but it failed.
Here is the log message:
2008-08-22 18:31:12,011 WARN controller.virtualdatabase.testDB Virtual
database testDB failed to enable database backend mysql-ape22 from
checkpoint (because of : java.sql.SQLException: Recovery process failed to
replay: request Autocommit StatementExecuteUpdateTask 562949953421313
(insert into tenant values (4, 'tenant0004', 40)) (Backend testDB -
BackendWorkerThread for backend 'mysql-ape22' with RAIDb level:1 failed
(null)))
java.sql.SQLException: Recovery process failed to replay: request Autocommit
StatementExecuteUpdateTask 562949953421313 (insert into tenant values (4,
'tenant0004', 40)) (Backend testDB - BackendWorkerThread for backend
'mysql-ape22' with RAIDb level:1 failed (null))
at
org.continuent.sequoia.controller.recoverylog.RecoverThread.waitForAllTasksC
ompletion(RecoverThread.java:625)
at
org.continuent.sequoia.controller.recoverylog.RecoverThread.run(RecoverThrea
d.java:272)
2008-08-22 18:31:12,012 WARN controller.core.Controller Failed to
automatically enable backends, manual resynchronization is probably needed
2008-08-22 18:31:12,012 INFO controller.core.Controller Adding
VirtualDatabase testDB
Have anyone tried similar steps as follows:
1) Bring up a 2-controller distribution.
2) Initialize and enable the backend of the VD of controller 1.
3) Transfer the dump from controller 1 to the other by using admin
console.
4) Enable controller 2 VD backends.
5) Use iSQL, connect to sequoia driver and insert one new entry via the
sequoia driver.
6) Everything is ok so far. New entry entered to both backends.
Recovery log showed new entry.
7) Shutdown VD on controller 2 and then shutdown controller 2 graceful by
using admin console.
8) Use iSQL, connect to sequoia driver and insert another entry.
9) Start controller 2 again.
The database I'm using is MySQL 5.
I greatly appreciate your pointer. Thanks.
Zoe
<<attachment: winmail.dat>>
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
