[DRILL-5302] Java application frequently disconnects from drillbit service

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Client - JDBC
• Assignee: Unassigned
• Reporter: prasannaP
• Created: 28/Feb/17 10:12
• Updated: 28/Feb/17 10:21

Description

Currently i am using apache drill 1.9.0. Now I am also facing same issue,my java application is using drill for query purpose.But periodically disconnects with drillbit service after few queries executions. If we use jps it is showing drillbit service is running.I am not find the cause,am i missing anything in the flow.
I am getting logs as,
===================
error code [0]; SYSTEM ERROR: RetriesExhaustedException: Can't get the locations
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT source, sentiment, COUNT(*) AS data_count FROM dfs.tmp.social_data_nlp WHERE created_time > DATE_SUB(CURRENT_DATE, 1) AND keyword_search = true AND ( searched_keyword = 'fire' OR searched_keyword = 'acciden' OR user_name = 'aajtak') GROUP BY source, sentiment]; SQL state [null]; error code [0]; SYSTEM ERROR: RetriesExhaustedException: Can't get the locations