Notifications

279 views

Description

Current indexes on [sys_schema_change] does not seem to be able to handle a large number of records, and can cause page to not load

Steps to Reproduce

  1. Get [sys_schema_change] table to be large, mil+ for good measure
  2. Upgrade an instance so that the upgrad monitor page has stats from the upgrade to display
  3. Nav to upgrade monitor $upgrade_client.do

    Page takes several minutes to load or can have the maximum execution time exceeded and not load.

Workaround

Add the following index to speed things up: sys_schema_change(started, finished, duration)


Related Problem: PRB1255465

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-12-04 12:44:34
Published:2019-04-01