Fix bug where multiple instances running can get duplicate items when creating job for queue

lmullen / cchc

America's Public Bible for Computing Cultural Heritage in the Cloud

Creative Commons Zero v1.0 Universal

8 stars 1 forks source link

Closed lmullen closed 2 years ago

lmullen commented 2 years ago

ERROR: duplicate key value violates unique constraint "jobs_fulltext_unique" (SQLSTATE 23505)

lmullen commented 2 years ago

This was fixed by using PostgreSQL's advisory locks.