Troubleshooting Tip: Unable to perform FortiNAC upgrade due to mysqldump: Error 1034

Description

This article describes the necessary steps to complete a FortiNAC upgrade when the following error appears:

"mysqldump: Error 1034: Index for table 'FirewallSession' is corrupt; try to repair it when dumping table FirewallSession at row: 92299 
ydb_dated_backup: Some unexpected error happened. 

**** Failed to backup DB Exiting"

Scope

FortiNAC-F.

Solution

Verify the status of the table on the database:

execute db-shell
MariaDB [bsc]> select * from FirewallSession;

ERROR 1034 (HY000): Index for table 'FirewallSession' is corrupt; try to repair it 
MariaDB [bsc]> quit

Important: Perform a VM snapshot/backup or a Database backup outside the box.

DROP or TRUNCATE the TABLE to fix the issue:

execute service stop nac 
execute db-shell
MariaDB [bsc]> DROP TABLE FirewallSession; 
MariaDB [bsc]> quit 
execute service start nac