Emmanuel Cecchet a écrit :
Arnaud,
Did you try the pgpass option as described here:
https://forge.continuent.org/pipermail/sequoia/2008-October/006237.html
Keep us posted with your progress,
Emmanuel
Hello ,
I'm progressing but I still have problems. I use the
PostgreSQLPlainTextBackuper like that :
<Backup>
<Backuper backuperName="postgres"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"
options="authentication=true,dumpServer=IP"/>
</Backup>
When I want to restore a dump to a backend, I get the following
stacktrace :
2009-01-05 15:36:21,570 DEBUG
backup.backupers.PostgreSQLPlainTextBackuper Rebuilding 'xxx' from dump
'backup'
2009-01-05 15:36:21,586 INFO backup.backupers.NativeCommandExec
Starting execution of "expect - "
2009-01-05 15:36:21,610 DEBUG backup.backupers.NativeCommandOutputThread
Starting NativeCommandOutputThread: Thread-8
2009-01-05 15:36:21,611 DEBUG backup.backupers.NativeCommandOutputThread
Terminating NativeCommandOutputThread: Thread[Thread-8,5,RMI Runtime]
2009-01-05 15:36:21,619 DEBUG backup.backupers.NativeCommandOutputThread
Starting NativeCommandOutputThread: Thread-9
2009-01-05 15:36:21,620 DEBUG backup.backupers.NativeCommandOutputThread
Terminating NativeCommandOutputThread: Thread[Thread-9,5,RMI Runtime]
2009-01-05 15:36:21,621 WARN backup.backupers.NativeCommandExec Writing
of data to stdin halted by exception
java.io.IOException: Broken pipe
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java:260)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandInputSource.write(NativeCommandInputSource.java:108)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.manageCommandExecution(NativeCommandExec.java:331)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.executeNativeCommand(NativeCommandExec.java:462)
at
org.continuent.sequoia.controller.backup.backupers.NativeCommandExec.executeNativeCommand(NativeCommandExec.java:474)
at
org.continuent.sequoia.controller.backup.backupers.AbstractPostgreSQLBackuper.executeNativeCommand(AbstractPostgreSQLBackuper.java:408)
at
org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper.restore(PostgreSQLPlainTextBackuper.java:290)
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)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:93)
at
com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:27)
at
com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:208)
at com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:120)
at com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:262)
at javax.management.StandardMBean.invoke(StandardMBean.java:391)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
at
com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318)
at
org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127)
at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1426)
at
javax.management.remote.rmi.RMIConnectionImpl.access$200(RMIConnectionImpl.java:72)
at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1264)
at java.security.AccessController.doPrivileged(Native Method)
at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1366)
at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:788)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
2009-01-05 15:36:21,624 INFO backup.backupers.NativeCommandExec Command
"expect - " logged 0 errors and terminated with exitcode 0
2009-01-05 15:36:21,631 INFO controller.RequestManager.mtp Recovery of
backend xxx done.
I think about compatibility problems my version of expect or postgresql ?!
I use expect 5.43.0 and PostgreSQL 8.3.4.
Thanks for your help.
Arnaud GIULIANI.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
