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

ConvertProcess throws ConvertException : org.postgresql.util.PSQLException

    Details

      Description

      Trying to upgrade user checking algo using the control panel functionality; I get the following in the log

      13:28:03,280 INFO  [PortalImpl:3841] 
      13:29:03,387 INFO  [PortalImpl:3829] Current URL /tomcat-log generates exception: null
      13:29:03,388 INFO  [PortalImpl:3841] 
      13:35:46,670 INFO  [PortalImpl:3829] Current URL /tomcat-log generates exception: null
      13:35:46,671 INFO  [PortalImpl:3841] 
      13:36:47,537 INFO  [PortalImpl:3829] Current URL /tomcat-log generates exception: null
      13:36:47,538 INFO  [PortalImpl:3841] 
      09:52:00,913 INFO  [PluginPackageUtil:1109] Reloading repositories
      09:52:00,912 INFO  [PluginPackageUtil:1109] Reloading repositories
      09:52:00,913 INFO  [PluginPackageUtil:1109] Reloading repositories
      Loading file:/home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/webapps/chat-portlet/WEB-INF/classes/portlet.properties
      14:19:10,470 INFO  [PluginPackageUtil:1230] Checking for available updates
      14:19:10,476 INFO  [PluginPackageUtil:1274] Finished checking for available updates in 5 ms
      14:19:47,947 DEBUG [MaintenanceUtil:64] Executing com.liferay.portal.convert.ConvertPermissionAlgorithm
      14:19:48,025 INFO  [ConvertProcess:41] Starting conversion for com.liferay.portal.convert.ConvertPermissionAlgorithm
      14:19:48,726 DEBUG [MaintenanceUtil:64] Processing Groups_Permissions
      14:19:48,730 INFO  [Table:371] Starting backup of Groups_Permissions to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-Groups_Permissions-1342448388730
      14:19:49,521 INFO  [Table:407] Finished backup of Groups_Permissions to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-Groups_Permissions-1342448388730 in 791 ms
      14:19:53,802 DEBUG [MaintenanceUtil:64] Converted roles for Groups_Permissions
      14:19:53,861 DEBUG [MaintenanceUtil:64] Processing OrgGroupPermission
      14:19:53,861 INFO  [Table:371] Starting backup of OrgGroupPermission to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-OrgGroupPermission-1342448393861
      14:19:53,877 INFO  [Table:407] Finished backup of OrgGroupPermission to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-OrgGroupPermission-1342448393861 in 16 ms
      14:19:53,877 DEBUG [MaintenanceUtil:64] Processing Users_Permissions
      14:19:53,878 INFO  [Table:371] Starting backup of Users_Permissions to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-Users_Permissions-1342448393878
      14:19:54,994 INFO  [Table:407] Finished backup of Users_Permissions to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-Users_Permissions-1342448393878 in 1116 ms
      14:19:56,157 DEBUG [MaintenanceUtil:64] Converted guest users to guest roles
      14:20:00,797 DEBUG [MaintenanceUtil:64] Converted roles for Users_Permissions
      14:20:00,947 DEBUG [MaintenanceUtil:64] Converted to RBAC permission
      14:20:00,947 DEBUG [MaintenanceUtil:64] Generating ResourceAction and ResourcePermission data
      14:20:00,948 INFO  [Table:371] Starting backup of ResourceCode to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourceCode-1342448400947
      14:20:00,953 INFO  [Table:407] Finished backup of ResourceCode to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourceCode-1342448400947 in 6 ms
      14:20:01,374 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401374
      14:20:01,432 INFO  [Table:407] Finished backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401374 in 58 ms
      14:20:01,440 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401440
      14:20:01,445 INFO  [Table:407] Finished backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401440 in 5 ms
      14:20:01,452 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401452
      14:20:01,483 INFO  [Table:407] Finished backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401452 in 31 ms
      14:20:01,496 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401496
      14:20:01,497 INFO  [Table:407] Finished backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401496 in 1 ms
      14:20:01,504 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401504
      14:20:01,505 INFO  [Table:407] Finished backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401504 in 1 ms
      14:20:01,513 INFO  [Table:371] Starting backup of ResourcePermissionView to /home/ferrema/liferay-portal-6.0.6/tomcat-6.0.29/temp/temp-db-ResourcePermissionView-1342448401513
      14:20:01,857 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertPermissionAlgorithm, values=null}
      com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
        Position: 363
      	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:662)
      Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
        Position: 363
      	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:344)
      	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, 5 days ago

                Packages

                Version Package
                6.0.6 GA