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:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr

[19 Jul 2017 16:33] Laurynas Biveinis
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
[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