MDL resource held outside TO isolation
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Medium
|
Seppo Jaakola |
Bug Description
Regression test for lp:861212 causes inconsistency. The following log snippet reveals that some MDL resources are held outside TOI critical section by locally executed ALTER.
121030 16:36:34 [Note] [Debug] WSREP: galera/
121030 16:36:34 [Note] WSREP: TO BEGIN: 7751450, 2
121030 16:36:34 [Note] WSREP: TO END: 7751450, 2 : ALTER TABLE comm02 DROP COLUMN d
121030 16:36:34 [Note] [Debug] WSREP: galera/
121030 16:36:34 [Note] [Debug] WSREP: galera/
121030 16:36:34 [Note] WSREP: TO BEGIN: 7751451, 2
121030 16:36:34 [Note] WSREP: MDL conflict
request: (21 seqno 7751451 wsrep (2, 1, 0) cmd 3 3 ALTER TABLE comm02 ADD COLUMN (d DATETIME))
granted: (22 seqno 7751450 wsrep (2, 1, 0) cmd 3 3 ALTER TABLE comm02 DROP COLUMN d)
121030 16:36:34 [Note] WSREP: MDL BF-BF conflict
request: (21 seqno 7751451 wsrep (2, 1, 0) cmd 3 3 ALTER TABLE comm02 ADD COLUMN (d DATETIME))
granted: (22 seqno 7751450 wsrep (2, 1, 0) cmd 3 3 ALTER TABLE comm02 DROP COLUMN d)
121030 16:36:34 [Note] WSREP: TO END: 7751450
121030 16:36:34 [Note] WSREP: TO END: 7751451, 2 : ALTER TABLE comm02 ADD COLUMN (d DATETIME)
121030 16:36:34 [Note] [Debug] WSREP: galera/
Changed in codership-mysql: | |
importance: | Undecided → High |
status: | New → In Progress |
assignee: | nobody → Teemu Ollakka (teemu-ollakka) |
milestone: | none → 5.5.28-23.7 |
Changed in codership-mysql: | |
status: | In Progress → New |
assignee: | Teemu Ollakka (teemu-ollakka) → nobody |
importance: | High → Medium |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
regression test lp1073220 can surface reliably inconsistencies in schema level