[OOZIE-1684] DB upgrade from 3.3.0 to trunk fails on Oracle

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: trunk
• Fix Version/s: 4.1.0
• Assignee: Robert Kanter
• Reporter: Robert Kanter
• Created: 04/Feb/14 00:45
• Updated: 09/Dec/14 00:44
• Resolved: 04/Feb/14 07:19

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?

Issue Links

• is broken by: OOZIE-1548 OozieDBCLI changes to convert clob to blob and remove the discriminator column
• is related to: OOZIE-1674 DB upgrade from 3.3.0 to trunk fails on postgres
• relates to: OOZIE-1907 DB upgrade from 3.3.0 to trunk fails on derby