start ..\bin\console.bat -p 1090 -f init_controller1.script
The first few commands work (making a backup), but restoring the backup to
the second backend doesn't work. I get error at the bottom of this message. Why
doesn't it work?
Tnx for your help.
Igor
------------------------------------------------------------------------------------------------------------------------------
17:42:08,977 INFO controller.RequestManager.myDB Backup has
completed.
17:42:09,102 INFO backend.DatabaseBackend.localhost1
Detected backend as: HSQL Database Engine
17:42:09,118 WARN
backend.DatabaseBackend.localhost1 Statement.getGeneratedKeys not
supported.
17:42:09,555 INFO controller.RequestManager.myDB Setting new
virtual database schema.
17:42:09,586 INFO
controller.recoverylog.RecoverThread Starting recovery
17:42:09,946
INFO controller.RequestManager.myDB All activity is suspended for
myDB
17:42:09,961 INFO controller.recoverylog.RecoverThread Recovery
completed
17:42:10,071 INFO controller.recoverylog.RecoverThread
Database backend localhost1 is now enabled
17:42:10,243 INFO
backup.backupers.OctopusBackuper Starting restore of backend localhost2 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.
17:42:10,477 ERROR backup.backupers.OctopusBackuper Error while performing
restore operation on backend
localhost2
org.webdocwf.util.loader.LoaderException: Exception in method
generate() in LoaderGenerator class!
Exception:Error while create include
files.
at
org.webdocwf.util.loader.generator.LoaderGenerator.generate(Unknown
Source)
at
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper.callOctopusLoader(OctopusBackuper.java:451)
at
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper.restore(OctopusBackuper.java:322)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2911)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2598)
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)
Caused by:
org.webdocwf.util.loader.LoaderException: Exception:Error while create include
files.
at
org.webdocwf.util.loader.generator.CreateIncludeFiles.<init>(Unknown
Source)
... 35 more
Caused by:
org.webdocwf.util.loader.LoaderException:
Exception:
at
org.webdocwf.util.loader.generator.CreateIncludeFiles.createIncludeFiles(Unknown
Source)
... 36 more
Caused by:
java.lang.Exception: There is no tables in specified source database. Check
input parameters.
... 37
more
java.lang.Throwable
at
org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Source)
at
org.continuent.sequoia.common.exceptions.SequoiaException.printStackTrace(SequoiaException.java:174)
at
org.apache.log4j.spi.ThrowableInformation.getThrowableStrRep(ThrowableInformation.java:59)
at
org.apache.log4j.spi.LoggingEvent.getThrowableStrRep(LoggingEvent.java:342)
at
org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:304)
at
org.apache.log4j.WriterAppender.append(WriterAppender.java:159)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at
org.apache.log4j.Category.callAppenders(Category.java:203)
at
org.apache.log4j.Category.forcedLog(Category.java:388)
at
org.apache.log4j.Category.error(Category.java:319)
at
org.continuent.sequoia.common.log.Trace.error(Trace.java:105)
at
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper.restore(OctopusBackuper.java:366)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2911)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2598)
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)
17:42:10,492 ERROR
controller.RequestManager.myDB Recovery could not
complete
org.webdocwf.util.loader.LoaderException: Exception in method
generate() in LoaderGenerator class!
Exception:Error while create include
files.
at
org.webdocwf.util.loader.generator.LoaderGenerator.generate(Unknown
Source)
at
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper.callOctopusLoader(OctopusBackuper.java:451)
at
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper.restore(OctopusBackuper.java:322)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2911)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2598)
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)
Caused by:
org.webdocwf.util.loader.LoaderException: Exception:Error while create include
files.
at
org.webdocwf.util.loader.generator.CreateIncludeFiles.<init>(Unknown
Source)
... 35 more
Caused by:
org.webdocwf.util.loader.LoaderException:
Exception:
at
org.webdocwf.util.loader.generator.CreateIncludeFiles.createIncludeFiles(Unknown
Source)
... 36 more
Caused by:
java.lang.Exception: There is no tables in specified source database. Check
input parameters.
... 37
more
java.lang.Throwable
at
org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Source)
at
org.continuent.sequoia.common.exceptions.SequoiaException.printStackTrace(SequoiaException.java:174)
at
org.continuent.sequoia.common.exceptions.SequoiaException.printStackTrace(SequoiaException.java:174)
at
org.apache.log4j.spi.ThrowableInformation.getThrowableStrRep(ThrowableInformation.java:59)
at
org.apache.log4j.spi.LoggingEvent.getThrowableStrRep(LoggingEvent.java:342)
at
org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:304)
at
org.apache.log4j.WriterAppender.append(WriterAppender.java:159)
at
org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
at
org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
at
org.apache.log4j.Category.callAppenders(Category.java:203)
at
org.apache.log4j.Category.forcedLog(Category.java:388)
at
org.apache.log4j.Category.error(Category.java:319)
at
org.continuent.sequoia.common.log.Trace.error(Trace.java:105)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.restoreBackendFromBackupCheckpoint(RequestManager.java:2921)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.restoreDumpOnBackend(VirtualDatabase.java:2598)
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)
17:42:10,492 INFO
controller.RequestManager.myDB Recovery of backend localhost2
done.
17:42:11,055 INFO controller.RequestManager.myDB All activity is
suspended for myDB
17:42:11,102 INFO controller.virtualdatabase.myDB
Checkpoint now-127.0.0.1:25322-20061013174210946+0200 was stored
17:42:11,102
WARN controller.virtualdatabase.myDB No information has been found for
remote controller Member(address=/192.168.0.226:2719:2719,
uid=my
DB)