FTWRL can cause deadlock in 5.1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Unassigned |
Bug Description
seesaw test with rsync SST sometimes gives the following:
111004 18:18:25 [Note] WSREP: Shifting SYNCED -> DONOR (TO: 136896)
111004 18:18:25 [Warning] WSREP: wsrep_notify_cmd is not defined, skipping notification.
111004 18:18:25 [Note] WSREP: Running: 'wsrep_
111004 18:18:25 [Note] WSREP: sst_donor_thread signaled with 0
111004 18:18:25 [Note] WSREP: Flushing tables for SST...
At this point the node stopped and even killing sqlgen didn't resolve the conflict:
mysql> show processlist;
+------
| Id | User | Host | db | Command | Time | State | Info |
+------
| 1 | system user | | NULL | Sleep | 489 | post SQL applying (138118) | NULL |
| 2 | system user | | NULL | Sleep | 525 | wsrep aborter idle | NULL |
| 3 | system user | | NULL | Sleep | 489 | post SQL applying (138114) | NULL |
| 4 | system user | | NULL | Sleep | 489 | post RBR applying (138120) | NULL |
| 5 | system user | | NULL | Sleep | 489 | post RBR applying (138121) | NULL |
| 4641 | test | void:35327 | test | Query | 490 | Waiting for release of readlock | UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (24516*y % 65537) + (y*z % 65537)) % 655 |
| 4648 | test | void:55655 | test | Query | 489 | Waiting for release of readlock | UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (17101*y % 65537) + (y*z % 65537)) % 655 |
| 4652 | test | void:60933 | test | Query | 489 | Waiting for release of readlock | UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (21591*y % 65537) + (y*z % 65537)) % 655 |
| 4654 | test | void:43127 | test | Query | 489 | Waiting for release of readlock | UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (16173*y % 65537) + (y*z % 65537)) % 655 |
| 4656 | test | void:48432 | test | Query | 489 | Waiting for release of readlock | UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (25678*y % 65537) + (y*z % 65537)) % 655 |
| 4660 | test | void:43568 | test | Query | 489 | Waiting for release of readlock | UPDATE comm01 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (44243*y % 65537) + (y*z % 65537)) % 655 |
| 4661 | test | void:48504 | test | Query | 489 | Waiting for release of readlock | UPDATE comm03 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (40425*y % 65537) + (y*z % 65537)) % 655 |
| 4662 | root | localhost | test | Query | 0 | sleeping | show processlist |
+------
13 rows in set (0.01 sec)
Changed in codership-mysql: | |
milestone: | none → 5.1.59-21.2 |
Changed in codership-mysql: | |
milestone: | 5.1.59-22.2 → 5.1.59-22.3 |
Changed in codership-mysql: | |
milestone: | 5.1.61-23.3 → 5.1.61-23.4 |
Changed in codership-mysql: | |
milestone: | 5.1.62-23.4 → 5.1.62-23.5 |