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

Activity overview

Latest activity by santosh_malimath

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
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
Limitation on number of lines in FlywayScript
  1. Community
  2. Flyway (General Discussion)
We are issue where our pipelines fails and throws error when we try to execute any script (Procedures) on the PostgreSQL DB (ATS FTEST) where the total character in the script exceeds 16330 charact...
2 followers 7 comments 0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1