If User Criteria is enabled on instances with a very large number of users, the secondary nodes are unusable if there are very large imports on the user table (such as daily LDAP imports).
Steps to Reproduce
On an instance with a very large sys_user and domains:
- Enable User Criteria.
- Run an LDAP import, or update all users (~500,000).
This creates a huge amount of sys_cache_flush data for criteria_cache and user_criteria_cache. When this is picked up by the secondary nodes, they become unavailable and eventually run out of memory.
Upgrade to Istanbul or later product versions.
Disable the User Criteria system property glide.sc.use_user_criteria (set to false /nav_to.do?uri=sys_properties.do?sys_id=f3d65982c3202100c8b837659bba8fe3) to avoid creating criteria_cache and user_criteria_cache in the Cache Flushes table when the LDAP import updates the User table.
Related Problem: PRB648805