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
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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