-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: Master
-
Fix Version/s: 7.2.10 DXP FP17, 7.2.10.6 DXP SP6, 7.2.X, 7.3.10.3 DXP SP3, 7.3.X, 7.4.13 DXP GA1, Master
-
Component/s: Core Infrastructure
-
Branch Version/s:7.3.x, 7.2.x
-
Backported to Branch:Committed
-
Fix Priority:3
-
Git Pull Request:
Database wrong references
Steps to reproduce
- Go to Control Panel => Virtual instances
- Create a new instance
- Get the companyId from the created instance
- Once the instance is completely created, delete it
- 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
- Expected result: the SQL doesn't return any record
- 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
- Expected result: the script doesn't return any table
Database tables with wrong records from deleted instance:
AccountGroup DLStorageQuota DispatchTrigger OAuth2Application OAuth2ApplicationScopeAliases OAuth2ScopeGrant PortalPreferences
- relates
-
LPS-140720 Instance delete operation is creating some orphan entries in the SystemEvent table
- Closed