Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-20446 CertificateCleanupJob fails with foreign key constraint violation on table cp_certificate
  3. SAT-22694

[QE] CertificateCleanupJob fails with foreign key constraint violation on table cp_certificate

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Undefined Undefined
    • None
    • None
    • Candlepin
    • 0
    • False
    • Hide

      None

      Show
      None
    • False
    • 0
    • Rocket

      Description of problem:

      On a very loaded system "CertificateCleanupJob" job shows following error:

      2023-08-03 17:45:22,829 [thread=Thread-3 (ActiveMQ-client-global-threads)] [job=8a35b3cf89b9b7aa0189bb44de043b1b, job_key=CertificateCleanupJob, org=, csid=] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 23503
      2023-08-03 17:45:22,829 [thread=Thread-3 (ActiveMQ-client-global-threads)] [job=8a35b3cf89b9b7aa0189bb44de043b1b, job_key=CertificateCleanupJob, org=, csid=] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: update or delete on table "cp_cert_serial" violates foreign key constraint "fk16370c54b9410fc" on table "cp_certificate"
      Detail: Key (id)=(1298353109733755480) is still referenced from table "cp_certificate".
      2023-08-03 17:45:22,840 [thread=Thread-3 (ActiveMQ-client-global-threads)] [job=8a35b3cf89b9b7aa0189bb44de043b1b, job_key=CertificateCleanupJob, org=, csid=] ERROR org.candlepin.async.JobManager - Job "CertificateCleanupJob" failed in 20722815ms

      Version-Release number of selected component (if applicable):
      Satellite 6.11

      QE Tracker for https://issues.redhat.com/browse/SAT-20446
      Bugzilla: https://bugzilla.redhat.com/show_bug.cgi?id=2229095

              rhn-support-shwsingh Shweta Singh
              satellite-focaccia-bot Focaccia Bot
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: