1 Reply Latest reply: Sep 25, 2009 8:45 AM by 514272 RSS

    Process queue not working

    514272
      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
          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