java.sql.SQLIntegrityConstraintViolationException: DELETE on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL110119171738411' for key (Schedule.0,TRIGGER_GROUP_SIMPLE). The statement has been rolled back.]

Terracotta | schrock | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Foreign key exception when deleting trigger?

    Terracotta | 6 years ago | schrock
    java.sql.SQLIntegrityConstraintViolationException: DELETE on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL110119171738411' for key (Schedule.0,TRIGGER_GROUP_SIMPLE). The statement has been rolled back.]

    Root Cause Analysis

    1. java.sql.SQLIntegrityConstraintViolationException

      DELETE on table 'QRTZ_TRIGGERS' caused a violation of foreign key constraint 'SQL110119171738411' for key (Schedule.0,TRIGGER_GROUP_SIMPLE). The statement has been rolled back.]

      at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger()
    2. quartz
      StdScheduler.rescheduleJob
      1. org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1517)
      2. org.quartz.impl.jdbcjobstore.JobStoreSupport$9.execute(JobStoreSupport.java:1484)
      3. org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:242)
      4. org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1480)
      5. org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:991)
      6. org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:302)
      6 frames