activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "steve neo (JIRA)" <j...@apache.org>
Subject [jira] Created: (AMQ-3189) Postgresql with spring embedded activeMQ has table already created exception
Date Thu, 24 Feb 2011 09:46:38 GMT
Postgresql with spring embedded activeMQ has table already created exception
----------------------------------------------------------------------------

                 Key: AMQ-3189
                 URL: https://issues.apache.org/jira/browse/AMQ-3189
             Project: ActiveMQ
          Issue Type: Bug
    Affects Versions: 5.4.2
         Environment: Postgresql 8.4,  latest Postgresql JDBC9.0.x, tomcat 6.x, spring 2.5
            Reporter: steve neo


Same configuration works fine with MySQL. For postgresql, first time starting will create
table without problem After restart tomcat, spring reports exception. But good thing is, MQ
is still workable after this exception.

============= Exception ================
13:38:53] INFO  [JDBCPersistenceAdapter] Database adapter driver override recognized for :
[postgresql_native_driver] - adapter: class org.apache.activemq.store.jdbc.adapter.PostgresqlJDBCAdapter
[13:38:53] WARN  [DefaultJDBCAdapter] Could not create JDBC tables; they could already exist.
Failure was: CREATE TABLE EDG_ACTIVEMQ_MSGS(ID BIGINT NOT NULL, CONTAINER VARCHAR(80), MSGID_PROD
VARCHAR(80), MSGID_SEQ BIGINT, EXPIRATION BIGINT, MSG BYTEA, PRIMARY KEY ( ID ) ) Message:
ERROR: relation "edg_activemq_msgs" already exists SQLState: 42P07 Vendor code: 0

[13:38:53] WARN  [JDBCPersistenceAdapter] Failure details: ERROR: relation "edg_activemq_msgs"
already exists

org.postgresql.util.PSQLException: ERROR: relation "edg_activemq_msgs" already exists

 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
~[postgresql-9.0-801.jdbc4.jar:na]

 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) ~[postgresql-9.0-801.jdbc4.jar:na]

 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.0-801.jdbc4.jar:na]

 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) ~[postgresql-9.0-801.jdbc4.jar:na]

 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
~[postgresql-9.0-801.jdbc4.jar:na]

 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) ~[postgresql-9.0-801.jdbc4.jar:na]

 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_21]

 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_21]
============= End Exception ================
I try dbcp.DataSource and postgresql Datasource both.

============= Datasource ================
<bean id="activeMQDS" class="org.postgresql.ds.PGPoolingDataSource" destroy-method="close">
        <property name="serverName" value="10.88.30.144"/> 
    <property name="databaseName" value="mydb"/> 
    <property name="portNumber" value="0"/> 
        <property name="user" value="${server.db.username}"/>
        <property name="password" value="${server.db.password}"/>
        <property name="dataSourceName" value="activeMQDS"/> 
   <property name="initialConnections" value="1"/> 
    <property name="maxConnections" value="10"/> 
    </bean>

============= broker ================
	<amq:broker id="activeMQBroker" useJmx="false" persistent="true" start="true" useShutdownHook="true"
dataDirectory="${geniuswiki.tmp.dir}activemq-data">
		<amq:persistenceAdapter>
			<amq:jdbcPersistenceAdapter id="jdbcAdapter" dataSource="#coreDS" createTablesOnStartup="true"
useDatabaseLock="false">
					<amq:statements tablePrefix="@TOKEN.TABLE.PREFIX@"	stringIdDataType ="VARCHAR(80)"
msgIdDataType="VARCHAR(80)" containerNameDataType="VARCHAR(80)"/>
				</amq:statements>
			</amq:jdbcPersistenceAdapter>
		</amq:persistenceAdapter>
		<amq:transportConnectors>
			<amq:transportConnector uri="tcp://${mq.server.url}?wireFormat.maxInactivityDuration=0"/>
		</amq:transportConnectors>
	</amq:broker>




-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message