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

Unable to upgrade to 7.0 if previous portal uses kaleo-web on mysql 5.5

    Details

    • Fix Priority:
      4

      Description

      Reproduced on:
      MySQL 5.5.48 > MySQL 5.6.29
      6.2.5 CE > master GIT ID: 09c3698ecee6f479bd38a3cc3183e392c61716d0.
      6.1.2 EE > master GIT ID: 09c3698ecee6f479bd38a3cc3183e392c61716d0.
      6.1.30 EE > master GIT ID: 09c3698ecee6f479bd38a3cc3183e392c61716d0.

      Not Reproducible on:
      MySQL 5.6.29 > MySQL 5.6.29
      6.2.5 CE > master GIT ID: 09c3698ecee6f479bd38a3cc3183e392c61716d0.

      Steps to Reproduce:

      1. Start portal 6.2/6.1 on MySQL 5.5
      2. Add kaleo-web portlet to the portal (or put an asset in workflow if it already is present in the bundle)
      3. Shutdown portal
      4. Import database into MySQL 5.6
      5. run "mysql_upgrade"
      6. Upgrade database to Portal 7.0 (Instructions)

      Expected Result:
      Upgrade completes without error

      Expected Result:
      Upgrade fails to complete with error message:

      00:04:17,440 INFO  [main][UpgradeProcess:96] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 3236ms
      com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Incorrect string value: '\xE3\x82\xBB\xE3\x83\xBC...' for column 'name' at row 1
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
      	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
      	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:158)
      	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:96)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Incorrect string value: '\xE3\x82\xBB\xE3\x83\xBC...' for column 'name' at row 1
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
      	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:74)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:87)
      	... 7 more
      Caused by: java.sql.SQLException: Incorrect string value: '\xE3\x82\xBB\xE3\x83\xBC...' for column 'name' at row 1
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:411)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:384)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:335)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:300)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.updateFileEntryTypeNamesAndDescriptions(UpgradeDocumentLibrary.java:269)
      	at com.liferay.portal.upgrade.v7_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:100)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:87)
      	... 10 more
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              victor.ware Victor Ware
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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

                  Packages

                  Version Package