Hi there,
I'm currently trying to build up a postgres cluster with two
controllers. Each of them have one backend. In case of failure one of
them the other should work.
Both have an redolog. But I can't restore the dump of tbn-01 on tbn-02.
I've done the following steps on controller 1:
> initialize tbn-01
> backup tbn-01 init-dump Octopus init-dump
> enable tbn-01
> transfer dump init-dump tbn-01:1090
> expert on
> restore log init-dump tbn-01:1090
After that I've done the following on controller 2:
> show dumps
(It was there)
> restore backend tbn-02 init-dump
> enable tbn-02
While "restore backend tbn-02 init-dump" I got those errors:
09:25:03,599 INFO backup.backupers.OctopusBackuper Starting restore of
backend tbn-02 from checkpoint init-dump
Default (Standard) Logger is load.
OctopusGenerator started.
CreateIncludeFiles is started. Generating sql and xml files is started.
createIncludeFiles method is started.
Working....test
done...
createIncludeFiles method is finished.
CreateIncludeFiles is finished. Generating sql and xml files is finished.
Generating of LoaderJob.olj file is started.
loadJobWriter method is started.
loadJobWriter method is finished.
Generating of LoaderJob.olj file is finished.
Duration: 0,117 seconds
OctopusGenerator finished.
Default (Standard) Logger is load.
Application is started.
Loader loads XML file : init-dump/init-dump/LoaderJob.olj
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropIntegrity.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropIntegrity.sql
(No such file or directo
ry)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropIntegrity.sql
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropTables.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropTables.sql
(No such file or directory)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/DropTables.sql
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateTables.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateTables.sql
(No such file or director
y)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateTables.sql
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIndex.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIndex.sql
(No such file or directory
)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIndex.sql
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreatePrimary.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreatePrimary.sql
(No such file or directo
ry)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreatePrimary.sql
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIntegrity.sql
java.io.FileNotFoundException:
/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIntegrity.sql
(No such file or direc
tory)
Document not found:
file:/tbn/sequoia-2.10.2-bin/bin/init-dump/init-dump/init-dump/SQLForAllVendors/Csv/sql/CreateIntegrity.sql
XML document is valid.
All rows are commited.
Application is finished.
All jobs duration: 0,474 seconds
09:25:04,511 INFO controller.RequestManager.tbn Recovery of backend
tbn-02 done.
The configuration for Octopus in both controllers are:
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
I'm pretty sure that this is a commonly used feature so I'm really
surprised that this happens.
I've tested it with c-jdbc 2.x, sequoia 2.10.2 and also sequoia 3.x beta1
Has anybody an idea?
Thanks for your help.
Marc
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
