0
Completed

Clear changes table when entities not present

Matthew Clark 7 years ago • updated by anonymous 3 years ago 6

I have not performed any operations on my local IdB 4 build, but the adapter is reporting 51909 changes. This is because there are 51909 items in the changes table for the adapter. However, there are no entities present in the Entity table. Relationship should be added between the two tables to clear the changes when the entity no longer exists.

Affected Versions:
Fixed by Version:

Relationship should be added between the two tables to clear the changes when the entity no longer exists.

First test that this is not going to harm performance. If it does, there are other possibilities, such as a job to clear out old changes.

Assigned to Tony.

When higher priority work has been completed, please have a look at this issue.

Using an environment with a large amount of data, try adding the relationship between the Entity and Changes tables such that old changes are removed and test performance.

Thanks.

Care will have to be taken, as the changes in this table could represent deletes to be performed. Should be reassessed once the new mechanism has been decided on IDB-299.

AvV: Please confirm that the adapter being removed deletes the partition.

Confirmed that this partition is cleared.

Confirmed in several regression tests. Closed.