hemilabs / heminetwork

The hemi network core daemons.
MIT License
73 stars 49 forks source link

need to select FOR UPDATE to lock row #245

Closed ClaytonNorthey92 closed 2 months ago

ClaytonNorthey92 commented 2 months ago

Summary prior, when selecting a row to update, we were not locking the row selected so multiple processes could get this row at the same time.

Changes select row FOR UPDATE to lock row to ensure only one process gets it