IBM Support

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

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

  • 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

[{"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