|
Problem IT37005
|
Status: Closed |
DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem 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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1 FP7 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1 FP7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.1 FP7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.05.2021
23.11.2021
29.03.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
