While preparing to upgrade Active IQ Unified Manager, MySQL does not start after upgrading to 8.0.x from 5.7.x
Applies to
- MySQL 5.7 -> 8.0 upgrades
- Red Hat Enterprise Linux or CentOS
Issue
- While preparing to upgrade Active IQ Unified Manager, MySQL does not start after upgrading to 8.0.x from 5.7.x
- Errors like the following are observed in
/var/log/mysql/error.log
2021-03-05T13:37:39.311701Z 2 [ERROR] [MY-013140] [Server] Can't find file: './netapp_performance/sample_current_vserver.frm' (errno: 0 - Success)
2021-03-05T13:37:39.311876Z 2 [ERROR] [MY-013137] [Server] Can't find file: './netapp_performance/sample_current_vserver.frm' (OS errno: 0 - Success)
2021-03-05T13:37:39.312063Z 2 [ERROR] [MY-010348] [Server] Error in reading file ./netapp_performance/sample_current_vserver.frm
2021-03-05T13:37:39.312248Z 2 [ERROR] [MY-010758] [Server] Error in creating TABLE_SHARE from sample_current_vserver.frm file.
2021-03-05T13:37:39.312824Z 2 [ERROR] [MY-013140] [Server] Can't find file: './netapp_performance/sample_current_volume.frm' (errno: 0 - Success)
2021-03-05T13:37:39.313018Z 2 [ERROR] [MY-013137] [Server] Can't find file: './netapp_performance/sample_current_volume.frm' (OS errno: 0 - Success)
2021-03-05T13:37:39.313205Z 2 [ERROR] [MY-010348] [Server] Error in reading file ./netapp_performance/sample_current_volume.frm
2021-03-05T13:37:39.313399Z 2 [ERROR] [MY-010758] [Server] Error in creating TABLE_SHARE from sample_current_volume.frm file.
2021-03-05T13:37:39.369719Z 2 [ERROR] [MY-013140] [Server] Can't find file: './netapp_performance/sample_current_qos_workload_detail.frm' (errno: 0 - Success)
2021-03-05T13:37:39.369941Z 2 [ERROR] [MY-013137] [Server] Can't find file: './netapp_performance/sample_current_qos_workload_detail.frm' (OS errno: 0 - Success)
2021-03-05T13:37:39.370149Z 2 [ERROR] [MY-010348] [Server] Error in reading file ./netapp_performance/sample_current_qos_workload_detail.frm
2021-03-05T13:37:39.370361Z 2 [ERROR] [MY-010758] [Server] Error in creating TABLE_SHARE from sample_current_qos_workload_detail.frm file.