Home » Server Options » Streams & AQ » Message always in ready state
Message always in ready state [message #175775] Mon, 05 June 2006 05:45
alvisemion
Messages: 4
Registered: June 2006
Junior Member
I created a queue multiconsumer.
I add one subscriber that call my stored: SP_GSL_FILEPDF_ENCRYPT

begin
dbms_aqadm.add_subscriber(
queue_name => 'MYSCHEMA.filepdf_queue',
subscriber => sys.aq$_agent('recipient', null, null));
end;
/

begin
dbms_aq.register(sys.aq$_reg_info_list(
sys.aq$_reg_info('MYSCHEMA.FILEPDF_QUEUE:RECIPIENT',
DBMS_AQ.NAMESPACE_AQ,
'plsql://MYSCHEMA.SP_GSL_FILEPDF_ENCRYPT',
HEXTORAW('FF')) ) ,
1);
commit;
end;
/

In my schema i created other queues.
Everything worked fine till now.

Now all messages enqueued to any queue stay in ready state and never go to processed or expired sate.
The enqueue properties are: NO DELAY, NO EXPIRATION, NO ATTEMPTS

I restart the db.
My v$system_event:
EVENT queue messages
TOTAL_WAITS 2810
TOTAL_TIMEOUTS 2810
TIME_WAITED 2804775
AVERAGE_WAIT 998
TIME_WAITED_MICRO 28047749893
EVENT_ID 1148964757

What colud be happend to my database?
What should i do or check to solve my problem?

Thanks in advance
Alvise
Previous Topic: Streams -- How to check the delay
Next Topic: 'Insufficient privileges' enque JMS ObjectMessage to owned by different usr
Goto Forum:
  


Current Time: Thu Mar 28 17:52:17 CDT 2024