APAR status
Closed as program error.
Error 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
Local fix
NA
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 4 Fixpack 5
Temporary fix
Comments
APAR Information
APAR number
IT27993
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-05
Closed date
2020-01-16
Last modified date
2020-01-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 January 2020