MYSQL service fails to start due to missing "File './unified-manager.xxxx" OS error
Applies to
- Active IQ Unified Manager 9.6+ (AIQUM)
- VMware Virtual Machine OVA
Issue
Mysql service fails to start and error.log shows below errors:
2024-02-07T08:07:14.238796Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-07T08:07:18.494136Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: File './unified-manager.001940' not found (OS errno 2 - No such file or directory)
2024-02-07T08:07:19.751476Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
mysqld: File './unified-manager.001941' not found (OS errno 2 - No such file or directory)
2024-02-26T09:05:59.635724Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1356
2024-02-26T09:05:59.644683Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-26T09:06:06.171653Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: File './unified-manager.002328' not found (OS errno 2 - No such file or directory)
2024-02-26T09:06:07.103253Z 0 [ERROR] [MY-010958] [Server] Could not open log file.
2024-02-26T09:06:07.103284Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2024-02-26T09:06:07.103345Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-02-26T09:06:09.039758Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.