IBM Support

Qradar 7.3.3 Fix Pack 4 Patch Fails During PSQL Tests



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


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


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


[{"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