Upgrade to 7.0: SQL exception inserting into release table using Postgre

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 Alpha 2, 7.0.0 Alpha 3
• Fix Version/s: 7.0.0 Alpha 3
• Component/s: Core Infrastructure, Database Upgrade Framework
• Labels:
  • QA-B
• Story Points: 1.25
• Fix Priority: 4
• Databases:
  PostgreSQL 8.4, PostgreSQL 9.0, PostgreSQL 9.1, PostgreSQL 9.2, PostgreSQL 9.3
• Git Pull Request: https://github.com/migue/liferay-portal/pull/551

Steps to reproduce it:

1. Startup a 6.2 or prior Liferay version using Postgre
2. Once it's started, shutdown it
3. Upgrade to 7.0 (master)

The process will suddenly shutdown and you will get the following exception:

11:13:00,366 INFO  [localhost-startStop-1][UpgradeProcess:175] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 782ms
11:13:00,371 ERROR [localhost-startStop-1][MainServlet:238] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ values  (10410, '2015-11-05 11:13:00.341000 +01:00:00', '2015-11-05 11:13:00.341000 +01:00:00', 'com.liferay.amazon.rankings.web', 1, '2015-11-05 11:13:00.341000 +01:00:00', 1, 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.', '0.0.1', 0) was aborted.  Call getNextException to see the cause.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ values  (10410, '2015-11-05 11:13:00.341000 +01:00:00', '2015-11-05 11:13:00.341000 +01:00:00', 'com.liferay.amazon.rankings.web', 1, '2015-11-05 11:13:00.341000 +01:00:00', 1, 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.', '0.0.1', 0) was aborted.  Call getNextException to see the cause.
	at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1317)
	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:235)
	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ values  (10410, '2015-11-05 11:13:00.341000 +01:00:00', '2015-11-05 11:13:00.341000 +01:00:00', 'com.liferay.amazon.rankings.web', 1, '2015-11-05 11:13:00.341000 +01:00:00', 1, 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.', '0.0.1', 0) was aborted.  Call getNextException to see the cause.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:171)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:179)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:151)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:133)
	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:142)
	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:176)
	at com.liferay.portal.events.StartupAction.run(StartupAction.java:79)
	... 19 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ values  (10410, '2015-11-05 11:13:00.341000 +01:00:00', '2015-11-05 11:13:00.341000 +01:00:00', 'com.liferay.amazon.rankings.web', 1, '2015-11-05 11:13:00.341000 +01:00:00', 1, 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.', '0.0.1', 0) was aborted.  Call getNextException to see the cause.
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:171)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:193)
	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:81)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:168)
	... 27 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into Release_ values  (10410, '2015-11-05 11:13:00.341000 +01:00:00', '2015-11-05 11:13:00.341000 +01:00:00', 'com.liferay.amazon.rankings.web', 1, '2015-11-05 11:13:00.341000 +01:00:00', 1, 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.', '0.0.1', 0) 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.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
	at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeModules.doUpgrade(UpgradeModules.java:62)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:168)
	... 30 more
Stopping the server due to unexpected startup errors