hive启动报错
问题描述:hive启动程序报错错误
Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "HikariCP" plugin to create a ConnectionPool gave an error : Failed to initialize pool: null, message from server: "Host '192.168.1.111' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
原因:同一个ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)中断的数据库连接而导致的阻塞 (短时间内链接错误次数过多)
解决办法:登录数据库所在虚拟机并登录数据库 执行 flush hosts 命令