IBM Support

Qradar 7.3.3 Fix Pack 4 Patch Fails During PSQL Tests

Troubleshooting


Problem

During the patch, pretest fails with psql error, "There are unfinished transactions remaining".

Symptom

The update will fail to complete with:

[ERROR](-i-testmode) sql pretest errored, halting.[6/9] Install & Upgrade Packages  failed to complete successfully.

In /var/log/setup-(..)/patches.log, you will see:

[6/9] Install & Upgrade Packages  installing produced:

There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.

 [INFO](-i-testmode) Set <hostname> status to 'Patch Test Failed'

[ERROR](-i-testmode) Patching can not continue

Cause

The upgrade's pretest may find one or more unfinished transactions that need to be cleaned up.

Resolving The Problem

You can resolve the issue by running this command:
yum-complete-transaction --cleanup-only
The unfinished transactions are cleaned up, and the patch can be re-run.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"ARM Category":[{"code":"a8m0z000000cwszAAA","label":"Install"}],"ARM Case Number":"TS004349601","Platform":[{"code":"PF016","label":"Linux"}],"Version":"7.3.3"}]

Document Information

Modified date:
23 November 2020

UID

ibm16348760