Closed fabriziomello closed 2 years ago
We're updating the bgw_job_stats table without properly lock the row to prevent concurrent updates from other background workers.
bgw_job_stats
Fixed it by properly lock it using SELECT ... FOR UPDATE and issue a COMMIT after each function call;
We're updating the
bgw_job_statstable without properly lock the row to prevent concurrent updates from other background workers.Fixed it by properly lock it using SELECT ... FOR UPDATE and issue a COMMIT after each function call;