Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timeout on dequeued message processing

Maris GabalinsJul 16 2009 — edited Sep 7 2009

Hi,

I got some weir behavior.

I have following processing order for messages from queue (pseudo code)

1. dequeue request
2. sleep some time (dbms_lock.sleep)
3. some processing
4. enqueue response
5. commit

All this processing happens in background database job (DBMS_SCHEDULER). For whatever reason JOB dies somewhere during step 2 with message error 1013 in job queue process ORA-01013: user requested cancel of current operation in RDBMS trace files - various sources indicate that some timeout condition can be most likely reason for error.

Have anybody encountered something similar or have any clue what is going wrong.

Thanks in advance
Sincerely
Maris

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2009

Added on Jul 16 2009

#advanced-queueing, #database-key-features

12 comments

4,063 views