1091 views

Description

SCStaleCacheListener listens to inserts/updates/deletes on the tables listed below. This affects user_items_cache and user_categories_cache for every domain in the system, potentially causing sys_cache_flush to have millions of records and stalling upgrades.

- sys_user
- sys_user_role
- sys_user_has_role

Steps to Reproduce

 

The defect affects instances that use User Criteria to control access to the items and categories in the Service Catalog within a domain-separated environment. The defect may cause very long upgrades and severe performance degradation. Any update to a record in the sys_user, sys_user_has_roles, or sys_user_grmember table will trigger the USER_CATEGORIES_CACHE cache flush. When enough of these triggers in quick succession, the system is unable to process the cache rebuild, slowing down the system and leading to unresponsive behavior. This impact grows by a factor based on the number of domains.

The defect occurs under the following scenarios:

  • Upgrade issue when com.glide.role_management.inh_count is not enabled and then com.glide.role_management adds multiple entries to the sys_user_has_role table. This can happen if a plugin upgrade adds a role or roles to other role or roles that are assigned to a large number of users.
  • Plugin activation com.glide.role_management.inh_count can run into this issue.
  • When a user adds a role or roles to another role or roles that are assigned to a large number of users.
  • LDAP imports to update users or user roles can be affected by this issue.

 

Workaround

If you are not using User Criteria, turn off glide.sc.use_user_criteria by setting it to false.

This property can be accessed directly via https://<instance_name>.service-now.com/sys_properties_list.do?sysparm_query=name%3Dglide.sc.use_user_criteria

Note: We do not recommend this workaround if you are using User Criteria for Service Catalog security. Upgrade to a fixed version listed in the Fixed In section below.

If the instance is migrating from Eureka and uses entitlements, the issue does not occur because the property is set to false during the upgrade.


Related Problem: PRB668555

Seen In

Fuji Patch 10
Fuji Patch 11
Fuji Patch 12 Hot Fix 1
Geneva Patch 3 Hot Fix 2
Geneva Patch 4
Geneva Patch 5
Geneva Patch 6
Geneva Patch 7

Fixed In

Fuji Patch 13 Hot Fix 1
Geneva Patch 6 Hot Fix 2
Geneva Patch 7
Helsinki Patch 0 Hot Fix 2
Helsinki Patch 1
Istanbul

Safe Harbor Statement

This "Planned Fixed In" information is intended to outline ServiceNow's general product direction and should not be included in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-08-01 08:53:27
Published:2016-05-12