Bug #79682 rpl.rpl_dump_thread_kill fails when run with --mem
Submitted: 16 Dec 2015 22:12 Modified: 22 Aug 2017 8:31
Reporter: Justin Tolmer Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.6.27 OS:CentOS (6)
Assigned to: CPU Architecture:Any

[16 Dec 2015 22:12] Justin Tolmer
Description:
Running on Centos6 with devtoolset-1.1.

rpl.rpl_dump_thread_kill 'stmt'          [ fail ]
        Test ended at 2015-12-16 14:07:57

CURRENT_TEST: rpl.rpl_dump_thread_kill
mysqltest: In included file "./include/wait_condition.inc": 
included from ./include/wait_condition.inc at line 60:
At line 60: Timeout in wait_condition.inc for $wait_condition

The result from queries just before the failure was:
< snip >
binlog_name = 'master-bin.000002'
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
master-bin.000002       4       Format_desc     1       120     Server ver: 5.6.27-debug-log, Binlog ver: 4

**** 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

**** slave_relay_info on server_1 ****
SELECT * FROM mysql.slave_relay_log_info;
Number_of_lines Relay_log_name  Relay_log_pos   Master_log_name Master_log_pos  Sql_delay       Number_of_workers       Id

**** slave_master_info on server_1 ****
SELECT * FROM mysql.slave_master_info;
Number_of_lines Master_log_name Master_log_pos  Host    User_name       User_password   Port    Connect_retry   Enabled_ssl     Ssl_ca  Ssl_capath      Ssl_cert
        Ssl_cipher      Ssl_key Ssl_verify_server_cert  Heartbeat       Bind    Ignored_server_ids      Uuid    Retry_count     Ssl_crl Ssl_crlpath     Enabled_auto_position
rand_seed: '' _rand_state: ''
extra debug info if any: ''
connection master;

More results from queries before failure can be found in /home/jtolmer/source/oracle_mysql/bld_debug/mysql-test/var/log/rpl_dump_thread_kill.log

How to repeat:
mkdir bld_debug
cd bld_debug
cmake .. -DCMAKE_BUILD_TYPE=Debug -DWITHOUT_ROCKSDB_SE_STORAGE_ENGINE=1 -DMYSQL_MAINTAINER_MODE=0
make -j12
cd mysql-test
./mtr --mem rpl.rpl_dump_thread_kill
[17 Dec 2015 7:05] MySQL Verification Team
Hello Justin,

Thank you for the report.
Verified as described with 5.6.27.

Thanks,
Umesh
[17 Dec 2015 7:05] MySQL Verification Team
// OS & other details

[ushastry@cluster-repo bugs]# md5sum mysql-5.6.27.tar.gz
7754df40bb5567b03b041ccb6b5ddffa  mysql-5.6.27.tar.gz

[ushastry@cluster-repo mysql-test]# cat /etc/*release
LSB_VERSION=base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Oracle Linux Server release 6.7
NAME="Oracle Linux Server"
VERSION="6.7"
ID="ol"
VERSION_ID="6.7"
PRETTY_NAME="Oracle Linux Server 6.7"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:6:7"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 6"
ORACLE_BUGZILLA_PRODUCT_VERSION=6.7
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=6.7
Red Hat Enterprise Linux Server release 6.7 (Santiago)
Oracle Linux Server release 6.7
[ushastry@cluster-repo mysql-test]# cmake --version
cmake version 2.8.12.2
[ushastry@cluster-repo mysql-test]# gcc --version
gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[ushastry@cluster-repo bld_debug]# cd mysql-test/
[ushastry@cluster-repo mysql-test]# ./mtr --mem rpl.rpl_dump_thread_kill
Logging: /data/ushastry/bugs/mysql-5.6.27/mysql-test/mysql-test-run.pl  --mem rpl.rpl_dump_thread_kill
2015-12-19 19:18:41 0 [Note] /data/ushastry/bugs/mysql-5.6.27/bld_debug/sql/mysqld (mysqld 5.6.27-debug) starting as process 10128 ...
2015-12-19 19:18:41 10128 [Note] Plugin 'FEDERATED' is disabled.
2015-12-19 19:18:41 10128 [Note] Binlog end
2015-12-19 19:18:41 10128 [Note] Shutting down plugin 'CSV'
2015-12-19 19:18:41 10128 [Note] Shutting down plugin 'MyISAM'
MySQL Version 5.6.27
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
 - adding combinations for rpl
Removing old var directory...
Creating var directory '/data/ushastry/bugs/mysql-5.6.27/bld_debug/mysql-test/var'...
 - symlinking 'var' to '/dev/shm/var_auto_GVdo'
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
rpl.rpl_dump_thread_kill 'mix'           [ skipped ]  Doesn't support --binlog-format='mixed'
rpl.rpl_dump_thread_kill 'row'           [ skipped ]  Doesn't support --binlog-format='row'
rpl.rpl_dump_thread_kill 'stmt'          [ fail ]
        Test ended at 2015-12-19 19:19:18

CURRENT_TEST: rpl.rpl_dump_thread_kill
mysqltest: In included file "./include/wait_condition.inc":
included from ./include/wait_condition.inc at line 60:
At line 60: Timeout in wait_condition.inc for $wait_condition

The result from queries just before the failure was:
< snip >
binlog_name = 'master-bin.000002'
SHOW BINLOG EVENTS IN 'master-bin.000002';
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
master-bin.000002       4       Format_desc     1       120     Server ver: 5.6.27-debug-log, Binlog ver: 4

**** 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

**** slave_relay_info on server_1 ****
SELECT * FROM mysql.slave_relay_log_info;
Number_of_lines Relay_log_name  Relay_log_pos   Master_log_name Master_log_pos  Sql_delay       Number_of_workers       Id

**** slave_master_info on server_1 ****
SELECT * FROM mysql.slave_master_info;
Number_of_lines Master_log_name Master_log_pos  Host    User_name       User_password   Port    Connect_retry   Enabled_ssl     Ssl_ca  Ssl_capath      Ssl_cert        Ssl_cipher      Ssl_key Ssl_verify_server_cert    Heartbeat       Bind    Ignored_server_ids      Uuid    Retry_count     Ssl_crl Ssl_crlpath     Enabled_auto_position
rand_seed: '' _rand_state: ''
extra debug info if any: ''
connection master;

More results from queries before failure can be found in /data/ushastry/bugs/mysql-5.6.27/bld_debug/mysql-test/var/log/rpl_dump_thread_kill.log

 - saving '/data/ushastry/bugs/mysql-5.6.27/bld_debug/mysql-test/var/log/rpl.rpl_dump_thread_kill-stmt/' to '/data/ushastry/bugs/mysql-5.6.27/bld_debug/mysql-test/var/log/rpl.rpl_dump_thread_kill-stmt/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 37 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): rpl.rpl_dump_thread_kill

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

2 tests were skipped, 0 by the test itself.

mysql-test-run: *** ERROR: there were failing test cases
[22 Aug 2017 8:31] Margaret Fisher
Development have now patched the affected test. Thanks again for the report.