IBM Support

IT36532: DB2 MAY CRASH IN A RARE TIMING WHEN RUNNING FEDERATED QUERIES WITH FENCED WRAPPER AND USER MAPPING PLUGIN IS ENABLED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as requirement.

Error description

  • Db2 instance may crash with Corrupt pool free tree node error
    after stored procedure termination when running federated query
    with fenced wrapper and user mapping plugin is enabled.
    
    The stack can be different, but the corrupted pool free tree
    node is in APM pool.
    
    User mapping plug-in allows user to access external user mapping
    repositories instead of using CREATE USER MAPPING DDLs.
    
    To enable it, user needs to create fsumplugin_file.cfg file and
    fsumplugin_file module on sqllib/function directory. For details
    refer External user mapping repositories section in Db2
    knowledge center.
    
    .
    
    Related db2diag.log messages:
    
    .
    
    2021-01-15-12.36.45.084599-300 I2324512E676          LEVEL:
    Severe
    
    PID     : 28490                TID : 46968982202112  PROC :
    db2sysc 1
    
    INSTANCE: xxxx       NODE : 001            DB   : TEST
    
    APPHDL  : 1-11343              APPID: xxxx
    
    UOWID   : xxx                   ACTID: 8
    
    AUTHID  : xxxxx    HOSTNAME: xxxxxx
    
    EDUID   : 70851                EDUNAME: db2agntp (xxxxx) 1
    
    FUNCTION: DB2 UDB, routine_infrastructure,
    sqlerFedInvokeFencedRoutine, probe:200
    
    RETCODE : ZRC=0xFFFFFB95=-1131
    
              SQL1131N  A stored procedure process has been
    terminated abnormally.
    
              Routine name: "". Specific name: "".
    
    .
    
    2021-01-15-12.36.45.302362-300 E2326207E2006         LEVEL:
    Severe
    
    PID     : 28490                TID : 46968827012864  PROC :
    db2sysc 1
    
    INSTANCE: xxxxx                NODE : 001            DB   :
    xxxxx
    
    APPHDL  : 4-55196              APPID: xxxxxx
    
    AUTHID  : xxxxx                 HOSTNAME: xxxxxxx
    
    EDUID   : 62634                EDUNAME: db2agntp (xxxxx) 1
    
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    
    MESSAGE : Memory validation failure, diagnostic file dumped.
    
    DATA #1 : String, 28 bytes
    
    Corrupt pool free tree node.
    
    DATA #2 : File name, 40 bytes
    
    28490.46968827012864.mem_diagnostics.txt
    
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    
      [0] 0x00002AAAB28BC4E5
    _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb +
    0x285
    
      [1] 0x00002AAAB28B75F8
    _ZN13SQLO_MEM_POOL10MemTreeGetEmmPP17SqloChunkSubgroupPj + 0x188
    
      [2] 0x00002AAAB28BC69C
    _ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmjmPP17SqloChunkSubgrou
    pPjP12SMemLogEvent + 0x6C
    
      [3] 0x00002AAAB28999A0 sqloGetMemoryBlockExtended + 0xFF0
    
      [4] .....
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT36532

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED REQ

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-04-12

  • Closed date

    2022-04-18

  • Last modified date

    2022-04-18

  • 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

[{"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:
03 May 2022