Hello,
I trying to use PostgreSQLBinaryBAckuper with postgresql server 8.3
hosted under linux. But I have problems when restoring dumps with them.
The log messages are :
2008-12-22 11:34:27,687 DEBUG backup.backupers.PostgreSQLBinaryBackuper
Restoring database 'xxx' on host '192.168.0.236:5432'
2008-12-22 11:34:27,688 INFO backup.backupers.PostgreSQLBinaryBackuper
Performing database operations using authentication
2008-12-22 11:34:27,688 DEBUG backup.backupers.PostgreSQLBinaryBackuper
Dropping database 'xxx'
2008-12-22 11:34:27,703 WARN backup.backupers.NativeCommandExec Native
command I/O failed: command=expect -
java.io.IOException: Cannot run program "expect": java.io.IOException:
error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:459)
at java.lang.Runtime.exec(Runtime.java:593)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.executeNativeCommand(NativeCommandExec.java:460)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand0(NativeCommandExec.java:248)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand(NativeCommandExec.java:204)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand(NativeCommandExec.java:216)
at
org.continuent.sequoia.controller.backup.backupers.AbstractPostgreSQLBackuper.safelyExecNativeCommand(AbstractPostgreSQLBackuper.java:502)
at
org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper.restore(PostgreSQLBinaryBackuper.java:215)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:3056)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2742)
at
org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:501)
...
Caused by: java.io.IOException: java.io.IOException: error=2, No such
file or directory
at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
at java.lang.ProcessImpl.start(ProcessImpl.java:65)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:452)
... 44 more
2008-12-22 11:34:27,708 INFO backup.backupers.NativeCommandExec Process
output (stdout):
2008-12-22 11:34:27,711 INFO backup.backupers.NativeCommandExec Process
output (stderr):
2008-12-22 11:34:27,712 WARN backup.backupers.PostgreSQLBinaryBackuper
Unable to drop database prior to restore
2008-12-22 11:34:27,712 DEBUG backup.backupers.PostgreSQLBinaryBackuper
Re-creating 'xxx'
2008-12-22 11:34:27,723 WARN backup.backupers.NativeCommandExec Native
command I/O failed: command=expect -
java.io.IOException: Cannot run program "expect": java.io.IOException:
error=2, No such file or directory
at java.lang.ProcessBuilder.start(ProcessBuilder.java:459)
at java.lang.Runtime.exec(Runtime.java:593)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.executeNativeCommand(NativeCommandExec.java:460)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand0(NativeCommandExec.java:248)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand(NativeCommandExec.java:204)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.safelyExecNativeCommand(NativeCommandExec.java:216)
at
org.continuent.sequoia.controller.backup.backupers.AbstractPostgreSQLBackuper.safelyExecNativeCommand(AbstractPostgreSQLBackuper.java:502)
at
org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper.restore(PostgreSQLBinaryBackuper.java:230)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:3056)
...
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: java.io.IOException: error=2, No such
file or directory
at java.lang.UNIXProcess.<init>(UNIXProcess.java:148)
at java.lang.ProcessImpl.start(ProcessImpl.java:65)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:452)
... 44 more
2008-12-22 11:34:27,726 INFO backup.backupers.NativeCommandExec Process
output (stdout):
2008-12-22 11:34:27,727 INFO backup.backupers.NativeCommandExec Process
output (stderr):
2008-12-22 11:34:27,728 ERROR backup.backupers.PostgreSQLBinaryBackuper
Error while performing backup
org.continuent.sequoia.common.exceptions.BackupException: createdb
execution did not complete successfully!
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
...
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
2008-12-22 11:34:27,737 ERROR controller.RequestManager.xxx Recovery
could not complete
org.continuent.sequoia.common.exceptions.BackupException: createdb
execution did not complete successfully!
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
Thank you for your help.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
