ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Mysql errors after upgrading form 21.2.7 to 21.2.8


Article ID: 240133


Updated On:


CA Performance Management - Usage and Administration DX NetOps


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

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