IT37005: DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT

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

APAR status

• Closed as program error.

Error description

• SQL statements issued may trap and bring the instance
  down with FODC generation.
  
  This type of db2 crash will show below generic messages in
  db2diag.log :
  
  
  2021-03-25-17.35.25.990209+480 I13360299A1267 LEVEL: Error
  PID : 19464234 TID : 61998 PROC : db2sysc 0
  INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
  APPHDL : 0-59952 APPID: X.X.X.X.0000.210325093641
  AUTHID : AUTHUSER HOSTNAME: HOST1
  EDUID : 61998 EDUNAME: db2agent (SAMPLE) 0
  FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
  probe:8
  MESSAGE : Error in agent servicing application with
  AUTHORIZATION ID:
  DATA #1 : Hexdump, 129 bytes
  0x0A000100623E92D1 : 5441 5F4D 4F4E 2020 0000 0000 0000 0000
  AUTHUSER ........
  ? .
  
  
  2021-03-25-17.35.44.938383+480 E13453350A1282 LEVEL: Severe
  PID : 19464234 TID : 61998 PROC : db2sysc 0
  INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
  APPHDL : 0-59952 APPID: X.X.X.X.0000.210325093641
  AUTHID : AUTHUSER HOSTNAME: HOST1
  EDUID : 61998 EDUNAME: db2agent (SAMPLE) 0
  FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
  probe:90
  MESSAGE : ADM14011C A critical failure has caused the following
  type of error:
  "Trap". The DB2 database manager cannot recover from the
  failure.
  First Occurrence Data Capture (FODC) was invoked in the
  following
  mode: "Automatic". FODC diagnostic information is located in the
  following directory:
  "/db2dump/db2inst1/dump/FODC_Trap_2021-03-25-17.35.25.620651_000
  0/".
  DATA #1 : Signal Number Recieved, 4 bytes
  11
  
  
  
  Checking the trap file for this PID.TID trap file -
  19464234.61998.000.trap.txt for thread 61998 will show below
  stack with top frame in sqlra_check_each_privs:
  
  -------Frame------ ------Function + Offset------
  0x090000001168CB6C
  sqlra_check_each_privs__FP8sqlrr_cbP16sqlra_cached_variP19sqlra_
  list_req_privP10sqlr_rolesbPb + 0xFB4
  0x09000000114A29C4
  sqlra_check_privs__FP8sqlrr_cbP16sqlra_cached_variP19sqlra_list_
  req_privP10sqlr_rolesbPb + 0x65C
  0x090000000F314454
  sqlra_check_stmt_privs__FP8sqlrr_cbiP19sqlra_list_req_privP16sql
  ra_cached_varbPb + 0x350
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1 FP7 or later                                 *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1 FP7 or later
  

Temporary fix

Comments

APAR Information

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

  IT36883

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

  IT38355

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP