[
https://issues.apache.org/jira/browse/LENS-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14304883#comment-14304883
]
Amareshwari Sriramadasu commented on LENS-168:
----------------------------------------------
Saw this error with open session, here is the full stack trace :
{noformat}
javax.ws.rs.WebApplicationException: HTTP 500 Internal Server Error
at
org.apache.lens.server.session.SessionResource.openSession(SessionResource.java:110)
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:606)
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:745)
Caused by: org.apache.lens.api.LensException:
com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.lens.server.user.UserConfigLoaderException: java.sql.SQLException:
Already closed.
at org.apache.lens.server.LensService.openSession(LensService.java:148)
at
org.apache.lens.server.session.HiveSessionService.openSession(HiveSessionService.java:169)
at
org.apache.lens.server.session.SessionResource.openSession(SessionResource.java:108)
... 26 more
Caused by: com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.lens.server.user.UserConfigLoaderException: java.sql.SQLException:
Already closed.
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2258)
at com.google.common.cache.LocalCache.get(LocalCache.java:3990)
at
com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4793)
at
org.apache.lens.server.user.DatabaseUserConfigLoader.getUserConfig(DatabaseUserConfigLoader.java:78)
at
org.apache.lens.server.user.UserConfigLoaderFactory.getUserConfig(UserConfigLoaderFactory.java:118)
at org.apache.lens.server.LensService.openSession(LensService.java:125)
... 28 more
Caused by: org.apache.lens.server.user.UserConfigLoaderException:
java.sql.SQLException: Already closed.
at
org.apache.lens.server.user.DatabaseUserConfigLoader$1.call(DatabaseUserConfigLoader.java:95)
at
org.apache.lens.server.user.DatabaseUserConfigLoader$1.call(DatabaseUserConfigLoader.java:78)
at
com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4796)
at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3589)
at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2374)
at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2337)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2252)
... 33 more
Caused by: java.sql.SQLException: Already closed.
at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
at org.apache.commons.dbutils.DbUtils.close(DbUtils.java:50)
at
org.apache.commons.dbutils.AbstractQueryRunner.close(AbstractQueryRunner.java:409)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:358)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:288)
at
org.apache.lens.server.util.UtilityMethods.queryDatabase(UtilityMethods.java:106)
at
org.apache.lens.server.user.DatabaseUserConfigLoader.queryDatabase(DatabaseUserConfigLoader.java:112)
at
org.apache.lens.server.user.DatabaseUserConfigLoader$1.call(DatabaseUserConfigLoader.java:82)
... 39 more
{noformat}
> SQLException in database/ldap-backed-database user config loader
> ----------------------------------------------------------------
>
> Key: LENS-168
> URL: https://issues.apache.org/jira/browse/LENS-168
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Rajat Khandelwal
>
> While testing, I kept the server up and tried connecting from cli on various
> intervals while no other connections were being opened to the server. Works
> perfectly fine with intervals of 1,2 hours. But when server was kept idle for
> say a day, trying connecting with cli gives the following error:
> {noformat}
> Caused by: java.sql.SQLException: Already closed.
> at
> org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
> at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
> at org.apache.commons.dbutils.DbUtils.close(DbUtils.java:50)
> at
> org.apache.commons.dbutils.AbstractQueryRunner.close(AbstractQueryRunner.java:409)
> at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:358)
> at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:288)
> at
> org.apache.lens.server.util.UtilityMethods.queryDatabase(UtilityMethods.java:106)
> at
> org.apache.lens.server.user.DatabaseUserConfigLoader.queryDatabase(DatabaseUserConfigLoader.java:112)
> at
> org.apache.lens.server.user.LDAPBackedDatabaseUserConfigLoader$2.call(LDAPBackedDatabaseUserConfigLoader.java:169)
> at
> org.apache.lens.server.user.LDAPBackedDatabaseUserConfigLoader$2.call(LDAPBackedDatabaseUserConfigLoader.java:166)
> at
> com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4796)
> at
> com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3589)
> at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2374)
> ... 35 more
> {noformat}
> This error comes only once and on second attempt it successfully goes
> through.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
