We now have the delete_deleted_job that causing a lot failmail and db deadlock, and it might related with the cache refresh mode been set to opportunistic, which might get triggered every time we delete a contact, so here is the proposed solution:
1: update the setting [smart_group_cache_refresh_mode] => opportunistic
2: (with that we would also need a cron possibly to flush smart group cache from time to time)
3: turn back the delete_deleted_job with smaller patch size and less frequent
Description
Description
Related Objects
Related Objects
- Mentioned Here
- T321253: Address speed for `delete_deleted_contacts`
Event Timeline
Comment Actions
To see the Settings fields for this value you can run cv api4 Setting.getFields '{"where":[["name","=","smart_group_cache_refresh_mode"]]}' or you could use the API Explorer
Comment Actions
Looks like this is all set. smart_group_cache_refresh_mode is currently set to 'opportunistic', and the delete_deleted_contacts job is running without deadlocking everywhere