You should be using different databases for each broker
cheers, Rob On 22 Mar 2006, at 11:02, Javier Leyba wrote:
Hi I did tests with two brokers persisting in the same DB and sometimes saw in log file a message like that: 2006-03-22 10:43:39,372 [eckpoint worker] DEBUG JDBCPersistenceAdapter - Commit failed: Duplicate entry '223' for key 1 java.sql.BatchUpdateException: Duplicate entry '223' for key 1at com.mysql.jdbc.ServerPreparedStatement.executeBatch (ServerPreparedStatement.java:642) at org.apache.commons.dbcp.DelegatingStatement.executeBatch (DelegatingStatement.java:205) at org.apache.commons.dbcp.DelegatingStatement.executeBatch (DelegatingStatement.java:205) at org.apache.activemq.store.jdbc.TransactionContext.executeBatch (TransactionContext.java:92) at org.apache.activemq.store.jdbc.TransactionContext.executeBatch (TransactionContext.java:71) at org.apache.activemq.store.jdbc.TransactionContext.commit (TransactionContext.java:151) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.commitTransactio n(JDBCPersistenceAdapter.java:302) at org.apache.activemq.store.journal.JournalPersistenceAdapter.commitTran saction(JournalPersistenceAdapter.java:177) at org.apache.activemq.store.journal.JournalMessageStore $3.execute(JournalMessageStore.java:269) at org.apache.activemq.util.TransactionTemplate.run (TransactionTemplate.java:43) at org.apache.activemq.store.journal.JournalMessageStore.checkpoint (JournalMessageStore.java:237) at org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint( JournalTopicMessageStore.java:156) at org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call (JournalPersistenceAdapter.java:355) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run (FutureTask.java:176) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $Worker.runTask(ThreadPoolExecutor.java:650) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor $Worker.run(ThreadPoolExecutor.java:675)at java.lang.Thread.run(Thread.java:534) I wonder if should I use one DB for each broker or should I add a new setting to avoid this kind of errors... Thanks in advance J
