IBM Support

IT29447: CRASH IN SQLPISROSIMPACTLOCK()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 can crash in function sqlpIsRosImpactLock().  This problem
    only occurs on a HADR primary database.
    
    The following is a sample stack dump of the trap:
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00002B8548A77CA6
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0356         (/home/db2eba/sqllib/lib64/libdb2osse.so.1)
    0x00002B8548A778EB ossDumpStackTraceV98 + 0x002b
    (/home/db2eba/sqllib/lib64/libdb2osse.so.1)
    0x00002B8548A73AD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00d7         (/home/db2eba/sqllib/lib64/libdb2osse.so.1)
    0x00002B8540E99187 sqlo_trce + 0x03c7
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85410051DB sqloEDUCodeTrapHandler + 0x03cb
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85395FDC10 address: 0x00002B85395FDC10 ; dladdress:
    0x00002B85395ED000 ; offset in lib: 0x0000000000010C10 ;
    (/lib64/libpthread.so.0)
    0x00002B854112A0C2 _Z19sqlpIsRosImpactLockPK8SQLP_LRB + 0x0002
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B854137D3C4
    _Z15sqlpUpgradeLockP9sqeBsuEduP14SQLP_LOCK_INFO + 0x0ce4
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B853BEDF1ED _Z17sqldEscalateLocksP8sqeAgenti + 0x11fd
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B853BC72F5F
    _Z13sqldLockTableP8sqeAgentP14SQLP_LOCK_INFOjti + 0x041f
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B853BC6F480
    _Z19sqldLockTableFixTCBP8sqeAgenttthmiiimmiPciS1_iP14SQLP_LOCK_I
    NFOPP8SQLD_TCBjj + 0x01c0
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B853BD1E814
    _Z22sqldLockTableForInxBldP8sqeAgentP17SQLD_CREATEINX_CBPjtPP8SQ
    LD_TCB + 0x0464         (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B853BD2007E
    _Z20sqldBeginIndexCreateP8sqeAgentP17SQLD_CREATEINX_CB + 0x046e
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B8541F33905
    _Z24sqlrlRecreateIndexObjectP8sqlrr_cbP8sqlrg_idP17SQLD_CREATEIN
    X_CBjtmP25sqlyk_keyXform_threadListP23SqlthJobProgressMonitor +
    0x0065         (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B8541F31798
    _Z20sqlrlRecreateIndexesP8sqlrr_cbttP8sqlrg_idiPhiS3_ijPshP8Sqlt
    hJobtP9SQLP_LSN8tP14SQLP_LOCK_INFOS3_ + 0x05a8
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B854248D070
    _Z24sqluRecreateIndexObjectsP13SQLUCACB_TYPEP8sqeAgentb + 0x0400
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B854248F4F5
    _Z23squInitInxObjForRebuildP13SQLUCACB_TYPEP18SQU_EDU_ESSENTIALS
    + 0x01e5         (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85424834B9 address: 0x00002B85424834B9 ; dladdress:
    0x00002B8539B8F000 ; offset in lib: 0x00000000088F44B9 ;
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85424816BC
    _Z15squBuildIndexesP13SQLULACB_TYPEP13SQLUCACB_TYPEP18SQU_EDU_ES
    SENTIALSihP17SQLU_FUNCPTR_LIST + 0x0acc
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85424D97A7 _ZN11sqluCRidder4iRunEv + 0x0bd7
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85424E5173 _Z17sqluLoadEDUDriverPhj + 0x0743
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85410026BA sqloEDUEntry + 0x057a
    (/home/db2eba/sqllib/lib64/libdb2e.so.1)
    0x00002B85395F5724 address: 0x00002B85395F5724 ; dladdress:
    0x00002B85395ED000 ; offset in lib: 0x0000000000008724 ;
    (/lib64/libpthread.so.0)
    0x00002B8549BF4E8D clone + 0x006d         (/lib64/libc.so.6)
    </StackTrace>
    

Local fix

  • Disable HADR feature.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 v11.1 Mod 5 Fixpack 5 or Later.               *
    ****************************************************************
    

Problem conclusion

  • First Fixed in Db2 v11.1 Mod 5 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29447

  • 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

    2019-06-14

  • Closed date

    2019-10-20

  • Last modified date

    2019-10-20

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 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:
02 September 2021