ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

Hello everyone We are running AMQ 5.14 embedded mode under JBoss 7 with Java 7, 100% persistent messaging supported by JournalledJDCBPersistence to an Oracle 12 DB. Durable topic subscription processing is our focus. Our activmq-broker.xml looks like this: http://www.springframework.org/schema

Re: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

Hi Tim, do you mean improper handling by our consumer code or improper handling by ActiveMQ when selectors don't match? -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Re: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

I missed the word "our" in your response which I now take to mean ActiveMQ potential mishandling. -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Re: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

Tim, we appreciate any and all help the community can offer and we'll do what we can to help ourselves. You are correct in that a repeat of the test with only DC1 results in the same behaviour and outcome. Pending messages for DC1 are lost/deleted after messages arrive on the same topic but whi

Re: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

Tim, thanks for getting backwill do as you suggested and report back soon. -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Re: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

Hi Tim, we managed to attach a debugger as requested and the path you identified does seem to be the one taken by the incorrect update to ACTIVEMQ_ACKS table in respect of DC1. We took several stack dumps (text below) at the different debug points you requested in case that also helps. Note that

Re: Queue Recovery loads the entire data?

Hi, I have a customer running AMQ 5.10.0, JDBC persistence and no journalling like the OP. We saw the same query as the OP last week..also during a restart of the JBoss app server running AMQ embedded. Oracle AWR reports showed this SQL was executed 14,000 times in 1 hour, effectively grindi

Re: Queue Recovery loads the entire data?

Hi Tim, in case you missed it, or in case I'm missing something..but doesn't my stack trace confirm Oracle driver selection by the oracle.jdbc.driver packages? Cheers Jason. -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Re: Queue Recovery loads the entire data?

Got it. I'll try it today. -- Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Re: Queue Recovery loads the entire data?

Nathan, I do have access to Oracle in dev/test so might be able to help with your line of enquiry if you want to share some further thoughts and/or you think it might expedite. Cheers all and thanks for sharing. We really appreciate the work of all the good people in this community. -- Sent fr

Re: Queue Recovery loads the entire data?

I couldn't see the limitQuery() support in the DefaultJDBCAdapter of AMQ5.10, but it did arrive in AMQ5.13. Our system is currently on 5.10 so we upgraded a test system to 5.13.4. I updated the jdbcPersistenceAdapter element to look like this... ..