Denis,
1. I am experiencing the problem with transferring dump from one
controller to another.
Yes, this seems explained by an error message in the log (see below).
2. There is something strange with time stamps. I 've marked it in log
and here I present interesting lines:
"14:59:08,046 DEBUG continuent.hedera.adapters Replying to
Member(address=/192.168.0.3:1409, uid=192.168.0.3:1409
<http://192.168.0.3:1409> ) for message 1
Transferring dump to second controller:
14:56:36,687 DEBUG continuent.hedera.adapters Received reply from
Member(address=/192.168.0.2:1173, uid=192.168.0.2:1173
<http://192.168.0.2:1173>) to message 1"
It was 14:59 and then became 14:56
You may have either something in your crontab or an NTP daemon that
readjusted the clock when 15:00 was reached. This is not an issue for
Sequoia but a 4 minute drift is quite significant.
Please look at the next log.
15:01:00,687 ERROR controller.virtualdatabase.VirtualDatabase
org.continuent.sequoia.common.exceptions.ControllerException: Invalid
dump name: init_dump
It seems that the dump you are trying to transfer is not valid.
Note that if the backup process did not complete successfully, then the
dump transfer will not be successful.
I am not sure that the MSSQLBackuper is capable of dump transfers. It
uses 'BACKUP DATABASE vdb TO DISK = path'
We don't really know what is the format of the dump on disk so you
should probably use a shared directory to store the dump (SMB mount or
something alike). Then you can just use the 'nocopy' option of transfer
dump to transfer it to the other controller, this will just copy the
metadata and point to the same location on disk.
The restore operation on the other controller will then restore the dump
from the shared directory.
I think that this backuper was initially developed by Adam Fletcher and
Mykola Paliyenko, maybe they could provide more details. But I think you
need a network share for the dumps with this backuper.
Thanks for the feedback,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
