Description:
Seeing the following test failure with MySQL 5.7.24 generic binary / Tested on CentOS6 32 bit
# uname -a
Linux 2.6.32-573.3.1.el6.i686 #1 SMP Thu Aug 13 19:58:36 UTC 2015 i686 i686 i386 GNU/Linux
=
mysql-test]# ./mtr --force rpl.rpl_no_gtid_split_statements
Logging: ./mtr --force rpl.rpl_no_gtid_split_statements
MySQL Version 5.7.24
Checking supported features...
- SSL connections supported
Collecting tests...
- adding combinations for rpl
Checking leftover processes...
Removing old var directory...
Creating var directory '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var'...
Installing system database...
Using parallel: 1
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
[ 33%] rpl.rpl_no_gtid_split_statements 'mix' [ skipped ] Doesn't support --binlog-format='mixed'
[ 66%] rpl.rpl_no_gtid_split_statements 'row' [ skipped ] Doesn't support --binlog-format='row'
[100%] rpl.rpl_no_gtid_split_statements 'stmt' [ fail ]
Test ended at 2018-11-26 05:54:34
CURRENT_TEST: rpl.rpl_no_gtid_split_statements
mysqltest: In included file ./include/write_result_to_file.inc at line 102:
included from ./include/assert_binlog_events.inc at line 188:
included from ./extra/rpl_tests/rpl_drop_multiple_tables.inc at line 123:
included from ./extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc at line 32:
included from ./extra/rpl_tests/rpl_split_statements.test at line 237:
included from /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/suite/rpl/t/rpl_no_gtid_split_statements.test at line 5:
At line 88: popen("perl /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/tmp8EpTU6", "r") failed
The result from queries just before the failure was:
< snip >
BEGIN
DROP TABLE IF EXISTS base;
DROP TABLE IF EXISTS temp_t;
DROP TABLE IF EXISTS temp_n;
END|
include/rpl_sync.inc
---- GTID_MODE=AUTOMATIC ----
CALL create_tables();
include/gtid_step_reset.inc
DROP TABLE base, temp_t;
include/gtid_step_assert.inc [count=2, only_count=0]
include/assert_binlog_events.inc
DROP TABLE temp_n;
include/rpl_sync.inc
include/rpl_reset.inc
CALL create_tables();
include/gtid_step_reset.inc
DROP TABLE base, temp_n;
include/gtid_step_assert.inc [count=2, only_count=0]
include/assert_binlog_events.inc
safe_process[23489]: Child process: 23490, exit: 1
- the logfile can be found in '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/log/rpl.rpl_no_gtid_split_statements-stmt/rpl_no_gtid_split_statements.log'
Retrying test rpl.rpl_no_gtid_split_statements, attempt(2/3)...
[100%] rpl.rpl_no_gtid_split_statements 'stmt' [ retry-fail ]
Test ended at 2018-11-26 05:54:40
CURRENT_TEST: rpl.rpl_no_gtid_split_statements
mysqltest: In included file ./include/write_result_to_file.inc at line 102:
included from ./include/assert_binlog_events.inc at line 188:
included from ./extra/rpl_tests/rpl_drop_multiple_tables.inc at line 123:
included from ./extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc at line 32:
included from ./extra/rpl_tests/rpl_split_statements.test at line 237:
included from /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/suite/rpl/t/rpl_no_gtid_split_statements.test at line 5:
At line 88: popen("perl /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/tmp4Zccl4", "r") failed
The result from queries just before the failure was:
< snip >
BEGIN
DROP TABLE IF EXISTS base;
DROP TABLE IF EXISTS temp_t;
DROP TABLE IF EXISTS temp_n;
END|
include/rpl_sync.inc
---- GTID_MODE=AUTOMATIC ----
CALL create_tables();
include/gtid_step_reset.inc
DROP TABLE base, temp_t;
include/gtid_step_assert.inc [count=2, only_count=0]
include/assert_binlog_events.inc
DROP TABLE temp_n;
include/rpl_sync.inc
include/rpl_reset.inc
CALL create_tables();
include/gtid_step_reset.inc
DROP TABLE base, temp_n;
include/gtid_step_assert.inc [count=2, only_count=0]
include/assert_binlog_events.inc
safe_process[23568]: Child process: 23569, exit: 1
- the logfile can be found in '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/log/rpl.rpl_no_gtid_split_statements-stmt/rpl_no_gtid_split_statements.log'
Test rpl.rpl_no_gtid_split_statements has failed 2 times, no more retries!
--------------------------------------------------------------------------
The servers were restarted 1 times
Spent 0.000 of 18 seconds executing testcases
Completed: Failed 1/1 tests, 0.00% were successful.
Failing test(s): rpl.rpl_no_gtid_split_statements
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
How to repeat:
Download MySQL generic binaries on 32 bit OS
Test following test,
./mtr --force rpl.rpl_no_gtid_split_statements
Description: Seeing the following test failure with MySQL 5.7.24 generic binary / Tested on CentOS6 32 bit # uname -a Linux 2.6.32-573.3.1.el6.i686 #1 SMP Thu Aug 13 19:58:36 UTC 2015 i686 i686 i386 GNU/Linux = mysql-test]# ./mtr --force rpl.rpl_no_gtid_split_statements Logging: ./mtr --force rpl.rpl_no_gtid_split_statements MySQL Version 5.7.24 Checking supported features... - SSL connections supported Collecting tests... - adding combinations for rpl Checking leftover processes... Removing old var directory... Creating var directory '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped [ 33%] rpl.rpl_no_gtid_split_statements 'mix' [ skipped ] Doesn't support --binlog-format='mixed' [ 66%] rpl.rpl_no_gtid_split_statements 'row' [ skipped ] Doesn't support --binlog-format='row' [100%] rpl.rpl_no_gtid_split_statements 'stmt' [ fail ] Test ended at 2018-11-26 05:54:34 CURRENT_TEST: rpl.rpl_no_gtid_split_statements mysqltest: In included file ./include/write_result_to_file.inc at line 102: included from ./include/assert_binlog_events.inc at line 188: included from ./extra/rpl_tests/rpl_drop_multiple_tables.inc at line 123: included from ./extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc at line 32: included from ./extra/rpl_tests/rpl_split_statements.test at line 237: included from /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/suite/rpl/t/rpl_no_gtid_split_statements.test at line 5: At line 88: popen("perl /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/tmp8EpTU6", "r") failed The result from queries just before the failure was: < snip > BEGIN DROP TABLE IF EXISTS base; DROP TABLE IF EXISTS temp_t; DROP TABLE IF EXISTS temp_n; END| include/rpl_sync.inc ---- GTID_MODE=AUTOMATIC ---- CALL create_tables(); include/gtid_step_reset.inc DROP TABLE base, temp_t; include/gtid_step_assert.inc [count=2, only_count=0] include/assert_binlog_events.inc DROP TABLE temp_n; include/rpl_sync.inc include/rpl_reset.inc CALL create_tables(); include/gtid_step_reset.inc DROP TABLE base, temp_n; include/gtid_step_assert.inc [count=2, only_count=0] include/assert_binlog_events.inc safe_process[23489]: Child process: 23490, exit: 1 - the logfile can be found in '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/log/rpl.rpl_no_gtid_split_statements-stmt/rpl_no_gtid_split_statements.log' Retrying test rpl.rpl_no_gtid_split_statements, attempt(2/3)... [100%] rpl.rpl_no_gtid_split_statements 'stmt' [ retry-fail ] Test ended at 2018-11-26 05:54:40 CURRENT_TEST: rpl.rpl_no_gtid_split_statements mysqltest: In included file ./include/write_result_to_file.inc at line 102: included from ./include/assert_binlog_events.inc at line 188: included from ./extra/rpl_tests/rpl_drop_multiple_tables.inc at line 123: included from ./extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc at line 32: included from ./extra/rpl_tests/rpl_split_statements.test at line 237: included from /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/suite/rpl/t/rpl_no_gtid_split_statements.test at line 5: At line 88: popen("perl /mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/tmp4Zccl4", "r") failed The result from queries just before the failure was: < snip > BEGIN DROP TABLE IF EXISTS base; DROP TABLE IF EXISTS temp_t; DROP TABLE IF EXISTS temp_n; END| include/rpl_sync.inc ---- GTID_MODE=AUTOMATIC ---- CALL create_tables(); include/gtid_step_reset.inc DROP TABLE base, temp_t; include/gtid_step_assert.inc [count=2, only_count=0] include/assert_binlog_events.inc DROP TABLE temp_n; include/rpl_sync.inc include/rpl_reset.inc CALL create_tables(); include/gtid_step_reset.inc DROP TABLE base, temp_n; include/gtid_step_assert.inc [count=2, only_count=0] include/assert_binlog_events.inc safe_process[23568]: Child process: 23569, exit: 1 - the logfile can be found in '/mysql/mysql-5.7.24-linux-glibc2.12-i686/mysql-test/var/log/rpl.rpl_no_gtid_split_statements-stmt/rpl_no_gtid_split_statements.log' Test rpl.rpl_no_gtid_split_statements has failed 2 times, no more retries! -------------------------------------------------------------------------- The servers were restarted 1 times Spent 0.000 of 18 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): rpl.rpl_no_gtid_split_statements 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 How to repeat: Download MySQL generic binaries on 32 bit OS Test following test, ./mtr --force rpl.rpl_no_gtid_split_statements