Hello Again/all
Sorry for creating noise on the list. Here is my latest finding. Again
I'm sure this is something I am doing wrong, but I am seeing the
following when going thru the basic administrative functions in the
documentation found online. Any and all help is appreciated.
localhost:1090 > admin SQA_VIASDSYDB
Virtual database Administrator Login > root
Virtual database Administrator Password >
Ready to administrate virtual database SQA_VIASDSYDB
SQA_VIASDSYDB(root) > show backupers
+-------------------+----------------+
| Backuper | Dump Format |
+-------------------+----------------+
| BKUP_SQA_IASDSYDB | MySQL raw dump |
+-------------------+----------------+
SQA_VIASDSYDB(root) > backup DB1 DB1_second_dump BKUP_SQA_IASDSYDB
/root/
Backend login for backup process > root
Backend password for backup process >
Backup backend DB1 in dump file DB1_second_dump
SQA_VIASDSYDB(root) > show dumps
+------------------+----------------------------------------------------
---------------+----------------+--------+-----------------+---------+--
------+
| Name | Checkpoint
| Format | Path | Date | Backend | Tables |
+------------------+----------------------------------------------------
---------------+----------------+--------+-----------------+---------+--
------+
| DB1_second_dump | backup
DB1_second_dump-192.168.61.14:25322-20080227160412243-0500 | MySQL raw
dump | /root/ | 2/27/08 4:04 PM | DB1 | * |
| DB1_initial_dump | Initial_empty_recovery_log
| MySQL raw dump | /root/ | 2/27/08 3:56 PM | DB1 | * |
+------------------+----------------------------------------------------
---------------+----------------+--------+-----------------+---------+--
------+
SQA_VIASDSYDB(root) > restore backend DB2 DB1_second_dump
Backend login for restore process > root
Backend password for restore process >
Restoring backend DB2 with dump DB1_second_dump
Unable to restore a dump on an active backend. Disable the backend
first.
SQA_VIASDSYDB(root) > disable DB2
Disabling backend DB2 with automatic checkpoint.
SQA_VIASDSYDB(root) > restore backend DB2 DB1_second_dump
Backend login for restore process > root
Backend password for restore process >
Restoring backend DB2 with dump DB1_second_dump
SQA_VIASDSYDB(root) > enable DB2
Enabling backend DB2 from its last known checkpoint
Virtual database SQA_VIASDSYDB failed to enable database backend DB2
from checkpoint (because of : java.sql.SQLException: Unable to get
checkpoint from recovery log.)
SQA_VIASDSYDB(root) >
Console Output:
16:05:08,076 ERROR sequoia.controller.recoverylog Logger thread was
unable to log Storing checkpoint disable
DB2-192.168.61.14:25322-20080227160508068-0500 with id 0 because of
java.sql.SQLException: Unable to store checkpoint disable
DB2-192.168.61.14:25322-20080227160508068-0500 in recovery log database
(Data truncation: Data too long for column 'name' at row 1)
java.sql.SQLException: Unable to store checkpoint disable
DB2-192.168.61.14:25322-20080227160508068-0500 in recovery log database
(Data truncation: Data too long for column 'name' at row 1)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.storeCheckpoi
ntWithLogId(LoggerThread.java:398)
at
org.continuent.sequoia.controller.recoverylog.events.StoreCheckpointWith
LogIdEvent.execute(StoreCheckpointWithLogIdEvent.java:69)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:05:08,076 INFO controller.RequestManager.SQA_VIASDSYDB Disabling
backend DB2, waiting for current transaction to complete on this backend
16:05:08,076 INFO controller.RequestManager.SQA_VIASDSYDB Resume
pending writes
16:05:08,083 ERROR controller.backend.BackendStateListener Could not
store information for backend: DB2
java.sql.SQLException: Unable to get checkpoint disable
DB2-192.168.61.14:25322-20080227160508068-0500 from the recovery log
(Checkpoint disable DB2-192.168.61.14:25322-20080227160508068-0500 does
not exist in recovery log)
at
org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdE
vent.execute(GetCheckpointLogIdEvent.java:96)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:05:08,084 INFO controller.RequestManager.SQA_VIASDSYDB Setting new
virtual database schema.
16:05:08,086 INFO sequoia.controller.connection 5 connections freed on
"jdbc:mysql://192.168.61.14:3306/DB2_iasdsydb"
16:05:08,171 INFO controller.RequestManager.SQA_VIASDSYDB Backend DB2
is now disabled
16:05:11,804 INFO backup.backupers.NativeCommandExec Starting execution
of "mysqladmin -h 192.168.61.14 --port=3306 -f -uroot --password= drop
DB2_iasdsydb"
16:05:11,810 INFO backup.backupers.NativeCommandExec Command
"mysqladmin -h 192.168.61.14 --port=3306 -f -uroot --password= drop
DB2_iasdsydb" logged 0 errors and terminated with exitcode 0
16:05:11,822 INFO backup.backupers.NativeCommandExec Starting execution
of "mysqladmin -h 192.168.61.14 --port=3306 -f -uroot --password= create
DB2_iasdsydb"
16:05:11,827 INFO backup.backupers.NativeCommandExec Command
"mysqladmin -h 192.168.61.14 --port=3306 -f -uroot --password= create
DB2_iasdsydb" logged 0 errors and terminated with exitcode 0
16:05:11,839 INFO backup.backupers.NativeCommandExec Starting execution
of "mysql -h 192.168.61.14 --port=3306 -uroot --password= DB2_iasdsydb"
16:05:11,846 INFO backup.backupers.NativeCommandExec Command "mysql -h
192.168.61.14 --port=3306 -uroot --password= DB2_iasdsydb" logged 0
errors and terminated with exitcode 0
16:05:11,848 ERROR controller.backend.BackendStateListener Could not
store information for backend: DB2
java.sql.SQLException: Unable to get checkpoint backup
DB1_second_dump-192.168.61.14:25322-20080227160412243-0500 from the
recovery log (Checkpoint backup
DB1_second_dump-192.168.61.14:25322-20080227160412243-0500 does not
exist in recovery log)
at
org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdE
vent.execute(GetCheckpointLogIdEvent.java:96)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:05:11,849 INFO controller.RequestManager.SQA_VIASDSYDB Recovery of
backend DB2 done.
16:05:14,842 INFO controller.RequestManager.SQA_VIASDSYDB Setting new
virtual database schema.
16:05:14,844 ERROR controller.recoverylog.RecoverThread Unable to get
checkpoint from recovery log.
java.sql.SQLException: Unable to get checkpoint backup
DB1_second_dump-192.168.61.14:25322-20080227160412243-0500 from the
recovery log (Checkpoint backup
DB1_second_dump-192.168.61.14:25322-20080227160412243-0500 does not
exist in recovery log)
at
org.continuent.sequoia.controller.recoverylog.events.GetCheckpointLogIdE
vent.execute(GetCheckpointLogIdEvent.java:96)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThr
ead.java:732)
16:05:14,849 INFO sequoia.controller.connection 10 connections freed on
"jdbc:mysql://192.168.61.14:3306/DB2_iasdsydb"
16:05:14,929 WARN controller.virtualdatabase.SQA_VIASDSYDB Virtual
database SQA_VIASDSYDB failed to enable database backend DB2 from
checkpoint (because of : java.sql.SQLException: Unable to get checkpoint
from recovery log.)
java.sql.SQLException: Unable to get checkpoint from recovery log.
at
org.continuent.sequoia.controller.recoverylog.RecoverThread.run(RecoverT
hread.java:168)
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
