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"}]
Was this topic helpful?
Document Information
Modified date:
23 November 2020
UID
ibm16348760