You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2015/06/20 03:48:00 UTC
[jira] [Comment Edited] (LENS-621) Fetching result set from
JDBCDriver query fails with persistent result turned on
[ https://issues.apache.org/jira/browse/LENS-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14594282#comment-14594282 ]
Amareshwari Sriramadasu edited comment on LENS-621 at 6/20/15 1:47 AM:
-----------------------------------------------------------------------
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}
was (Author: amareshwari):
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)