Hello, I'm having a problem with process queue 2, since yesterday the queue doesn't process the messages, they are always on state 3 or 1: here's the output:
SQL> select queue, msg_state, count(*)
where msg_state != 0 group by queue, msg_state; 2 3
The problem was that there was two repeted messages in the new_queue that stops the process queue sending messages outside.
Here's the SQL I useded:
select msg_id, rowid from new_queue where msg_id in (select msg_id from (select msg_id, count(*) cnt from new_queue group by msg_id) where cnt > 1) order by msg_id; // verify repeted messages; If no queries, that's fine otherwise delete one of the msgid message
delete from new_queue where msg_id=38823565 and rowid='AAAP5xAAwAAABDaAAB';