[
https://issues.apache.org/jira/browse/DRILL-462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
prasann...@trinitymobility.com updated DRILL-462:
-
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 2017-02-28 10:12 (http-nio-8098-exec-5)
org.trinity.social.dao.SocialDataDaoImpl 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
[Error Id: 9f6ccd37-ee0f-47b4-9a6b-4eeb4456d542 on
trinitybdClusterM02.trinitymobility.local:31010]; nested exception is
java.sql.SQLException: SYSTEM ERROR: RetriesExhaustedException: Can't get
the locations
[Error Id: 9f6ccd37-ee0f-47b4-9a6b-4eeb4456d542 on
trinitybdClusterM02.trinitymobility.local:31010]
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
[Error Id: 9f6ccd37-ee0f-47b4-9a6b-4eeb4456d542 on
trinitybdClusterM02.trinitymobility.local:31010]; nested exception is
java.sql.SQLException: SYSTEM ERROR: RetriesExhaustedException: Can't get
the locations
[Error Id: 9f6ccd37-ee0f-47b4-9a6b-4eeb4456d542 on
trinitybdClusterM02.trinitymobility.local:31010]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tran
slate(AbstractFallbackSQLExceptionTranslator.java:84)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tran
slate(AbstractFallbackSQLExceptionTranslator.java:81)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tran
slate(AbstractFallbackSQLExceptionTranslator.java:81)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:474)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:484)
~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:51
0) ~[spring-jdbc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.trinity.social.dao.SocialDataDaoImpl.getAllDataByKeywordCount(SocialData
DaoImpl.java:98) [classes/:?]
at
org.trinity.social.service.SpatialDataFilterServiceImpl.getDataByKeywords(Sp
atialDataFilterServiceImpl.java:48) [classes/:?]
at
org.trinity.social.controller.SocialDataController.getKeywordData(SocialData
Controller.java:26) [classes/:?]
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43) ~[?:1.8.0_66]
at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_66]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(Invoc
ableHandlerMethod.java:220) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForReque
st(InvocableHandlerMethod.java:134)
[spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandle
rMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
[spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerA
dapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
[spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerA
dapter.handleInternal(RequestMappingHandlerAdapter.java:738)
[spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.hand