[jira] [Created] (AMQ-6983) DB schema not being created in postgresql

["Altin Ukshini (JIRA)" <ji...@apache.org>]

Altin Ukshini created AMQ-6983:
----------------------------------

             Summary: DB schema not being created in postgresql
                 Key: AMQ-6983
                 URL: https://issues.apache.org/jira/browse/AMQ-6983
             Project: ActiveMQ
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 5.15.2
         Environment: DB: Postgresql v9.6.9

OS: CentOS 7
            Reporter: Altin Ukshini


I am trying to setup activemq as master/slave with postgresql. After setting up the configs as suggested in the docs, I keep seeing the following in activemq.log

 
{code:java}
2018-06-08 20:16:42,698 | WARN  | slaveBroker lease acquire failure: org.postgresql.util.PSQLException: ERROR: relation "activemq_lock" does not exist
  Position: 8 | org.apache.activemq.store.jdbc.LeaseDatabaseLocker | main
org.postgresql.util.PSQLException: ERROR: relation "activemq_lock" does not exist
  Position: 8
{code}
I checked the activemq database and there were no tables, seems like they are not being created.

This is my config:
{code:java}
<broker xmlns="http://activemq.apache.org/schema/core" brokerName="slaveBroker">

................

    <persistenceAdapter>
        <jdbcPersistenceAdapter dataDirectory="${activemq.data}" dataSource="#postgres-ds" lockKeepAlivePeriod="5000">
            <locker>
                <lease-database-locker lockAcquireSleepInterval="10000"/>
            </locker>
        </jdbcPersistenceAdapter>
    </persistenceAdapter>

................

</broker>

..................

        <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
        <property name="url" value="jdbc:postgresql://127.0.0.1:5432/activemq"/>
                <property name="user" value="activemq"/>
                <property name="password" value="PASSWORDS"/>
                <property name="initialConnections" value="10"/>
                <property name="maxConnections" value="50"/>
        </bean>

{code}
Should the tables be created automatically?



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