Convert Legacy Permissions Fails for PostgreSQL

• Type: Bug
• Status: Closed
• Resolution: Won't Fix
• Affects Version/s: 6.0.6 GA
• Fix Version/s: 6.0.6 GA
• Component/s: Environments > Databases, User Management > Roles
• Labels:
  • permissions
• Environment: Standard Tomcat Bundle

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