Instance delete operation is not deleting the instance data on all database tables

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.2.X, 7.3.10.3 DXP SP3, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Core Infrastructure
• Labels:
  • ee-ts
  • liferay-dxp-73-sp3
  • pt-app-security-review
• Branch Version/s:
  7.3.x, 7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/108018

Database wrong references

Steps to reproduce

1. Go to Control Panel => Virtual instances
2. Create a new instance
3. Get the companyId from the created instance
4. Once the instance is completely created, delete it
5. Execute this SQL:

   select * from AccountGroup where companyId = <companyId>
   

   • Expected result: the SQL doesn't return any record
   • Wrong result: the SQL returns some records
6. To get the list of all affected tables, use theattached get_tables_with_invalid_records.groovy groovy script: set the companyId value in the second "long wrongValue" line of the script and execute it from server administration.
   • Expected result: the script doesn't return any table
   • Wrong result: the script return following tables

Database tables with wrong records from deleted instance:

AccountGroup
DLStorageQuota
DispatchTrigger
OAuth2Application
OAuth2ApplicationScopeAliases
OAuth2ScopeGrant
PortalPreferences