How do I use --logLevel in Liquibase The 2019 Stack Overflow Developer Survey Results Are InWARN - Failed to getImportedKeys The cursor has been previously released and is unavailableLiquibase lock - reasons?Liquibase: How to skip tables in origin database when using diffchangelogWhy and when Liquibase?liquibase with long running statementLiquibase update or liquibase migrate?Can't make one to many connection between two tablesGet DatabaseException trying to run Liquibase generateChangeLog under informixlogging not working in liquibase 3.6.1 using loglevel=debugLiquibase 3.6.2 logLevel=debug not honored?liquibase --logLevel is not working in version 3.6.3 and 3.6.2
Shouldn't "much" here be used instead of "more"?
Resizing object distorts it (Illustrator CC 2018)
Is this app Icon Browser Safe/Legit?
Is there a symbol for a right arrow with a square in the middle?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Why isn't airport relocation done gradually?
How to manage monthly salary
How technical should a Scrum Master be to effectively remove impediments?
What is the most effective way of iterating a std::vector and why?
How are circuits which use complex ICs normally simulated?
Delete all lines which don't have n characters before delimiter
Reference request: Oldest number theory books with (unsolved) exercises?
What is the meaning of Triage in Cybersec world?
Aging parents with no investments
Why do UK politicians seemingly ignore opinion polls on Brexit?
Why didn't the Event Horizon Telescope team mention Sagittarius A*?
Loose spokes after only a few rides
Should I use my personal e-mail address, or my workplace one, when registering to external websites for work purposes?
What is the accessibility of a package's `Private` context variables?
What does ひと匙 mean in this manga and has it been used colloquially?
Is a "Democratic" Oligarchy-Style System Possible?
Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?
Apparent duplicates between Haynes service instructions and MOT
Can one be advised by a professor who is very far away?
How do I use --logLevel in Liquibase
The 2019 Stack Overflow Developer Survey Results Are InWARN - Failed to getImportedKeys The cursor has been previously released and is unavailableLiquibase lock - reasons?Liquibase: How to skip tables in origin database when using diffchangelogWhy and when Liquibase?liquibase with long running statementLiquibase update or liquibase migrate?Can't make one to many connection between two tablesGet DatabaseException trying to run Liquibase generateChangeLog under informixlogging not working in liquibase 3.6.1 using loglevel=debugLiquibase 3.6.2 logLevel=debug not honored?liquibase --logLevel is not working in version 3.6.3 and 3.6.2
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
It doesn't seem to matter what I set it to, I don't get anything that looks like additional information:
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=debug --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:30:34 GMT (version 3.6.3
built at 2019-01-29 11:34:48)
Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=severe --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:33:46 GMT (version 3.6.3
built at 2019-01-29 11:34:48) Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
After both of these have run:
ls -l ./lb.log
ls: ./lb.log: No such file or directory
liquibase informix
add a comment |
It doesn't seem to matter what I set it to, I don't get anything that looks like additional information:
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=debug --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:30:34 GMT (version 3.6.3
built at 2019-01-29 11:34:48)
Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=severe --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:33:46 GMT (version 3.6.3
built at 2019-01-29 11:34:48) Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
After both of these have run:
ls -l ./lb.log
ls: ./lb.log: No such file or directory
liquibase informix
add a comment |
It doesn't seem to matter what I set it to, I don't get anything that looks like additional information:
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=debug --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:30:34 GMT (version 3.6.3
built at 2019-01-29 11:34:48)
Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=severe --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:33:46 GMT (version 3.6.3
built at 2019-01-29 11:34:48) Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
After both of these have run:
ls -l ./lb.log
ls: ./lb.log: No such file or directory
liquibase informix
It doesn't seem to matter what I set it to, I don't get anything that looks like additional information:
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=debug --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:30:34 GMT (version 3.6.3
built at 2019-01-29 11:34:48)
Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
liquibase --url="jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet" --logLevel=severe --logFile=./lb.log --classpath=/opt/informix/informix/jdbc/lib/ifxjdbc.jar --changeLogFile ./test1ChangeLog.xml --includeTablespace=true generateChangeLog
Starting Liquibase at Thu, 07 Mar 2019 12:33:46 GMT (version 3.6.3
built at 2019-01-29 11:34:48) Unexpected error running Liquibase:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable.
liquibase.exception.LiquibaseException:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:279)
at liquibase.integration.commandline.Main.doMigration(Main.java:1058)
at liquibase.integration.commandline.Main.run(Main.java:199) at
liquibase.integration.commandline.Main.main(Main.java:137) Caused by:
liquibase.command.CommandExecutionException:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.command.AbstractCommand.execute(AbstractCommand.java:24) at
liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:277)
... 3 common frames omitted Caused by:
liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:223)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:66)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:69)
at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:286)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:407)
at
liquibase.snapshot.DatabaseSnapshot.replaceObject(DatabaseSnapshot.java:429)
at
liquibase.snapshot.DatabaseSnapshot.includeNestedObjects(DatabaseSnapshot.java:334)
at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:309)
at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:102)
at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:59)
at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:38)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:217)
at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:190)
at
liquibase.command.core.DiffCommand.createReferenceSnapshot(DiffCommand.java:221)
at
liquibase.command.core.DiffCommand.createDiffResult(DiffCommand.java:143)
at
liquibase.command.core.GenerateChangeLogCommand.run(GenerateChangeLogCommand.java:46)
at liquibase.command.AbstractCommand.execute(AbstractCommand.java:19)
... 4 common frames omitted Caused by:
liquibase.exception.DatabaseException: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getForeignKeys(JdbcDatabaseSnapshot.java:74)
at
liquibase.snapshot.jvm.ForeignKeySnapshotGenerator.snapshotObject(ForeignKeySnapshotGenerator.java:127)
... 27 common frames omitted Caused by: java.sql.SQLException: The
cursor has been previously released and is unavailable. at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304) at
com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2038) at
com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4082) at
com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:494) at
com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:5389)
at
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData$1.fastFetch(JdbcDatabaseSnapshot.java:126)
at liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:70) ...
29 common frames omitted Caused by: java.sql.SQLException: null at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443) at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394) at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477) ... 37
common frames omitted
For more information, please use the --logLevel flag
After both of these have run:
ls -l ./lb.log
ls: ./lb.log: No such file or directory
liquibase informix
liquibase informix
asked Mar 8 at 9:40
Spokey WheelerSpokey Wheeler
386
386
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060448%2fhow-do-i-use-loglevel-in-liquibase%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060448%2fhow-do-i-use-loglevel-in-liquibase%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown