Bug #113665 perfschema.relaylog fails with a result difference
Submitted: 17 Jan 14:06 Modified: 6 May 9:16
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:8.0.37, 8.4.0 OS:MacOS (12.4.1)
Assigned to: CPU Architecture:ARM

[17 Jan 14:06] Laurynas Biveinis
Description:
./mtr perfschema.relaylog
...
[ 50%] perfschema.relaylog                       [ fail ]
        Test ended at 2024-01-17 16:04:41

CURRENT_TEST: perfschema.relaylog
--- /Users/laurynas/vilniusdb/mysql-8.0.36/mysql-test/suite/perfschema/r/relaylog.result	2024-01-17 13:21:28
+++ /Users/laurynas/vilniusdb/mysql-8.0.36/_build-release/mysql-test/var/log/relaylog.reject	2024-01-17 17:04:41
@@ -101,8 +101,8 @@
   order by event_name;
 EVENT_NAME	COUNT_STAR	SUM_TIMER_WAIT	MIN_TIMER_WAIT	AVG_TIMER_WAIT	MAX_TIMER_WAIT
 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_commit	NONE	NONE	NONE	NONE	NONE
-wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index	MANY	MANY	MANY	MANY	MANY
-wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log	MANY	MANY	MANY	MANY	MANY
+wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index	MANY	NONE	NONE	NONE	NONE
+wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log	MANY	NONE	NONE	NONE	NONE
 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log_end_pos	NONE	NONE	NONE	NONE	NONE
 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_sync	NONE	NONE	NONE	NONE	NONE
 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_xids	NONE	NONE	NONE	NONE	NONE

mysqltest: Result content mismatch

How to repeat:
Server built with CMake options
-DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DMYSQL_MAINTAINER_MODE=ON -DDOWNLOAD_BOOST=ON -DWITH_BOOST=~/vilniusdb/mysql-boost/ -DWITH_SYSTEM_LIBS=ON -DFORCE_COLORED_OUTPUT=ON -DCMAKE_C_FLAGS_DEBUG=-g -DCMAKE_CXX_FLAGS_DEBUG=-g -DCMAKE_CXX_FLAGS_RELEASE=-O2 -g -DNDEBUG -Wno-unused-variable
[17 Jan 14:15] MySQL Verification Team
Thank you for the report
[23 Jan 11:39] Laurynas Biveinis
Same on 8.3.0.
[6 May 7:17] Laurynas Biveinis
Same on 8.0.37
[6 May 9:16] Laurynas Biveinis
Same on 8.4.0