My Oracle Support Banner

ZDLRA: Tasks stuck in TIME_WAIT with NEXT_RUN_TIME in NULL value (Doc ID 2518775.1)

Last updated on APRIL 12, 2022

Applies to:

Zero Data Loss Recovery Appliance X6 Hardware - Version All Versions and later
Information in this document applies to any platform.

Symptoms

- BACKUP_SBT tasks remain on TIME_WAIT status:


SQL> select state, task_type, count(*) from ra_task where archived = 'N' and state = 'TIME_WAIT' group by state, task_type;

STATE TASK_TYPE COUNT(*)
---------------- ---------- ----------
TIME_WAIT BACKUP_SBT 28



- Also NEXT_RUN_TIME is NULL for those tasks:

SQL> select task_id, creation_time, error_count, interrupt_count,
last_interrupt_time, last_execute_time, next_run_time
from ra_task
where task_type='BACKUP_SBT' and state='TIME_WAIT' and NEXT_RUN_TIME is null order by creation_time

TASK_ID CREATION_TIME ERROR_COUNT INTERRUPT_COUNT
LAST_INTERRUPT_TIME LAST_EXECUTE_TIME
NEXT_RUN_TIME
---------- ------------------------------------ ----------- ---------------
------------------------------------ ------------------------------------
------------------------------------
47088358 21-JAN-19 07.41.43.041179 PM -06:00 0 1
22-JAN-19 11.14.48.892765 PM -06:00 22-JAN-19 11.14.48.418246 PM -06:00
47088360 21-JAN-19 07.41.43.226605 PM -06:00 0 1
22-JAN-19 11.14.50.020571 PM -06:00 22-JAN-19 11.14.49.563098 PM -06:00
...
47088449 21-JAN-19 08.01.18.309633 PM -06:00 0 1
22-JAN-19 11.15.11.661505 PM -06:00 22-JAN-19 11.15.11.207188 PM -06:00
47088451 21-JAN-19 08.02.08.112917 PM -06:00 0 1
22-JAN-19 11.15.11.665784 PM -06:00 22-JAN-19 11.15.11.207264 PM -06:00
47088455 21-JAN-19 08.02.23.920887 PM -06:00 0 1
22-JAN-19 11.15.13.551489 PM -06:00 22-JAN-19 11.15.13.043191 PM -06:00

28 rows selected.

Changes

 Nothing in particular

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.