DB2 - Problem description
Problem IT36532 | Status: Closed |
DB2 MAY CRASH IN A RARE TIMING WHEN RUNNING FEDERATED QUERIES WITH FENCED WRAPPER AND USER MAPPING PLUGIN IS ENABLED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
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] ..... | |
Problem Summary: | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.04.2021 01.07.2021 01.07.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |