[Rt-devel] BUG: RT race condition

[Todd Chapman]

I don't know how this happened but 2 of my users did
a "Take" on the same ticket at the same time and both
were able to take the ticket.

How can this happen?

mysql> select
id,ObjectType,ObjectId,Type,Field,OldValue,NewValue,Creator,Created from Transactions where ObjectId=103886;
+-------+------------+----------+-------------+---------+----------+----------+---------+---------------------+
| id    | ObjectType | ObjectId | Type        | Field   | OldValue | NewValue | Creator | Created             |
+-------+------------+----------+-------------+---------+----------+----------+---------+---------------------+
| 47759 | RT::Ticket |   103886 | Create      | NULL    | NULL     | NULL     |    2012 | 2007-01-16 04:26:31 |
| 47760 | RT::Ticket |   103886 | EmailRecord | NULL    | NULL     | NULL     |       1 | 2007-01-16 04:26:32 |
| 47761 | RT::Ticket |   103886 | CustomField | 9       | NULL     | NULL     |       1 | 2007-01-16 04:26:32 |
| 47762 | RT::Ticket |   103886 | AddWatcher  | AdminCc | NULL     | 3883     |       1 | 2007-01-16 04:26:32 |
| 84725 | RT::Ticket |   103886 | Take        | Owner   | 10       | 334      |     334 | 2007-01-22 16:06:02 |
| 84726 | RT::Ticket |   103886 | Take        | Owner   | 10       | 336      |     336 | 2007-01-22 16:06:02 |
| 84739 | RT::Ticket |   103886 | CustomField | 15      | NULL     | NULL     |     334 | 2007-01-22 16:08:58 |
| 84754 | RT::Ticket |   103886 | Correspond  | NULL    | NULL     | NULL     |     334 | 2007-01-22 16:09:35 |
| 84755 | RT::Ticket |   103886 | Status      | Status  | new      | open     |       1 | 2007-01-22 16:09:35 |
| 84756 | RT::Ticket |   103886 | EmailRecord | NULL    | NULL     | NULL     |       1 | 2007-01-22 16:09:36 |
| 84757 | RT::Ticket |   103886 | EmailRecord | NULL    | NULL     | NULL     |       1 | 2007-01-22 16:09:36 |
| 84758 | RT::Ticket |   103886 | Status      | Status  | open     | resolved |     334 | 2007-01-22 16:09:36 |
+-------+------------+----------+-------------+---------+----------+----------+---------+---------------------+
12 rows in set (0.15 sec)