IBM Support

IV88370: LARGE REFERENCE SET BULK LOADS CAN SOMETIMES CAUSE QRADAR USER INTERFACE OUTAGES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • It has sometimes been observed, when perfoming a large bulk
    load of reference sets into QRadar, that the User Interface can
    become inaccessible.  In these specific instances, a
    Transaction Sentry (TxSentry) occurs during the lenghty bulk
    load process and the load of reference sets does not complete
    successfully.
    
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    
    [hostcontext.hostcontext]
    [7b7f64c0-8e4d-4bba-b805-b42a9861ae3e/SequentialEventDispatcher]
    com.q1labs.hostcontext.tx.TxSentry: [WARN]
    [NOT:0000004000][127.0.0.1/- -] [-/- -]    TX on host
    127.0.0.1: pid=31603 age=632 IP=127.0.0.1 port=40137 locks=19
    query=' update reference_data set current_count = $1 where name
    = $2'
    [hostcontext.hostcontext]
    [7b7f64c0-8e4d-4bba-b805-b42a9861ae3e/SequentialEventDispatcher]
    com.q1labs.hostcontext.tx.TxSentry: [WARN]
    [NOT:0000004000][127.0.0.1/- -] [-/- -]    Lock acquired on
    host 127.0.0.1:rel=reference_data_element_ndx1 age=632
    granted=t mode=AccessShareLockquery=' update reference_data set
    current_count = $1 wher'
    [hostcontext.hostcontext]
    [7b7f64c0-8e4d-4bba-b805-b42a9861ae3e/SequentialEventDispatcher]
    com.q1labs.hostcontext.tx.TxSentry: [WARN]
    [NOT:0000004000][127.0.0.1/- -] [-/- -]    Lock acquired on
    host 127.0.0.1:rel=public_reference_data_element_activity
    age=632 granted=tmode=RowExclusiveLock query=' update
    reference_data set current_count =$1 wher'
    

Local fix

  • Perform and Reference Set loads in smaller quantities (<50k
    elements at once).
    

Problem summary

  • This issue was resolved with QRadar/QRM/QVM/QRIF 7.2.8
    

Problem conclusion

  • This issue was resolved with QRadar/QRM/QVM/QRIF 7.2.8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV88370

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    724

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-19

  • Closed date

    2016-09-28

  • Last modified date

    2016-09-28

  • 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

  • R728 PSY

       UP

[{"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":"724","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
28 September 2016