activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javier Leyba" <xle...@gmail.com>
Subject JDBC Persistence
Date Wed, 22 Mar 2006 11:02:18 GMT
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

Mime
View raw message