techprocess
asked on
problem while start up in JBOSS server 4.0.5 GA
hi all
I have JOBSS server 4.0.5 GA installed on the our server having the operating system as windows server 2003. Server gets startup correctly and works fine at the first time but when i shutdown the server and again tried to start it, it hangs up. Following is the stack trace from log file(jb.10102007.log)
Stack Trace
16:31:49,968 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../dep
loy/management/console-mgr .sar/web-c onsole.war /
16:31:53,484 INFO [MailService] Mail Service bound to java:/Mail
16:31:54,390 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-local- jdbc.rar
16:31:54,656 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-xa-jdb c.rar
16:31:54,812 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-local-jdb c.rar
16:31:55,015 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-xa-jdbc.r ar
16:31:55,093 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jms/jms-ra.rar
16:31:55,390 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/mail-ra.rar
16:32:18,062 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca
:service=DataSourceBinding ,name=Defa ultDS' to JNDI name 'java:DefaultDS'
16:37:20,359 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[Fo rmatI
d=257, GlobalId=TPSLVL00102/3, BranchQual=, localId=3] timed out. status=STATUS_
ACTIVE
This happening because server throws the following exception in the server.log file(c:/jboss4.0.5.GA/serv er/default /log)
Stack Trace
java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
at org.hsqldb.jdbc.Util.throw Error(Unkn own Source)
at org.hsqldb.jdbc.jdbcPrepar edStatemen t.executeU pdate(Unkn own Source)
at org.jboss.resource.adapter .jdbc.Cach edPrepared Statement. executeUpd ate(Cached PreparedSt atement.ja va:95)
at org.jboss.resource.adapter .jdbc.Wrap pedPrepare dStatement .executeUp date(Wrapp edPrepared Statement. java:251)
at org.jboss.mq.pm.jdbc2.Pers istenceMan ager.creat eSchema(Pe rsistenceM anager.jav a:277)
2007-10-10 16:32:19,093 DEBUG [org.jboss.mq.pm.jdbc2.Per sistenceMa nager] Could not create table with SQL: CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )
java.sql.SQLException: Table already exists: JMS_TRANSACTIONS in statement [CREATE CACHED TABLE JMS_TRANSACTIONS]
at org.hsqldb.jdbc.Util.throw Error(Unkn own Source)
at org.hsqldb.jdbc.jdbcPrepar edStatemen t.executeU pdate(Unkn own Source)
at org.jboss.resource.adapter .jdbc.Cach edPrepared Statement. executeUpd ate(Cached PreparedSt atement.ja va:95)
2007-10-10 16:32:19,093 DEBUG [org.jboss.mq.pm.jdbc2.Per sistenceMa nager] Could not create table with SQL: CREATE CACHED TABLE JMS_TRANSACTIONS ( TXID INTEGER, PRIMARY KEY (TXID) )
java.sql.SQLException: Table already exists: JMS_TRANSACTIONS in statement [CREATE CACHED TABLE JMS_TRANSACTIONS]
at org.hsqldb.jdbc.Util.throw Error(Unkn own Source)
at org.hsqldb.jdbc.jdbcPrepar edStatemen t.executeU pdate(Unkn own Source)
at org.jboss.resource.adapter .jdbc.Cach edPrepared Statement. executeUpd ate(Cached PreparedSt atement.ja va:95)
I am suspecting server throws this exception due to it is not able to shutdown the instance of "hypersonicdatabase" which is the default database of the JBOSS.
please tell me what is the meaning of the above exception and how to resolve it.
I have JOBSS server 4.0.5 GA installed on the our server having the operating system as windows server 2003. Server gets startup correctly and works fine at the first time but when i shutdown the server and again tried to start it, it hangs up. Following is the stack trace from log file(jb.10102007.log)
Stack Trace
16:31:49,968 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../dep
loy/management/console-mgr
16:31:53,484 INFO [MailService] Mail Service bound to java:/Mail
16:31:54,390 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-local-
16:31:54,656 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-ha-xa-jdb
16:31:54,812 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-local-jdb
16:31:55,015 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jboss-xa-jdbc.r
16:31:55,093 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/jms/jms-ra.rar
16:31:55,390 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in .../deploy/mail-ra.rar
16:32:18,062 INFO [WrapperDataSourceService]
:service=DataSourceBinding
16:37:20,359 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl[Fo
d=257, GlobalId=TPSLVL00102/3, BranchQual=, localId=3] timed out. status=STATUS_
ACTIVE
This happening because server throws the following exception in the server.log file(c:/jboss4.0.5.GA/serv
Stack Trace
java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
at org.hsqldb.jdbc.Util.throw
at org.hsqldb.jdbc.jdbcPrepar
at org.jboss.resource.adapter
at org.jboss.resource.adapter
at org.jboss.mq.pm.jdbc2.Pers
2007-10-10 16:32:19,093 DEBUG [org.jboss.mq.pm.jdbc2.Per
java.sql.SQLException: Table already exists: JMS_TRANSACTIONS in statement [CREATE CACHED TABLE JMS_TRANSACTIONS]
at org.hsqldb.jdbc.Util.throw
at org.hsqldb.jdbc.jdbcPrepar
at org.jboss.resource.adapter
2007-10-10 16:32:19,093 DEBUG [org.jboss.mq.pm.jdbc2.Per
java.sql.SQLException: Table already exists: JMS_TRANSACTIONS in statement [CREATE CACHED TABLE JMS_TRANSACTIONS]
at org.hsqldb.jdbc.Util.throw
at org.hsqldb.jdbc.jdbcPrepar
at org.jboss.resource.adapter
I am suspecting server throws this exception due to it is not able to shutdown the instance of "hypersonicdatabase" which is the default database of the JBOSS.
please tell me what is the meaning of the above exception and how to resolve it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.