Bugs item #1108795, was opened at 2005-01-25 01:45
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1108795&group_id=22866
Category: JBossCache
Group: v4.0
Status: Open
Resolution: None
Priority: 5
Submitted By: jl (jlzhang)
Assigned to: Nobody/Anonymous (nobody)
Summary: try to created existing tables when starting server
Initial Comment:
Here is bug information from the server log. It seems
either Jboss need to check the existence before create
or use a replacement or drop the tables during server
shutdown.
2005-01-25 10:24:10,709 DEBUG
[org.jboss.system.ServiceController] starting service
jboss.mq:service=DestinationManager
2005-01-25 10:24:10,709 DEBUG
[org.jboss.system.ServiceController] waiting in start
jboss.mq:service=DestinationManager on
jboss.mq:service=PersistenceManager
2005-01-25 10:24:10,709 DEBUG
[org.jboss.system.ServiceController] starting service
jboss.mq:service=PersistenceManager
2005-01-25 10:24:10,709 DEBUG
[org.jboss.mq.pm.jdbc2.PersistenceManager] Starting
jboss.mq:service=PersistenceManager
2005-01-25 10:24:10,709 DEBUG
[org.jboss.mq.pm.jdbc2.PersistenceManager] Resolving
uncommited TXS
2005-01-25 10:24:10,719 DEBUG
[org.jboss.mq.pm.jdbc2.PersistenceManager] Could not
create table with SQL: CREATE CACHED TABLE
JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL,
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER,
TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY
(MESSAGEID, DESTINATION) )
java.sql.SQLException: Table already exists:
JMS_MESSAGES in statement [CREATE CACHED TABLE
JMS_MESSAGES]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown
Source)
at
org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate
(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatem
ent.executeUpdate
(WrappedPreparedStatement.java:316)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUnc
ommitedTXs(PersistenceManager.java:224)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.startService
(PersistenceManager.java:1422)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart
(ServiceMBeanSupport.java:272)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifec
ycle(ServiceMBeanSupport.java:222)
at
sun.reflect.GeneratedMethodAccessor2.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke
(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch
(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke
(Invocation.java:72)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke
(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:642)
at
org.jboss.system.ServiceController$ServiceProxy.invoke
(ServiceController.java:891)
at $Proxy0.start(Unknown Source)
....
2005-01-25 10:24:10,729 DEBUG
[org.jboss.mq.pm.jdbc2.PersistenceManager] 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.jdbcUtil.throwError(Unknown
Source)
at
org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate
(Unknown Source)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatem
ent.executeUpdate
(WrappedPreparedStatement.java:316)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUnc
ommitedTXs(PersistenceManager.java:296)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.startService
(PersistenceManager.java:1422)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart
(ServiceMBeanSupport.java:272)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifec
ycle(ServiceMBeanSupport.java:222)
at
sun.reflect.GeneratedMethodAccessor2.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke
(Method.java:324)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke
(ReflectedDispatcher.java:144)
at org.jboss.mx.server.Invocation.dispatch
(Invocation.java:80)
at org.jboss.mx.server.Invocation.invoke
(Invocation.java:72)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke
(AbstractMBeanInvoker.java:249)
at org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:642)
at
org.jboss.system.ServiceController$ServiceProxy.invoke
(ServiceController.java:891)
at $Proxy0.start(Unknown Source)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1108795&group_id=22866
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
