Hi I assigned the Jira you created to me.
Quick question: how do you create the tables ? By hand or you let ActiveMQ create them ? Regards JB On Wed, May 22, 2024 at 2:16 AM Susinda <susi...@gmail.com> wrote: > > Hi All > > I'm getting this error with activemq classic 6.1.1 when I use postgress as > a datastore > Any help is apprceiated > > 2024-05-21 23:59:32,959 | INFO | Using Persistence Adapter: > JDBCPersistenceAdapter(HikariDataSource (null)) | > org.apache.activemq.broker.BrokerService | main > > 2024-05-21 23:59:32,968 | INFO | Starting Persistence Adapter: > JDBCPersistenceAdapter(HikariDataSource (null)) | > org.apache.activemq.broker.BrokerService | main > > 2024-05-21 23:59:32,969 | INFO | HikariPool-1 - Starting... | > com.zaxxer.hikari.HikariDataSource | main > > 2024-05-21 23:59:35,211 | INFO | HikariPool-1 - Added connection > org.postgresql.jdbc.PgConnection@70101687 | > com.zaxxer.hikari.pool.HikariPool | main > > 2024-05-21 23:59:35,214 | INFO | HikariPool-1 - Start completed. | > com.zaxxer.hikari.HikariDataSource | main > > 2024-05-21 23:59:35,433 | INFO | Database adapter driver override > recognized for : [postgresql_jdbc_driver] - adapter: class > org.apache.activemq.store.jdbc.adapter.PostgresqlJDBCAdapter | > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > 2024-05-21 23:59:38,423 | WARN | Could not create JDBC tables; they could > already exist. Failure was: ALTER TABLE ACTIVEMQ_ACKS DROP CONSTRAINT > "activemq_acks_pkey" Message: ERROR: constraint "activemq_acks_pkey" of > relation "activemq_acks" does not exist SQLState: 42704 Vendor code: 0 | > org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main > > 2024-05-21 23:59:38,423 | WARN | Failure details: ERROR: constraint > "activemq_acks_pkey" of relation "activemq_acks" does not exist | > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > org.postgresql.util.PSQLException: ERROR: constraint "activemq_acks_pkey" > of relation "activemq_acks" does not exist > > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371) > > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419) > > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341) > > at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326) > > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297) > > at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) > > at > com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) > > 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:325) > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) > > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) > > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) > > 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-21 23:59:38,637 | 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: ERROR: multiple primary > keys for table "activemq_acks" are not allowed SQLState: 42P16 Vendor code: > 0 | org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter | main > > 2024-05-21 23:59:38,638 | WARN | Failure details: ERROR: multiple primary > keys for table "activemq_acks" are not allowed | > org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main > > org.postgresql.util.PSQLException: ERROR: multiple primary keys for table > "activemq_acks" are not allowed > > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371) > > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419) > > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341) > > at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326) > > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302) > > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297) > > at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) > > at > com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) > > 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:325) > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) > > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) > > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:959) > > 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) --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@activemq.apache.org For additional commands, e-mail: users-h...@activemq.apache.org For further information, visit: https://activemq.apache.org/contact
