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 1
at
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.commitTransaction(JDBCPersistenceAdapter.java:302)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.commitTransaction(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
