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.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Terracotta by udiraz, 1 year ago
ERROR: duplicate key value violates unique constraint "qrtz_locks_pkey" Detail: Key (sched_name, lock_name)=(ServerScheduler, TRIGGER_ACCESS) already exists.
via Stack Overflow by Chaitanya
, 2 years ago
ORA-02291: integrity constraint (LEARNING.FK4A94943B0A1327A) violated - parent key not found
via Stack Overflow by Ziya
, 2 years ago
Duplicate entry 'PD-2794-86686' for key 'PRIMARY'
via Stack Overflow by Paul Taylor
, 2 years ago
Unique index or primary key violation: "PRIMARY_KEY_6 ON PUBLIC.COVERIMAGE(DATAKEY)"; SQL statement: insert into CoverImage (height, imageData, isLinked, mimeType, resizedHeight, resizedImageData, resizedWidth, source, version, width, dataKey) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-166]
via Coderanch by vivek dhiman, 1 year ago
ERROR: insert or update on table "customer2" violates foreign key constraint "fk6268c146f6fdda6" Detail: Key (vendorid)=(101) is not present in table "vendor2".
via Spring JIRA by Ayushya Devmurari, 1 year ago
Violation of PRIMARY KEY constraint 'PK__BATCH_JO__4848154A7F60ED59'. Cannot insert duplicate key in object 'dbo.BATCH_JOB_INSTANCE'. The duplicate key value is (0).
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)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy97.executeUpdate(Unknown Source)
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:108)
at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.removeJob(JobStoreSupport.java:1248)
at org.quartz.core.QuartzScheduler.deleteJob(QuartzScheduler.java:953)
at org.quartz.impl.StdScheduler.deleteJob(StdScheduler.java:292)

Users with the same issue

45 times, 7 months ago
165 times, 1 year ago
7 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.