IBM Support

IJ03981: QRADAR UPGRADE AND/OR PATCH FAILS WITH 'ERROR EXECUTING 34-POSTGRESQL-UPGRADE.SH' WHEN UNEXPECTED DATABASE EXIST

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • It has been identified that during the upgrade and/or patching
    process to QRadar 7.3.1.x, if any unexpected databases exist on
    the system (eg. A non-qradar test database), a required
    database patch/upgrade script fails with a message in the
    qradar_setup.upgrade_pre_reboot.log similar to:
    <day-date-time> OK: PG service postgresql-qf is not currently
    running and was not running previously.
    Error executing 34-postgresql-upgrade.sh.  See
    /var/log/setup-7.3.1.201xxxxxxxxxxx/qradar_setup.log for more
    details.
    ERROR: The upgrade phase script 34-postgresql-upgrade.sh failed.
    See /var/log/setup-7.3.1.201xxxxxxxxxxx/qradar_setup.log for
    more details.
    

Local fix

  • Prior to patch/upgrade to 7.3.1.x -
    Verify that there are no manually created databases present on
    the system.  If present, remove them prior to upgrade/patch.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 731 Patch 5.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 731 Patch 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ03981

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    731

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-02-07

  • Closed date

    2018-07-27

  • Last modified date

    2018-07-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    QRADAR SOFTWARE

  • Fixed component ID

    5725QRDSW

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"731","Edition":""}]

Document Information

Modified date:
27 July 2018