>From the logs, it looks like it's failing to drop the primary key and then failing to create it (because it failed to drop it). For now let's assume that we're ending up in a good place (the table exists, the index exists), though we may have to reexamine that assumption if we find evidence of problems that call it into question.
To know whether you're dequeuing messages, you can attach a JMX viewer such as JConsole and look through the MBeans to find the one for your queue. There will be attributes about enqueue and dequeue counts which should make it clear which of the two possibilities you mentioned is actually occurring. Tim On Oct 18, 2017 7:21 AM, "ubaid" <ubaid.has...@aajtech.com> wrote: > Tim, > Can you help me a little bit more: > With the same configuration and with the change you told me earlier the > connection has been made, the tables are created but I still got an error > as > follow: > > Could not create JDBC tables; they could already exist. Failure was: ALTER > TABLE ACTIVEMQ_ACKS DROP PRIMARY KEY Message: Incorrect syntax near the > keyword 'PRIMARY'. SQLState: S0001 Vendor code: 156 > jvm 1 | WARN | Failure details: Incorrect syntax near the keyword > 'PRIMARY'. > jvm 1 | com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect > syntax > near the keyword 'PRIMARY'. > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError( > SQLServerException.java:217)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult( > SQLServerStatement.java:1655)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement( > SQLServerStatement.java:885)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute( > SQLServerStatement.java:778)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer. > java:7505)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand( > SQLServerConnection.java:2445)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand( > SQLServerStatement.java:191)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement( > SQLServerStatement.java:166)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.execute( > SQLServerStatement.java:751)[sqljdbc42.jar:] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter. > executeStatement(DefaultJDBCAdapter.java:114)[activemq-jdbc-store-5.15.1. > jar:5.15.1] > jvm 1 | at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables( > DefaultJDBCAdapter.java:92)[activemq-jdbc-store-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter. > init(JDBCPersistenceAdapter.java:307)[activemq-jdbc-store- > 5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.LockableServiceSupport.preStart( > LockableServiceSupport.java:89)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)[ > activemq-client-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter( > BrokerService.java:687)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.startPersistenceAdapter( > BrokerService.java:671)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.start(BrokerService.java:635)[ > activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet( > XBeanBrokerService.java:73)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac > tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.invokeInitMethods(AbstractAutowireCapableBeanFac > tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.initializeBean(AbstractAutowireCapableBeanFac > tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.doCreateBean(AbstractAutowireCapableBeanFac > tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.createBean(AbstractAutowireCapableBeanFac > tory.java:483)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory$1. > getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.9. > RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry. > getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.9. > RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean( > AbstractBeanFactory.java:302)[spring-beans-4.3.9.RELEASE. > jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean( > AbstractBeanFactory.java:197)[spring-beans-4.3.9.RELEASE. > jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.DefaultListableBeanFactory. > preInstantiateSingletons(DefaultListableBeanFactory. > java:761)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.context.support.AbstractApplicationContext. > finishBeanFactoryInitialization(AbstractApplicationContext. > java:867)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.context.support.AbstractApplicationContext.refresh( > AbstractApplicationContext.java:543)[spring-context-4.3. > 9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>( > ResourceXmlApplicationContext.java:64)[xbean-spring-4.2.jar:4.2] > jvm 1 | at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>( > ResourceXmlApplicationContext.java:52)[xbean-spring-4.2.jar:4.2] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>( > XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext( > XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory.createBroker( > XBeanBrokerFactory.java:67)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerFactory.createBroker( > BrokerFactory.java:71)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerFactory.createBroker( > BrokerFactory.java:54)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.StartCommand.runTask( > StartCommand.java:87)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.AbstractCommand. > execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.ShellCommand.runTask( > ShellCommand.java:154)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.AbstractCommand. > execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.ShellCommand.main( > ShellCommand.java:104)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.apache.activemq.console.Main.runTaskClass(Main.java: > 262)[activemq.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.tanukisoftware.wrapper.WrapperSimpleApp.run( > WrapperSimpleApp.java:240)[wrapper.jar:3.2.3] > jvm 1 | at java.lang.Thread.run(Unknown Source)[:1.8.0_144] > jvm 1 | WARN | Could not create JDBC tables; they could already exist. > Failure was: ALTER TABLE ACTIVEMQ_ACKS ADD PRIMARY KEY (CONTAINER, > CLIENT_ID, SUB_NAME, PRIORITY) Message: Table 'ACTIVEMQ_ACKS' already has a > primary key defined on it. SQLState: S0000 Vendor code: 1779 > jvm 1 | WARN | Failure details: Table 'ACTIVEMQ_ACKS' already has a > primary key defined on it. > jvm 1 | com.microsoft.sqlserver.jdbc.SQLServerException: Table > 'ACTIVEMQ_ACKS' already has a primary key defined on it. > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError( > SQLServerException.java:217)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult( > SQLServerStatement.java:1655)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement( > SQLServerStatement.java:885)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute( > SQLServerStatement.java:778)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer. > java:7505)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand( > SQLServerConnection.java:2445)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand( > SQLServerStatement.java:191)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement( > SQLServerStatement.java:166)[sqljdbc42.jar:] > jvm 1 | at > com.microsoft.sqlserver.jdbc.SQLServerStatement.execute( > SQLServerStatement.java:751)[sqljdbc42.jar:] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.commons.dbcp2.DelegatingStatement.execute( > DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1] > jvm 1 | at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter. > executeStatement(DefaultJDBCAdapter.java:114)[activemq-jdbc-store-5.15.1. > jar:5.15.1] > jvm 1 | at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables( > DefaultJDBCAdapter.java:92)[activemq-jdbc-store-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter. > init(JDBCPersistenceAdapter.java:307)[activemq-jdbc-store- > 5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.LockableServiceSupport.preStart( > LockableServiceSupport.java:89)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)[ > activemq-client-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter( > BrokerService.java:687)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.startPersistenceAdapter( > BrokerService.java:671)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerService.start(BrokerService.java:635)[ > activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet( > XBeanBrokerService.java:73)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac > tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.invokeInitMethods(AbstractAutowireCapableBeanFac > tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.initializeBean(AbstractAutowireCapableBeanFac > tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.doCreateBean(AbstractAutowireCapableBeanFac > tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac > tory.createBean(AbstractAutowireCapableBeanFac > tory.java:483)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory$1. > getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.9. > RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry. > getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.9. > RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean( > AbstractBeanFactory.java:302)[spring-beans-4.3.9.RELEASE. > jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean( > AbstractBeanFactory.java:197)[spring-beans-4.3.9.RELEASE. > jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.beans.factory.support.DefaultListableBeanFactory. > preInstantiateSingletons(DefaultListableBeanFactory. > java:761)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.context.support.AbstractApplicationContext. > finishBeanFactoryInitialization(AbstractApplicationContext. > java:867)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.springframework.context.support.AbstractApplicationContext.refresh( > AbstractApplicationContext.java:543)[spring-context-4.3. > 9.RELEASE.jar:4.3.9.RELEASE] > jvm 1 | at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>( > ResourceXmlApplicationContext.java:64)[xbean-spring-4.2.jar:4.2] > jvm 1 | at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>( > ResourceXmlApplicationContext.java:52)[xbean-spring-4.2.jar:4.2] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>( > XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext( > XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.xbean.XBeanBrokerFactory.createBroker( > XBeanBrokerFactory.java:67)[activemq-spring-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerFactory.createBroker( > BrokerFactory.java:71)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.broker.BrokerFactory.createBroker( > BrokerFactory.java:54)[activemq-broker-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.StartCommand.runTask( > StartCommand.java:87)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.AbstractCommand. > execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.ShellCommand.runTask( > ShellCommand.java:154)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.AbstractCommand. > execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.command.ShellCommand.main( > ShellCommand.java:104)[activemq-console-5.15.1.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.apache.activemq.console.Main.runTaskClass(Main.java: > 262)[activemq.jar:5.15.1] > jvm 1 | at > org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.15.1] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method)[:1.8.0_144] > jvm 1 | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at java.lang.reflect.Method.invoke(Unknown > Source)[:1.8.0_144] > jvm 1 | at > org.tanukisoftware.wrapper.WrapperSimpleApp.run( > WrapperSimpleApp.java:240)[wrapper.jar:3.2.3] > jvm 1 | at java.lang.Thread.run(Unknown Source)[:1.8.0_144] > > > > but it still creates the table, my main concern over here is that my > messages are queued in ActiveMQ but there is nothing in the rows of > database, all three of the tables are empty either my queue is not empty or > all of the messages are dequeued. > > Thanks Tim > > > > -- > Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User- > f2341805.html >
