| Bug #77875 | Test rpl.rpl_gtid_drop_table fails | ||
|---|---|---|---|
| Submitted: | 29 Jul 2015 19:20 | Modified: | 30 Jul 2015 7:41 |
| Reporter: | Justin Tolmer | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | Tests: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.6.26 | OS: | CentOS (6.6) |
| Assigned to: | CPU Architecture: | Any | |
[30 Jul 2015 7:41]
MySQL Verification Team
Hello Justin, Thank you for the report. Observed this on CentOS 6.6 but had not seen on OL6, OL7. Thanks, Umesh
[30 Jul 2015 7:45]
MySQL Verification Team
5.6.26 results
Attachment: 77875.results (application/octet-stream, text), 10.23 KiB.
[17 Mar 2016 9:38]
Viswanatham Gudipati
Posted by developer:
rpl.rpl_gtid_drop_table 'mix' w3 [ fail ]
Test ended at 2016-03-17 04:32:03
CURRENT_TEST: rpl.rpl_gtid_drop_table
mysqltest: In included file .\include\assert.inc at line 72:
included from G:\ade\test\sb_1-18302185-1458149228.93\mysql-advanced-5.8.0-dmr-winx64\mysql-test\suite\rpl\t\rpl_gtid_drop_table.test at line 336:
At line 71: Test assertion failed in assert.inc
The result from queries just before the failure was:
< snip >
Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name
**** 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 Channel_name Tls_version
**** mysql.gtid_executed on server_1 ****
SELECT * FROM mysql.gtid_executed;
source_uuid interval_start interval_end
11111111-1111-1111-1111-111111111111 1 4
c2be0176-ebf0-11e5-a517-0021f6bb0015 1 24
rpl_topology= 1->2->3
rand_seed: '' _rand_state: ''
extra debug info if any: ''
rpl_topology=1->2->3
connection slave;
Assertion text: 'Slave_open_temp_tables should be 0'
Assertion condition: '[SHOW STATUS LIKE "Slave_open_temp_tables", Value, 1] = 0'
Assertion condition, interpolated: '10 = 0'
Assertion result: '0'
rpl.rpl_gtid_drop_table 'stmt' w4 [ retry-pass ] 22313
Failure History :
http://pb2.no.oracle.com/?template=mysql_show_test_failure&test_failure_id=&test_output_id...
Run command:
mysql-test-run.pl --force --timer --parallel=auto --suite=rpl --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on --parallel=8
Description: We're running mysql-test-run tests based on mysql-test/collections/default.weekly, but hit a failure. rpl.rpl_gtid_drop_table 'mix' w1 [ fail ] Test ended at 2015-07-29 12:08:38 CURRENT_TEST: rpl.rpl_gtid_drop_table mysqltest: In included file "./include/assert.inc": included from ./include/assert.inc at line 67: At line 66: Test assertion failed in assert.inc The result from queries just before the failure was: < snip > **** 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_pos ition rand_seed: '' _rand_state: '' extra debug info if any: '' connection slave; Assertion text: 'Slave_open_temp_tables should be 0' Assertion condition: '10 = 0' Assertion condition, interpolated: '10 = 0' Assertion result: '0' How to repeat: I'm building a 64-bit debug build using the current 5.6.26 sources from github. mkdir bld_debug cd bld_debug cmake .. -DCMAKE_BUILD_TYPE=Debug make -j12 cd mysql-test ./mtr --debug-server --parallel=auto --mysqld=--enforce-gtid-consistency --mysqld=--log-slave-updates --mysqld=--gtid-mode=on rpl.rpl_gtid_drop_table cat /etc/centos-release CentOS release 6.6 (Final) git log --oneline | head 9c6193f Update docker package names 5ae4527 BUG#20894024 - FIREWALL STILL DEPENDS ON MAX_DIGEST_SIZE OF THE P_S DIGEST 156faa3 955bcbb Bug#17650326 MYSQLBINLOG PRINTS INVALID SQL FROM RELAY LOGS WHEN GTID IS ENABLED 4f88274 Null merging mysql-5.5 to mysql-5.6 92b4683 Bug #19138298 RECORD IN INDEX WAS NOT FOUND ON ROLLBACK, TRYING TO INSERT dc2aa05 Bug #19929435 DROP DATABASE HANGS WITH MALFORMED TABLE 0e4b83d Merge branch 'mysql-5.5' into mysql-5.6 00fd99c Bug #18075170 SQL NODE RESTART REQUIRED TO AVOID DEADLOCK AFTER RESTORE bfba233 Bug #21184091 ASSERT `READ_ROWS >= 0.0' AT COST_MODEL_SERVER::TMPTABLE_READWRITE_COST()