Patch 777 has not been released yet

Summary for Patch 777 (Cancelled)

Version 5.3.0.2

Full summary
Summary Database cleanup
Platform Unix
Category functionality
Requires 696, 591
696, 591, 590, 462 (incl. dependencies)
Client Required Patch/es
Supersedes 772, 619, 763
Superseded by
Affects Server: Core
Last Updated June 13, 2012

Download now

Download_red patch777.tar.gz

Description

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.

Supersedes Patch Description

Expand all

Patch 772 — Database processing
This patch is replacing patch 763, which had serious performance problems.

Revision 3 contains a fix for bugs in the previous revisions. It has not
the recovery / cleanup which revision 1 had. Instead 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.

The cleanup of a corrupt database will be made available as a script.

Revision 4 is for better performance when processing data-*-*-*.temp files
in propagate data types.
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 763 — Some cleanup in database back-end
This patch has added functionality for cleaning up in the database.

Sometimes the database has been inconsistent due to various error situations.

* Link which points to a directory where there is no file
* Data file missing where the back-end would expect to find a file during aggregation

These two issues have been fixed.

Revision 2: Recover old data when temp file is present. "add" will also run in only one process. If
another process is started, it will trigger another loop of "add" and exit.

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 5.3.0.2