Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 79774
Status: new
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: moseley [...] hank.org
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: Ordered race conditions
Download (untitled) / with headers
text/plain 558b
We have had various problems with race conditions and the Ordered component. There's a race between the SELECT and UPDATE, and also during multiple updates (as was done in old approach of updating each row in a separate query). For inserts what I have done is SELECT 1 FROM grouping_table WHERE id = group_id FOR UPDATE. Note the lock is on the row in the grouping table, not the table that is using Ordered. Only tested in Postgresql. I suppose SELECT .. FOR UPDATE on the Ordered rows would work for other operations, right? See also RT#79773


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.