org.hibernate.exception.ConstraintViolationException

ERROR: duplicate key value violates unique constraint "qrtz_locks_pkey" Detail: Key (sched_name, lock_name)=(ServerScheduler, TRIGGER_ACCESS) already exists.

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web33

  • via Stack Overflow by SK08...
    ,
  • Stack trace

    • org.hibernate.exception.ConstraintViolationException: ERROR: duplicate key value violates unique constraint "qrtz_locks_pkey" Detail: Key (sched_name, lock_name)=(ServerScheduler, TRIGGER_ACCESS) already exists. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)[hibernate-core-4.1.8.Final.jar:4.1.8.Final] at com.sun.proxy.$Proxy97.executeUpdate(Unknown Source)[na:na] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:108)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.removeJob(JobStoreSupport.java:1248)[quartz-2.1.7.jar:na] at org.quartz.core.QuartzScheduler.deleteJob(QuartzScheduler.java:953)[quartz-2.1.7.jar:na] at org.quartz.impl.StdScheduler.deleteJob(StdScheduler.java:292)[quartz-2.1.7.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 visitor
    Unknown visitorOnce,
    linxiaolonglinxiaolong
    4 times, last one
    Unknown visitor
    Unknown visitorOnce,
    MalcshourMalcshour
    165 times, last one
    tjagotjago
    7 times, last one
    3 more bugmates