Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-60204

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

    Details

      Description

      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
      

        Attachments

        1. liferay.2016-01-07.log
          435 kB
          Melody Wu
        2. new_error.png
          76 kB
          Melody Wu
        3. reproduce.png
          71 kB
          Melody Wu

          Activity

            People

            Assignee:
            melody.wu Melody Wu
            Reporter:
            alberto.chaparro Alberto Chaparro
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              6 years, 26 weeks, 2 days ago

                Packages

                Version Package
                7.0.0 Alpha 3