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.
Or:
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
Component :
The mysql show create proc.txt file (output of the "show create procedure em.rotate_event_partitions;") has the wrong definition of the procedure.
Here are the steps to fix the issue:
a) Copy the event_partitions.sql file from the Pc box to MySQL box:
scp /opt/CA/PerformanceCenter/EM/SQL/event_partitions.sql
To a temporary folder, like /tmp
b) Then run on the MySQL box:
mysql -p em < /tmp/event_partitions.sql