You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "prasannaP (JIRA)" <ji...@apache.org> on 2017/02/28 10:16:45 UTC
[jira] [Updated] (DRILL-5302) Java application frequently
disconnects from drillbit service
[ 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)