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

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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