Bug #119252 Test router.response_cache failure

• Submitted: 28 Oct 4:50
• Reporter: Laurynas Biveinis (OCA)
• Status: Open
• Category: Tests
• Severity: S7 (Test Cases)
• Version: 9.5.0
• OS: MacOS (26.0.1)
• CPU Architecture: ARM

[28 Oct 4:50] Laurynas Biveinis

Description:
./mtr router.response_cache
...
[ 50%] router.response_cache                     [ fail ]
        Test ended at 2025-10-28 06:48:41

CURRENT_TEST: router.response_cache
--- /Users/laurynas/vilniusdb/mysql-9.5.0/mysql-test/suite/router/r/response_cache.result	2025-10-21 18:23:38
+++ /Users/laurynas/vilniusdb/mysql-9.5.0/_build-debug-san/mysql-test/var/log/response_cache.reject	2025-10-28 07:48:40
@@ -584,7 +584,7 @@
 select max(TIMER_END) into @initial_time from performance_schema.events_statements_history_long;
 select max(TIMER_END) into @initial_time from performance_schema.events_statements_history_long;
 stats
-{"files": 1, "items": 5, "fileHits": 1.0, "itemHits": 10.0, "endpoints": 11, "fileLoads": 2.0, "itemLoads": 9.0, "fileEjects": 1.0, "fileMisses": 2.0, "itemEjects": 3.0, "itemMisses": 10.0}
+{"files": 1, "items": 5, "fileHits": 1.0, "itemHits": 10.0, "endpoints": 11, "fileLoads": 2.0, "itemLoads": 9.0, "fileEjects": 1.0, "fileMisses": 2.0, "itemEjects": 2.0, "itemMisses": 10.0}
 update performance_schema.setup_consumers set enabled="YES" where name='events_statements_history_long';
 DROP SCHEMA basic_schema;
 DROP SCHEMA mysql_rest_service_metadata;

mysqltest: Result content mismatch

The result from queries just before the failure was:
{
    "result": "6",
    "_metadata": {
        "gtid":GTID
    }
}
OK
select max(TIMER_END) into @initial_time from performance_schema.events_statements_history_long;
select max(TIMER_END) into @initial_time from performance_schema.events_statements_history_long;
select max(TIMER_END) into @initial_time from performance_schema.events_statements_history_long;
stats
{"files": 1, "items": 5, "fileHits": 1.0, "itemHits": 10.0, "endpoints": 11, "fileLoads": 2.0, "itemLoads": 9.0, "fileEjects": 1.0, "fileMisses": 2.0, "itemEjects": 2.0, "itemMisses": 10.0}
update performance_schema.setup_consumers set enabled="YES" where name='events_statements_history_long';
DROP SCHEMA basic_schema;
DROP SCHEMA mysql_rest_service_metadata;
DROP ROLE mysql_rest_service_admin;
DROP ROLE mysql_rest_service_schema_admin;
DROP ROLE mysql_rest_service_meta_provider;
DROP ROLE mysql_rest_service_data_provider;
DROP ROLE mysql_rest_service_dev;
safe_process[91966]: Child process: 91970, exit: 1

How to repeat:
CMake options -DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DFORCE_UNSUPPORTED_COMPILER=ON -DCMAKE_BUILD_TYPE=Debug -DWITH_DEBUG=ON -DMYSQL_MAINTAINER_MODE=ON -DWITH_SYSTEM_LIBS=ON -DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF -DFORCE_COLORED_OUTPUT=ON -DCMAKE_CXX_FLAGS=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_DEBUG=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_RELEASE=-O2 -DNDEBUG -Wno-nonnull -g