Since the PM was upgraded to 21.2.10, the following errors are stored in the /opt/CA/MySql/data/PerformanceCenter.gestion.enaire.es.err file:
There is a version mismatch between em and netqosportal database schemas:
DX NetOps Performance Management 21.2.10
Stored procedures didn't get installed properly.
1. Download the 2 stored procedures files from this KB article.
2. Copy the 2 stored procedures files into the /opt/CA/PerformanceCenter/EM/ directory.
3. Run this command and save the output to a text file:
ls -lah /opt/CA/MySql/data/em/*.ibd
4. Stop the Event Manager service. Other services can remain running. Run:
systemctl stop caperfcenter_eventmanager
5. Run the following, from the /opt/CA/MySql/bin/ folder (this should be quick):
cd /opt/CA/MySql/bin/
./mysql em -p < /opt/CA/PerformanceCenter/EM/SQL/update_rotate_partitions_collation.sql
6. Run the following, from the /opt/CA/MySql/bin/ folder (this should take a while):
./mysql em -p < /opt/CA/PerformanceCenter/EM/SQL/merge_old_event_partitions.sql
7. When the command completes restart the Event Manager service. Run:
systemctl start caperfcenter_eventmanager
8. Run this command and save the output to a text file:
ls -lah /opt/CA/MySql/data/em/*.ibd
You may want to compare the ls outputs.
In DX NetOps PM 21.2.8 we enhanced to support for MySQL 8.
We used to use daily partitions to go with pmax. The merge_old_event_partitions.sql stored procedure moves all the p<date> partitions into pmax so that the partition maintenance would operate on all data.
The stored procedures will not update the em.revision info table.