AIQUM failed to start due to mysql Data Dictionary initialization failed error
Applies to
- Active IQ Unified Manager(AIQUM) 9.x
- Windows Platform
Issue
- MySQL failed to start in AIQUM
server.log:
javax.resource.ResourceException: IJ031084: Unable to create connection
java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to connect to host:localhost, port:3306. Connection refused: connect
java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:localhost, port:3306. Connection refused: connect
- MySQL
error.log:
[ERROR] [MY-013881] [InnoDB] The redo log file .\#innodb_redo\#ib_redo<sequence_number> has start_lsn xxxx but expected yyyy (end_lsn of the previous redo log file).
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
- The issue can also happen during upgrade from older version
- Error during the upgrade:
"Failed to start MySQL service. Setup will terminate now!!!"