Lahiru Gunathilake created AIRAVATA-2127:
--------------------------------------------
Summary: Unable to access registry after a long idle period
Key: AIRAVATA-2127
URL: https://issues.apache.org/jira/browse/AIRAVATA-2127
Project: Airavata
Issue Type: Bug
Reporter: Lahiru Gunathilake
After a long idle time when trying to access airavata with pga I see following
logs repeatedly
13:49:30.103 [pool-7-thread-50] DEBUG net.sf.ehcache.Cache - CacheWriter
factory not configured. Skipping...
13:49:30.103 [pool-7-thread-50] DEBUG net.sf.ehcache.config.ConfigurationHelper
- No CacheExceptionHandlerFactory class specified. Skipping...
And then when trying to create an experiment and launch following exception is
thrown.
13:49:30.383 [pool-7-thread-50] ERROR
org.apache.airavata.api.server.handler.AiravataServerHandler - Error in getting
all accessible users for resource. Resource ID :
esfsdf_d626c924-7773-411e-a8fb-8247152a92c0 Resource Type : EXPERIMENT
edu.internet2.middleware.grouper.exception.GrouperException: unable to retrieve
GrouperSystem: Problems with db: DB: user: root, url:
jdbc:mysql://localhost:3306/grouper, driver: com.mysql.jdbc.Driver
at
edu.internet2.middleware.grouper.SubjectFinder.findRootSubject(SubjectFinder.java:866)
at
edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)
at
edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:445)
at
org.apache.airavata.grouper.resource.ResourceServiceImpl.getAllAccessibleUsers(ResourceServiceImpl.java:231)
at
org.apache.airavata.grouper.GroupManagerImpl.getAllAccessibleUsers(GroupManagerImpl.java:80)
at
org.apache.airavata.api.server.handler.AiravataServerHandler.getAllAccessibleUsers(AiravataServerHandler.java:3434)
at
org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$3218f2d6.CGLIB$getAllAccessibleUsers$3(<generated>)
at
org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$3218f2d6$$FastClassByGuice$$b2e53120.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
at
org.apache.airavata.api.server.security.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:57)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:75)
at
com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:55)
at
org.apache.airavata.api.server.handler.AiravataServerHandler$$EnhancerByGuice$$3218f2d6.getAllAccessibleUsers(<generated>)
at
org.apache.airavata.api.Airavata$Processor$getAllAccessibleUsers.getResult(Airavata.java:18389)
at
org.apache.airavata.api.Airavata$Processor$getAllAccessibleUsers.getResult(Airavata.java:18373)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Problems with db: DB: user: root, url:
jdbc:mysql://localhost:3306/grouper, driver: com.mysql.jdbc.Driver
at
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:57)
at
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:436)
at
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:340)
at
edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:251)
at
edu.internet2.middleware.grouper.subj.SubjectResolverFactory.getInstance(SubjectResolverFactory.java:58)
at
edu.internet2.middleware.grouper.SubjectFinder.getResolver(SubjectFinder.java:878)
at
edu.internet2.middleware.grouper.SubjectFinder.findRootSubject(SubjectFinder.java:863)
... 21 common frames omitted
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost'
(using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875)
at
com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown
Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:54)
... 27 common frames omitted
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
