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/02/04 11:14:34 UTC
[jira] [Commented] (LENS-168) SQLException in
database/ldap-backed-database user config loader
[ 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)