[
https://issues.apache.org/jira/browse/AIRAVATA-2127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eroma closed AIRAVATA-2127.
---------------------------
Resolution: Fixed
Closing as the explained bug is no longer exists or experienced in current
airavata 0.17 release
> 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.15#6346)
