search

CZERTAINLY / CZERTAINLY-Core

CZERTAINLY - core of the platform managing certificate lifecycle management related tasks
https://www.czertainly.com
MIT License
4 stars 13 forks source link

deadlock detected #806

Open semik opened 3 months ago

semik commented 3 months ago

Describe the bug I was testing massive upload of certificates via API into CZERTAINLY and sometimes my client was getting HTTP 500. In logs of core I see:

[2024-07-26 13:31:24.358] ERROR [rabbit-simple-30] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper - 150]: ERROR: deadlock detected

Complete exception is attached in file deadlock.log

To Reproduce Steps to reproduce the behavior:

  1. Execute several parallel upload tasks using upload-certs.py
  2. Wait untill HTTP 500 ocurs.

The problem is somehow related to periodically executed jobs. I'm not sure if updateCertificateStatusJob or updateIntuneRevocationRequestsJob. When I disabled both of them, error didn't show up for several days.

Additional context

The error is from version 2.12.