[jira] [Updated] (AMQ-7178) Table Creation Postgres ActiveMQ

["Sven Renner (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMQ-7178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sven Renner updated AMQ-7178:
-----------------------------
    Component/s: Broker

> Table Creation Postgres ActiveMQ
> --------------------------------
>
>                 Key: AMQ-7178
>                 URL: https://issues.apache.org/jira/browse/AMQ-7178
>             Project: ActiveMQ
>          Issue Type: Bug
>          Components: activemq-camel, Broker
>            Reporter: Sven Renner
>            Priority: Major
>
> I tried running my ActiveMQ / Postgres Setup on Openshift but keep having errors in my Postgres SQL. 
>  
> activemq.xml:
> {code:java}
> <persistenceAdapter >
>  <jdbcPersistenceAdapter dataSource="#postgres-ds" lockKeepAlivePeriod="5000">
>  <statements>
>  <statements messageTableName = "activemq_msgs" durableSubAcksTableName = "activemq_acks" lockTableName = "activemq_lock"/>
>  </statements>
>  <locker>
>  <lease-database-locker lockAcquireSleepInterval="10000"/>
>  </locker>
>  </jdbcPersistenceAdapter>
>  </persistenceAdapter>{code}
> {code:java}
> <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
>         <property name="url" value="jdbc:postgresql://postgres-ingn-db/db"/>
>         <property name="user" value="xxx"/>
>         <property name="password" value="xxx"/>
>         <property name="initialConnections" value="1"/>
>         <property name="maxConnections" value="10"/>
>     </bean>
> {code}
> ERROR:  relation "activemq_msgs" already exists
> STATEMENT:  CREATE TABLE activemq_msgs(ID BIGINT NOT NULL, CONTAINER VARCHAR(250) NOT NULL, MSGID_PROD VARCHAR(250), MSGID_SEQ BIGINT, EXPIRATION BIGINT, MSG BYTEA, PRIMARY KEY ( ID ) )
> ERROR:  relation "activemq_msgs_midx" already exists
> STATEMENT:  CREATE INDEX activemq_msgs_MIDX ON activemq_msgs (MSGID_PROD,MSGID_SEQ)
> I tried some stuff from https://issues.apache.org/jira/browse/AMQ-3189 but couldn't get it work.
> Thanks in advance



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)