| Bug #106807 | A number of replication-related test cases fail in debug version | ||
|---|---|---|---|
| Submitted: | 23 Mar 2022 7:50 | Modified: | 24 Mar 2022 12:00 |
| Reporter: | Peter Parker | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Tests: Replication | Severity: | S7 (Test Cases) |
| Version: | 8.0.25 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[24 Mar 2022 12:00]
MySQL Verification Team
Hello Peter Parker, Thank you for the report and feedback. I tried to reproduce with 8.0.28 source debug build but not seeing any issues. Could you please try with 8.0.28 and report us back if you are seeing? Thank you. -- -env cat /etc/*release Oracle Linux Server release 7.9 NAME="Oracle Linux Server" VERSION="7.9" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="7.9" PRETTY_NAME="Oracle Linux Server 7.9" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:9:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.9 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.9 Red Hat Enterprise Linux Server release 7.9 (Maipo) Oracle Linux Server release 7.9 scl enable devtoolset-10 bash MYSQL_VERSION="8028_debug" TARGET=/export/home/tmp/ushastry/src/$MYSQL_VERSION rm -rf /export/home/tmp/ushastry/src/$MYSQL_VERSION rm -rf bld/ mkdir bld && cd bld rm -rf CMakeCache.txt /home/umshastr/work/binaries/utils/cmake-3.19/bin/cmake .. \ -DBUILD_CONFIG=mysql_release \ -DWITH_DEBUG=1 \ -DCMAKE_INSTALL_PREFIX=$TARGET \ -DWITH_BOOST=../boost make -j16 make install cd /export/home/tmp/ushastry/src/$MYSQL_VERSION mv bin/mysqld-debug bin/mysqld cd mysql-test - ./mtr --force --timestamp --max-test-fail=0 --suite-timeout=6000 --testcase-timeout=300 --big-test --debug-server --suite=rpl . . 20323 15:45:38 [ 99%] rpl.rpl_row_jsondiff_basic_pk 'stmt' [ pass ] 81568 220323 15:47:03 [ 99%] rpl.rpl_row_jsondiff_datatypes 'row' [ pass ] 62308 220323 15:48:02 [ 99%] rpl.rpl_test_framework 'stmt' [ pass ] 37658 220323 15:48:19 [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 439 times The servers were reinitialized 4 times Spent 13123.745 of 18342 seconds executing testcases Completed: All 1098 tests were successful. 783 tests were skipped, 30 by the test itself. regards, Umesh
[24 Mar 2022 12:15]
MySQL Verification Team
Please note that mtr test case names are also changed after 8.0.26 i.e. slave word is replaced with replica. find . -name rpl_mts_slave_preserve_commit_order_error_nobinlog* find . -name rpl_mts_replica_preserve_commit_order_error_nobinlog* ./suite/rpl/r/rpl_mts_replica_preserve_commit_order_error_nobinlog.result ./suite/rpl/t/rpl_mts_replica_preserve_commit_order_error_nobinlog-slave.opt ./suite/rpl/t/rpl_mts_replica_preserve_commit_order_error_nobinlog.test
[5 Apr 2022 6:10]
MySQL Verification Team
8.0.28 test results - aarch64
Attachment: 106807_8.0.28_aarch64.log (application/octet-stream, text), 961.54 KiB.
Description: one of the failed cases: 220322 17:00:35 [ 6%] rpl.rpl_mts_slave_preserve_commit_order_error_nobinlog 'mix' w3 [ fail ] Test ended at 2022-03-22 17:00:35 CURRENT_TEST: rpl.rpl_mts_slave_preserve_commit_order_error_nobinlog mysqltest: At line 67: Timeout in wait_condition.inc for $wait_condition In included file ./include/wait_condition.inc: 68 included from /data/mtr/pq_debug/mysql-test/suite/rpl/t/rpl_mts_slave_preserve_commit_order_error_nobinlog.test: 63 The result from queries just before the failure was: 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 Channel_name Privilege_checks_username Privilege_checks_hostname Require_row_format Require_table_primary_key_check Assign_gtids_to_anonymous_transactions_type Assign_gtids_to_anonymous_transactions_value **** 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 Public_key_path Get_public_key Network_namespace Master_compression_algorithm Master_zstd_compression_level Tls_ciphersuites Source_connection_auto_failover **** mysql.gtid_executed on server_1 **** 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 slave; safe_process[21885]: Child process: 21886, exit: 1 How to repeat: 1. Take source code from https://github.com/mysql/mysql-server/tree/mysql-8.0.25 2. Run cmake: cmake ${SOURCE_DIR} -DBUILD_CONFIG=mysql_release -DWITH_DEBUG=1 3. Compile: make 4. Run the MySQL Test Suite: ./mtr --force --timestamp --max-test-fail=0 --suite-timeout=6000 --testcase-timeout=300 --big-test --debug-server --suite=rpl