[ 
https://issues.apache.org/jira/browse/DRILL-5302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

prasannaP updated DRILL-5302:
-----------------------------
    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



> Java application frequently disconnects from drillbit service
> -------------------------------------------------------------
>
>                 Key: DRILL-5302
>                 URL: https://issues.apache.org/jira/browse/DRILL-5302
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>            Reporter: prasannaP
>
> 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



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to