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

Report information
The Basics
Id:
79774
Status:
new
Priority:
Low/Low
Queue:

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

BugTracker
Severity:
Wishlist
Broken in:
(no value)
Fixed in:
(no value)



Subject: Ordered race conditions
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 runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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