Re: Queue Recovery loads the entire data?

2018-02-07 Thread jasons
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... ..

Re: Queue Recovery loads the entire data?

2018-02-05 Thread jasons
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?

2018-02-05 Thread jasons
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?

2018-02-05 Thread jasons
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?

2018-01-30 Thread jasons
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: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

2017-12-05 Thread jasons
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: ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

2017-11-23 Thread jasons
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

2017-11-08 Thread jasons
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

2017-11-07 Thread jasons
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

2017-11-07 Thread jasons
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

ActiveMQ losing durable topic messages when JournalledJDBCPersistence enabled

2017-11-06 Thread jasons
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