| Bug #87125 | Unstable test perfschema.rpl_statements | ||
|---|---|---|---|
| Submitted: | 19 Jul 2017 16:33 | Modified: | 1 Jun 2018 6:59 |
| Reporter: | Laurynas Biveinis (OCA) | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Tests: Replication | Severity: | S3 (Non-critical) |
| Version: | 8.0.2 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mtr | ||
[20 Jul 2017 7:32]
MySQL Verification Team
Hello Laurynas, Thank you for the report. I could not repeat the issue at my end, anything else required(cmake, os etc details) to trigger the issue? Please let me know. -- [umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.2-dmr-linux-glibc2.12-x86_64/mysql-test: ./mtr --debug-server rpl_statements --repeat=20 Logging: ./mtr --debug-server rpl_statements --repeat=20 MySQL Version 8.0.2 Too long tmpdir path '/export/umesh/server/binaries/Trunk/mysql-8.0.2-dmr-linux-glibc2.12-x86_64/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/lsT3xZT7Hq' Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/Trunk/mysql-8.0.2-dmr-linux-glibc2.12-x86_64/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 perfschema.rpl_statements [ pass ] 1121 perfschema.rpl_statements [ pass ] 999 perfschema.rpl_statements [ pass ] 963 perfschema.rpl_statements [ pass ] 975 perfschema.rpl_statements [ pass ] 999 perfschema.rpl_statements [ pass ] 961 perfschema.rpl_statements [ pass ] 999 perfschema.rpl_statements [ pass ] 996 perfschema.rpl_statements [ pass ] 977 perfschema.rpl_statements [ pass ] 949 perfschema.rpl_statements [ pass ] 950 perfschema.rpl_statements [ pass ] 965 perfschema.rpl_statements [ pass ] 935 perfschema.rpl_statements [ pass ] 969 perfschema.rpl_statements [ pass ] 970 perfschema.rpl_statements [ pass ] 964 perfschema.rpl_statements [ pass ] 931 perfschema.rpl_statements [ pass ] 940 perfschema.rpl_statements [ pass ] 939 perfschema.rpl_statements [ pass ] 956 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 19.458 of 52 seconds executing testcases Completed: All 20 tests were successful. Thanks, Umesh
[21 Jul 2017 2:59]
Laurynas Biveinis
I am seeing it quite often on a variety of platforms / build configurations (various versions of Ubuntu, Debian, Mac, debug builds w/ and w/o ASan), but no fully deterministic procedure. You seem to be already testing with high MTR --repeat value, thus what else might help might be a side CPU/I/O load.
[1 Jun 2018 6:59]
MySQL Verification Team
Sorry, even with high cpu load, IO load I'm not seeing this issue on almost all available boxes(Ubuntu, Mac, OL7) and as many as 15+ times with/without ASAN builds. ushastry@ArtfulAardvark:~/Downloads/mysql-8.0.11/bld/mysql-test$ gcc --version gcc (Ubuntu 7.2.0-8ubuntu3.2) 7.2.0 Copyright (C) 2017 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@ArtfulAardvark:~/Downloads/mysql-8.0.11/bld/mysql-test$ cmake --version cat cmake version 3.9.1 CMake suite maintained and supported by Kitware (kitware.com/cmake). ushastry@ArtfulAardvark:~/Downloads/mysql-8.0.11/bld/mysql-test$ cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=17.10 DISTRIB_CODENAME=artful DISTRIB_DESCRIPTION="Ubuntu 17.10" NAME="Ubuntu" VERSION="17.10 (Artful Aardvark)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 17.10" VERSION_ID="17.10" HOME_URL="https://www.ubuntu.com/" SUPPORT_URL="https://help.ubuntu.com/" BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/" PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy" VERSION_CODENAME=artful UBUNTU_CODENAME=artful cmake .. -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../boost -DWITH_ASAN=ON -DWITH_DEBUG=1 -DENABLE_DOWNLOADS=1 make -j8 ushastry@ArtfulAardvark:~/Downloads/mysql-8.0.11/bld/mysql-test$ ./mtr --debug-server rpl_statements --repeat=20 Logging: /home/ushastry/Downloads/mysql-8.0.11/mysql-test/mysql-test-run.pl --debug-server rpl_statements --repeat=20 2018-06-01T06:37:38.507826Z 0 [System] [MY-010116] [Server] /home/ushastry/Downloads/mysql-8.0.11/bld/runtime_output_directory/mysqld-debug (mysqld 8.0.11-debug-asan) starting as process 15051 MySQL Version 8.0.11 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-8.0.11/bld/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 perfschema.rpl_statements [ pass ] 9485 perfschema.rpl_statements [ pass ] 7958 perfschema.rpl_statements [ pass ] 9226 perfschema.rpl_statements [ pass ] 8553 perfschema.rpl_statements [ pass ] 7902 perfschema.rpl_statements [ pass ] 8657 perfschema.rpl_statements [ pass ] 8729 perfschema.rpl_statements [ pass ] 8685 perfschema.rpl_statements [ pass ] 7493 perfschema.rpl_statements [ pass ] 7599 perfschema.rpl_statements [ pass ] 8088 perfschema.rpl_statements [ pass ] 8429 perfschema.rpl_statements [ pass ] 8103 perfschema.rpl_statements [ pass ] 7956 perfschema.rpl_statements [ pass ] 7959 perfschema.rpl_statements [ pass ] 15153 perfschema.rpl_statements [ pass ] 11558 perfschema.rpl_statements [ pass ] 7788 perfschema.rpl_statements [ pass ] 9632 perfschema.rpl_statements [ pass ] 8341 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 177.294 of 326 seconds executing testcases Completed: All 20 tests were successful. Please feel free to open if you are seeing with latest GA builds along with
Description: Intermittently ./mtr --debug-server rpl_statements --repeat=20 ... perfschema.rpl_statements [ fail ] Test ended at 2017-07-19 19:29:52 CURRENT_TEST: perfschema.rpl_statements mysqltest: At line 109: query 'select thread_id into @slave_thread_id from performance_schema.events_statements_history where sql_text like '%marker%'' failed: 1172: Result consisted of more than one row ... How to repeat: See above