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

Failed upgrade process com.liferay.portal.upgrade.v7_4_x.UpgradeCountry

    Description

    Steps to Reproduce:

    1. Import attached database (7.3.0 GA1) into PostgreSQL 11.2.
    2. Upgrade the database to master.

    Expected Result:
    The upgrades process complete as expected.

    Actual Result:
    The upgrade process com.liferay.portal.upgrade.v7_4_x.UpgradeCountry failed with following error:

         [java] 04:40:10,350 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.v7_4_x.UpgradeCountry in 29 ms
         [java] 04:40:10,350 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 1803 ms
         [java] com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
         [java]   Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
         [java]   Position: 62
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109)
         [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:156)
         [java] 	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:119)
         [java] 	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:182)
         [java] 	at com.liferay.portal.tools.DBUpgrader._upgradePortal(DBUpgrader.java:334)
         [java] 	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:151)
         [java] 	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:143)
         [java] 	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:123)
         [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         [java] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         [java] 	at java.lang.reflect.Method.invoke(Method.java:498)
         [java] 	at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:54)
         [java] Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
         [java]   Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
         [java]   Position: 62
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109)
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:131)
         [java] 	at com.liferay.portal.upgrade.PortalUpgradeProcess.doUpgrade(PortalUpgradeProcess.java:130)
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104)
         [java] 	... 12 more
         [java] Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
         [java]   Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
         [java]   Position: 62
         [java] 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
         [java] 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
         [java] 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
         [java] 	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
         [java] 	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
         [java] 	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
         [java] 	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
         [java] 	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
         [java] 	at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:244)
         [java] 	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
         [java] 	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
         [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:337)
         [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:303)
         [java] 	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:71)
         [java] 	at com.liferay.portal.upgrade.v7_4_x.UpgradeCountry.doUpgrade(UpgradeCountry.java:40)
         [java] 	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104)
         [java] 	... 15 more
    

      Attachments

        Activity

          People

          Assignee:
          patricia.perez Patricia Perez
          Reporter:
          sharry.shi Sharry Shi
          Participants of an Issue:
          Recent user:
          Patricia Perez
          Engineering Assignee:
          Drew Brokke
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Days since last comment:
            30 weeks, 5 days ago

              Packages

              Version Package
              Master