[jboss-user] [JBoss Messaging] - Error: relation "jbm_dual" already exists

[tim@nwresearch.com]

tim at nwresearch.com [http://community.jboss.org/people/tim%40nwresearch.com] created the discussion

"Error: relation "jbm_dual" already exists"

To view the discussion, visit: http://community.jboss.org/message/581729#581729

--------------------------------------------------------------
I've set up jboss messaging in a 2 node Jboss 4.2.3 cluster with a postgresql database for shared jboss messaging datastore.  When the second node is started, I see errors in the log like the second node is trying to recreate the messaging database tables.

2011-01-18 18:04:55,891 DEBUG [org.jboss.messaging.core.impl.JDBCSupport] Failed to execute: CREATE TABLE JBM
_DUAL (DUMMY INTEGER, PRIMARY KEY (DUMMY))
org.postgresql.util.PSQLException: ERROR: relation "jbm_dual" already exists
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:299)
        at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
        at org.jboss.messaging.core.impl.JDBCSupport.createSchema(JDBCSupport.java:301)
        at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:167)
        at org.jboss.messaging.core.impl.JDBCPersistenceManager.start(JDBCPersistenceManager.java:149)
        at org.jboss.messaging.core.jmx.JDBCPersistenceManagerService.startService(JDBCPersistenceManagerServ
ice.java:100)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java
:142)
....

Similar errors are repeated for all the tables and user inserts.


This seems to me like a problem, but as near as I can tell things seem to be working dispite the errors.  Is this error something to worry about?  Is there a configuration which will prevent the second node from trying to recreate the tables which already exist?
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/581729#581729]

Start a new discussion in JBoss Messaging at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2042]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110118/74a48130/attachment.html