org.quartz.impl.jdbcjobstore.LockException

Failure obtaining db row lock: ERROR: current transaction is aborted, commands ignored until end of transaction block

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web47

  • via Terracotta Project Issue Tracker by Ketil Aasarod, 1 year ago
    Failure obtaining db row lock: ERROR: current transaction is aborted, commands ignored until end of transaction block
  • via Terracotta Project Issue Tracker by Ketil Aasarod, 1 year ago
    Failure obtaining db row lock: ERROR: current transaction is aborted, commands ignored until end of transaction block
  • via Terracotta by udiraz, 2 weeks ago
    Failure obtaining db row lock: ERROR: current transaction is aborted, commands ignored until end of transaction block
  • Stack trace

    • org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157)[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3780)[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)[quartz-2.2.1.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1086)[quartz-2.2.1.jar:na] at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:969)[quartz-2.2.1.jar:na] at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:958)[quartz-2.2.1.jar:na] at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:268)[quartz-2.2.1.jar:na] at org.springframework.scheduling.quartz.SchedulerAccessor.addJobToScheduler(SchedulerAccessor.java:342)[spring-context-support-4.0.1.RELEASE.jar:4.0.1.RELEASE] at org.springframework.scheduling.quartz.SchedulerAccessor.addTriggerToScheduler(SchedulerAccessor.java:365)[spring-context-support-4.0.1.RELEASE.jar:4.0.1.RELEASE] at org.springframework.scheduling.quartz.SchedulerAccessor.registerJobsAndTriggers(SchedulerAccessor.java:303)[spring-context-support-4.0.1.RELEASE.jar:4.0.1.RELEASE] at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:514)[spring-context-support-4.0.1.RELEASE.jar:4.0.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)[spring-beans-4.0.1.RELEASE.jar:4.0.1.RELEASE] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)[spring-beans-4.0.1.RELEASE.jar:4.0.1.RELEASE] 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:2161)[postgresql-9.3-1101-jdbc41.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)[postgresql-9.3-1101-jdbc41.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)[postgresql-9.3-1101-jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)[postgresql-9.3-1101-jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)[postgresql-9.3-1101-jdbc41.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)[postgresql-9.3-1101-jdbc41.jar:na] at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)[c3p0-0.9.1.1.jar:0.9.1.1] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96)[quartz-2.2.1.jar:na]

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Once, 1 month ago
    Unknown user
    Once, 1 year ago
    94 more bugmates