activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Davies <rajdav...@gmail.com>
Subject Re: JDBC Persistence
Date Wed, 22 Mar 2006 11:53:50 GMT
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 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.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


Mime
View raw message