search

nuodb / migration-tools

Migration tools for NuoDB
http://nuodb.github.com/migration-tools/
BSD 3-Clause "New" or "Revised" License
27 stars 10 forks source link

Table "FOO" has been changed #53

Open AmosTrask opened 5 years ago

AmosTrask commented 5 years ago

I am trying to import a previously exported database and I have the following stacktrace.

09-10-2019 08:30:06 (ERROR) (com.nuodb.migrator.jdbc.metadata.generator.ScriptExporterBase.exportScript(ScriptExporterBase.java:57)) - Failed exporting script com.nuodb.migrator.jdbc.metadata.generator.Script@487d769f
09-10-2019 08:30:06 (ERROR) (com.nuodb.migrator.bootstrap.Bootstrap.main(Bootstrap.java:122)) - Execution failed
com.nuodb.migrator.jdbc.session.WorkException: java.sql.SQLTransactionRollbackException: Table FOO has been changed
at com.nuodb.migrator.jdbc.session.SimpleWorkManager.close(SimpleWorkManager.java:181)
at com.nuodb.migrator.backup.loader.SimpleBackupLoaderManager.close(SimpleBackupLoaderManager.java:175)
at com.nuodb.migrator.backup.loader.BackupLoader.load(BackupLoader.java:373)
at com.nuodb.migrator.backup.loader.BackupLoader.load(BackupLoader.java:172)
at com.nuodb.migrator.backup.loader.BackupLoader.load(BackupLoader.java:162)
at com.nuodb.migrator.backup.loader.BackupLoader.load(BackupLoader.java:158)
at com.nuodb.migrator.load.LoadJob.execute(LoadJob.java:112)
at com.nuodb.migrator.job.SimpleJobExecutor.execute(SimpleJobExecutor.java:114)
at com.nuodb.migrator.Migrator.execute(Migrator.java:79)
at com.nuodb.migrator.Migrator.execute(Migrator.java:69)
at com.nuodb.migrator.cli.run.CliLoadJob.execute(CliLoadJob.java:89)
at com.nuodb.migrator.cli.run.CliRunAdapter.execute(CliRunAdapter.java:65)
at com.nuodb.migrator.cli.CliHandler.handleCommand(CliHandler.java:223)
at com.nuodb.migrator.cli.CliHandler.handleOptionSet(CliHandler.java:169)
at com.nuodb.migrator.cli.CliHandler.parse(CliHandler.java:85)
at com.nuodb.migrator.cli.CliHandler.boot(CliHandler.java:78)
at com.nuodb.migrator.bootstrap.Bootstrap.boot(Bootstrap.java:84)
at com.nuodb.migrator.bootstrap.Bootstrap.main(Bootstrap.java:119)

Caused by: java.sql.SQLTransactionRollbackException: Table FOO has been changed
at com.nuodb.jdbc.SQLStateException$8.create(SQLStateException.java:58)
at com.nuodb.jdbc.SQLStateException.raise(SQLStateException.java:142)
at com.nuodb.jdbc.RemConnection.sendAndReceive(RemConnection.java:1123)
at com.nuodb.jdbc.RemConnection.sendAndReceive(RemConnection.java:1095)
at com.nuodb.jdbc.RemStatement.executeUpdate(RemStatement.java:294)
at com.nuodb.jdbc.RemStatement.executeUpdate(RemStatement.java:286)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at jdk.internal.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.nuodb.migrator.utils.ReflectionUtils.invokeMethodNoWrap(ReflectionUtils.java:160)
at com.nuodb.migrator.utils.aop.ReflectionProxy$1.proceed(ReflectionProxy.java:76)
at com.nuodb.migrator.utils.aop.MethodInterceptors$4.invoke(MethodInterceptors.java:149)
at com.nuodb.migrator.utils.aop.ReflectionProxy$1.proceed(ReflectionProxy.java:78)
at com.nuodb.migrator.jdbc.connection.LoggingConnectionProvider$8.invoke(LoggingConnectionProvider.java:177)
at com.nuodb.migrator.utils.aop.ReflectionProxy$1.proceed(ReflectionProxy.java:78)
at com.nuodb.migrator.utils.aop.ReflectionProxy.invoke(ReflectionProxy.java:81)
at com.sun.proxy.$Proxy6.executeUpdate(Unknown Source)
at com.nuodb.migrator.jdbc.metadata.generator.ConnectionScriptExporter.doExportScript(ConnectionScriptExporter.java:71)
at com.nuodb.migrator.jdbc.metadata.generator.ScriptExporterBase.exportScript(ScriptExporterBase.java:54)
at com.nuodb.migrator.jdbc.metadata.generator.CompositeScriptExporter.exportScript(CompositeScriptExporter.java:63)
at com.nuodb.migrator.jdbc.metadata.generator.CompositeScriptExporter.exportScripts(CompositeScriptExporter.java:70)
at com.nuodb.migrator.backup.loader.LoadConstraintWork.execute(LoadConstraintWork.java:125)
at com.nuodb.migrator.jdbc.session.SimpleWorkManager.execute(SimpleWorkManager.java:125)
at com.nuodb.migrator.jdbc.session.SimpleWorkManager.execute(SimpleWorkManager.java:88)
at com.nuodb.migrator.jdbc.session.SimpleWorkManager.execute(SimpleWorkManager.java:105)
at com.nuodb.migrator.backup.loader.BackupLoader$2.run(BackupLoader.java:620)
at com.nuodb.migrator.utils.concurrent.ForkJoinTask$AdaptedRunnable.exec(ForkJoinTask.java:1103)
at com.nuodb.migrator.utils.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:279)
at com.nuodb.migrator.utils.concurrent.ForkJoinWorkerThread.execTask(ForkJoinWorkerThread.java:573)
at com.nuodb.migrator.utils.concurrent.ForkJoinPool.scan(ForkJoinPool.java:677)
at com.nuodb.migrator.utils.concurrent.ForkJoinPool.work(ForkJoinPool.java:560)
at com.nuodb.migrator.utils.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:370)