Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-20446

CertificateCleanupJob fails with foreign key constraint violation on table cp_certificate

XMLWordPrintable

    • Critical
    • None

      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

              bcourt@redhat.com Barnaby Court
              jira-bugzilla-migration RH Bugzilla Integration
              Shweta Singh Shweta Singh
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: