DB2 - Problem description
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) |