Rohini, I think I’m not explaining my concern well; let me back up a bit. We normally only require a database schema change/upgrade between major releases (i.e. Oozie 3.x —> 4.y). The changes introduced by OOZIE-1468 (Add created time column in WF_ACTIONS and SLA tables) make changes to the database schema by adding a new column and setting indexes. However, in trunk’s release-log.txt, OOZIE-1468 is currently marked under “Oozie 4.1.0 release”. Doesn’t OOZIE-1468 have to go in Oozie 5.0?
In any case, we don’t actually have a way to upgrade an existing database from pre-OOZIE-1468 to post-OOZIE-1468; that appears to be part of what OOZIE-1548 (OozieDBCLI changes to convert clob to blob and remove the discriminator column) is doing. OOZIE-1548 also internally refers to Oozie 5 for the new database version. Once this goes into trunk, we’d have to move to an Oozie 5 based release in trunk, right? So between OOZIE-1468 and OOZIE-1548, it looks like we’ll be moving to Oozie 5 (at least in trunk) very soon. This will make it difficult to have any minor releases (e.g. 4.x.0) in the Oozie 4 branch because anything that depends on OOZIE-1468 or OOZIE-1548, or that requires either of them in order to cleanly apply, we won’t be able to backport to branch-4. That’s what I’m concerned about. Thoughts? Oozie HA doesn’t require a database schema change, so it should be fine in any Oozie 4.x release. thanks - Robert On Mon, Dec 2, 2013 at 11:00 AM, Rohini Palaniswamy <rohini.adi...@gmail.com > wrote: > Robert, > Do you have something in mind for Oozie 4.x.0 release like HA? > > Regards, > Rohini > > ---------- Forwarded message ---------- > From: Robert Kanter (JIRA) <j...@apache.org> > Date: Mon, Dec 2, 2013 at 10:33 AM > Subject: [jira] [Commented] (OOZIE-1468) Add created time column in > WF_ACTIONS and SLA tables > To: dev@oozie.apache.org > > > > [ > > https://issues.apache.org/jira/browse/OOZIE-1468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13836761#comment-13836761 > ] > > Robert Kanter commented on OOZIE-1468: > -------------------------------------- > > (I used the wrong word in my last comment; 4.0.1 is a point release and > 4.x.0 is a minor release) > > > Add created time column in WF_ACTIONS and SLA tables > > ---------------------------------------------------- > > > > Key: OOZIE-1468 > > URL: https://issues.apache.org/jira/browse/OOZIE-1468 > > Project: Oozie > > Issue Type: Improvement > > Affects Versions: 4.0.0 > > Reporter: Shwetha G S > > Assignee: Rohini Palaniswamy > > Fix For: trunk > > > > Attachments: OOZIE-1468-1.patch, OOZIE-1468-2.patch > > > > > > Its useful to have a created_time column in WF_ACTIONS table that is set > at insert time and not updated later. This can be used to know time of > insert and its required for table partitioning(for db purging). > > Any thoughts? > > > > -- > This message was sent by Atlassian JIRA > (v6.1#6144) >
