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 |
