Postgres Upgrade from 6.2 to 7.0 fails

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 Beta 5, 7.0.0 Beta 6
• Fix Version/s: 7.0.0 Beta 7
• Component/s: Environments, Environments > Databases
• Labels:
  • LR7UPGRADE
• Story Points: 1.5
• Fix Priority: 5
• Databases:
  PostgreSQL 9.3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/36024

Steps to Reproduce

1. Configure Liferay 6.2 to use a Postgres DB
2. Start Liferay Portal 6.2 to create a DB in Postgres
3. Stop Liferay Portal 6.2
4. Start an upgrade against the Liferay 6.2 database by using the stand-alone upgrade tool:

   ./run.sh --classpath $TOMCAT_DIR/lib,$TOMCAT_DIR/lib/ext,$TOMCAT_DIR/webapps/ROOT/WEB-INF/lib --liferay_home $LRHOME_DIR
   

5. During the upgrade the process will fail with the following error:

   15:44:40,806 INFO  [main][UpgradeProcess:65] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 1621ms
   com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ (mvccVersion, releaseId, createDate, modifiedDate, servletContextName, schemaVersion, buildNumber, buildDate, verified, state_, testString) values (0, 20608, '2016-02-03 15:44:40.777000 +00:00:00', '2016-02-03 15:44:40.777000 +00:00:00', 'com.liferay.amazon.rankings.web', '0.0.1', 1, '2016-02-03 15:44:40.777000 +00:00:00', '0', 0, 'You take the blue pill, the story ends, you wake up in your bed and believe whatever you want to believe. You take the red pill, you stay in Wonderland, and I show you how deep the rabbit hole goes.') was aborted.  Call getNextException to see the cause.
   	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
   	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:184)
   	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:152)
   	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:134)
   	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
   	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
   	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:145)
   	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:67)
   Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ (mvccVersion, releaseId, createDate, modifiedDate, servletContextName, schemaVersion, buildNumber, buildDate, verified, state_, testString) values (0, 20608, '2016-02-03 15:44:40.777000 +00:00:00', '2016-02-03 15:44:40.777000 +00:00:00', 'com.liferay.amazon.rankings.web', '0.0.1', 1, '2016-02-03 15:44:40.777000 +00:00:00', '0', 0, 'You take the blue pill, the story ends, you wake up in your bed and believe whatever you want to believe. You take the red pill, you stay in Wonderland, and I show you how deep the rabbit hole goes.') was aborted.  Call getNextException to see the cause.
   	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:59)
   	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:83)
   	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:88)
   	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
   	... 7 more
   Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ (mvccVersion, releaseId, createDate, modifiedDate, servletContextName, schemaVersion, buildNumber, buildDate, verified, state_, testString) values (0, 20608, '2016-02-03 15:44:40.777000 +00:00:00', '2016-02-03 15:44:40.777000 +00:00:00', 'com.liferay.amazon.rankings.web', '0.0.1', 1, '2016-02-03 15:44:40.777000 +00:00:00', '0', 0, 'You take the blue pill, the story ends, you wake up in your bed and believe whatever you want to believe. You take the red pill, you stay in Wonderland, and I show you how deep the rabbit hole goes.') was aborted.  Call getNextException to see the cause.
   	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
   	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1999)
   	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
   	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
   	at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
   	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
   	at com.liferay.portal.upgrade.v7_0_0.UpgradeModules.addRelease(UpgradeModules.java:71)
   	at com.liferay.portal.upgrade.v7_0_0.UpgradeModules.updateExtractedModules(UpgradeModules.java:148)
   	at com.liferay.portal.upgrade.v7_0_0.UpgradeModules.doUpgrade(UpgradeModules.java:80)
   	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:56)
   	... 10 more