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

Convert Legacy Permissions Fails for PostgreSQL

    Details

      Description

      Following exception thrown when attempting to convert from permissions algorithm 5. Note the missing space in "selectpg_sleep"!

      I am currently rerunning a migration from Liferay CE 5.2.3 to 6.1.1 and this is the first step upgrading to 6.0.6. The whole process is scripted and ran without this issue on the test migration which was run in Aug/Sep 2012. As far as I know the only changes from when it worked to when it doesn't is the database content (which I doubt would introduce this problem) and the PostgreSQL version which changed from 9.1.3 to 9.2.2. I'm guessing that Liferay is executing different code this time due to the change in PostgreSQL version?

      23:46:06,444 INFO [Table:371] Starting backup of ResourcePermissionView to D:\WorkArea\SportZman\PortalUpgrade\portals\Interim-6.0.6\tomcat-6.0.29\temp/temp-db-ResourcePermissionView-1357688766444
      23:46:06,466 FATAL [ConvertProcessMessageListener:35] Unable to process message

      {destinationName=liferay/convert_process, responseDestinationName=null, responseId=null, payload=com.liferay.portal.conv ert.ConvertPermissionAlgorithm, values=null}

      com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "selectpg_sleep"
      Position: 1
      at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
      at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
      at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
      at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
      at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "selectpg_sleep"
      Position: 1
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
      at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:383)
      at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:347)
      at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:345)
      at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:158)
      at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:660)
      at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
      ... 7 more

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                6 years, 40 weeks, 6 days ago

                Packages

                Version Package
                6.0.6 GA