intermittent rpl_deadlock_innodb failures
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
New
|
Undecided
|
Unassigned | ||
| MySQL Server |
Unknown
|
Unknown
|
|||
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Stewart Smith | ||
| 5.1 |
Fix Released
|
High
|
Stewart Smith | ||
| 5.5 |
Fix Released
|
High
|
Stewart Smith | ||
Bug Description
For example:
rpl.rpl_
Test ended at 2011-06-21 03:34:19
CURRENT_TEST: rpl.rpl_
mysqltest: In included file "./include/
included from ./include/
included from ./include/
included from ./extra/
At line 115: Timeout in include/
The result from queries just before the failure was:
< snip >
master-bin.000001 845
**** SHOW BINLOG EVENTS on server_1 ****
binlog_name = 'master-bin.000001'
SHOW BINLOG EVENTS IN 'master-
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.13-log, Binlog ver: 4
master-bin.000001 107 Query 1 224 use `test`; CREATE TABLE t1 (a INT NOT NULL, KEY(a)) ENGINE=innodb
master-bin.000001 224 Query 1 324 use `test`; CREATE TABLE t2 (a INT) ENGINE=innodb
master-bin.000001 324 Query 1 441 use `test`; CREATE TABLE t3 (a INT NOT NULL, KEY(a)) ENGINE=innodb
master-bin.000001 441 Query 1 509 BEGIN
master-bin.000001 509 Query 1 597 use `test`; INSERT INTO t1 VALUES (1)
master-bin.000001 597 Query 1 730 use `test`; INSERT INTO t2 VALUES (2), (2), (2), (2), (2), (2), (2), (2), (2), (2)
master-bin.000001 730 Query 1 818 use `test`; INSERT INTO t3 VALUES (3)
master-bin.000001 818 Xid 1 845 COMMIT /* xid=384 */
**** SHOW RELAYLOG EVENTS on server_1 ****
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name Pos Event_type Server_id End_log_pos Info
More results from queries before failure can be found in /mnt/workspace/
- saving '/mnt/workspace
Another instance on a branch with unrelated change:
http://
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 25 lines (+12/-1)2 files modifiedseries (+1/-1)
slave_timeout_fix.patch (+11/-0)
- Laurynas Biveinis (community): Approve
-
Diff: 24 lines (+12/-0)2 files modifiedseries (+1/-0)
slave_timeout_fix.patch (+11/-0)
| Stewart Smith (stewart) wrote | #1 |
| Stewart Smith (stewart) wrote | #2 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
currently trying this patch to see if it may help:
--- a/mysql-
+++ b/mysql-
@@ -79,7 +79,7 @@
# mysqltest doesn't provide any better way to multiply by 10
--let $_wait_
---let $_slave_
+--let $_slave_
--let $_slave_continue= 1
while ($_slave_continue)
{