DB2 - Problem description
Problem IT37212 | Status: Closed |
RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN. Most likely to happen on PPCLE . The XXXX marked areas below is masked column data. Observed Stack 1 FUNCTION: DB2 UDB, SQO Memory Management, sqloDiagnoseFreeBlockFailure, probe:10 MESSAGE : Possible memory corruption detected. DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes 0x820F0002 DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8 bytes 0x000010139629ec50 DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 0x00001011AB465E38 : XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX ................ 0x00001011AB465E48 : XXXX XXXX XXXX XXXX ........ code: 0xdb2cafe0 curSize: 892350770 SMemBlkFileId: 875574320 SMemBlkLOC: 12336 SMemBlkNum: 12848 CodedCSG: 32323238 DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 0x000010139629EC50 : 0000 0000 0000 0000 6500 0000 0000 0000 ........e....... 0x000010139629EC60 : 6500 0000 0020 0000 001B 0000 F71B 0000 e.... .......... 0x000010139629EC70 : D0CF 5BAA 1010 0000 0000 0000 0000 0000 ..[............. CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00001000025E1E58 /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x2341E58 [1] 0x00001000025E5924 pdLog + 0x4D4 [2] 0x000010000A03671C /head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x9D9671C [3] 0x000010000A036E3C sqlofmblkEx + 0xBC [4] 0x0000100009F6DC74 _ZN17sqloFastAllocator9freeBlockEPKcmPv + 0xF4 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Db2 Linux Unix Windows v11.5 and up * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or later * **************************************************************** | |
Local Fix: | |
Retry query. It is a timing problem and the query may run on subsequent attemps. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Db2 Linux Unix Windows v11.5 and up * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2021 01.12.2021 01.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |