DB2 - Problem description
Problem IT27993 | Status: Closed |
DPF INSTANCE MAY CRASH DUE TO MEMORY CORRUPTION WHEN CALLING STORED PROCEDURE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
DPF Instance may crash due to memory corruption when calling Stored procedure. 2019-01-14-14.31.08.604673-300 I297377755E428 LEVEL: Severe PID : 129799 TID : 139925930825472 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 014 HOSTNAME: host3 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50 MESSAGE : Synchronization Semaphore ID DATA #1 : Hexdump, 8 bytes 0x00007F430B66CD54 : 0200 0000 0000 0000 ........ 2019-01-14-14.31.08.604824-300 I297378184E341 LEVEL: Severe PID : 129799 TID : 139925930825472 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 014 HOSTNAME: host3 FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs, probe:100 RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter" 2019-01-14-14.31.08.604937-300 I297378526E420 LEVEL: Severe PID : 129799 TID : 139925930825472 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 014 HOSTNAME: host3 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50 MESSAGE : IPC Semaphore Set ID DATA #1 : Hexdump, 8 bytes 0x00007F430B66CD34 : 8281 D872 0000 0000 ...r.... 2019-01-14-14.31.08.825967-300 E297393675E1032 LEVEL: Critical PID : 124535 TID : 140232666113792 PROC : db2sysc 14 INSTANCE: db2inst1 NODE : 014 DB : SAMPLE APPHDL : 1-29257 APPID: 10.1.1.1.65272.190114193108 AUTHID : db2inst1 HOSTNAME: host3 EDUID : 309284 EDUNAME: db2agntp (SAMPLE) 14 FUNCTION: DB2 UDB, SQO Memory Management, sqloDiagnoseFreeBlockFailure, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "Panic". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/home/db2inst1/db2dump/HOST_host3/FODC_Panic_2019- 01-14-14.31.08.813903_0014/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem. 2019-01-14-14.31.08.839490-300 I297395703E602 LEVEL: Info PID : 129799 TID : 139925932271360 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 014 DB : SAMPLE APPID : 10.1.1.1.65272.190114193108 HOSTNAME: host3 FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:1999 MESSAGE : ZRC=0xFFFFFB95=-1131 SQL1131N A stored procedure process has been terminated abnormally. Routine name: "". Specific name: "". DATA #1 : String, 46 bytes FMP exiting with error. Last agent registered: DATA #2 : EDUID, 4 bytes 309352 2019-01-14-14.31.08.839757-300 I297396306E505 LEVEL: Warning PID : 129799 TID : 139925932271360 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 014 DB : SAMPLE APPID : 10.1.1.1.65272.190114193108 HOSTNAME: host3 FUNCTION: DB2 UDB, routine_infrastructure, sqlerWorkerThreadEntry, probe:1022 MESSAGE : ZRC=0xFFFFFB95=-1131 SQL1131N A stored procedure process has been terminated abnormally. Routine name: "". Specific name: "". 2019-01-14-14.31.08.896867-300 E297406826E2636 LEVEL: Severe PID : 124535 TID : 140232666113792 PROC : db2sysc 14 INSTANCE: db2inst1 NODE : 014 DB : SAMPLE APPHDL : 1-29257 APPID: 10.1.1.1.65272.190114193108 EDUID : 309284 EDUNAME: db2agntp (SAMPLE) 14 FUNCTION: DB2 UDB, SQO Memory Management, sqloDiagnoseFreeBlockFailure, probe:999 MESSAGE : Memory validation failure, diagnostic file dumped. DATA #1 : String, 28 bytes Corrupt pool free tree node. DATA #2 : File name, 42 bytes 124535.140232666113792.mem_diagnostics.txt CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FA9648AF935 _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb + 0x285 [1] 0x00007FA9648AAA48 _ZN13SQLO_MEM_POOL10MemTreeGetEmmPP17SqloChunkSubgroupPj + 0x188 [2] 0x00007FA9648AFAEC _ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmjmPP17SqloChunkSubgrou pPjP12SMemLogEvent + 0x6C [3] 0x00007FA96488CDF0 sqloGetMemoryBlockExtended + 0xFF0 [4] 0x00007FA962DCDC0E _Z14sqlerGetFMPIPCP18SQLCC_INITSTRUCT_Tj + 0x18E [5] 0x00007FA95F5CA9EE _Z12sqlccGetIPCsP18SQLCC_INITSTRUCT_TP26SQLCC_IPC_CON_REQST_DATA _Tb + 0xB7E [6] 0x00007FA962E06008 _Z16sqlerAllocFmpIPCPP18SQLCC_INITSTRUCT_TP8sqeAgenti + 0x188 [7] 0x00007FA962DFA635 _Z22sqlerGetFmpThreadEntryP11sqlerFmpRowP14sqlerFmpHandleP17sqle rFmpParmsBaseb + 0xB75 [8] 0x00007FA962DF85CE _Z19sqlerGetFmpFromPoolP14sqlerFmpHandleP17sqlerFmpParmsBase + 0x11CE [9] 0x00007FA962DF594E _Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x5FE [10] 0x00007FA96569F1F9 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0x4A9 [11] 0x00007FA9656A67BC _Z8sqlriutfP8sqlrr_cb + 0x79C [12] 0x00007FA9656DD72F _Z11sqlri_tfopnP8sqlrr_cbP9sqlri_tao + 0x10F [13] 0x00007FA96548E4EC _Z8sqlriopnP8sqlrr_cbP9sqlri_taoPi + 0x4AC [14] 0x00007FA965608558 _Z7sqlritaP8sqlrr_cb + 0xB78 [15] 0x00007FA96552498D _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4BD [16] 0x00007FA964F583A6 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x806 [17] 0x00007FA964F54D55 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1075 [18] 0x00007FA962A827A2 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x546B7A2 [19] 0x00007FA962A81070 _Z21sqleProcessSubRequestP8sqeAgent + 0x3E0 [20] 0x00007FA962AB58B7 _ZN8sqeAgent6RunEDUEv + 0x5D7 [21] 0x00007FA966377F4E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [22] 0x00007FA9648D92B8 sqloEDUEntry + 0x578 [23] 0x0000003457607AA1 /lib64/libpthread.so.0 + 0x7AA1 [24] 0x00000034572E893D clone + 0x6D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : PH15540 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.02.2019 16.01.2020 16.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |