|
I have some problems when I use a postgres (8.1)
database on Windows and using the PostgreSQLTarBackuper.
Problem 1: I have to set the database user to trusted in pg_hba.conf so
pg_dump doesn't have to fill in a password. If I don't do this, the controller
and console will hang because pg_dump will wait for a password. (maybe building
in a timeout when executing external commands would be nice). This will also be
a problem for the other postgres backuper classes (I think) because they all use
the AbstractPostgreSQLBackuper class.
Problem 2: When I restore a dump, the output will give me an exception
telling me that the restore wasn't successfully. Well it isn't really
a problem (I think) because the database and tables are created and the tables
are populated. The command that didn't succeed is "PROCEDURAL LANGUAGE plpgsql;"
because of "language "plpgsql" already exists". So doesn't look like a
problem to me. Sequoia will only think it hasn't succeeded because of this.
Maybe someone knows a fix for this?
Igor
-----------------------------------------
11:25:45,162 INFO backup.backupers.NativeCommandExec Command
"pg_restore -h localhost -p 5432 -U izemail --format=t -d izemail2
\tmp\backup\init_dump
.tar izemail2" logged 5 errors and terminated with exitcode 1 11:25:45,162 INFO backup.backupers.AbstractPostgreSQLBackuper pg_restore: [archiver (db)] Error while PROCESSING TOC: 11:25:45,178 INFO backup.backupers.AbstractPostgreSQLBackuper pg_restore: [archiver (db)] Error from TOC entry 248; 2612 16386 PROCEDURAL LANGUAGE pl pgsql 11:25:45,178 INFO backup.backupers.AbstractPostgreSQLBackuper pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists 11:25:45,193 INFO backup.backupers.AbstractPostgreSQLBackuper Command was: CREATE PROCEDURAL LANGUAGE plpgsql; 11:25:45,193 INFO backup.backupers.AbstractPostgreSQLBackuper WARNING: errors ignored on restore: 1 11:25:45,193 ERROR backup.backupers.PostgreSQLTarBackuper Error while performing backup org.continuent.sequoia.common.exceptions.BackupException: pg_restore execution did not complete successfully! at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Unknown Source) at java.lang.Exception.<init>(Unknown Source) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.BackupException.<init>(BackupException.java:50) at org.continuent.sequoia.controller.backup.backupers.PostgreSQLTarBackuper.restore(PostgreSQLTarBackuper.java:376) at org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2921) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2608) at org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:488) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(Unknown Source) at javax.management.StandardMBean.invoke(Unknown Source) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) 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(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$100(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 11:25:45,365 ERROR controller.RequestManager.myDB Recovery could not complete org.continuent.sequoia.common.exceptions.BackupException: pg_restore execution did not complete successfully! at org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103) at java.lang.Throwable.<init>(Unknown Source) at java.lang.Exception.<init>(Unknown Source) at org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57) at org.continuent.sequoia.common.exceptions.BackupException.<init>(BackupException.java:50) at org.continuent.sequoia.controller.backup.backupers.PostgreSQLTarBackuper.restore(PostgreSQLTarBackuper.java:376) at org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2921) at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2608) at org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:488) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(Unknown Source) at javax.management.StandardMBean.invoke(Unknown Source) at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) 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(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$100(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.lang.Thread.run(Unknown Source) -----------------------------------------
|
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
