FTWRL can cause deadlock in 5.1

Bug #867725 reported by Alex Yurchenko
6
This bug affects 1 person
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_sst_rsync_wan 'donor' '192.168.0.3:4441/rsync_sst' 'root:rootpass' '/tmp/galera0/mysql/var/' '78ce99d2-ee67-11e0-0800-f04f5e9ed809' '136896' 2>sst.err'
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
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.