AFAIK we do migrate between major versions, that was the initial motivation of the db tool.
On Tue, Aug 26, 2014 at 2:24 PM, bowen zhang < bowenzhang...@yahoo.com.invalid> wrote: > Hi guys, > If I recall correctly, we don't generally have DB upgrade within a major > version of oozie. Can anyone from yahoo explain why [OOZIE-1548] OozieDBCLI > changes to convert clob to blob and remove the discriminator column - ASF > JIRA is so important? do we really need this for 4.1? And Robert's > [OOZIE-1674] DB upgrade from 3.3.0 to trunk fails on postgres - ASF JIRA > fixed the postgres upgrade issue but we are still missing sqlserver upgrade > option. > Thanks, > Bowen > > > > [OOZIE-1548] OozieDBCLI changes to convert clob to blob and remove the > discriminator column - A... > For oracle and derby, convert from clob to blob For postgres, convert from > text to bytea For mysql, convert from text/mediumtext to mediumblob > View on issues.apache.org Preview by Yahoo > > > > > [OOZIE-1674] DB upgrade from 3.3.0 to trunk fails on postgres - ASF JIRA > [oozie@localhost ~]$ oozie-4.1.0-SNAPSHOT/bin/ooziedb.sh upgrade -run > setting CATALINA_OPTS="$CATALINA_OPTS -Xmx1024m" Validate DB Connection > DONE > Check DB schema exists > DONE > Verify there are not active Workflow Jobs > DONE > Check OOZIE_SYS table does no... > View on issues.apache.org Preview by Yahoo -- Alejandro