|
Problem IT36948
|
Status: Closed |
RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN .
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN In 11.5.5.1 with
improved CDE hash join logic activated by
development recommendation.
stacks similar to:
.
-----Frame------ ------Address----- ------Function +
Offset------
0x0000101AF9BE5130 0x0000100010ACFCB0 gsignal + 0x0060
( = offset 0x3FCB0 in /lib64/libc.so.6)
0x0000101AF9BE5280 0x000010000A08E9CC sqloExitEDU + 0x02ec
( = offset 0x9DEE9CC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5770 0x0000100007BE422C _Z10sqle_panici + 0x05cc
( = offset 0x794422C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5A50 0x000010000A02E578
sqloCrashOnCriticalMemoryValidationFailure + 0x0058
( = offset 0x9D8E578 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5A70 0x000010000A057A38
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb +
0x0238
( = offset 0x9DB7A38 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5C50 0x000010000A032814
( = offset 0x9D92814 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5D40 0x000010000A032A1C sqlofmblkEx + 0x00bc
( = offset 0x9D92A1C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE5F30 0x0000100009F69894
_ZN17sqloFastAllocator9freeBlockEPKcmPv + 0x00f4
( = offset 0x9CC9894 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE6000 0x0000100009F6B314
_ZN23sqloFastThreadAllocator7freeMemEPKcmPv + 0x00a4
( = offset 0x9CCB314 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE6050 0x00001000031C5AB0
_ZN7ibm_cde8services4Heap7freeMemEPKcmPv + 0x0230
( = offset 0x2F25AB0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE6260 0x0000100006496068
_ZN7ibm_cde5query19CHTExtraPayloadPageIlE10unloadPageEPNS_8servi
ces14SpillableStoreEP13SQLO_MEM_POOL + 0x01d8
( = offset 0x61F6068 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE62C0 0x0000100006482534
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE11finalizeEPsILi0EEEbv
+ 0x1e94
( = offset 0x61E2534 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE8660 0x0000100006484108
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE8finalizeILi0EEEbv +
0x03a8
( = offset 0x61E4108 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE8760 0x0000100007484CE8
_ZN7ibm_cde5query14JoinProbeTableILNS0_15HashTableFormatE0ELNS_5
types12MultiplicityE100ELS4_100ELb1ELb0EE17finalizeHashTableEv +
0x0068
( = offset 0x71E4CE8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BE8810 0x00001000074675F4
_ZN7ibm_cde5query13JoinSpillInfo10managePartILb1EEEvmmmRl +
0x12c4
( = offset 0x71C75F4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BEB700 0x0000100007439EE0
_ZN7ibm_cde5query13JoinSpillInfo11manageSpillEmNS1_14JoinSpillPh
aseElm + 0x0650
( = offset 0x7199EE0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BEB890 0x000010000743AD48
_ZN7ibm_cde5query13JoinSpillInfo15buildHashTablesEm + 0x05e8
( = offset 0x719AD48 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BEBA20 0x0000100006487254
_ZN7ibm_cde5query23BuildHashTableEvaluator26processInputsSynchro
nouslyEv + 0x02c4
( = offset 0x61E7254 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000101AF9BEBAF0 0x0000100004A7F88C
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x059c
( = offset 0x47DF88C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
.
or
.
0x000010182B3E56E0 0x00001000031EEAAC
_ZN7ibm_cde8services14SpillableStore15performPrefetchERNS0_13Spi
llableScanE + 0x027c
( = offset 0x2F4EAAC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E57E0 0x000010000649B150
_ZN7ibm_cde5query19CHTExtraPayloadPageIlE8loadPageEPNS_8services
14SpillableStoreEP13SQLO_MEM_POOL + 0x0310
( = offset 0x61FB150 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E6270 0x000010000649B380
_ZN7ibm_cde5query19CHTExtraPayloadPageIlE7addUserEPNS_8services1
4SpillableStoreEP13SQLO_MEM_POOL + 0x0110
( = offset 0x61FB380 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E62C0 0x00001000064823C8
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE11finalizeEPsILi0EEEbv
+ 0x1d28
( = offset 0x61E23C8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8660 0x0000100006484108
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE8finalizeILi0EEEbv +
0x03a8
( = offset 0x61E4108 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8760 0x0000100007484CE8
_ZN7ibm_cde5query14JoinProbeTableILNS0_15HashTableFormatE0ELNS_5
types12MultiplicityE100ELS4_100ELb1ELb0EE17finalizeHashTableEv +
0x0068
( = offset 0x71E4CE8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8810 0x00001000074675F4
_ZN7ibm_cde5query13JoinSpillInfo10managePartILb1EEEvmmmRl +
0x12c4
( = offset 0x71C75F4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EB700 0x0000100007439EE0
_ZN7ibm_cde5query13JoinSpillInfo11manageSpillEmNS1_14JoinSpillPh
aseElm + 0x0650
( = offset 0x7199EE0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EB890 0x000010000743AD48
_ZN7ibm_cde5query13JoinSpillInfo15buildHashTablesEm + 0x05e8
( = offset 0x719AD48 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBA20 0x0000100006487254
_ZN7ibm_cde5query23BuildHashTableEvaluator26processInputsSynchro
nouslyEv + 0x02c4
( = offset 0x61E7254 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBAF0 0x0000100004A7F88C
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x059c
( = offset 0x47DF88C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBE70 0x0000100004A091B4
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x02f4
( = offset 0x47691B4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)0x000010182B3E56E0
0x00001000031EEAAC
_ZN7ibm_cde8services14SpillableStore15performPrefetchERNS0_13Spi
llableScanE + 0x027c
( = offset 0x2F4EAAC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E57E0 0x000010000649B150
_ZN7ibm_cde5query19CHTExtraPayloadPageIlE8loadPageEPNS_8services
14SpillableStoreEP13SQLO_MEM_POOL + 0x0310
( = offset 0x61FB150 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E6270 0x000010000649B380
_ZN7ibm_cde5query19CHTExtraPayloadPageIlE7addUserEPNS_8services1
4SpillableStoreEP13SQLO_MEM_POOL + 0x0110
( = offset 0x61FB380 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E62C0 0x00001000064823C8
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE11finalizeEPsILi0EEEbv
+ 0x1d28
( = offset 0x61E23C8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8660 0x0000100006484108
_ZN7ibm_cde5query9CompactHTIllllLb1ELb0EE8finalizeILi0EEEbv +
0x03a8
( = offset 0x61E4108 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8760 0x0000100007484CE8
_ZN7ibm_cde5query14JoinProbeTableILNS0_15HashTableFormatE0ELNS_5
types12MultiplicityE100ELS4_100ELb1ELb0EE17finalizeHashTableEv +
0x0068
( = offset 0x71E4CE8 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3E8810 0x00001000074675F4
_ZN7ibm_cde5query13JoinSpillInfo10managePartILb1EEEvmmmRl +
0x12c4
( = offset 0x71C75F4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EB700 0x0000100007439EE0
_ZN7ibm_cde5query13JoinSpillInfo11manageSpillEmNS1_14JoinSpillPh
aseElm + 0x0650
( = offset 0x7199EE0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EB890 0x000010000743AD48
_ZN7ibm_cde5query13JoinSpillInfo15buildHashTablesEm + 0x05e8
( = offset 0x719AD48 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBA20 0x0000100006487254
_ZN7ibm_cde5query23BuildHashTableEvaluator26processInputsSynchro
nouslyEv + 0x02c4
( = offset 0x61E7254 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBAF0 0x0000100004A7F88C
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x059c
( = offset 0x47DF88C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x000010182B3EBE70 0x0000100004A091B4
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x02f4
( = offset 0x47691B4 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
.
or
.
0x00001026227ED3D0 0x0000100009F6ABC0
_ZN23sqloFastThreadAllocator13termFastAllocEv + 0x00a0
( = offset 0x9CCABC0 in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001026227ED440 0x0000100005CB577C
_ZN12cdeInterface20cdeCleanupAgentCacheEv + 0x00ec
( = offset 0x5A1577C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001026227ED520 0x000010000A875A9C
_Z16sqlrr_smp_routerP8sqlrr_cb + 0x01bc
( = offset 0xA5D5A9C in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001026227ED600 0x000010000A879DBC
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x150c
( = offset 0xA5D9DBC in
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00001026227ED8A0 0x0000100007BABD74 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CDE JOIN QUERIES THAT REQUIRE A LOT OF MEMORY *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See Error Description *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* CDE JOIN QUERIES THAT REQUIRE A LOT OF MEMORY *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See Error Description *
**************************************************************** |
| Comment |
See Error Description |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.05.2021
16.06.2021
16.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
