Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-1684

DB upgrade from 3.3.0 to trunk fails on Oracle

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: trunk
    • Fix Version/s: 4.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Similar issue to OOZIE-1674, but for Oracle instead of Postgres. Upgrading from a database created by Oozie 3.3.0 (DB version 1) to the current trunk (DB version 3) fails with this error:

      java.sql.SQLSyntaxErrorException: ORA-00904: "PUSH_MISSING_DEPENDENCIES": invalid identifier
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
      	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
      	at org.apache.oozie.tools.OozieDBCLI.convertClobToBlobInOracle(OozieDBCLI.java:458)
      	at org.apache.oozie.tools.OozieDBCLI.ddlTweaksFor50(OozieDBCLI.java:626)
      	at org.apache.oozie.tools.OozieDBCLI.upgradeDBto50(OozieDBCLI.java:240)
      	at org.apache.oozie.tools.OozieDBCLI.upgradeDB(OozieDBCLI.java:220)
      	at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:128)
      	at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:76)
      

      After more investigation, it turns out that if you do the 3.3.0 (version 1) to trunk (version 3) upgrade, any columns or tables added in 4.0.0 (version 2) are not actually added to the database (though they do get printed into the sql file).
      More specifically:

      • COORD_ACTIONS.PUSH_MISSING_DEPENDENCIES column
      • WF_ACTIONS.CREATED_TIME column
      • SLA_REGISTRATION table
      • SLA_SUMMARY table
      • Possibly other changes?

        Attachments

        1. OOZIE-1684.patch
          1.0 kB
          Robert Kanter

          Issue Links

            Activity

              People

              • Assignee:
                rkanter Robert Kanter
                Reporter:
                rkanter Robert Kanter
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: