java.sql.SQLException: The database is already in use by another process

hsqldb | adelboy | 2 decades ago
  1. 0

    The database is already in use by another pro

    hsqldb | 2 decades ago | adelboy
    java.sql.SQLException: The database is already in use by another process
  2. 0

    Just happens sometimes... com.atlassian.confluence.InfrastructureException: Couldn't close the session at com.atlassian.confluence.persistence.hibernate.HibernateThreadLocal.endSession(HibernateThreadLocal.java:76) at com.atlassian.confluence.setup.ConfluenceConfigurationFilter.doFilter(ConfluenceConfigurationFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) Caused by: net.sf.hibernate.JDBCException: Cannot open connection: The database is already in use by another process at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:265) at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3231) at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3214) at com.atlassian.confluence.persistence.hibernate.HibernateThreadLocal.endSession(HibernateThreadLocal.java:58) ... 30 more Caused by: java.sql.SQLException: The database is already in use by another process at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.Log.open(Unknown Source) at org.hsqldb.Database$Logger.openLog(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.Database.<init>(Unknown Source) at org.hsqldb.jdbcConnection.openStandalone(Unknown Source) at org.hsqldb.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:97) at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:262) ... 33 more 2003-09-25 19:26:46 StandardManager[] Cannot serialize session attribute DefaultComponentManager for session CD0348DDC9D21C58A58B9E3004251BBF java.io.NotSerializableException: com.atlassian.confluence.search.lucene.LuceneIndexer at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1054) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278) at java.util.ArrayList.writeObject(ArrayList.java:529) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:809) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1296) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1332) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1304) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1332) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1304) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:278) at org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1439) at org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:881) at org.apache.catalina.session.StandardManager.unload(StandardManager.java:536) at org.apache.catalina.session.StandardManager.stop(StandardManager.java:691) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:3669) at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:1036) at org.apache.catalina.core.StandardHostDeployer.remove(StandardHostDeployer.java:470) at org.apache.catalina.core.StandardHost.remove(StandardHost.java:852) at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:758) at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:738) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:360) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1221) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1233) at org.apache.catalina.core.StandardService.stop(StandardService.java:554) at org.apache.catalina.core.StandardServer.stop(StandardServer.java:2225) at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:624)

    Atlassian JIRA | 1 decade ago | Mike Aizatsky
    com.atlassian.confluence.InfrastructureException: Couldn't close the session
  3. 0

    java.lang.IllegalStateException: getAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.getAttribute(StandardSession.java:954) at org.apache.catalina.session.StandardSessionFacade.getAttribute(StandardSessionFacade.java:171) at com.opensymphony.webwork.lifecycle.SessionLifecycleListener.sessionDestroyed(SessionLifecycleListener.java:61) at org.apache.catalina.session.StandardSession.expire(StandardSession.java:659) at org.apache.catalina.session.StandardSession.expire(StandardSession.java:608) at org.apache.catalina.session.StandardManager.processExpires(StandardManager.java:793) at org.apache.catalina.session.StandardManager.run(StandardManager.java:870) at java.lang.Thread.run(Thread.java:536) 2003-09-18 13:59:30 StandardWrapperValve[simple-display]: Servlet.service() for servlet simple-display threw exception com.atlassian.confluence.InfrastructureException: Couldn't close the session at com.atlassian.confluence.persistence.hibernate.HibernateThreadLocal.endSession(HibernateThreadLocal.java:76) at com.atlassian.confluence.setup.ConfluenceConfigurationFilter.doFilter(ConfluenceConfigurationFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) Caused by: net.sf.hibernate.JDBCException: Cannot open connection: The database is already in use by another process at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:265) at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3231) at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3214) at com.atlassian.confluence.persistence.hibernate.HibernateThreadLocal.endSession(HibernateThreadLocal.java:58) ... 33 more Caused by: java.sql.SQLException: The database is already in use by another process at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.Log.open(Unknown Source) at org.hsqldb.Database$Logger.openLog(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.Database.<init>(Unknown Source) at org.hsqldb.jdbcConnection.openStandalone(Unknown Source) at org.hsqldb.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:97) at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:262) ... 36 more

    Atlassian JIRA | 1 decade ago | Zohar Melamed
    com.atlassian.confluence.InfrastructureException: Couldn't close the session
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HSQLDB - User - HSQL in memory database with JBoss 3.2.5

    nabble.com | 11 months ago
    java.sql.SQLException: The database is already in use by another process
  6. 0

    Out of Memory error in connecting to HSQLDB

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: The database is already in use by another process

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      The database is already in use by another process

      at org.hsql.Trace.getError()
    2. org.hsql
      Database.<init>
      1. org.hsql.Trace.getError(Trace.java:124)
      2. org.hsql.Trace.getError(Trace.java:115)
      3. org.hsql.Trace.error(Trace.java:127)
      4. org.hsql.Log.open(Log.java:116)
      5. org.hsql.Database.<init>(Database.java:47)
      5 frames