1 Reply Latest reply on Jan 26, 2006 12:34 AM by Elias Ross

    Why do I see java.sql.SQLException: Table 'JMS_MESSAGES' alr

    Padumane Kishan Newbie

      Hi,

      Can someone tell me why am I see this exception during JBoss startup? I am running JBOSS 4.0.2 default configuration. Here is the exception from the log file.


      Thanks in advance.


      2006-01-25 06:21:05,317 DEBUG [org.jboss.system.ServiceController] starting service jboss.ejb:persistencePolicy=d
      atabase,service=EJBTimerService
      2006-01-25 06:21:05,317 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Starting jboss.ejb:persistencePol
      icy=database,service=EJBTimerService
      2006-01-25 06:21:05,360 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registerin
      g pool with interval 900000 old interval: 9223372036854775807
      2006-01-25 06:21:05,360 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to n
      otify thread: old next: 1138199315360, new next: 1138199315360
      2006-01-25 06:21:05,360 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools
      , interval: 450000
      2006-01-25 06:21:05,361 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using propert
      ies: {user=jboss, password=--hidden--}
      2006-01-25 06:21:05,361 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Checking driv
      er for URL: jdbc:mysql://localhost:3306/jboss
      2006-01-25 06:21:05,362 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver not ye
      t registered for url: jdbc:mysql://localhost:3306/jboss
      2006-01-25 06:21:05,378 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver alread
      y registered for url: jdbc:mysql://localhost:3306/jboss
      2006-01-25 06:21:05,759 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Found 0 timer(s)
      2006-01-25 06:21:05,769 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Started jboss.ejb:persistencePoli
      cy=database,service=EJBTimerService
      2006-01-25 06:21:05,769 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.ejb:p
      ersistencePolicy=database,service=EJBTimerService dependent components: []
      2006-01-25 06:21:05,769 DEBUG [org.jboss.system.ServiceController] starting service jboss:service=KeyGeneratorFac
      tory,type=HiLo
      2006-01-25 06:21:05,769 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Starting jboss:se
      rvice=KeyGeneratorFactory,type=HiLo
      2006-01-25 06:21:05,774 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing DDL: dr
      op table HILOSEQUENCES
      2006-01-25 06:21:05,777 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing DDL: cr
      eate table HILOSEQUENCES (
      SEQUENCENAME varchar(50) not null,
      HIGHVALUES integer not null,
      constraint hilo_pk primary key (SEQUENCENAME)
      )
      2006-01-25 06:21:05,779 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing SQL: se
      lect * from HILOSEQUENCES where SEQUENCENAME='general'
      2006-01-25 06:21:05,780 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing SQL: in
      sert into HILOSEQUENCES(SEQUENCENAME, HIGHVALUES) values ('general', 0)
      2006-01-25 06:21:05,781 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Started jboss:ser
      vice=KeyGeneratorFactory,type=HiLo
      2006-01-25 06:21:05,781 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss:servi
      ce=KeyGeneratorFactory,type=HiLo dependent components: []
      2006-01-25 06:21:05,781 DEBUG [org.jboss.system.ServiceController] starting service jboss.mq:service=StateManager
      2006-01-25 06:21:05,781 DEBUG [org.jboss.mq.sm.jdbc.JDBCStateManager] Starting jboss.mq:service=StateManager
      2006-01-25 06:21:05,966 DEBUG [org.jboss.mq.sm.jdbc.JDBCStateManager] Started jboss.mq:service=StateManager
      2006-01-25 06:21:05,966 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.mq:se
      rvice=StateManager dependent components: [ObjectName: jboss.mq:service=DestinationManager
      State: CREATED
      I Depend On:
      jboss.mq:service=MessageCache
      jboss.mq:service=PersistenceManager
      jboss.mq:service=StateManager
      Depends On Me:
      jboss.mq.destination:name=testTopic,service=Topic
      jboss.mq.destination:name=securedTopic,service=Topic
      jboss.mq.destination:name=testDurableTopic,service=Topic
      jboss.mq.destination:name=testQueue,service=Queue
      jboss.mq.destination:name=A,service=Queue
      jboss.mq.destination:name=B,service=Queue
      jboss.mq.destination:name=C,service=Queue
      jboss.mq.destination:name=D,service=Queue
      jboss.mq.destination:name=ex,service=Queue
      jboss.mq:service=SecurityManager
      jboss.mq.destination:name=DLQ,service=Queue
      ]
      2006-01-25 06:21:05,966 DEBUG [org.jboss.system.ServiceController] starting service jboss.mq:service=DestinationM
      anager
      2006-01-25 06:21:05,966 DEBUG [org.jboss.system.ServiceController] waiting in start jboss.mq:service=DestinationM
      anager on jboss.mq:service=PersistenceManager
      2006-01-25 06:21:05,966 DEBUG [org.jboss.system.ServiceController] starting service jboss.mq:service=PersistenceM
      anager
      2006-01-25 06:21:05,966 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting jboss.mq:service=PersistenceMan
      ager
      2006-01-25 06:21:05,970 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Resolving uncommited TXS
      2006-01-25 06:21:05,973 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: CREATE
      TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), ME
      SSAGEBLOB LONGBLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
      java.sql.SQLException: Table 'JMS_MESSAGES' already exists
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
      - at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:3
      16)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:224)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1420)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(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:141)
      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:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:418)
      at org.jboss.system.ServiceController.start(ServiceController.java:440)
      at org.jboss.system.ServiceController.start(ServiceController.java:440)
      at org.jboss.system.ServiceController.start(ServiceController.java:440)
      at org.jboss.system.ServiceController.start(ServiceController.java:440)
      at sun.reflect.GeneratedMethodAccessor10.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:141)
      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:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:273)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      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:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127
      )
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
      at $Proxy35.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:229)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:964)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:775)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738)
      at sun.reflect.GeneratedMethodAccessor46.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:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:121)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127
      )
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy8.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:325)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:501)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.
      java:204)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277
      )
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:272)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(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:141)
      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:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:897)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:418)
      at sun.reflect.GeneratedMethodAccessor10.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:141)
      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:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:434)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:315)
      at org.jboss.Main.boot(Main.java:195)
      at org.jboss.Main$1.run(Main.java:463)
      at java.lang.Thread.run(Thread.java:534)