You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@oozie.apache.org by The Trainer <tr...@gmail.com> on 2013/05/29 04:48:50 UTC

Oozie 2.3.2 - Long running coordinators - purge service not deleting historical actions

Hi All,

I am using Oozie 2.3.2 and I have more than 5 different coordinator jobs
 running concurrently  for 1 year duration.

Found that Purge service is not deleting already SUCCESSFUL Coordinator
Action table records if COORD_ACTIONS parent Coordinator job is still in
RUNNING status.

Any remedy for this?

There are so many records getting created in COORD_ACTIONS table because o
above different coordinator jobs.

Thanks,

Re: Oozie 2.3.2 - Long running coordinators - purge service not deleting historical actions

Posted by Alejandro Abdelnur <tu...@cloudera.com>.
as mohammad says, oozie 2 has issues in its purge logic.  

still what you are seeing it is the expected behavior. no data of running jobs is deleted. 

one way of solving this is to have back to back coord jobs every few months. then the completed ones will qualify for purging. 

thx


Alejandro
(phone typing)

On May 28, 2013, at 20:07, Mohammad Islam <mi...@yahoo.com> wrote:

> Yes that is bug in 2.3.3.
> You will need to delete those manually from the table.
> 
> Regards,
> Mohammad
> 
> 
> 
> ________________________________
> From: The Trainer <tr...@gmail.com>
> To: "user@oozie.apache.org" <us...@oozie.apache.org> 
> Sent: Tuesday, May 28, 2013 7:48 PM
> Subject: Oozie 2.3.2 - Long running coordinators - purge service not deleting historical actions
> 
> 
> Hi All,
> 
> I am using Oozie 2.3.2 and I have more than 5 different coordinator jobs
> running concurrently  for 1 year duration.
> 
> Found that Purge service is not deleting already SUCCESSFUL Coordinator
> Action table records if COORD_ACTIONS parent Coordinator job is still in
> RUNNING status.
> 
> Any remedy for this?
> 
> There are so many records getting created in COORD_ACTIONS table because o
> above different coordinator jobs.
> 
> Thanks,

Re: Oozie 2.3.2 - Long running coordinators - purge service not deleting historical actions

Posted by Mohammad Islam <mi...@yahoo.com>.
Yes that is bug in 2.3.3.
You will need to delete those manually from the table.

Regards,
Mohammad



________________________________
 From: The Trainer <tr...@gmail.com>
To: "user@oozie.apache.org" <us...@oozie.apache.org> 
Sent: Tuesday, May 28, 2013 7:48 PM
Subject: Oozie 2.3.2 - Long running coordinators - purge service not deleting historical actions
 

Hi All,

I am using Oozie 2.3.2 and I have more than 5 different coordinator jobs
running concurrently  for 1 year duration.

Found that Purge service is not deleting already SUCCESSFUL Coordinator
Action table records if COORD_ACTIONS parent Coordinator job is still in
RUNNING status.

Any remedy for this?

There are so many records getting created in COORD_ACTIONS table because o
above different coordinator jobs.

Thanks,