Details
-
Bug
-
Status: Closed
-
Resolution: Fixed
-
7.0.X EE, Master
-
7.0.x
-
Committed
-
1.5
-
4
Description
Steps to reproduce
- Add a role in 6012.
#Add a calendar portlet in page on 6012. - Click in the "Permissions" button showed below and change the permission of this portlet. (Please be sure to change the permission of owner, user, and the role we just created)
- Execute the following sql:
select * from ResourcePermission where name in ('com.liferay.calendar', 'com.liferay.portlet.calendar')
The name of the records are all in 'com.liferay.portlet.calendar'.
- Upgrade to 6.2 SP18.
After upgraded successfully, there will be 'com.liferay.calendar' related records like the following:288 10136 com.liferay.portlet.calendar 4 10162 10145 0 14 289 10136 com.liferay.portlet.calendar 4 10162 10149 0 0 688 10136 com.liferay.calendar 4 10162 10145 0 6 689 10136 com.liferay.calendar 4 10162 10149 0 2
5. Upgrade to DXP SP1.
Results
After upgraded to dxp sp1, there will be Duplicate entry error as in the description.
Caused by: org.mariadb.jdbc.internal.common.QueryException: Duplicate entry '10112-com.liferay.calendar-4-88857-10120' for key 'IX_8D83D0CE' at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:995) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1050) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1030) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289)