栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Azkaban集群启动报错 Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Azkaban集群启动报错 Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1

2021/12/01 09:26:38.610 +0800 ERROR [MySQLDataSource] [Azkaban] Failed to find write-enabled DB connection. Wait 15 seconds and retry. No.Attempt = 1
java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'linux121' (using password: YES))
	at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294)
	at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
	at azkaban.db.MySQLDataSource.getConnection(MySQLDataSource.java:76)
	at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175)
	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:286)
	at azkaban.db.DatabaseOperator.query(DatabaseOperator.java:68)
	at azkaban.executor.ExecutorDao.fetchExecutor(ExecutorDao.java:63)
	at azkaban.executor.JdbcExecutorLoader.fetchExecutor(JdbcExecutorLoader.java:272)
	at azkaban.execapp.AzkabanExecutorServer.insertExecutorEntryIntoDB(AzkabanExecutorServer.java:264)
	at azkaban.execapp.AzkabanExecutorServer.start(AzkabanExecutorServer.java:242)
	at azkaban.execapp.AzkabanExecutorServer.launch(AzkabanExecutorServer.java:152)
	at azkaban.execapp.AzkabanExecutorServer.main(AzkabanExecutorServer.java:148)
Caused by: java.sql.SQLException: Access denied for user 'root'@'linux121' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)

原因

Azkaban配置文件中的root用户,也就是mysql中的root用户访问权限是’localhost’

解决方案

mysql中的root用户访问权限修改为’%’
update user set Host='%' where User = 'root';
flush privileges;

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/632600.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号