Still encountering duplicate left/right categoryId entries when adding asset categories

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X
• Fix Version/s: 7.0.X, 7.1.10 DXP FP23, 7.1.10.6 SP6, 7.1.X, 7.2.10 DXP FP11, 7.2.10.4 DXP SP4, 7.2.X
• Component/s: Categories
• Labels:
  • ee-ts
  • liferay-dxp-71-sp6
  • liferay-dxp-72-sp4
  • liferay-fixpack-dxp-11-7210
  • liferay-fixpack-dxp-23-7110
• Branch Version/s:
  7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3

Steps to Reproduce

1. Start up Liferay connected to a MySQL database
2. Sign in as admin
3. Navigate to Control Panel > Configuration > Server Administration
4. Go to the Script tab
5. Run the following Groovy script:

   import com.liferay.asset.kernel.service.AssetVocabularyLocalServiceUtil;
   import com.liferay.asset.kernel.service.AssetCategoryLocalServiceUtil;
   import com.liferay.portal.kernel.model.GroupConstants
   import com.liferay.portal.kernel.service.GroupLocalServiceUtil
   import com.liferay.portal.kernel.service.ServiceContext;
   import com.liferay.portal.kernel.util.PortalUtil
   import com.liferay.portal.kernel.util.StringUtil
   
   import java.util.concurrent.Executors;
   
   userId = PortalUtil.getUserId(actionRequest);
   companyId = PortalUtil.getCompanyId(actionRequest);
   groupId = GroupLocalServiceUtil.getGroup(companyId, GroupConstants.GUEST).getGroupId()
   
   serviceContext = new ServiceContext()
   
   vocabularyName = "Groovy_TestVocabulary"
   vocabulary = AssetVocabularyLocalServiceUtil.fetchGroupVocabulary(groupId, "Groovy_TestVocabulary")
   
   if (vocabulary == null) {
       vocabulary = AssetVocabularyLocalServiceUtil.addVocabulary(userId, groupId, vocabularyName, serviceContext);
   }
   
   AssetCategoryLocalServiceUtil.addCategory(userId, groupId, "cat-" + StringUtil.randomString(5) + "-" + StringUtil.randomId(5), vocabulary.getVocabularyId(), serviceContext);
   
   category = AssetCategoryLocalServiceUtil.addCategory(userId, groupId, "cat-" + StringUtil.randomString(5) + "-" + StringUtil.randomId(5), vocabulary.getVocabularyId(), serviceContext);
   
   AssetCategoryLocalServiceUtil.addCategory(userId, groupId, "cat-" + StringUtil.randomString(5) + "-" + StringUtil.randomId(5), vocabulary.getVocabularyId(), serviceContext);
   
   // Introduce duplicate left/right category ids to tree
   category.setLeftCategoryId(1);
   category.setRightCategoryId(2);
   
   AssetCategoryLocalServiceUtil.updateAssetCategory(category);
   
   // Add new category - Expected to detect broken tree and rebuild
   AssetCategoryLocalServiceUtil.addCategory(userId, groupId, "cat-" + StringUtil.randomString(5) + "-" + StringUtil.randomId(5), vocabulary.getVocabularyId(), serviceContext);
   

6. Inspect the AssetCategory table in the database
7. Check the various rows in the AssetCategory table, and assert that some rows are showing duplicate leftCategoryId and rightCategoryId as the previous entry.

Actual Behavior
Rows are showing duplicate leftCategoryId and rightCategoryId in multiple rows.

Expected Behavior
Rows should have unique leftCategoryId and rightCategoryIds.