DB2 - Problem description
Problem IT37037 | Status: Closed |
DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
db2loggr may trap and SIGSEGV due to overshoot bufferSize memory . Error reported in db2diag.log is as following: 2019-10-01-01.08.31.858661+480 E8460A1216 LEVEL:Severe PID : 25100372 TID : 42455 PROC : db2sysc 1 INSTANCE: db2inst2 NODE : 001 DB : sample HOSTNAME: host1 EDUID : 42455 EDUNAME: db2loggr (SAMPLE) 1 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: "/home/db2inst2/sqllib/db2dump/DIAG0001/FODC_Trap_2019-10-01-01. 08.30 .745564_25100372_42455_001/". DATA #1 : Signal Number Recieved, 4 bytes 11 DATA #2 : Siginfo, 64 bytes 0x0A0000002180EDC0 : 0000 000B 0000 0000 0000 0032 0000 0000 ...........2.... 0x0A0000002180EDD0 : 0000 0000 0000 0000 0A00 0000 9E45 1000 .............E.. 0x0A0000002180EDE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0A0000002180EDF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2019-10-01-01.08.31.861629+480 I9677A710 LEVEL: Event PID : 25100372 TID : 42455 PROC : db2sysc 1 INSTANCE: db2inst2 NODE : 001 DB : SAMPLE HOSTNAME: host1 EDUID : 42455 EDUNAME: db2loggr (SAMPLE) 1 FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2159 MESSAGE : lastCrashCount DATA #1 : unsigned integer, 8 bytes 0 DATA #2 : String, 10 bytes inRecovery DATA #3 : Boolean, 1 bytes false CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000000A1CB8CC sqloPGRPRegisterOneCrash + 0x1D0 [1] 0x090000000A1CCCCC sqloEDUCodeTrapHandler + 0xD5C 2019-10-01-01.08.33.714568+480 E10388A593 LEVEL:Severe PID : 23593132 TID : 258 PROC : db2wdog 1 [db2inst2] INSTANCE: db2inst2 NODE : 001 HOSTNAME: host1 EDUID : 258 EDUNAME: db2wdog 1 [db2inst2] FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred. All DB2 processes associated with this instance have been shutdown. Diagnostic information has been recorded. Contact IBM Support for further assistance. 2019-10-01-01.08.33.716426+480 E10982A472 LEVEL: Error PID : 23593132 TID : 258 PROC : db2wdog 1 [db2inst2] INSTANCE: db2inst2 NODE : 001 HOSTNAME: host1 EDUID : 258 EDUNAME: db2wdog 1 [db2inst2] FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:9064 DATA #1 : Process ID, 4 bytes 25100372 DATA #2 : Hexdump, 8 bytes 0x0A000000007FDC58 : 0000 0101 0000 000B ........ 2019-10-01-01.08.33.717275+480 I11455A434 LEVEL: Info PID : 23593132 TID : 258 PROC : db2wdog 1 [db2inst2] INSTANCE: db2inst2 NODE : 001 HOSTNAME: host1 EDUID : 258 EDUNAME: db2wdog 1 [db2inst2] FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5568 DATA #1 : String, 24 bytes Process Termination Code DATA #2 : Hex integer, 4 bytes 0x00000101 2019-10-01-01.08.33.718358+480 I11890A1000 LEVEL: Event PID : 23593132 TID : 258 PROC : db2wdog 1 [db2inst2] INSTANCE: db2inst2 NODE : 001 HOSTNAME: host1 EDUID : 258 EDUNAME: db2wdog 1 [db2inst2] FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10 MESSAGE : Sending SIGKILL to the following process id DATA #1 : signed integer, 4 bytes 19267702 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000000B18C578 sqlossig + 0xA0 [1] 0x00000001000189EC sqleKillAllPidsFromList__FPP13SQLE_PID_LIST@AF65_2 + 0x4C [2] 0x000000010000680C sqleCleanupResources__Fi + 0x1CEC [3] 0x0000000100007BF8 sqleWatchDog__FUl + 0x1278 [4] 0x00000001000020E0 DB2main + 0xE40 [5] 0x090000000B4FCEBC sqloEDUMainEntry__FPcUi + 0x78 [6] 0x090000000B501D84 sqloEDUEntry + 0x114 [7] 0x0900000000546E10 _pthread_body + 0xF0 [8] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.05.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |