Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.1.67, 5.2.14, 5.3.12
-
None
Description
For example:
rpl.rpl_deadlock_innodb 'mix' w7 [ retry-fail ]
|
Test ended at 2011-06-21 03:34:19
|
|
CURRENT_TEST: rpl.rpl_deadlock_innodb
|
mysqltest: In included file "./include/wait_for_slave_param.inc":
|
included from ./include/wait_for_slave_param.inc at line 115:
|
included from ./include/wait_for_slave_sql_error.inc at line 41:
|
included from ./extra/rpl_tests/rpl_deadlock.test at line 84:
|
At line 115: Timeout in include/wait_for_slave_param.inc
|
|
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-bin.000001';
|
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/percona-server-5.5-trunk/BUILD_TYPE/release/Host/ubuntu-maverick-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/7/log/rpl_deadlock_innodb.log
|
|
- saving '/mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/release/Host/ubuntu-maverick-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/7/log/rpl.rpl_deadlock_innodb-mix/' to '/mnt/workspace/percona-server-5.5-trunk/BUILD_TYPE/release/Host/ubuntu-maverick-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/log/rpl.rpl_deadlock_innodb-mix/'
|
Another instance on a branch with unrelated change:
http://jenkins.percona.com/job/percona-server-5.5-param/BUILD_TYPE=debug,Host=ubuntu-natty-64bit/8/console