Azkaban遇到的问题及解决方案

1、首次启动时报错

[hadoop@master bin]$ ./azkaban-web-start.sh 
Using Hadoop from /home/hadoop/app/modules/hadoop-2.8.5
Using Hive from /home/hadoop/app/modules/apache-hive-1.2.2-bin
./..
/home/hadoop/app/modules/jdk1.8.0_192/lib::./../lib/azkaban-2.5.0.jar:./../lib/commons-collections-3.2.1.jar:./../lib/commons-configuration-1.8.jar:./../lib/commons-dbcp-1.4.jar:./../lib/commons-dbutils-1.5.jar:./../lib/commons-email-1.2.jar:./../lib/commons-fileupload-1.2.1.jar:./../lib/commons-io-2.4.jar:./../lib/commons-jexl-2.1.1.jar:./../lib/commons-lang-2.6.jar:./../lib/commons-logging-1.1.1.jar:./../lib/commons-pool-1.6.jar:./../lib/guava-13.0.1.jar:./../lib/h2-1.3.170.jar:./../lib/httpclient-4.2.1.jar:./../lib/httpcore-4.2.1.jar:./../lib/jackson-core-asl-1.9.5.jar:./../lib/jackson-mapper-asl-1.9.5.jar:./../lib/jetty-6.1.26.jar:./../lib/jetty-util-6.1.26.jar:./../lib/joda-time-2.0.jar:./../lib/jopt-simple-4.3.jar:./../lib/junit-4.8.jar:./../lib/log4j-1.2.16.jar:./../lib/mail-1.4.5.jar:./../lib/mysql-connector-java-5.1.28.jar:./../lib/servlet-api-2.5.jar:./../lib/slf4j-api-1.6.1.jar:./../lib/slf4j-log4j12-1.6.4.jar:./../lib/velocity-1.7.jar:./../lib/velocity-tools-2.0.jar:./../extlib/*.jar:./../plugins/*/*.jar:/home/hadoop/app/modules/hadoop-2.8.5/conf:/home/hadoop/app/modules/hadoop-2.8.5/*:/home/hadoop/app/modules/apache-hive-1.2.2-bin/conf:/home/hadoop/app/modules/apache-hive-1.2.2-bin/lib/*
[hadoop@master bin]$ 2019/06/02 09:34:32.857 +0800 ERROR [AzkabanWebServer] [Azkaban] Starting Jetty Azkaban Executor...
2019/06/02 09:34:32.941 +0800 INFO [AzkabanServer] [Azkaban] Loading azkaban settings file from ./../conf
2019/06/02 09:34:32.941 +0800 INFO [AzkabanServer] [Azkaban] Loading azkaban properties file
2019/06/02 09:34:32.978 +0800 INFO [AzkabanWebServer] [Azkaban] Setting up Jetty Https Server with port:8443 and numThreads:25
2019/06/02 09:34:33.053 +0800 INFO [log] [Azkaban] Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
2019/06/02 09:34:33.112 +0800 INFO [AzkabanWebServer] [Azkaban] Loading user manager class azkaban.user.XmlUserManager
2019/06/02 09:34:33.171 +0800 INFO [XmlUserManager] [Azkaban] Loading user azkaban
2019/06/02 09:34:33.173 +0800 INFO [XmlUserManager] [Azkaban] Loading user metrics
Exception in thread "main" azkaban.executor.ExecutorManagerException: Error fetching active flows
	at azkaban.executor.JdbcExecutorLoader.fetchActiveFlows(JdbcExecutorLoader.java:209)
	at azkaban.executor.ExecutorManager.loadRunningFlows(ExecutorManager.java:146)
	at azkaban.executor.ExecutorManager.<init>(ExecutorManager.java:84)
	at azkaban.webapp.AzkabanWebServer.loadExecutorManager(AzkabanWebServer.java:248)
	at azkaban.webapp.AzkabanWebServer.<init>(AzkabanWebServer.java:185)
	at azkaban.webapp.AzkabanWebServer.main(AzkabanWebServer.java:726)
Caused by: java.sql.SQLException: SELECT command denied to user 'azkaban'@'localhost' for table 'execution_flows' Query: SELECT ex.exec_id exec_id, ex.enc_type enc_type, ex.flow_data flow_data, ax.host host, ax.port port, ax.update_time axUpdateTime FROM execution_flows ex INNER JOIN active_executing_flows ax ON ex.exec_id = ax.exec_id Parameters: []
	at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:350)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:306)
	at azkaban.executor.JdbcExecutorLoader.fetchActiveFlows(JdbcExecutorLoader.java:202)
	... 5 more

我的原因是创建azkaban的表时不规范，删了重新创建就好了，贴一下其他人的原因。

阿里云登录 - 欢迎登录阿里云，安全稳定的云计算服务平台