Skip to Content.
Sympa Menu

perfsonar-user - Re: [perfsonar-user] perfsonar-ui-web fails to start - unable to access database

Subject: perfSONAR User Q&A and Other Discussion

List archive

Re: [perfsonar-user] perfsonar-ui-web fails to start - unable to access database


Chronological Thread 
  • From: Sowmya Balasubramanian <>
  • To: Trey Dockendorf <>
  • Cc: perfsonar-user <>
  • Subject: Re: [perfsonar-user] perfsonar-ui-web fails to start - unable to access database
  • Date: Mon, 10 Aug 2015 11:42:43 -0700
Hi Trey,

I have contacted the developer to see if he can throw some light on what is causing these errors.

Thanks,
Sowmya

On Mon, Aug 10, 2015 at 8:31 AM, Trey Dockendorf <> wrote:
I've installed perfsonar-ui-web-1.5.1 and noticed it's failing to start.  The /var/log/tomcat6/catalina.out shows "java.sql.SQLException: Database '/var/lib/perfsonar-ui/database' not found." before the exception [1].  I also noticed a permission denied message to "derby.log" but unsure where that log is trying to write.

/var/lib/perfsonar-ui/ is owned by tomcat and I noticed persistence.xml has the /var/lib/perfsonar-ui/database path with "create=true", but seems the database is never created.

This install is on my perfsonar bandwidth host just to test out the perfsonar-ui interface.  Tomcat installed is 6.0.24-90.el6.

Steps taken before the error:

wget http://downloads.perfsonar.eu/repositories/rpm/perfsonar-stable-x86_64.repo
mv perfsonar-stable-x86_64.repo /etc/yum.repos.d/
yum install perfsonar-ui-web

I tried restarting the tomcat6 service but the error is the same.

Thanks,
- Trey

[1]:
INFO [10-Aug 10:19:41 OiosamlProcessingFilterEntryPoint.java] The parameter oiosaml-j.home which is set in web.xml to: /home/tomcat/.oiosaml is not set to an (existing) directory, or the directory is empty - OIOSAML-J is not configured.
INFO [10-Aug 10:19:41 DefaultSecurityFilterChain.java] Creating filter chain: org.springframework.security.web.util.AnyRequestMatcher@1, [org.springframework.security.web.context.SecurityContextPersistenceFilter@ef1347f, org.springframework.security.web.authentication.logout.LogoutFilter@7dad8582, net.geant.security.oiosaml.OiosamlProcessingFilter@b185a44, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@6bce2c0c, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2cadff1f, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@53486323, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3564b98c, org.springframework.security.web.session.SessionManagementFilter@67d1b1b6, org.springframework.security.web.access.ExceptionTranslationFilter@77ea58f9, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@3a7780f0]
Mon Aug 10 10:19:41 CDT 2015 Thread[main,5,main] java.io.FileNotFoundException: derby.log (Permission denied)
55  psUI  INFO   [main] openjpa.Runtime - Starting OpenJPA 2.4.0
134  psUI  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary".
Aug 10, 2015 10:19:41 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Aug 10, 2015 10:19:41 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/perfsonar-ui] startup failed due to previous errors
Mon Aug 10 10:19:41 CDT 2015 Thread[main,5,main] Cleanup action starting
java.sql.SQLException: Database '/var/lib/perfsonar-ui/database' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:233)
        at org.perfsonar.ui.listener.PerfsonarInitListener.contextDestroyed(PerfsonarInitListener.java:23)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4249)
        at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4890)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4754)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
        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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: ERROR XJ004: Database '/var/lib/perfsonar-ui/database' not found.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 39 more
============= begin nested exception, level (1) ===========
ERROR XJ004: Database '/var/lib/perfsonar-ui/database' not found.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:233)
        at org.perfsonar.ui.listener.PerfsonarInitListener.contextDestroyed(PerfsonarInitListener.java:23)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4249)
        at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4890)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4754)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
        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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
============= end nested exception, level (1) ===========
Cleanup action completed
Aug 10, 2015 10:19:41 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

=============================

Trey Dockendorf 
Systems Analyst I 
Texas A&M University 
Academy for Advanced Telecommunications and Learning Technologies 
Phone: (979)458-2396 
Email:  
Jabber:


Archive powered by MHonArc 2.6.16.

Top of Page