IBM Support

IT31215: UNDER RARE SCENARIOS, AUTHENTICATION WILL HANG DURING A PASSWORDCHECK

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

  • Under rare scenarios, authentication may hang during a password
    check. Future authentication requests will hang.
    
    The Db2 diagnostic log will contain a message similar to the
    following:
    
    2019-11-15-15.56.01.957455-300 I501991E2965          LEVEL:
    Severe
    PID     : 12810                TID : 140116873963264 KTID :
    14316
    PROC    : db2sysc
    INSTANCE: db2inst1             NODE : 000            DB   :
    TESTDB
    APPHDL  : 0-20
    HOSTNAME: hotellnx120
    EDUID   : 29                   EDUNAME: db2agent (TESTDB)
    FUNCTION: DB2 UDB, oper system services,
    sqloAtForkPrepareHandler, probe:100
    DATA #1 : Codepath, 8 bytes
    3:17
    MESSAGE : Cannot invoke fork() within the engine, this thread
    will be suspended
              now for further investigation.
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007F6F93FA23CE pdLog + 0x3E3
      [1] 0x00007F6FB564BFCB sqloAtForkPrepareHandler + 0xA73
      [2] 0x00007F6F8D15C282 __libc_fork + 0x52
      [3] 0x00007F6F93B85673 _Z8sqloForkv + 0x1F
      [4] 0x00007F6FB54798D1
    _Z35sqloSpawnAndWaitForPasswordCheckExePKcS0_i + 0x205
      [5] 0x00007F6FB547AFAB sqlockpw_int2 + 0x298
      [6] 0x00007F6FB25BB3DF _Z19sqlockpw_intWrapperPKcS0_iiS0_ +
    0x74
      [7] 0x00007F6F700D40A5
    _Z26osplugin_validate_passwordPKciS0_iiS0_ijPPv + 0x401
      [8] 0x00007F6F700D4DE4
    _Z25osplugin_validatePasswordPKciS0_iiS0_iS0_iS0_ijPPvPPcPi +
    0x856
      [9] 0x00007F6FB2579809
    _Z25secValidatePasswordPluginPciS_iiS_iS_iS_iPPvji + 0x179
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 systems on all Linux, Unix and Windows platforms at  *
    * service levels Version 11.1 GA  through to Version 11.1 Fix  *
    * Pack 5                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or later.                            *
    ****************************************************************
    

Problem conclusion

  • The complete fix for this problem first appears in Db2 Version
    11.1.4 Fix Pack 6 and the subsequent Fix Packs.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31215

  • 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-12-09

  • 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:

    IT31271

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:
01 April 2021