跑数出现连不上hive数据库的问题

0
这边有5个跑数节点,在跑数过程中,时不时的就会出现跑数失败,连不上数据库的情况,这边是配置的sentry进行权限管理,
:019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : An error occurred executing this job entry : 
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - 
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Could not open client transport with JDBC Uri: jdbc:hive2://ip:10000/default: Peer indicated failure: Error validating the login
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : An error occurred executing this job entry : 
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - 
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Could not open client transport with JDBC Uri: jdbc:hive2://ip:10000/default: Peer indicated failure: Error validating the login
2019/04/18 03:13:18 - Kitchen - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : Finished with errors
已邀请:
0

lanmengxiaozi - 80后IT 2019-04-23 回答

补充下:这边是用kettle抽数,并且这边每天晚上都会重启hive,但是还是会出现部分任务在某些时间点上出现连不上数据库;
0

x50854968 - 123 2019-05-28 回答

mysql有重置连接的设置,未活动的会关闭
 
0

doubleK24 2020-10-26 回答

请问一下楼主解决了吗?我这边也是时不时会出现这个问题

要回复问题请先登录注册