[
https://issues.apache.org/jira/browse/LENS-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14594282#comment-14594282
]
Amareshwari Sriramadasu commented on LENS-621:
----------------------------------------------
Exception in logs :
{{noformat}
20 Jun 2015 06:20:18,298 [28cb7c8d-bdd1-4736-9027-d500f86de48f]
[Grizzly-worker(2)] INFO
org.apache.lens.server.query.QueryExecutionServiceImpl - GetResultSetMetadata:
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?><lensSessionHandle><publicId>8b08b731-cba8-4063-b0fd-783687a9c11f</publicId><secretId>38410fd2-31d6-4c4c-9cb0-71eedee379b3</secretId></lensSessionHandle>
query: 71e9ebfe-4828-428f-9dd0-90aba44ed818
20 Jun 2015 06:20:18,299 [28cb7c8d-bdd1-4736-9027-d500f86de48f]
[Grizzly-worker(2)] ERROR org.apache.lens.server.LensRequestListener -
Encountered HTTP exception
javax.ws.rs.WebApplicationException: HTTP 500 Internal Server Error
at
org.apache.lens.server.query.QueryServiceResource.getResultSetMetadata(QueryServiceResource.java:678)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:195)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:353)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:343)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:318)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:983)
at
org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:330)
at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:212)
at
org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)
at
org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.apache.lens.server.api.error.LensException
at
org.apache.lens.driver.jdbc.JDBCResultSet.seekToStart(JDBCResultSet.java:306)
at
org.apache.lens.server.query.QueryExecutionServiceImpl.getResultset(QueryExecutionServiceImpl.java:1321)
at
org.apache.lens.server.query.QueryExecutionServiceImpl.getResultSetMetadata(QueryExecutionServiceImpl.java:1816)
at
org.apache.lens.server.query.QueryServiceResource.getResultSetMetadata(QueryServiceResource.java:676)
... 26 more
Caused by: java.sql.SQLException: You can't operate on a closed ResultSet!!!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.isBeforeFirst(NewProxyResultSet.java:2348)
at
org.apache.lens.driver.jdbc.JDBCResultSet.seekToStart(JDBCResultSet.java:301)
... 29 more
Caused by: java.lang.NullPointerException
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.isBeforeFirst(NewProxyResultSet.java:2342)
... 30 more
20 Jun 2015 06:20:18,300 [28cb7c8d-bdd1-4736-9027-d500f86de48f]
[Grizzly-worker(2)] WARN org.glassfish.jersey.server.ServerRuntime$Responder
- WebApplicationException cause:
org.apache.lens.server.api.error.LensException
at
org.apache.lens.driver.jdbc.JDBCResultSet.seekToStart(JDBCResultSet.java:306)
at
org.apache.lens.server.query.QueryExecutionServiceImpl.getResultset(QueryExecutionServiceImpl.java:1321)
at
org.apache.lens.server.query.QueryExecutionServiceImpl.getResultSetMetadata(QueryExecutionServiceImpl.java:1816)
at
org.apache.lens.server.query.QueryServiceResource.getResultSetMetadata(QueryServiceResource.java:676)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
at
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:195)
at
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:353)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:343)
at
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:318)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
at
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:983)
at
org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:330)
at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:212)
at
org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)
at
org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: You can't operate on a closed ResultSet!!!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.isBeforeFirst(NewProxyResultSet.java:2348)
at
org.apache.lens.driver.jdbc.JDBCResultSet.seekToStart(JDBCResultSet.java:301)
... 29 more
Caused by: java.lang.NullPointerException
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.isBeforeFirst(NewProxyResultSet.java:2342)
... 30 more
{noformat}
> Fetching result set from JDBCDriver query fails with persistent result turned
> on
> --------------------------------------------------------------------------------
>
> Key: LENS-621
> URL: https://issues.apache.org/jira/browse/LENS-621
> Project: Apache Lens
> Issue Type: Bug
> Components: server
> Affects Versions: 2.2
> Reporter: Amareshwari Sriramadasu
> Fix For: 2.2
>
>
> Seeing the following when i run examples :
> {noformat}
> lens-shell>query execute cube select customer_city_name, store_sales from
> sales where time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00')
> 20 Jun 2015 06:20:18,040 [Spring Shell] INFO cliLogger - Query handle:
> 71e9ebfe-4828-428f-9dd0-90aba44ed818
> 20 Jun 2015 06:20:18,127 [Spring Shell] INFO cliLogger - User query: 'cube
> select customer_city_name, store_sales from sales where
> time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00')' was submitted
> to org.apache.lens.driver.jdbc.JDBCDriver
> 20 Jun 2015 06:20:18,127 [Spring Shell] INFO cliLogger - Driver query:
> 'SELECT ( customer_city . name ), sum(( sales . store_sales )) FROM
> mydb_sales_aggr_fact2 sales join mydb_city_subset customer_city on
> sales.customer_city_id = customer_city.id WHERE (((( sales . delivery_time )
> = '2015-04-12 00:00:00' ))) GROUP BY ( customer_city . name )' and Driver
> handle: null
> 20 Jun 2015 06:20:18,165 [Spring Shell] INFO cliLogger - SUCCESSFUL:Query
> is successful! - Result Available
> Failed to get resultset metadata, cause:HTTP 500 Internal Server Error
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
