main.sp-bugs2 test hangs and fails, if server is compiled without perfschema

worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029

main.sp-bugs2                            [ fail ]

        Test ended at 2025-11-10 15:42:36

CURRENT_TEST: main.sp-bugs2

mysqltest: At line 123: query 'reap' failed: ER_SP_DOES_NOT_EXIST (1305): FUNCTION sys.ps_is_consumer_enabled does not exist

The result from queries just before the failure was:

< snip >

begin

declare found int;

repeat

set found = exists (select * from information_schema.routines where routine_name='f');

if (sys.ps_is_consumer_enabled('events_waits_history_long') = 'yes') then

select * from mysql.user;

end if;

select release_all_locks();

until found end repeat;

end$$

select get_lock('p1', 300);

get_lock('p1', 300)

1

call p1();

connect con1,localhost,root,,;

select get_lock('p1', 300);

get_lock('p1', 300)

0

create function f() returns int return 1;

connection default;