I eliminated this last error by shutting down JBoss, truncating the timers table, and then restarting JBoss.
Another issue has come up with this configuration. I tried to install a second box (one of our testing serviers) using the final configuration from the above experiments and ran into problems. Apparently, if I use the XA data source specification that I show above (without first using the non-XA source), then the JMS tables will not get created in the database and the Messaging service fails to start. Here are some stacktrace snips: | 2009-04-16 10:17:34,446 DEBUG [org.jboss.messaging.core.jmx.JDBCPersistenceManagerService] (main) Starting jboss.messaging:service=PersistenceManager | | 2009-04-16 10:17:34,493 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] (main) Failed to execute: CREATE TABLE JBM_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY)) ENGINE = INNODB | | java.sql.SQLException: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state | | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) | | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) | | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) | | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) | | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) | | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) | | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) | | at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605) | | at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524) | | at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeUpdate(StatementWrapper.java:839) | | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249) | | at org.jboss.messaging.core.impl.JDBCSupport.createSchema(JDBCSupport.java:301) | | at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:167) | | at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:148) | | at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:100) | | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376) | | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269) | | 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:597) | | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) | | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) | | at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138) | | at org.jboss.mx.server.Invocation.invoke(Invocation.java:90) | | at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140) | | at org.jboss.mx.server.Invocation.invoke(Invocation.java:90) | | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) | | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) | | at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206) | | at $Proxy36.start(Unknown Source) | | at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42) | | at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37) | | at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) | | at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) | | at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) | | at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) | | at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286) | | at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598) | | at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) | | at org.jboss.system.ServiceController.doChange(ServiceController.java:688) | | at org.jboss.system.ServiceController.start(ServiceController.java:460) | | at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163) | | at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99) | | at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46) | | at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) | | at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50) | | at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098) | | at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) | | at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598) | | at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781) | | at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698) | | at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304) | | at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205) | | at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405) | | at org.jboss.Main.boot(Main.java:209) | | at org.jboss.Main$1.run(Main.java:547) | | at java.lang.Thread.run(Thread.java:619) | ...(omitted many similar traces for different JBM tables)... | 2009-04-16 10:17:34,509 DEBUG [org.jboss.messaging.core.impl.JDBCPersistenceManager] (main) Adding record on JBM_DUAL | | 2009-04-16 10:17:34,524 DEBUG [org.jboss.messaging.core.impl.JDBCPersistenceManager] (main) Checking for existance on JBM_DUAL | | 2009-04-16 10:17:34,524 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) org.jboss.messaging.core.jmx.jdbcpersistencemanagerserv...@112e6ef startService | | com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbossdfmdb.jbm_dual' doesn't exist | | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) | | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) | | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) | | at java.lang.reflect.Constructor.newInstance(Constructor.java:513) | | at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) | | at com.mysql.jdbc.Util.getInstance(Util.java:381) | | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) | | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) | | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) | | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) | | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) | | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) | | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) | | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) | | at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422) | | at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeQuery(StatementWrapper.java:743) | | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226) | | at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:203) | | at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerService.java:100) | | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376) | | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269) | | 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:597) | | at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) | | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) | | at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138) | | at org.jboss.mx.server.Invocation.invoke(Invocation.java:90) | | at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140) | | at org.jboss.mx.server.Invocation.invoke(Invocation.java:90) | | at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) | | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) | | at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206) | | at $Proxy36.start(Unknown Source) | | at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42) | | at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37) | | at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62) | | at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71) | | at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51) | | at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) | | at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286) | | at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598) | | at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) | | at org.jboss.system.ServiceController.doChange(ServiceController.java:688) | | at org.jboss.system.ServiceController.start(ServiceController.java:460) | | at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163) | | at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99) | | at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46) | | at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62) | | at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50) | | at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098) | | at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348) | | at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598) | | at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062) | | at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822) | | at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553) | | at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781) | | at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698) | | at org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304) | | at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205) | | at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405) | | at org.jboss.Main.boot(Main.java:209) | | at org.jboss.Main$1.run(Main.java:547) | | at java.lang.Thread.run(Thread.java:619) | | 2009-04-16 10:17:34,524 DEBUG [org.jboss.messaging.core.jmx.JDBCPersistenceManagerService] (main) Starting failed jboss.messaging:service=PersistenceManager | According to http://www.jboss.org/index.html?module=bb&op=viewtopic&t=84442&postdays=0&postorder=asc&start=0 I shouldn't be using XA for my messaging. This sends me back to the beginning in configuring two data sources. Perhaps I should just move the timer to my application's datasource. Is there a problem doing that? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4226007#4226007 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4226007 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
