calendar failed to upgrade due to SQLIntegrityConstraintViolationException

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X EE, Master
• Fix Version/s: 7.0.0 DXP FP22, 7.0.0 DXP SP4, 7.0.X EE, 7.0.4 CE GA5, 7.1.X, Master
• Component/s: Calendar > Upgrade
• Labels:
  • QA-AUTOMATION
  • backend_test
  • ee-ts
  • fw_code_review
  • fw_test_integration
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-22-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.5
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/49834

Steps to reproduce

1. Add a role in 6012.
   #Add a calendar portlet in page on 6012.
2. 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)
   
3. 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'.

4. 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)