How do I use --logLevel in LiquibaseWARN - 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
Your magic is very sketchy
Why did Kant, Hegel, and Adorno leave some words and phrases in the Greek alphabet?
What will be the benefits of Brexit?
Is it okay / does it make sense for another player to join a running game of Munchkin?
Understanding "audieritis" in Psalm 94
Was Spock the First Vulcan in Starfleet?
Trouble understanding overseas colleagues
Was the picture area of a CRT a parallelogram (instead of a true rectangle)?
Hostile work environment after whistle-blowing on coworker and our boss. What do I do?
Confused about a passage in Harry Potter y la piedra filosofal
Is there any reason not to eat food that's been dropped on the surface of the moon?
Generic lambda vs generic function give different behaviour
What defines a dissertation?
Teaching indefinite integrals that require special-casing
Time travel short story where a man arrives in the late 19th century in a time machine and then sends the machine back into the past
Can a monster with multiattack use this ability if they are missing a limb?
Why Were Madagascar and New Zealand Discovered So Late?
What are the ramifications of creating a homebrew world without an Astral Plane?
voltage of sounds of mp3files
How do I define a right arrow with bar in LaTeX?
What would be the benefits of having both a state and local currencies?
How can I get through very long and very dry, but also very useful technical documents when learning a new tool?
The baby cries all morning
How was Earth single-handedly capable of creating 3 of the 4 gods of chaos?
How do I use --logLevel in Liquibase
WARN - 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
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
336
336
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