Hi all.
I'm preparing to upgrade liferay 6.1 to 6.2. Pretty much got everything sorted out, except for the permissions. I added the v5 check in portal-ext.properties, and went to Server Administration --> Data Migration, and executed the permissions conversion.
It goes through the process, and then I hit this error, and the process stops:
18:38:52,641 DEBUG [liferay/convert_process-1][MaintenanceUtil:64] Updating ResourcePermission table
18:38:52,694 FATAL [liferay/convert_process-1][ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertPermissionAlgorithm, values={principalPassword=xxxxxxx, principalName=10169, companyId=10132}}
com.liferay.portal.convert.ConvertException: java.sql.BatchUpdateException: Duplicate entry '10132-58-4-10455_LAYOUT_58-10144' for key 2
It looks like I have a duplicate key. So, I did the following SQL:
mysql> select * from ResourcePermission where primKey LIKE '%10455_LAYOUT_58%';
+----------------------+-----------+------+-------+-----------------+--------+-----------+---------+
| resourcePermissionId | companyId | name | scope | primKey | roleId | actionIds | ownerId |
+----------------------+-----------+------+-------+-----------------+--------+-----------+---------+
| 334 | 10132 | 58 | 4 | 10455_LAYOUT_58 | 10139 | 1 | NULL |
| 332 | 10132 | 58 | 4 | 10455_LAYOUT_58 | 10140 | 7 | NULL |
| 333 | 10132 | 58 | 4 | 10455_LAYOUT_58 | 10144 | 1 | NULL |
+----------------------+-----------+------+-------+-----------------+--------+-----------+---------+
3 rows in set (0.01 sec)
But I don't see any duplicate entries? They each have a different PermissionId. Can someone give me a hand to identify the problem? Is it safe to delete these entries?
Since I have a backup, I went ahead and deleted the entries. But, it found another set. I have no idea how many dupes I have? Anyone care to guide me to be the best appropriate step?
mysql> select * from ResourcePermission where primKey LIKE '%10455_LAYOUT_1_WAR_chatportlet%';
+----------------------+-----------+-------------------+-------+--------------------------------+--------+-----------+---------+
| resourcePermissionId | companyId | name | scope | primKey | roleId | actionIds | ownerId |
+----------------------+-----------+-------------------+-------+--------------------------------+--------+-----------+---------+
| 1231 | 10132 | 1_WAR_chatportlet | 4 | 10455_LAYOUT_1_WAR_chatportlet | 10139 | 1 | NULL |
| 1229 | 10132 | 1_WAR_chatportlet | 4 | 10455_LAYOUT_1_WAR_chatportlet | 10140 | 7 | NULL |
| 1230 | 10132 | 1_WAR_chatportlet | 4 | 10455_LAYOUT_1_WAR_chatportlet | 10144 | 1 | NULL |
+----------------------+-----------+-------------------+-------+--------------------------------+--------+-----------+---------+
So, in an effort to figure out all these dupes, I wrote the following SQL:
select * from ResourcePermission inner join (select primKey from ResourcePermission group by primKey having count(resourcePermissionId) > 1) dup on ResourcePermission.primKey = dup.primKey;
I have almost 5000 records that are duplicate primKey (14,833 records returned). This site does have 2 instances associated with it. Could that be the problem? If so, how can I fix it?
