Alexander Barkov added a comment - 2024-10-28 10:40 - edited The problem happens because when a package procedure (or a package function) is executed, performance schema remembers it as: type='procedure' db='db' name='pkg1.p1' When a DROP DATABASE happens, performance schema removes from its cached only a record like this: type='package body' db='db' name='pkg1' To make it work properly, when removing a package body from the perfschema cache, it should parse the package body and remove its all routines. This looks quite complex. Another option is to remember package routines in perfschema as their owner package body. So when db.pkg1.p1 is executed, perfschema remembers it as: type='package body' db='db' name='pkg1' But this will worsen the statistics.

Daniel Black added a comment - 2024-12-19 02:50 https://buildbot.mariadb.org/#/builders/534/builds/23551 (main) CURRENT_TEST: perfschema.lowercase_fs_off --- /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/suite/perfschema/r/lowercase_fs_off.result 2024-12-14 12:15:59.000000000 +0000 +++ /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/suite/perfschema/r/lowercase_fs_off.reject 2024-12-14 12:27:47.236326902 +0000 @@ -16,7 +16,7 @@ FROM performance_schema.events_statements_summary_by_program WHERE object_type='procedure' AND LOWER(object_schema)='m33020_db1'; object_type object_schema object_name count_star count_statements sum_rows_sent -PROCEDURE m33020_DB1 sp 1 1 1 -PROCEDURE m33020_db1 sp 1 1 1 +PROCEDURE m33020_DB1 sp 2 2 1 +PROCEDURE m33020_db1 sp 2 2 1 DROP DATABASE m33020_db1; DROP DATABASE m33020_DB1;

Yuchen Pei added a comment - 2024-12-20 02:50 Not sure how this can be reproduced locally, not with the old trick of --no-reorder, i.e. the following passes at f5821aaf7731e1f74b970fdaf186b945ae012c9d despite failing in the previous buildbot link, with or without --ps-protocol: mtr --no-reorder perfschema.information_schema perfschema.lowercase_fs_off This was from August and looks like the same failure https://buildbot.mariadb.org/#/builders/572/builds/12277

Yuchen Pei added a comment - 2025-01-21 00:24 Just encountered the new failure in https://buildbot.mariadb.org/#/builders/369/builds/27641

Yuchen Pei added a comment - 2025-03-03 23:50 The latest failure on 11.8 on the new buildbot is from 2025-02-17 59ad3225ae16b5672f10f30841ef414a8cb0d42c: https://buildbot.mariadb.org/#/builders/572/builds/16691 cross ref could not find anything on the old buildbot: https://buildbot.mariadb.net/ci/reports/cross_reference#branch=11.8&revision=&platform=&fail_name=perfschema.lowercase_fs_off&fail_variant=&fail_info_full=&typ=&info=&dt=&limit=100&fail_info_short=