Spectrum install failure due to Mysql failing to start

Products

• CA Spectrum

Issue/Introduction

Mysql will not start on one of the Spectroserver installs of 22.2.5 

 

specadmin@cas-poller bin]$ tail -f MYSQL.OUT

2023-03-08T17:11:48.450747Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2023-03-08T17:11:48.450777Z 0 [System] [MY-010116] [Server] /opt/CA/Spectrum/mysql/bin//mysqld (mysqld 8.0.31-commercial) starting as process 28037

2023-03-08T17:11:48.456707Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.

2023-03-08T17:11:48.462580Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.

2023-03-08T17:11:48.462632Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2023-03-08T17:11:56.448840Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.

2023-03-08T17:11:56.448906Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.

2023-03-08T17:11:56.448932Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: './ddmdb/db_descriptor.ibd' OS error: 71

2023-03-08T17:11:56.448960Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace `ddmdb/db_descriptor` because it could not be opened.

2023-03-08T17:11:57.091192Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2023-03-08T17:12:11.609046Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.

2023-03-08T17:12:11.612566Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2023-03-08T17:12:11.612622Z 0 [ERROR] [MY-010119] [Server] Aborting

2023-03-08T17:12:12.687069Z 0 [System] [MY-010910] [Server] /opt/CA/Spectrum/mysql/bin//mysqld: Shutdown complete (mysqld 8.0.31-commercial)  MySQL Enterprise Server - Commercial.

Environment

Release : 22.2

Cause

Missing ddmdb/db_descriptor.ibd file

Resolution

Move the $SPECROOT/mysql directory to mysql_old and reinstall.

Unfortunately trying to repair/fix/replace the file will not work as it is an innodb database.