Notifications

512 views

Description

Starting with the Helsinki release, the sys_domain and sys_domain_path fields were added to the Discovery Log [discovery_log] and TCP Connection [cmdb_tcp] tables. Upgrades of instances that have large numbers of rows in these table can lead to performance issues when the upgrade process adds and populates the new fields.

This issue is fixed in the Jakarta release by adding the sys_domain and sys_domain_path fields when the Domain Support - Domain Extensions Installer plugin is activated, after the upgrade process is finished.

Steps to Reproduce

 

  1. Do a huge discovery or add a large number of rows to the Discovery Log [discovery_log] or TCP Connection [cmdb_tcp] table (20 million rows or so).

  2. Upgrade to Helsinki or Istanbul.

    Note that the upgrade takes a long time because of the addition of the new fields on the table with the large number of records.

 

 

Workaround

Make sure before the upgrade that the Discovery Log [discovery_log] and TCP Connection [cmdb_tcp] tables are relatively small (less than 1 million rows) or truncate the tables.

IMPORTANT: After you remove records from the TCP Connection [cmdb_tcp] table, be sure to run any required Discoveries after the upgrade to repopulate the table.


Related Problem: PRB755422

Seen In

There is no data to report.

Fixed In

Helsinki Patch 10
Istanbul Patch 5
Jakarta

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-12 05:21:52
Published:2017-02-02