The database is already in use by another process
james.plastow Sep 20, 2005 4:45 AMHi, 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)