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:

  1. Enable User Criteria.
  2. 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.


  1. Upgrade to Istanbul or later product versions.

  2. 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

Seen In

Fuji Patch 10
Fuji Patch 12 Hot Fix 1
Fuji Patch 7 Hot Fix 5

Fixed In

Fuji Patch 12
Geneva Patch 4

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-15 18:17:02