Description:
I've noted that rpl.rpl_gtid_disconnect_drop_temporary_table fails on MySQL 8.0.11 built from GitHub source on up to date 64-bit Ubuntu 14.04:
openxs@ao756:~/dbs/8.0/mysql-test$ ./mtr rpl.rpl_gtid_disconnect_drop_temporary_table
Logging: ./mtr rpl.rpl_gtid_disconnect_drop_temporary_table
2018-04-22T18:18:18.076722Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161)
2018-04-22T18:18:18.076868Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000)
2018-04-22T18:18:18.077316Z 0 [System] [MY-010116] [Server] /home/openxs/dbs/8.0/bin/mysqld (mysqld 8.0.11) starting as process 19367
MySQL Version 8.0.11
Checking supported features...
- SSL connections supported
Collecting tests...
- adding combinations for rpl
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/openxs/dbs/8.0/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
rpl.rpl_gtid_disconnect_drop_temporary_table 'mix' [ fail ]
Test ended at 2018-04-22 21:24:40
CURRENT_TEST: rpl.rpl_gtid_disconnect_drop_temporary_table
mysqltest: In included file ./include/assert_binlog_events.inc at line 328:
included from /home/openxs/dbs/8.0/mysql-test/suite/rpl/t/rpl_gtid_disconnect_drop_temporary_table.test at line 99:
At line 318: Binlog contents did not match expected pattern.
The result from queries just before the failure was:
< snip >
SELECT * FROM mysql.gtid_executed;
source_uuid interval_start interval_end
rpl_topology= 1->2
rand_seed: '' _rand_state: ''
extra debug info if any: ''
rpl_topology=1->2
connection master;
event_sequence=(Anonymous_)?Gtid # !Q(DROP.*TEMPORARY.*)
Regex:
^(Anonymous_)?Gtid(?:/[^
]*)?
Query/(?:use.*; )?DROP.*TEMPORARY.*(?:/[^
]*)?
?$
File contents:
statement=SHOW BINLOG EVENTS IN 'master-bin.000001' FROM 336
invert=
include_header_events=
event_separator=
safe_process[19495]: Child process: 19496, exit: 1
- the logfile can be found in '/home/openxs/dbs/8.0/mysql-test/var/log/rpl.rpl_gtid_disconnect_drop_temporary_table-mix/rpl_gtid_disconnect_drop_temporary_table.log'
Only 1 of 3 completed.
mysql-test-run: *** ERROR: Not all tests completed
How to repeat:
Build MySQL 8.0.11 from GitHub source using the following cmake command:
openxs@ao756:~/git/mysql-server$ cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/8.0 -DWITH_BOOST=/home/openxs/boost -DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_UNIT_TESTS=OFF
Then install it, got to the mysql-test subdirectory and run the test:
./mtr rpl.rpl_gtid_disconnect_drop_temporary_table
Enjoy the results.
Suggested fix:
Do something for this test not to fail.
Description: I've noted that rpl.rpl_gtid_disconnect_drop_temporary_table fails on MySQL 8.0.11 built from GitHub source on up to date 64-bit Ubuntu 14.04: openxs@ao756:~/dbs/8.0/mysql-test$ ./mtr rpl.rpl_gtid_disconnect_drop_temporary_table Logging: ./mtr rpl.rpl_gtid_disconnect_drop_temporary_table 2018-04-22T18:18:18.076722Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2018-04-22T18:18:18.076868Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2018-04-22T18:18:18.077316Z 0 [System] [MY-010116] [Server] /home/openxs/dbs/8.0/bin/mysqld (mysqld 8.0.11) starting as process 19367 MySQL Version 8.0.11 Checking supported features... - SSL connections supported Collecting tests... - adding combinations for rpl Checking leftover processes... Removing old var directory... Creating var directory '/home/openxs/dbs/8.0/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 rpl.rpl_gtid_disconnect_drop_temporary_table 'mix' [ fail ] Test ended at 2018-04-22 21:24:40 CURRENT_TEST: rpl.rpl_gtid_disconnect_drop_temporary_table mysqltest: In included file ./include/assert_binlog_events.inc at line 328: included from /home/openxs/dbs/8.0/mysql-test/suite/rpl/t/rpl_gtid_disconnect_drop_temporary_table.test at line 99: At line 318: Binlog contents did not match expected pattern. The result from queries just before the failure was: < snip > SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= 1->2 rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology=1->2 connection master; event_sequence=(Anonymous_)?Gtid # !Q(DROP.*TEMPORARY.*) Regex: ^(Anonymous_)?Gtid(?:/[^ ]*)? Query/(?:use.*; )?DROP.*TEMPORARY.*(?:/[^ ]*)? ?$ File contents: statement=SHOW BINLOG EVENTS IN 'master-bin.000001' FROM 336 invert= include_header_events= event_separator= safe_process[19495]: Child process: 19496, exit: 1 - the logfile can be found in '/home/openxs/dbs/8.0/mysql-test/var/log/rpl.rpl_gtid_disconnect_drop_temporary_table-mix/rpl_gtid_disconnect_drop_temporary_table.log' Only 1 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed How to repeat: Build MySQL 8.0.11 from GitHub source using the following cmake command: openxs@ao756:~/git/mysql-server$ cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DCMAKE_INSTALL_PREFIX=/home/openxs/dbs/8.0 -DWITH_BOOST=/home/openxs/boost -DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_UNIT_TESTS=OFF Then install it, got to the mysql-test subdirectory and run the test: ./mtr rpl.rpl_gtid_disconnect_drop_temporary_table Enjoy the results. Suggested fix: Do something for this test not to fail.