Bug #119252 Test router.response_cache failure

Submitted:	28 Oct 2025 4:50	Modified:	24 Mar 13:34
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Open	Impact on me:	None
Category:	Tests	Severity:	S7 (Test Cases)
Version:	9.6.0	OS:	MacOS (26.0.1)
Assigned to:		CPU Architecture:	ARM

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

Same on 9.6.0

Does not reproduce under 9.7.0-er

Page generated in 0.050 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.