CA Mysql Service will not start on ADA Console server

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)
• CA Application Delivery Analysis (NetQoS / ADA)
• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

The CA Mysql and other ADA services are not starting.

The \CA\Mysql\data\<serverName>.log file has the following errors:

020-02-14T16:45:12.508616Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 1010722932016 and the end 1010722965968.

2020-02-14T16:45:12.509617Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2020-02-14T16:45:12.813630Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

2020-02-14T16:45:12.814630Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2020-02-14T16:45:12.815629Z 0 [ERROR] Failed to initialize plugins.

2020-02-14T16:45:12.815629Z 0 [ERROR] Aborting

Environment

Release : 11.0.2

Component : NQSAMC - NETQOS SA MGMT CONSOLE

Resolution

Ran through the steps below
1. Added Set "innodb_log_checksums = ON" to the my.ini under the innodb section of the file and saved it.

2. Deleted the 2 log files like  \CA\Mysql\data\ib_logfile*.

3. Start The CA Mysql service which may take some time as it was creating new ib_logfiles.

4.  Remove the "innodb_log_checksums = ON" from the my.ini and restart CA Mysql and all services.

Additional Information

https://dba.stackexchange.com/questions/163445/innodb-ignoring-the-redo-log-due-to-missing-mlog-checkpoint