rpl.rpl_stop_slave fails due to timeout in jenkins debug builds

[Alexey Kopytov]

E.g. http://jenkins.percona.com/view/Percona%20Server%205.1/job/percona-server-5.1-param/BUILD_TYPE=debug-no-Werror,Host=ubuntu-natty-32bit/35/console :

rpl.rpl_stop_slave 'mix' w1 [ fail ] timeout after 900 seconds
        Test ended at 2011-06-30 20:28:37

Test case timeout after 900 seconds

Similar upstream bugs:

http://bugs.mysql.com/bug.php?id=58546
http://bugs.mysql.com/bug.php?id=61091

[Alexey Kopytov (akopytov)]

It appears to be a different issue, or the fix for bug #800035 was incomplete. The mentioned Jenkins build was building a tree with the fix for bug #800035 included: http://bazaar.launchpad.net/~akopytov/percona-server/bug794790/view/head:/slave_timeout_fix.patch. However, rpl_stop_slave still failed with a timeout.

Reopening the bug.

[Stewart Smith (stewart)]

Still occurring :(

http://jenkins.percona.com/job/percona-server-5.1-trunk/lastCompletedBuild/BUILD_TYPE=debug,Host=centos5-64/testReport/(root)/rpl/rpl_stop_slave__mix_/

_StringException: Text attachment: traceback
------------
Timeout after 900 seconds

Test case timeout after 900 seconds

== /home/jenkins/workspace/percona-server-5.1-trunk/BUILD_TYPE/debug/Host/centos5-64/Percona-Server/mysql-test/var/2/log/rpl_stop_slave.log ==
SET GLOBAL debug= 'd,dump_thread_wait_before_send_xid';
[connection slave]
include/restart_slave.inc
BEGIN;
UPDATE t1 SET c2 = 2 WHERE c1 = 1;
[connection master]
BEGIN;
INSERT INTO t1 VALUES(2, 2);
INSERT INTO t2 VALUES(1);
UPDATE t1 SET c2 = 3 WHERE c1 = 1;
COMMIT;
[connection slave1]
STOP SLAVE;
[connection slave]
ROLLBACK;
[connection master]
SET DEBUG_SYNC= 'now SIGNAL signal.continue';
SET DEBUG_SYNC= 'RESET';
[connection slave]
include/wait_for_slave_to_stop.inc

 == /home/jenkins/workspace/percona-server-5.1-trunk/BUILD_TYPE/debug/Host/centos5-64/Percona-Server/mysql-test/var/2/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/tmp/cjdy50tnWv/2/mysqld.2.sock' (111)

 == /home/jenkins/workspace/percona-server-5.1-trunk/BUILD_TYPE/debug/Host/centos5-64/Percona-Server/mysql-test/var/2/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/tmp/cjdy50tnWv/2/mysqld.1.sock' (111)

------------

[Stewart Smith (stewart)]

http://jenkins.percona.com/view/PS%205.1/job/percona-server-5.1-trunk/lastCompletedBuild/BUILD_TYPE=debug,Host=debian6-32/testReport/%28root%29/rpl/rpl_stop_slave__mix_/

Can still occur. Likely due to loaded slave :/

[Laurynas Biveinis (laurynas-biveinis)]

Still seen on recent 5.1 and 5.6 Jenkins trunk builds, but not in 5.5. 5.5 still may need fixing depending on what the root cause is, or 5.1 and 5.6 issues might be unrelated to each other.

http://jenkins.percona.com/job/percona-server-5.1-trunk/730/BUILD_TYPE=debug,Host=centos6-32/testReport/junit/%28root%29/rpl/rpl_stop_slave__stmt_/
http://jenkins.percona.com/job/percona-server-5.6-trunk/195/BUILD_TYPE=debug,Host=ubuntu-saucy-32bit/testReport/junit/%28root%29/rpl/rpl_stop_slave__mix_/

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1215