java.lang.RuntimeException: java.lang.RuntimeException: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from public.databasechangeloglock: ERROR: current transaction is aborted, commands ignored until end of transaction block

JIRA | Patrick Huang | 4 months ago
  1. 0

    When I start an app in wildfly 10 with an empty database, it seems liquibase will try to do a query before it actually create the table. But with postgres, according to this [stackoverflow answer|http://stackoverflow.com/a/13103690/345718], marks the transaction to failure. But despite the error, it goes on and created the tables but in the end cause the app to fail to deploy. Redeploy the app again (and this time the DATABASECHANGELOG table is there) will work fine. {code:java} 05:20:45,699 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 77) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./sync: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./sync: java.lang.RuntimeException: java.lang.RuntimeException: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from public.databasechangeloglock: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at org.jboss.threads.JBossThread.run(JBossThread.java:320) Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:337) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 24 more 05:20:45,714 INFO [liquibase] (ServerService Thread Pool -- 76) Successfully acquired change log lock 05:20:46,393 INFO [liquibase] (ServerService Thread Pool -- 76) Creating database history table with name: public.databasechangelog {code}

    JIRA | 4 months ago | Patrick Huang
    java.lang.RuntimeException: java.lang.RuntimeException: liquibase.exception.LockException: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.DatabaseException: Error executing SQL select count(*) from public.databasechangeloglock: ERROR: current transaction is aborted, commands ignored until end of transaction block
  2. 0

    Could not get a cluster ID

    GitHub | 2 years ago | wezell
    com.dotmarketing.exception.DotDataException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Hibernate error: current transaction is aborted, commands ignored until end of transaction block

    Stack Overflow | 6 years ago | sass
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  5. 0

    Forum: /home/Developer/Forum

    labkey.org | 1 year ago
    org.springframework.jdbc.UncategorizedSQLException: ExecutingSelector; uncategorized SQLException for SQL []; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

  1. csanyigabor 4 times, last 3 months ago
  2. Tahir 1 times, last 4 months ago
  3. RoiOtero 3 times, last 5 months ago
  4. haerick 8 times, last 6 months ago
  5. silex 15 times, last 6 months ago
2 more registered users
33 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: current transaction is aborted, commands ignored until end of transaction block

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
    6 frames
  3. IronJacamar
    WrappedStatement.executeQuery
    1. org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)
    1 frame
  4. Liquibase Core
    JdbcExecutor.execute
    1. liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:337)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    2 frames
  5. WildFly: Undertow
    UndertowDeploymentService$1.run
    1. org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85)
    1 frame
  6. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    3. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    5. java.lang.Thread.run(Thread.java:745)
    5 frames
  7. JBoss Threads
    JBossThread.run
    1. org.jboss.threads.JBossThread.run(JBossThread.java:320)
    1 frame