IBM Support

IT32586: ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The problem is difficult to reproduce. The function which
    trapped was sqloGetTIDFromEDUID() and the leading trigger was a
    call to table function env_get_db2_edu_system_resources()
    
    In the db2diag.log we see:
    
    
    EDUID   : 20511                EDUNAME: db2agent (dbname) 0
    FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
    probe:30
    MESSAGE : ADM14005E  The following error occurred: "AppErr".
    First Occurrence
              Data Capture (FODC) has been invoked in the following
    mode:
              "Automatic".  Diagnostic information has been recorded
    in the
              directory named
    
    "/db2/path/db2dump/FODC_AppErr_2020-03-03-09.36.38.022000_20054_
    20511_
              000/".
    
    
    
    EDUID   : 20511                EDUNAME: db2agent (dbname) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
    probe:1
    MESSAGE : Error in agent servicing application with coor_node:
    DATA #1 : Hexdump, 2 bytes
    0x00007DBAA700F822 : 0000
    
    The stack trace shows Trap in sqloGetTIDFromEDUID :
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007F5A49A16F85
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0385
                    (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
    0x00007F5A49A16B8C ossDumpStackTraceV98 + 0x002c
                    (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
    0x00007F5A49A12C2D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00fd
                    (/db2/db2pjr/sqllib/lib64/libdb2osse.so.1)
    0x00007F5A500D1114 sqlo_trce + 0x0404
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A5015B299 sqloEDUCodeTrapHandler + 0x02b9
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x0000003D6CC0F7E0 address: 0x0000003D6CC0F7E0 ; dladdress:
    0x0000003D6CC00000 ; offset in lib: 0x000000000000F7E0 ;
                    (/lib64/libpthread.so.0)
    0x00007F5A4E01A75E sqloGetTIDFromEDUID + 0x005e
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A4E07FFDC sqloGetCPUUsage + 0x020c
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A504D043F
    _Z50sqlrwGatherEnvDB2EduSystemInformationForThisMemberP8sqeAgent
    PPcPl + 0x031f
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A50439844
    _Z30sqlrkGetWLMTableFunctionResultP8sqeAgentP20sqlrw_rpc_tf_requ
    estPPvPl + 0x0184
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A4E32EE41 _Z36sqlrwGetWLMTableFunctionMergedResultjPPv
    + 0x0661
                    (/db2/db2pjr/sqllib/lib64/libdb2e.so.1)
    0x00007F5A4D304B7C _Z29sqlerTrustedRtnCallbackRouterjPPv +
    0x00bc
    .
    .
    </StackTrace>
    

Local fix

  • Avoid a call to table function ENV_GET_DB2_EDU_SYSTEM_RESOURCES
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32586

  • 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-04-17

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

    IT32507

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

    424AC6Ÿ

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       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