Ranger Upgrade fails with incorrect key file for table 'xa_access_audit'

[#1]

"Error executing: call add_columns_to_support_audit_log_aggregation();

java.sql.SQLException: Incorrect key file for table 'xa_access_audit'; try to repair it

SQLException : SQL state: HY000 java.sql.SQLException: Incorrect key file for table 'xa_access_audit'; try to repair it ErrorCode: 1034

2016-04-11 06:05:59,187 [E] 015-auditlogaggregation.sql import failed!"

SOLUTION:

Make sure you have enough space in the /tmp directory and take the backup of 'xa_access_audit' as below.

Login to MySQL.

use ranger_audit;

create table xa_access_audit_backup as select * from 'xa_access_audit' ;

truncate table xa_access_audit_backup;

and retry the upgrade.