Problem with mySQL as persitence storage for messages

[Arif Mohd <ar...@wipro.com>]

Hi,
   Iam using activeMQ 4.1,servicemix 3.1 and using mySQL as persitence
storage for messages, iam getting the following exception under the scenario
as mentione below.

     when i place multiple requests(4-5) at a time, could any body help me
out what i have to do, to get rid of this error
     ideally activemq should open and close the connections to DB properly
irrespective of the load, any help will be great for me.


ERROR - JournalPersistenceAdapter      - Failed to checkpoint a message
store: edu.emory.mathcs.backport.java.util.concurre
cutionException: java.io.IOException: Not started.
edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
java.io.IOException: Not started.
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
        at
org.apache.activemq.store.journal.JournalPersistenceAdapter.doCheckpoint(JournalPersistenceAdapter.java:386)
        at
org.apache.activemq.store.journal.JournalPersistenceAdapter$2.iterate(JournalPersistenceAdapter.java:129)
        at
org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:111)
        at
org.apache.activemq.thread.PooledTaskRunner.access$100(PooledTaskRunner.java:26)
        at
org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:44)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
        at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.io.IOException: Not started.
        at
org.apache.activemq.store.jdbc.TransactionContext.rollback(TransactionContext.java:168)
        at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.rollbackTransaction(JDBCPersistenceAdapter.java:368)
        at
org.apache.activemq.store.journal.JournalPersistenceAdapter.rollbackTransaction(JournalPersistenceAdapter.java:1
        at
org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:62)
        at
org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247)
        at
org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:221)
        at
org.apache.activemq.store.journal.JournalPersistenceAdapter$4.call(JournalPersistenceAdapter.java:356)
        at
edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
        ... 3 more
-- 
View this message in context: http://www.nabble.com/Problem-with-mySQL-as-persitence-storage-for-messages-tf3926193s2354.html#a11134303
Sent from the ActiveMQ - User mailing list archive at Nabble.com.