Summary for Patch 787 rev2 (Verified)

Summary Speed and cleanup of database processes
Platform Unix
Category bugfix
Valid for 5.5.2.1, 6.0.x, 6.1.x
Requires 5.5.2.1 - 6.0.2.7: 762, 5.5.2.1 - 6.0.1.0: 696
Client Required Patch/es
Supersedes 761, 619, 561
Superseded by
Affects Server: Core
Last Updated February 10, 2014

Download now

Download_red patch787-2.tar.gz

Description

* This patch is replacing patch 763, which had serious performance
problems.

* It prevents the same issue, by preventing duplication of 'add' and 'check_and_split_data'
processes. This will avoid corruptions of the
database in some cases.

* Cleanup of database after crash or a similar situation.

The cleanup script is found under /opt/openit/contrib/bin/db_clean_structure.pl.

It can be activated to run regularly by making a file:

/var/opt/openit/etc/database_test_active

It will then run whenever the database is being updated by aggregation.

It can be run manually, and then it has to run as the "openit" user.

Revision 2 is for fixing a dependency problem with patch 782.

Supersedes Patch Description

Expand all

Patch 761 — Functionality for removing entries from WebGUI list
Supports removal of massive lists of classification values
in the WebGUI, to speed up processing and to make the
list easier to handle.

To activate it, set, in /etc/opt/openit/openit.cfg:

CLASSVAR_REGEXP_FILTER   $CONFIG/classvar_regexp_filter

Make the file, and enter into it:

<data type name>:<classification name>:<regexp>

for each data type / classification wanted.

When the regexp matches, the entry will be removed from
the classification list in the WebGUI.

Rev 2: Added requirement for patch 723.
Patch 619 — Handling of illegal olap time stamps in check_and_split_data
check_and_split_data used to abort processing when encountering an olap file with illegal time
stamp. This has been fixed so that it will rename file to *.inconsistent and proceed with next file.

Revision 3: Added Perl modules for compatibility with older versions of Open iT.

Revision 4: Supersedes 561.
Patch 561 — Fix for check_and_split_data
* Processing in chunks, avoiding multiple check_and_split_data processes.
* Handling of start/end time of days with DST changes.

Installation

Unpack tar file in e.g /tmp/patch on the Open iT host. Do the following as root:

	cd /tmp/patch
	./patch.pl

Corresponding Windows Patches

No corresponding Patches available.



Back to Version List