How can we help you today? How can we help you today?
santosh_malimath
Activity overview Badges (0) Posts (1) Comments (6)

Comments

Sort by recent activity
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate.  Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has...
0 votes
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate.  Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has...
0 votes
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate.  Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has...
0 votes
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate.  Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has...
0 votes
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate.  Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)  at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has...
0 votes
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:872) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:82) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Unable to restore autocommit to original value for connection org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:794) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:97) at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:325) at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290) at org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:56) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:194) at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:191) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:69) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) ERROR: Migration of schema "ds_local" to version "2501171909 - OTP TestRun" failed! Changes successfully rolled back. ERROR: Unable to release PostgreSQL advisory lock org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:865) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1771) at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:418) at org.flywaydb.core.internal.jdbc.JdbcTemplate.prepareStatement(JdbcTemplate.java:344) at org.flywaydb.core.internal.jdbc.JdbcTemplate.queryForBoolean(JdbcTemplate.java:170) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.unlock(PostgreSQLAdvisoryLockTemplate.java:99) at org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:80) at org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141) at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:191) at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:152) at org.flywaydb.core.Flyway$1.execute(Flyway.java:216) at org.flywaydb.core.Flyway$1.execute(Flyway.java:165) at org.flywaydb.core.Flyway.execute(Flyway.java:570) at org.flywaydb.core.Flyway.migrate(Flyway.java:165) at org.flywaydb.commandline.Main.executeOperation(Main.java:223) at org.flywaydb.commandline.Main.main(Main.java:144) / comments
  1. Community
  2. Flyway (General Discussion)
  3. Limitation on number of lines in FlywayScript
We are running a SQL file which has procedure in it and gives the following error when we run flyway migrate. Unable to rollback transaction org.postgresql.util.PSQLException: This connection ha...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1