- Get All Questions & Answer for CDP Generalist Exam (CDP-0011) and trainings.
- Get All Questions & Answer for CDP Administrator - Private Cloud Base Exam CDP-2001 and trainings.
- Get All Questions & Answer for CDP Data Developer Exam CDP-3001 and trainings.
This Question is from QuickTechie Cloudera CDP Certification Preparation Kit.
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.
- Get All Questions & Answer for CDP Generalist Exam (CDP-0011) and trainings.
- Get All Questions & Answer for CDP Administrator - Private Cloud Base Exam CDP-2001 and trainings.
- Get All Questions & Answer for CDP Data Developer Exam CDP-3001 and trainings.
This Question is from QuickTechie Cloudera CDP Certification Preparation Kit.