Hi, Guillaume.
Can you check that after the restore, the database has been
successfully created and you have all the content you're waiting for
in it?
Not all contents, only contents of dump file.
Can you also check that after the restore, the new database (if it has
been successfully created) is still accessible with the user and
password you use for your JDBC connection?
It is still accessible.
Should enable command to replay contents of recovery log or I should do that
by
another command?
LOG:
Starting:
17:03:24,500 INFO controller.core.Controller Sequoia controller (3.0-beta2)
17:03:24,843 INFO controller.core.Controller Loading configuration file:
xml\pcController.xml
17:03:25,031 INFO controller.core.Controller JMX is enabled
17:03:25,093 INFO controller.core.Controller Starting JMX server on host:
192.168.0.2:1090
17:03:25,968 INFO controller.backup.BackupManager Registering backuper
MSSQLServer to handle format MSSQL raw dump
17:03:26,000 INFO backend.DatabaseBackend.mainPCDB Adding connection
manager for virtual user "sa"
17:03:26,796 INFO sequoia.controller.recoverylog Creating recovery log
table: RECOVERY
17:03:26,953 INFO sequoia.controller.recoverylog Creating checkpoint table:
CHECKPOINT
17:03:26,953 INFO sequoia.controller.recoverylog Creating backend table:
BACKEND
17:03:26,968 INFO sequoia.controller.recoverylog Creating dump table: DUMP
17:03:27,046 INFO controller.RequestManager.VirtualDatabase Request manager
will parse requests with the following granularity: TABLE
17:03:27,078 INFO controller.virtualdatabase.VirtualDatabase Using Hedera
properties file: /hedera_appia.properties
17:03:27,406 INFO appia.xml.AppiaXML Loading XML configuration from file:
C:\sequoia\config\my_appia.xml
17:03:27,921 INFO continuent.hedera.appia AppiaThread: Starting Appia.
17:03:30,062 INFO controller.virtualdatabase.VirtualDatabase Group
VirtualDatabase connected to Member(address=/192.168.0.2:3982, uid=
192.168.0.2:3982)
17:03:30,062 INFO controller.virtualdatabase.VirtualDatabase Group now
contains 2 controllers.
17:03:30,062 INFO controller.virtualdatabase.VirtualDatabase Checking
virtual database configuration with remote controllers.
17:03:30,203 INFO controller.virtualdatabase.VirtualDatabase Updating
backend list for controller Member(address=/192.168.0.3:1227, uid=
192.168.0.3:1227)
17:03:30,218 WARN controller.virtualdatabase.VirtualDatabase Some virtual
database users are missing from this configuration, trying to create them
transparently...
17:03:30,218 INFO controller.virtualdatabase.VirtualDatabase Virtual
database configuration is compatible with other controllers.
17:03:30,218 INFO controller.virtualdatabase.VirtualDatabase Controller
identifier is set to: 1
17:03:30,265 INFO controller.virtualdatabase.VirtualDatabase Resyncing
recovery log ...
17:03:30,265 INFO controller.virtualdatabase.VirtualDatabase No shutdown
checkpoint found in recovery log. Clearing recovery log (dirty).
17:03:30,265 INFO controller.virtualdatabase.VirtualDatabase Please resync
manually using 'recover log'.
17:03:30,281 INFO controller.virtualdatabase.VirtualDatabase Resyncing
recovery log done
17:03:30,281 WARN controller.virtualdatabase.VirtualDatabase Cannot enable
backend mainPCDB from a known state. Resynchronize this backend by restoring
a dump.
17:03:30,281 INFO controller.core.Controller Adding VirtualDatabase
VirtualDatabase
17:03:30,312 INFO controller.core.Controller Waiting for connections on
0.0.0.0:25322
17:03:30,312 INFO controller.core.Controller Controller started on
2007.01.31 05 at 05:03:30 PM EET
17:03:30,312 INFO controller.core.Controller Controller mainPCController
ready, listening to requests ...
Initializing, backup to init_dump, enabling backend
17:03:48,828 INFO controller.RequestManager.VirtualDatabase Starting backup
of backend mainPCDB
17:03:59,406 INFO controller.RequestManager.VirtualDatabase Backup has
completed.
17:03:59,656 INFO backend.DatabaseBackend.mainPCDB Detected backend as:
Microsoft SQL Server
17:05:20,609 INFO controller.RequestManager.VirtualDatabase Setting new
virtual database schema.
17:05:20,640 INFO controller.recoverylog.RecoverThread Starting recovery
17:05:20,718 INFO controller.RequestManager.VirtualDatabase All activity is
suspended for VirtualDatabase
17:05:20,718 INFO controller.recoverylog.RecoverThread Recovery completed
17:05:29,484 INFO controller.recoverylog.RecoverThread Database backend
mainPCDB is now enabled
17:05:57,453 ERROR controller.virtualdatabase.VirtualDatabase
org.continuent.sequoia.common.exceptions.ControllerException: Remote dump
'init_dump' already exists.
17:05:57,562 INFO controller.RequestManager.VirtualDatabase All activity is
suspended for VirtualDatabase
17:05:57,593 INFO controller.virtualdatabase.VirtualDatabase Checkpoint
now-mainPCController-20070131170557531+0200 was stored
17:05:57,593 WARN controller.virtualdatabase.VirtualDatabase No information
has been found for remote controller Member(address=/192.168.0.2:3982, uid=
192.168.0.2:3982)
17:06:40,328 INFO controller.virtualdatabase.VirtualDatabase Checkpoint
disable slavePCDB-slavePCController-20070131170647250+0200 was stored
17:06:40,359 INFO controller.virtualdatabase.VirtualDatabase Backend
slavePCDB disabled on controller Member(address=/192.168.0.3:1227, uid=
192.168.0.3:1227)
17:11:12,015 INFO controller.RequestManager.VirtualDatabase All activity is
suspended for VirtualDatabase
Creating table "Table_1"
Creating dump_1:
17:11:12,062 INFO controller.virtualdatabase.VirtualDatabase Checkpoint
backup dump_1-mainPCController-20070131171112000+0200 was stored
17:11:12,062 INFO controller.virtualdatabase.VirtualDatabase Disabling
backend mainPCDB, waiting for current transaction to complete on this
backend
17:11:12,078 INFO controller.RequestManager.VirtualDatabase Setting new
virtual database schema.
17:11:12,093 INFO sequoia.controller.connection 5 connections freed on
"jdbc:jtds:sqlserver://192.168.0.2/VirtualDatabase"
17:11:12,312 INFO controller.virtualdatabase.VirtualDatabase Backend
mainPCDB is now disabled
17:11:12,343 WARN controller.virtualdatabase.VirtualDatabase Updating
backend list with unknown backend mainPCDB disabled on controller
Member(address=/192.168.0.2:3982, uid=192.168.0.2:3982)
17:11:12,375 INFO controller.RequestManager.VirtualDatabase Backend
mainPCDB is now disabled
17:11:12,390 INFO controller.RequestManager.VirtualDatabase Starting backup
of backend mainPCDB
17:11:14,640 INFO controller.RequestManager.VirtualDatabase Backup has
completed.
17:11:14,781 INFO controller.recoverylog.RecoverThread Starting recovery
17:11:14,812 INFO controller.RequestManager.VirtualDatabase All activity is
suspended for VirtualDatabase
17:11:14,828 INFO controller.recoverylog.RecoverThread Recovery completed
17:11:22,562 INFO controller.recoverylog.RecoverThread Database backend
mainPCDB is now enabled
Stopping MS SQL Service
Creating table "Table test":
17:19:26,562 ERROR sequoia.controller.connection Backend mainPCDB is no more
accessible.
17:19:26,718 INFO controller.RequestManager.VirtualDatabase Setting new
virtual database schema.
17:19:26,765 ERROR controller.RequestManager.VirtualDatabase Request create
table Table_test (ID bigint)/ failed on all local backends but succeeded on
other controllers. Disabling all local backends.
Starting MS SQL Service
Drop Virtual Database directly from SQl Server
Recovering from dump_1:
17:24:08,250 INFO controller.RequestManager.VirtualDatabase Recovery of
backend mainPCDB done.
Database appears with only one table instead of two( "Table_1" is there,
"Table_test" is missing)
Enabling backend:
17:27:05,656 ERROR backend.DatabaseBackend.mainPCDB Unable to get a
connection to gather database schema.
17:27:05,671 WARN backend.DatabaseBackend.mainPCDB Unable to gather schema
from database meta data: java.sql.SQLException: Failed to get information
about database schema: java.sql.SQLException: Unable to get a connection to
gather database schema.
17:27:05,687 ERROR backend.DatabaseBackend.mainPCDB Unable to get a
connection to gather database schema.
17:27:05,687 WARN backend.DatabaseBackend.mainPCDB Unable to gather schema
from database meta data: java.sql.SQLException: Failed to get information
about database schema: java.sql.SQLException: Unable to get a connection to
gather database schema.
17:27:05,687 WARN controller.virtualdatabase.VirtualDatabase Backend
mainPCDB has no defined schema.
Contents of recovery log:
................
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND
CHECKPOINT_NAME='Initial_empty_recovery_log'
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',6,'')
SET AUTOCOMMIT TRUE
INSERT INTO DUMP VALUES('init_dump','2007-01-31
17:03:59.390000000','\tmp','MSSQL
raw dump','Initial_empty_recovery_log','mainPCDB','*')
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=6 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND
VALUES('VirtualDatabase','mainPCDB',3,'Initial_empty_recovery_log')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND
CHECKPOINT_NAME='Initial_empty_recovery_log'
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',7,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=7 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',7,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=7 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',2,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=2 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',1,'')
SET AUTOCOMMIT TRUE
INSERT INTO CHECKPOINT
VALUES('now-mainPCController-20070131170557531+0200',0)
INSERT INTO CHECKPOINT VALUES('disable
slavePCDB-slavePCController-20070131170647250+0200',0)
INSERT INTO RECOVERY VALUES(1,'sa','create table Table_1 (ID bigint,NAME
varchar(50), EMAIL varchar(50),TEXT1 varchar(50),TEXT2 varchar(50),TEXT3
varchar(50),TEXT4 varchar(50),TEXT5
varchar(50))','','A',0,281474976710657,'E',406,0,-1)
SET AUTOCOMMIT FALSE
DELETE FROM RECOVERY WHERE LOG_ID=1
INSERT INTO RECOVERY VALUES(1,'sa','create table Table_1 (ID bigint,NAME
varchar(50), EMAIL varchar(50),TEXT1 varchar(50),TEXT2 varchar(50),TEXT3
varchar(50),TEXT4 varchar(50),TEXT5
varchar(50))','','A',0,281474976710657,'S',2266,0,1)
SET AUTOCOMMIT TRUE
INSERT INTO RECOVERY VALUES(2,'sa','select * from
Table_1','','A',0,281474976710658,'E',43531,0,-1)
SET AUTOCOMMIT FALSE
DELETE FROM RECOVERY WHERE LOG_ID=2
INSERT INTO RECOVERY VALUES(2,'sa','select * from
Table_1','','A',0,281474976710658,'S',45625,0,2)
SET AUTOCOMMIT TRUE
INSERT INTO CHECKPOINT VALUES('backup
dump_1-mainPCController-20070131171112000+0200',2)
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=1 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',5,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=5 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',3,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',3,'backup
dump_1-mainPCController-20070131171112000+0200')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND CHECKPOINT_NAME='backup
dump_1-mainPCController-20070131171112000+0200'
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',6,'')
SET AUTOCOMMIT TRUE
INSERT INTO DUMP VALUES('dump_1','2007-01-31 17:11:14.640000000','\tmp','MSSQL
raw dump','backup
dump_1-mainPCController-20070131171112000+0200','mainPCDB','*')
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=6 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',3,'backup
dump_1-mainPCController-20070131171112000+0200')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND CHECKPOINT_NAME='backup
dump_1-mainPCController-20070131171112000+0200'
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',7,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=7 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',7,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=7 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',2,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=2 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',1,'')
SET AUTOCOMMIT TRUE
INSERT INTO RECOVERY VALUES(3,'sa','create table Table_test (ID
bigint)','','A',0,281474976710659,'E',31,0,-1)
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=1 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',3,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM RECOVERY WHERE LOG_ID=3
INSERT INTO RECOVERY VALUES(3,'sa','create table Table_test (ID
bigint)','','A',0,281474976710659,'S',0,0,3)
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',4,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=4 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',4,'')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=4 AND CHECKPOINT_NAME=''
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',3,'backup
dump_1-mainPCController-20070131171112000+0200')
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT FALSE
DELETE FROM BACKEND WHERE DATABASE_NAME='VirtualDatabase' AND
BACKEND_NAME='mainPCDB' AND BACKEND_STATE=3 AND CHECKPOINT_NAME='backup
dump_1-mainPCController-20070131171112000+0200'
INSERT INTO BACKEND VALUES('VirtualDatabase','mainPCDB',7,'')
SET AUTOCOMMIT TRUE
--
Best regards,
Denis Garyachy.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
