This discussion is archived
1 Reply Latest reply: Sep 25, 2009 6:45 AM by 514272 RSS

Process queue not working

514272 Newbie
Currently Being Moderated
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(*)
from es_queue
where msg_state != 0 group by queue, msg_state; 2 3

QUEUE MSG_STATE     COUNT(*)
---------- ---------- ----------
     1     3     7
     2     1     360
     2     3     1
     3     3     206


Can anyone help me please? Its very urgent.

Regards,
Nuno Correia
  • 1. Re: Process queue not working
    514272 Newbie
    Currently Being Moderated
    Problem solve.

    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';
    commit;

    Regards,
    Nuno

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points