Launching soon: The world's first vendor agnostic bug scrubLearn more & join waitlist
OPERATIONAL DEFECT DATABASE
...
...
MariaDB (MySQL) and services dependent upon it are down on the Firepower Management Center (FMC). MariaDB does not start upon (re)boot of the FMC.
You will see the below logs under /var/lib/mysql/mysql-server.err root@FMC01-L1:/Volume/home/admin# cat /var/lib/mysql/mysql-server.err 2022-06-27 4:02:10 0 [Warning] You need to use --log-bin to make --binlog-format work. 2022-06-27 4:02:10 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ 2022-06-27 4:02:10 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect. 2022-06-27 4:02:10 0 [Warning] InnoDB: Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 2022-06-27 4:02:10 0 [Note] InnoDB: Uses event mutexes 2022-06-27 4:02:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-06-27 4:02:10 0 [Note] InnoDB: Number of pools: 1 2022-06-27 4:02:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-06-27 4:02:10 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2022-06-27 4:02:10 0 [Note] InnoDB: Using Linux native AIO 2022-06-27 4:02:10 0 [Note] InnoDB: Initializing buffer pool, total size = 809500672, chunk size = 1048576 2022-06-27 4:02:10 0 [Note] InnoDB: Completed initialization of buffer pool 2022-06-27 4:02:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=84122732487864,84122732487864 2022-06-27 4:02:12 0 [ERROR] InnoDB: The age of the last checkpoint is 123887353, which exceeds the log capacity 120794112. 2022-06-27 4:02:13 0 [Note] InnoDB: Starting final batch to recover 22095 pages from redo log. 2022-06-27 4:02:13 0 [ERROR] InnoDB: Not applying INSERT_REUSE_REDUNDANT due to corruption on [page id: space=0, page number=28352] 2022-06-27 4:02:13 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 2022-06-27 4:02:13 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 2022-06-27 4:02:13 0 [Note] InnoDB: Starting shutdown... 2022-06-27 4:02:14 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-06-27 4:02:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-06-27 4:02:14 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-06-27 4:02:14 0 [ERROR] Failed to initialize plugins. 2022-06-27 4:02:14 0 [ERROR] Aborting 2022-06-27 4:03:10 0 [Warning] You need to use --log-bin to make --binlog-format work. 2022-06-27 4:03:10 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/ 2022-06-27 4:03:10 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect. 2022-06-27 4:03:10 0 [Warning] InnoDB: Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 2022-06-27 4:03:10 0 [Note] InnoDB: Uses event mutexes
Contact Cisco TAC.
If the workaround procedure is not sufficient to repair the corruption in the MariaDB database, it may be necessary to re-image the FMC and restore a known good FMC backup.