IBM Support

IT32752: HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO AVOID A MEMBER CRASH IN PURESCALE.

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

  • PS member crashed on stack:
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000000F8E3584
    sqlpshrFlushLogBufForOnlineMembers__FP8sqeAgentP19sqlpDbcbLookup
    TableRUlPsUlPv + 0x340
    0x090000000F9532C4
    sqlpGroupOperationDriver__FP8sqeAgentP19sqlpDbcbLookupTablePFP8s
    qeAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT3PvCUi + 0x60C
    0x090000000F8257A0
    executeOperationOnLocalView__15sqlpDbcbsHandleFP9sqeBsuEduPFP8sq
    eAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT2PvCUi + 0x3A0
    
    db2diag:
    =========
    2020-04-27-07.35.21.958712-240 I224852457A533       LEVEL:
    Severe
    PID     : 16973950             TID : 78780          PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006           DB   :
    xxxxxx
    APPHDL  : 6-63885              APPID: 1.2.2.1.1.2
    AUTHID  : db2db2             HOSTNAME: xxxxxxxxx0
    EDUID   : 78780                EDUNAME: db2agent (xxxxxx) 6
    FUNCTION: DB2 UDB, buffer dist serv,
    sqkdBdsBufferTable::getNextReply, probe:20
    RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node
    Recovery"
    
    
    2020-04-27-07.35.21.959692-240 I224853526A514       LEVEL: Error
    PID     : 16973950             TID : 78780          PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006           DB   :
    xxxxxx
    APPHDL  : 6-63885              APPID: 1.2.2.1.1.2
    AUTHID  : db2db2             HOSTNAME: xxxxxxxxx0
    EDUID   : 78780                EDUNAME: db2agent (xxxxxx) 6
    FUNCTION: DB2 UDB, buffer dist serv, sqlkd_rcv_init, probe:30
    RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node
    Recovery"
    
    2020-04-27-07.35.21.960214-240 E224854041A402       LEVEL: Error
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::closeConn,
    probe:25
    DATA #1 : <preformatted>
    Link info: node 5; type 6; state 2; session 1; activated 1
    
    2020-04-27-07.35.23.366726-240 I224854444A8827      LEVEL: Error
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, fast comm manager,
    sqkfTcpServices::identifyUntrustedIncomingEvent, probe:41
    MESSAGE : Error while waiting for connect() completion with node
    5. rc = -2129723367. status = 3; port = 60000
    DATA #1 : Hexdump, 1648 bytes
    0x0780000004FE6FE8 : 0000 0000 0000 0000 0000 0000 0000 0000
    ................
    ..........
    .........
    2020-04-27-07.35.23.375995-240 I224863272A474       LEVEL: Error
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, fast comm manager,
    sqkfSendConduit::HandleConnectLostEvent, probe:10
    MESSAGE : Node link dropped by remote peer:
    DATA #1 : Hexdump, 2 bytes
    0x0A0000000E3FE842 : 0005
    ..
    
    2020-04-27-07.35.23.376309-240 I224863747A479       LEVEL: Error
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, fast comm manager,
    sqkfSendConduit::HandleConnectLostEvent, probe:20
    MESSAGE : Handling conn lost due to event:
    DATA #1 : Hexdump, 8 bytes
    0x0A0000000E3FE9E8 : 0780 0000 04FE 6F80
    ......o.
    
    2020-04-27-07.35.23.376661-240 I224864227A479       LEVEL: Error
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, fast comm manager,
    sqkfSendConduit::HandleConnectLostEvent, probe:30
    MESSAGE : Informing node failure. link state =
    DATA #1 : Hexdump, 4 bytes
    0x0A0000000E3FE844 : 0000 0002
    ....
    
    2020-04-27-07.35.23.376988-240 I224864707A428       LEVEL: Event
    PID     : 16973950             TID : 2057           PROC :
    db2sysc 6
    INSTANCE: db2xxxxs             NODE : 006
    HOSTNAME: xxxxxxxxx0
    EDUID   : 2057                 EDUNAME: db2fcms 6
    FUNCTION: DB2 UDB, base sys utilities, sqleSendNodeFailure,
    probe:6390
    DATA #1 : <preformatted>
    SD: Requested synchronous member failure recovery for member =
    [5] with seq. no = 87
    .....
    ...
    2020-04-27-07.36.19.607769-240 E224897726A824       LEVEL: Error
    PID     : 16973950             TID : 77041          PROC :
    db2sysc 6
    INSTANCE: db2xxxxs              NODE : 006           DB   :
    xxxxxx
    APPHDL  : 6-63891              APPID: 1.2.2.1.1.2
    AUTHID  : ATTNYADM             HOSTNAME: lxdbd2t059
    EDUID   : 77041                EDUNAME: db2agent (xxxxxx) 6
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
    probe:30
    MESSAGE : ADM14005E  The following error occurred: "Trap".
    First Occurrence
              Data Capture (FODC) has been invoked in the following
    mode:
              "Automatic".  Diagnostic information has been recorded
    in the
              directory named
    
    "/home/db2xxxxs/sqllib/db2dump/DIAG0006/FODC_Trap_20xx-xx-xx-07.
    36.19
              .605200_16973950_77041_006/".
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Database recovery                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 6 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32752

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-04

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

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

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

    IT36232

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
16 March 2021