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

Upgrade from 6.1 GA2 to 6.2 fails when using PostgreSQL

    Details

      Description

      When trying to upgrade, Liferay throws the following exception:

      20:05:24,425 INFO  [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeJournal
      20:05:24,572 ERROR [localhost-startStop-1][MainServlet:215] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
        Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
        Posição: 216
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
        Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
        Posição: 216
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:54)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1244)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:212)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1267)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1186)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1081)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5027)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5314)
      	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:657)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
      	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
      	at java.lang.Thread.run(Thread.java:662)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
        Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
        Posição: 216
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:113)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:66)
      	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
      	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:138)
      	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:61)
      	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:142)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:109)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:48)
      	... 20 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
        Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
        Posição: 216
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:181)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:195)
      	at com.liferay.portal.upgrade.UpgradeProcess_6_2_0.doUpgrade(UpgradeProcess_6_2_0.java:66)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
      	... 28 more
      Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
        Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
        Posição: 216
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
      	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
      	at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:269)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:289)
      	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:282)
      	at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:35)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateResourcePermission(UpgradeJournal.java:271)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.updateStructures(UpgradeJournal.java:365)
      	at com.liferay.portal.upgrade.v6_2_0.UpgradeJournal.doUpgrade(UpgradeJournal.java:201)
      	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:178)
      	... 31 more
      Stopping the server due to unexpected startup errors
      

        Attachments

          Activity

            People

            • Assignee:
              mark.jin Mark Jin (Inactive)
              Reporter:
              cleydyr.albuquerque Cleydyr Albuquerque
              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:
                6 years, 8 weeks, 5 days ago

                Packages

                Version Package
                6.2.0 CE M6