Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (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.

200 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎04-11-2016 01:56 PM
Updated by:
 
Contributors
Top Kudoed Authors