Details

      Description

      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
        

        Attachments

          Activity

            People

            Assignee:
            ian.song Ian Song (Inactive)
            Reporter:
            id27904 id27904
            Participants of an Issue:
            Recent user:
            Scott McIntosh
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              2 years, 46 weeks, 5 days ago

                Packages

                Version Package
                7.0.0 Beta 7