Bug #113665 perfschema.relaylog fails with a result difference

• Submitted: 17 Jan 14:06
• Modified: 17 Oct 12:59
• Reporter: Laurynas Biveinis (OCA)
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 8.0.40, 8.4.3, 9.1.0
• OS: MacOS (12.4.1)
• 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

[2 Jul 13:44] Laurynas Biveinis

Did not reproduce on 8.0.38
Reproduced on 8.4.1

[3 Jul 6:28] Laurynas Biveinis

Did not reproduce on 9.0.0

[16 Oct 11:01] Laurynas Biveinis

Same on 8.0.40

[17 Oct 10:46] Laurynas Biveinis

Same on 8.4.3

[17 Oct 12:59] Laurynas Biveinis

Same on 9.1.0