azkaban执行任务错误，修复MySQL表

问题描述：azkaban执行任务报错

azkaban.executor.ExecutorManagerException: Error writing job offline-xxx-hdfs2hive-m5
    at azkaban.executor.ExecutionJobDao.uploadExecutableNode(ExecutionJobDao.java:76)
    at azkaban.executor.JdbcExecutorLoader.uploadExecutableNode(JdbcExecutorLoader.java:198)
    at azkaban.execapp.JobRunner.uploadExecutableNode(JobRunner.java:640)
    at azkaban.execapp.JobRunner.doRun(JobRunner.java:592)
    at azkaban.execapp.JobRunner.run(JobRunner.java:563)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Incorrect key file for table './azkaban/execution_jobs.MYI'; try to repair it Query: INSERT INTO execution_jobs (exec_id, project_id, version, flow_id, job_id, start_time, end_time, status, input_params, attempt) VALUES (?,?,?,?,?,?,?,?,?,?) Parameters: [733846, 29, 1, offline-xxx-hdfs2hive-m5, offline-xxx-hdfs2hive-m5, 1594280705040, -1, 110, ......, 0]
    at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
    at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
    at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
    at azkaban.db.DatabaseOperator.update(DatabaseOperator.java:121)
    at azkaban.executor.ExecutionJobDao.uploadExecutableNode(ExecutionJobDao.java:71)
    ... 9 more

解决方案：

进入Mysql

check table tablename;

repair table tablename;