Hi, Which ActiveMQ version are you using ?
Regards JB On Fri, May 17, 2024 at 7:24 AM Susinda <susi...@gmail.com> wrote: > > Hi All > Anyone got below error before, any suggestion please. > > > | INFO | Using Persistence Adapter: > JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@f2ce6b) | > org.apache.activemq.broker.BrokerService | main > > 2024-05-17 12:53:31,481 | INFO | Starting Persistence Adapter: > JDBCPersistenceAdapter(org.apache.commons.dbcp2.BasicDataSource@f2ce6b) | > org.apache.activemq.broker.BrokerService | main > > 2024-05-17 12:53:36,835 | INFO | Database adapter driver override > recognized for : [mysql_connector_j] - adapter: class > org.apache.activemq.store.jdbc.adapter.MySqlJDBCAdapter | > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > 2024-05-17 12:53:43,713 | WARN | Could not create JDBC tables; they could > already exist. Failure was: ALTER TABLE ACTIVEMQ_ACKS DROP PRIMARY KEY > Message: This version of MySQL doesn't yet support 'existing primary key > drop without adding a new primary key. In > @@sql_generate_invisible_primary_key=ON mode table should have a primary > key. Please add a new primary key to be able to drop existing primary key.' > SQLState: 42000 Vendor code: 1235 | > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main > > 2024-05-17 12:53:43,714 | WARN | Failure details: This version of MySQL > doesn't yet support 'existing primary key drop without adding a new primary > key. In @@sql_generate_invisible_primary_key=ON mode table should have a > primary key. Please add a new primary key to be able to drop existing > primary key.' | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet support > 'existing primary key drop without adding a new primary key. In > @@sql_generate_invisible_primary_key=ON mode table should have a primary > key. Please add a new primary key to be able to drop existing primary key.' > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) > > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113) > > at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:829) > > at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:681) > > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) > > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) > > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.executeStatement(DefaultJDBCAdapter.java:112) > > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:90) > > at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:318) > > at > org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:99) > > at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54) > > at > org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:681) > > at > org.apache.activemq.broker.BrokerService.startPersistenceAdapter(BrokerService.java:663) > > at org.apache.activemq.broker.BrokerService.start(BrokerService.java:627) > > at > org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:73) > > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.base/java.lang.reflect.Method.invoke(Method.java:568) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1890) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1843) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) > > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) > > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:962) > > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) > > at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64) > > at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52) > > at > org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104) > > at > org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104) > > at > org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67) > > at > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71) > > at > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54) > > at > org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87) > > at > org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63) > > at > org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154) > > at > org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63) > > at > org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104) > > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.base/java.lang.reflect.Method.invoke(Method.java:568) > > at org.apache.activemq.console.Main.runTaskClass(Main.java:262) > > at org.apache.activemq.console.Main.main(Main.java:115) > > 2024-05-17 12:53:44,283 | 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: Multiple primary key > defined SQLState: 42000 Vendor code: 1068 | > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main > > 2024-05-17 12:53:44,283 | WARN | Failure details: Multiple primary key > defined | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > java.sql.SQLSyntaxErrorException: Multiple primary key defined > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112) > > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113) > > at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:829) > > at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:681) > > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) > > at > org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:182) > > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.executeStatement(DefaultJDBCAdapter.java:112) > > at > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:90) > > at > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:318) > > at > org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:99) > > at org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54) > > at > org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:681) > > at > org.apache.activemq.broker.BrokerService.startPersistenceAdapter(BrokerService.java:663) > > at org.apache.activemq.broker.BrokerService.start(BrokerService.java:627) > > at > org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:73) > > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.base/java.lang.reflect.Method.invoke(Method.java:568) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1890) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1843) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) > > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) > > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:962) > > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) > > at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64) > > at > org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52) > > at > org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104) > > at > org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104) > > at > org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67) > > at > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71) > > at > org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54) > > at > org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87) > > at > org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63) > > at > org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154) > > at > org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63) > > at > org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104) > > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.base/java.lang.reflect.Method.invoke(Method.java:568) > > at org.apache.activemq.console.Main.runTaskClass(Main.java:262) > > at org.apache.activemq.console.Main.main(Main.java:115) > > 2024-05-17 12:53:47,869 | INFO | Database lock driver override not found > for : [mysql_connector_j]. Will use default implementation. | > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > 2024-05-17 12:53:47,875 | INFO | Attempting to acquire the exclusive lock > to become the Master broker | > org.apache.activemq.store.jdbc.DefaultDatabaseLocker | main > > 2024-05-17 12:53:48,686 | INFO | Becoming the master on dataSource: > org.apache.commons.dbcp2.BasicDataSource@f2ce6b | > org.apache.activemq.store.jdbc.DefaultDatabaseLocker | main > > 2024-05-17 12:53:48,692 | INFO | Starting Temp Data Store | > org.apache.activemq.broker.BrokerService | main