A Lot of ERROR: duplicate key value violates unique in BDD logs
I'm trying to understand why our PostGRESQL databases have so muche "duplicate key value violates unique" errors for years.
Our DBA have seen it in production and DEV-test env. while we were using PEGA 8.7. The same errors are presents since we updgrade to PEGA 24.1 on Sept 9 2025.
few Examples :
2025-09-28 23:39:00 CEST:<>:pega_base@<>:[847310]: ERROR: duplicate key value violates unique constraint "pr_sys_locks_pk"
2025-09-28 23:39:00 CEST:1<>:pega_base@<>:[847310]: DETAIL: Key (pzinskey)=(PYALERTJOBFORMAXERRORRECORDSOFLSETABLE) already exists.
2025-09-28 23:39:07 CEST:<>:pega_base@<>:[844901]: ERROR: duplicate key value violates unique constraint "pr_sys_locks_pk"
It can happen nearly on any table. It doesn't seem to really impact PEGA but those errors cannot not be just ignored.
Can you clarify please? Config issue? Usual behavior?