Bug #42357 rpl.rpl_slave_status: test fails with timeout on pushbuild
Submitted: 26 Jan 2009 21:55 Modified: 12 Oct 2010 14:49
Reporter: Luis Soares Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:5.1-rpl OS:Any
Assigned to: Mats Kindahl CPU Architecture:Any
Tags: 5.1-rpl-green, pushbuild, test failure

[26 Jan 2009 21:55] Luis Soares
Description:
Test failed on pushbuild with:

timer 5572: expired after 900 seconds
worker[1] Trying to dump core for [mysqltest - pid: 5724, winpid: 5724]
worker[1] Trying to dump core for [mysqld.1 - pid: 264, winpid: 264]
worker[1] Trying to dump core for [mysqld.2 - pid: 6928, winpid: 6928]
rpl.rpl_slave_status                     [ fail ]  timeout after 900 seconds
        Test ended at 2009-01-26 20:37:53

Test case timeout after 900 seconds

== e:/var-ps_row-101/log/rpl_slave_status.log == 
[on master]
GRANT REPLICATION SLAVE ON *.* TO rpl@127.0.0.1 IDENTIFIED BY 'rpl';
[on slave]
include/stop_slave.inc
CHANGE MASTER TO master_user='rpl', master_password='rpl';
include/start_slave.inc
==== Do replication as new user ====
[on master]
CREATE TABLE t1 (n INT);
INSERT INTO t1 VALUES (1);
[on slave]
SELECT * FROM t1;
n
1
==== Delete new replication user ====
[on master]
DROP USER rpl@127.0.0.1;
FLUSH PRIVILEGES;
[on slave]
==== Restart slave without privileges =====

 == e:/var-ps_row-101/tmp/analyze-timeout-mysqld.1.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
416	rpl	localhost:4216	NULL	Binlog Dump	793	Has sent all binlog to slave; waiting for binlog to be updated	NULL
417	root	localhost:4262	NULL	Query	0	NULL	SHOW PROCESSLIST

 == e:/var-ps_row-101/tmp/analyze-timeout-mysqld.2.err ==
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
2	root	localhost:4205	test	Query	744	Killing slave	STOP SLAVE
6	system user		NULL	Connect	819	Waiting for slave mutex on exit	NULL
7	system user		NULL	Connect	744	Has read all relay log; waiting for the slave I/O thread to update it	NULL
8	root	localhost:4263	NULL	Query	0	NULL	SHOW PROCESSLIST

 - saving 'e:/var-ps_row-101/log/rpl.rpl_slave_status/' to 'e:/var-ps_row-101/log/rpl.rpl_slave_status/'

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=120 vm-win2003-32-a ps_row

http://tinyurl.com/ao7spq