Hi there:
I have been hitting with the following errors after restarting the
UserApps. Before I restart it, I have stop all the mysql and also verify
whether all the jboss process has exited. After restarted, the following
error message is caught on the screen. However, UserApp has managed to
be accessed by the end user. How can I solve this issue?


2008-02-27 12:04:44,975 WARN [org.jboss.system.ServiceController:start]
Problem starting service jboss:service=Hypersonic,database=localDB
java.sql.SQLException: The database is already in use by another
process: org.hsqldb.persist.NIOLockFile@bc17b1e3[file
=/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck,
exists=true, locked=false, valid=false, fl =null]:
java.io.FileNotFoundException:
/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck
(Permission denied)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at
org.jboss.jdbc.HypersonicDatabase.getConnection(Hy personicDatabase.java:761)
at
org.jboss.jdbc.HypersonicDatabase.startStandaloneD atabase(HypersonicDatabase.java:611)
at
org.jboss.jdbc.HypersonicDatabase.startService(Hyp ersonicDatabase.java:557)
at
org.jboss.system.ServiceMBeanSupport.jbossInternal Start(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternal Lifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknow n Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.in voke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknow n Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer .java:302)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
at $Proxy43.start(Unknown Source)
at org.jboss.deployment.XSLSubDeployer.start(XSLSubDe ployer.java:197)
at org.jboss.deployment.MainDeployer.start(MainDeploy er.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:782)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unkno wn Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
at $Proxy8.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner. deploy(URLDeploymentScanner.java:421)
at
org.jboss.deployment.scanner.URLDeploymentScanner. scan(URLDeploymentScanner.java:634)
at
org.jboss.deployment.scanner.AbstractDeploymentSca nner$ScannerThread.doScan(AbstractDeploymentScanne r.java:263)
at
org.jboss.deployment.scanner.AbstractDeploymentSca nner.startService(AbstractDeploymentScanner.java:3 36)
at
org.jboss.system.ServiceMBeanSupport.jbossInternal Start(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternal Lifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknow n Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.in voke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceCo ntroller.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknow n Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer .java:302)
at org.jboss.deployment.MainDeployer.start(MainDeploy er.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeplo yer.java:766)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invok e(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterc eptor.invoke(ModelMBeanOperationInterceptor.java:1 42)
at org.jboss.mx.server.Invocation.invoke(Invocation.j ava:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyE xt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerI mpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImp l.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:490)
at java.lang.Thread.run(Thread.java:595)
2008-02-27 12:04:48,765 INFO
[org.jboss.web.tomcat.tc5.TomcatDeployererformDeployInternal] deploy,
ctxPath=/IDM, warUrl=.../tmp/deploy/tmp20825IDM-exp.war/



--- MBeans waiting for other MBeans ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: The database is already in use by
another process: org.hsqldb.persist.NIOLockFile@bc17b1e3[file
=/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck,
exists=true, locked=false, valid=false, fl =null]:
java.io.FileNotFoundException:
/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck
(Permission denied)
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=De faultDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss:service=Hypersonic,database=localDB
State: FAILED
Reason: java.sql.SQLException: The database is already in use by
another process: org.hsqldb.persist.NIOLockFile@bc17b1e3[file
=/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck,
exists=true, locked=false, valid=false, fl =null]:
java.io.FileNotFoundException:
/home/novell/idm/jboss-mysql/jboss/server/IDM/data/hypersonic/localDB.lck
(Permission denied)
Depends On Me:
jboss.jca:service=ManagedConnectionFactory,name=De faultDSHi