Db2 instance may crash with Corrupt pool free tree node error
after stored procedure termination when running federated query
with fenced wrapper and user mapping plugin is enabled.
The stack can be different, but the corrupted pool free tree
node is in APM pool.
User mapping plug-in allows user to access external user mapping
repositories instead of using CREATE USER MAPPING DDLs.
To enable it, user needs to create fsumplugin_file.cfg file and
fsumplugin_file module on sqllib/function directory. For details
refer External user mapping repositories section in Db2
knowledge center.
.
Related db2diag.log messages:
.
2021-01-15-12.36.45.084599-300 I2324512E676 LEVEL:
Severe
PID : 28490 TID : 46968982202112 PROC :
db2sysc 1
INSTANCE: xxxx NODE : 001 DB : TEST
APPHDL : 1-11343 APPID: xxxx
UOWID : xxx ACTID: 8
AUTHID : xxxxx HOSTNAME: xxxxxx
EDUID : 70851 EDUNAME: db2agntp (xxxxx) 1
FUNCTION: DB2 UDB, routine_infrastructure,
sqlerFedInvokeFencedRoutine, probe:200
RETCODE : ZRC=0xFFFFFB95=-1131
SQL1131N A stored procedure process has been
terminated abnormally.
Routine name: "". Specific name: "".
.
2021-01-15-12.36.45.302362-300 E2326207E2006 LEVEL:
Severe
PID : 28490 TID : 46968827012864 PROC :
db2sysc 1
INSTANCE: xxxxx NODE : 001 DB :
xxxxx
APPHDL : 4-55196 APPID: xxxxxx
AUTHID : xxxxx HOSTNAME: xxxxxxx
EDUID : 62634 EDUNAME: db2agntp (xxxxx) 1
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, 40 bytes
28490.46968827012864.mem_diagnostics.txt
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAAB28BC4E5
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb +
0x285
[1] 0x00002AAAB28B75F8
_ZN13SQLO_MEM_POOL10MemTreeGetEmmPP17SqloChunkSubgroupPj + 0x188
[2] 0x00002AAAB28BC69C
_ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmjmPP17SqloChunkSubgrou
pPjP12SMemLogEvent + 0x6C
[3] 0x00002AAAB28999A0 sqloGetMemoryBlockExtended + 0xFF0
[4] ..... |
