Hypersonic issue of Jboss

[vicky john]

Hypersonic locked today in production. Users were complaining they were getting
white screens. After investigating it was discovered that the oracle
connections were at 35 but they should have been 135. Modified and shut down
the server (using the sudo stop). In the server log instead of the "shutdown
complete" message it showed:

ng application context [Root XmlWebApplicationContext]
2008-04-21 14:27:35,933 INFO [ ] JBoss Shutdown Hook
org.springframework.beans.factory.support.DefaultListableBeanFactory Destroying
singletons in factory
{org.springframework.beans.factory.support.DefaultListableBeanFactory defining
beans [quartzUser,users]; Root of BeanFactory hierarchy}
2008-04-21 14:27:36,741 INFO [ ] JBoss Shutdown Hook
org.jboss.web.tomcat.tc5.TomcatDeployer undeploy, ctxPath=/kn/csl,
warUrl=.../tmp/deploy/tmp28500CSL.ear-contents/CSLWeb.war/
2008-04-21 14:27:36,743 INFO [ ] JBoss Shutdown Hook
org.apache.catalina.core.StandardWrapper Waiting for 1 instance(s) to be
deallocated
2008-04-21 14:27:37,765 INFO [ ] JBoss Shutdown Hook
org.apache.catalina.core.StandardWrapper Waiting for 1 instance(s) to be
deallocated
2008-04-21 14:27:38,791 INFO [ ] JBoss Shutdown Hook
org.apache.catalina.core.StandardWrapper Waiting for 1 instance(s) to be
deallocated
2008-04-21 14:27:38,901 INFO [ ] JBoss Shutdown Hook org.jboss.ejb.EJBDeployer
Undeploying:
file:/home/jboss/jboss-4.0.3/server/default/tmp/deploy/tmp28500CSL.ear-contents/FrameworkEJB.jar

After a few minutes when it didn't change I did a kill -9 on the jdk service
and tried starting the server again. Server.log wouldn't go past this:

2008-04-21 14:37:04,505 INFO [ ] main
org.jboss.resource.deployment.RARDeployment Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
2008-04-21 14:37:04,624 INFO [ ] main
org.jboss.resource.deployment.RARDeployment Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
2008-04-21 14:37:04,796 INFO [ ] main
org.jboss.resource.deployment.RARDeployment Required license terms exist, view
META-INF/ra.xml in .../deploy/jms/jms-ra.rar
2008-04-21 14:37:04,924 INFO [ ] main
org.jboss.resource.deployment.RARDeployment Required license terms exist, view
META-INF/ra.xml in .../deploy/mail-ra.rar
2008-04-21 14:37:23,179 INFO [ ] main
org.jboss.resource.connectionmanager.ConnectionFactoryBindingService Bound
ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI
name 'java efaultDS'

Tried two more times rebooting with the same results. Removed the /tmp & /work
directories; no change. Removed the hypersonic .lck file, still no change.
Finally I brought the jboss server down again, deleted everything out of the
hypersonic directory (/home/jboss/jboss-4.0.3/server/default/data/hypersonic)
and added back all the files under hypersonic folder, when this happened in test server.

After this I was able to bring the server back up. I really need this issue
fixed. Also need to know how to monitor for locks &/or the connection threshold
so we can prevent the locking in the first place.

[Jaikiran Pai]

JBoss strongly recommends that you do not use Hypersonic DB in production. See this for more details.

[vicky john]

Hi,
Thanks a lot for your information.
But can you please suggest what exactly i need to take care of..
Means..is it sufficient if i use our own datasource instead of 'defaultds'
or anything else i need to take care??
please suggest..

[Jaikiran Pai]

Originally posted by vasavi vasireddy:
Means..is it sufficient if i use our own datasource instead of 'defaultds'
or anything else i need to take care??

You will first have to switch from the Hypersonic DB. The steps to do this are mentioned in that wiki. The original issue that you posted may or may not be directly related to Hypersonic DB usage. So even after switching to a different DB server, if you run into this same issue then you have to find out what's causing it.