AQ issue with delayed message
- From: rjamya <rjamya@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Nov 2005 14:22:15 -0500
We have a process that deliberately delays all enqueued messages by a max of
900 seconds. Usually between 60 and 900 seconds. Since Sunday (fall back
switchover) what we have seen is in the aq$queue_table view, enq_time,
enq_timestamp and delay column show correct value. First two columns are
close to sysdate and delay column is 15 minutes away. But the
delay_timestamp time is an hour away.
This is causing all messages to be sent out delayed by an hour, which of
course is unacceptable. While we are working with OWS, I wanted to find out
if anyone has encountered this issue.
DB: 10.1.0.4 <http://10.1.0.4>, RAC. Bouncing AQ processes didn't help. What
i noticed is that for the view aq$queue_table the delay column has a
timestamp with timezone conversion but I think that value is wrong.
msg_id enq_time enq_timestamp delay delay_timestamp
04C2AA7B041180ACE043AC16A84180AC 11/4/2005 1:42:22 PM 11/4/2005 1:42:
22.235464 PM 11/4/2005 1:57:22 PM 11/4/2005 2:57:22.235464 PM
04C285531BBE801EE043AC16A841801E 11/4/2005 1:31:59 PM 11/4/2005 1:31:
58.863202 PM 11/4/2005 1:46:59 PM 11/4/2005 2:46:58.863202 PM
04C285531BBE801EE043AC16A841801E 11/4/2005 1:31:59 PM 11/4/2005 1:31:
58.863202 PM 11/4/2005 1:46:59 PM 11/4/2005 2:46:58.863202 PM
04C261257F4360C0E043AC16A84160C0 11/4/2005 1:21:52 PM 11/4/2005 1:21:
51.894160 PM 11/4/2005 1:36:52 PM 11/4/2005 2:36:51.894160 PM
04C261257F4360C0E043AC16A84160C0 11/4/2005 1:21:52 PM 11/4/2005 1:21:
51.894160 PM 11/4/2005 1:36:52 PM 11/4/2005 2:36:51.894160 PM
The timezone conversion is as follows ... cast(FROM_TZ(qt.delay, '-04:00')
at time zone sessiontimezone as date) delay but since it is auto generated
code, we can't mess with it.
any clue's as to what is happening?? sysdate and host date time is accurate,
we have and use our own time server (been doing this since a long time).
TIA
Raj
--
Other related posts:
- » AQ issue with delayed message
