Mysql errors after upgrading form 21.2.7 to 21.2.8

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

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 '='

Cause

It seems the new stored procedure for 21.2.x didn't get installed.

Environment

Release : 21.2

Component :

Resolution

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