IBM Support

IT34465: DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Db2 instance may hit SIGSEGV (signal 11) with following
    stacktrace:
    
    
    <Header>
    DB2 build information: DB2 v11.1.4.4 special_38396 SQL11014
    timestamp: 1601620491.106298000
    timezone : 36000
    convert : echo `perl -MPOSIX -le 'print strftime
    "%Y-%m-%d-%H.%M.%S",gmtime(1601656491)'`.106298000 +1000
    instance name: db2inst1.000
    EDU name : db2agent (SAMPLE) 0 [-]
    EDU ID : 75821
    Signal #11
    uname: S:AIX R:1 V:7 M:00FA46304C00 N:dj2102p-dbsa001
    process id: 50397756
    parent process id: 63439304
    thread id : 75821 (0x1282D)
    kthread id : 132383423
    </Header>
    <SignalDetails>
    <Siginfo_t length="64">
    0000000B 00000000 00000032 00000000
    00000000 00000000 0A00031D 30000000
    00000000 00000000 00000000 00000000
    00000000 00000000 00000000 00000000
    </Siginfo_t>
    Signal #11 (SIGSEGV): si_addr is 0x0A00031D30000000, si_code is
    0x00000032 (SEGV_MAPERR:Address not mapped to object.)
    </SignalDetails>
    
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000002C86C0C8 sqlnls_CharWidth2 + 0x3C8
    0x090000004175C4DC sqlnpMaskPassword__FCPcCPUlCUiCb + 0x1DC
    0x09000000429519F0
    gen_dlconn_events__15sqm_dlconn_listFPC8sqeAgentP8SQLP_LRB +
    0x1210
    0x090000004114E4B4
    sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL
    P_LTRN_CHAINCbN25 + 0x22B4
    0x090000004806520C
    sqlplMakeNewRequestNonSD__FP9sqeBsuEduP14SQLP_LOCK_INFOP11SQLP_T
    ENTRYP8SQLP_LRBT4P15SQLP_LTRN_CHAINbT7Cb + 0x1AAC
    0x0900000041473870
    sqlpUpgradeLock__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x1870
    0x09000000420BC554 sqldEscalateLocks__FP8sqeAgenti + 0xD54
    0x0900000041ABECB8
    sqldLockTable__FP8sqeAgentP14SQLP_LOCK_INFOUiUsi + 0xF78
    0x090000004210402C
    sqldScanOpen__FP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv +
    0x5EC
    0x090000004374F9C4 sqlriopn__FP8sqlrr_cbP9sqlri_taoPi + 0xD84
    0x09000000474B57E0 sqlriNljnNonPiped__FP8sqlrr_cb + 0x3E0
    0x0900000043B3B95C
    sqlriExecThreadFunc__FP8sqlrr_cbP12sqlri_opparmPl + 0x5C
    0x0900000043B3B268 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x648
    0x0900000042BB15C4 sqlrr_process_execute_request__FP8sqlrr_cbib
    + 0x3624
    0x0900000042B4B720 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
    + 0x4A0
    0x090000004527926C executeSection__10pvmPackageFP5sqlcaUib +
    0x98C
    0x0900000045274228 executeQuery__3PVMFUib + 0x208
    0x0900000045280EE0 run__3PVMFv + 0xFE0
    0x090000004526CB5C pvm_entry + 0x45C
    0x0900000040A8CA8C sqloInvokeFnArgs + 0x5D6C
    0x0900000044439718
    IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt
    fb + 0x2AF8
    0x090000004442F468 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x2008
    0x0900000044430370 sqlricall__FP8sqlrr_cb + 0x670
    0x0900000043B3B238 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x618
    0x0900000042BB15C4 sqlrr_process_execute_request__FP8sqlrr_cbib
    + 0x3624
    0x0900000042B4B720 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
    + 0x4A0
    0x0900000047F766BC
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5BC
    0x0900000047EF2CE0
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x280
    0x0900000047EF5D64
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2264
    0x0900000047EC0F3C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
    0x0900000047EC9654
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x0900000047EBEFF0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
    0x0900000047EBC434 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x334
    0x0900000040BE49A0 RunEDU__8sqeAgentFv + 0xB60
    0x0900000040BBEBC0 EDUDriver__9sqzEDUObjFv + 0x300
    0x0900000040AA0200 sqloEDUEntry + 0x360
    </StackTrace>
    
    This is due to a db2 deadlock event monitor capturing a static
    sql statement which contains sensitive information (e.g.
    passwords) which must be masked. The error may occur if the
    large value is being masked.
    

Local fix

  • Disable any db2 deadlock event monitors.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 users prior to Db2 v11.1 m4 fp7                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade Db2 LUW to Db2 v11.1 m4 fp7.                  *
    ****************************************************************
    

Problem conclusion

  • The problem will be fixed in Db2 v11.1 m4 fp7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34465

  • 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-10-06

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT34510

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       UP

  • RB50 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022