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
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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