MySQL 租户中删除存储过程时报错 4016 的原因和解决方法

[2025-02-10 11:55:09.721222] WDIAG [SHARE.SCHEMA] grant_routine (ob_priv_sql_service.cpp:337) [62041][DDLQueueTh0][T0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=29][errcode=-4016] affected_rows unexpected to be one (affected_rows=0, ret=-4016)
[2025-02-10 11:55:09.721249] WDIAG [RS] revoke_routine (ob_ddl_operator.cpp:8482) [62041][DDLQueueTh0][T0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=25][errcode=-4016] Failed to revoke routine(routine_priv_key={tenant_id:1004, user_id:500003, db:"ob_xxx_xxx", routine:"PROC_xxxxx_xxxxx_xxxxx", routine_type:1}, ret=-4016)
[2025-02-10 11:55:09.721263] WDIAG [RS] drop_routine (ob_ddl_service.cpp:35135) [62041][DDLQueueTh0][T0][xxxxx-xxxxx-xxxxx-xxxxx] [lt=12][errcode=-4016] fail to grant routine(ret=-4016, routine_key={tenant_id:1004, user_id:500003, db:"ob_xxx_xxx", routine:"PROC_xxxxx_xxxxx_xxxxx", routine_type:1}, priv_set=137447342080)