[ 
https://issues.apache.org/jira/browse/OOZIE-1398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13682289#comment-13682289
 ] 

Rohini Palaniswamy commented on OOZIE-1398:
-------------------------------------------

The first two are already taken care of. DB_VERSION used to be 1 for 3.2. This 
patch does not contain it because it was done in OOZIE-1150. 

{noformat}
if (ver.equals("1")) { // if db.version equals to 1 (after 3.2+), need to 
upgrade
                upgradeDBTo40(sqlFile, run, true);
            }
            else if (ver.equals(DB_VERSION)) { // if db.version equals to 2, 
it's already upgraded
                throw new Exception("Oozie DB has already been upgraded");
            }

upgradeDBTo40() {
...
upgradeOozieDBVersion(sqlFile, run);
..
}
{noformat}
                
> [Scale] Reduce the number of CLOB columns used
> ----------------------------------------------
>
>                 Key: OOZIE-1398
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1398
>             Project: Oozie
>          Issue Type: Improvement
>    Affects Versions: trunk, 3.3.2
>            Reporter: Rohini Palaniswamy
>            Assignee: Ryota Egashira
>             Fix For: trunk
>
>         Attachments: OOZIE-1398-v4.patch, OOZIE-1398-v5.patch, 
> OOZIE-1398-v7.patch, OOZIE-1398-v8.patch, OOZIE-1398-v8.patch
>
>
>   When the number of concurrent submissions on Oozie increased to 100-200 per 
> minute, it was not able to scale and we hit Oracle issues as there were lot 
> of CLOB columns and DB became a bottle neck.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to