1 Reply Latest reply on Sep 21, 2005 8:12 AM by James Plastow

    The database is already in use by another process

    James Plastow Newbie

      Hi, i'm new to JBoss and am currently trying to setup an LGOL-NET server, which needs JBoss in order to run.

      i've had it working and was able to access the jmx-console page, but after problems with the LGOL-NET login page i restarted and since have repeatedly been unable to get the server going due to the database apparently already in use by another process...

      I tried mixing and matching the JBoss Server App/mysql/winmysqladmin services (in case it was one of those that was using the database when it wasn't supposed to be), with not much success!

      How many (and if you could tell me, which) services should be running for JBoss to work?

      After just going into the log file to copy out some code, i found that there's a problem with authorisation too, but as i had it working before i'm guessing both errors have occured due to the same problem, both are in bold, below (there are a few instances of each error, i've only put one of each in bold)

      Running:
      Win2000 Pro
      Java2sdk 1.4.0
      JBoss 3.2.3
      MySQL 4.0.17

      Thanks in advance for any help!

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO | jvm 1 | 2005/09/20 08:34:47 | 08:34:47,673 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
      INFO | jvm 1 | 2005/09/20 08:34:47 | org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: The database is already in use by another process)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mq.pm.jdbc2.PersistenceManager.getConnection(PersistenceManager.java:1266)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:216)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1356)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at java.lang.reflect.Method.invoke(Method.java:324)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at java.lang.reflect.Method.invoke(Method.java:324)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at $Proxy5.deploy(Unknown Source)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.Main.boot(Main.java:150)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.Main$1.run(Main.java:395)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at $Proxy12.start(Unknown Source)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.ServiceController.start(ServiceController.java:411)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.system.ServiceController.start(ServiceController.java:411)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at java.lang.Thread.run(Thread.java:536)
      INFO | jvm 1 | 2005/09/20 08:34:47 | Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'mySQL username@localhost' (Using password: YES)"); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'mySQL username@localhost' (Using password: YES)"))
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      INFO | jvm 1 | 2005/09/20 08:34:47 | at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:118)


        • 1. Re: The database is already in use by another process
          James Plastow Newbie

          Right, there's no longer any authorisation error, but no matter what i do i keep getting the "database is already in use by another process" error, and have just noticed that there's a few "port already in use" and "address already in use" errors too.

          Following on from my original post, after the server has finished starting up with the errors, i get a HTTP Status 500 - status report when trying http://localhost:8080/jmx-console

          INFO | jvm 1 | 2005/09/21 12:43:46 | 12:43:45,937 ERROR [PersistenceManager] Starting failed
          INFO | jvm 1 | 2005/09/21 12:43:46 | org.jboss.mq.SpyJMSException: Could not get a connection for jdbc2 table construction ; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: The database is already in use by another process); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: The database is already in use by another process)))


          Let me know if it's better for me to paste the whole log

          Anyone know where the problem might be? (even if you don't know what the problem actually is!) be it services/wrapper.conf/jboss-service.xml etc etc...

          Thanks!

          James