I just looked into the MySQL error log on Portal DB server. There are some messages since we upgraded the environment the day before yesterday.
2022-04-12T22:00:00.524057Z 3498 [ERROR] [MY-010045] [Server] Event Scheduler: [[email protected]%][em.e_rotate_event_partitions] VALUES value for partition 'p20220413' must have type INT 2022-04-12T22:00:00.524121Z 3498 [Note] [MY-010046] [Server] Event Scheduler: [[email protected]%].[em.e_rotate_event_partitions] event execution failed.
2022-04-27T22:00:00.958266Z 6067 [ERROR] [MY-010045] [Server] Event Scheduler: [[email protected]][em.e_rotate_event_partitions] Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_tolower_ci,IMPLICIT) for operation '='
It seems the new stored procedure for 21.2.x didn't get installed.
Release : 21.2
mysql -p em < /tmp/event_partitions.sql