DB2 - Problem description
Problem IT21576 | Status: Closed |
SQL0901N "NO SPACE TO INSERT KEY INTO CHT 85 0" | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Query may produced the error SQL0901N with the message: "no space to insert key into CHT 85 0" The stack for the error will show similar to the following: <StackTrace> -------Frame------ ------Function + Offset------ 0x0900000000564F14 pthread_kill + 0xD4 0x0900000022429B20 sqloDumpEDU + 0xC4 0x090000002244AC98 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x110 0x0900000020AA4F38 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x940 0x0900000020AA4480 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28 0x09000000205A4A5C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0x234 0x09000000205A41F0 sqlrrSqlCode + 0xA4 0x0900000034D760FC done__Q3_7ibm_cde8services24AssertionFailedExceptionFv + 0x1290 0x0900000032D189C8 constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv ices16CdeOStringStream + 0x208 0x0900000032D07ACC constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv ices16CdeOStringStream@glue7B + 0x7C 0x0900000033AC69E4 formCompactHashTable__Q3_7ibm_cde5query18RegularLPHashTableXTlTl SP0SP0_Hll_UibCP13SQLO_MEM_POOL_Q2_3std8auto_ptrXTQ3_7ibm_cde5qu ery9CompactHTXTlTlTlTlSP0SP1SP1__ + 0xD4 0x0900000033AC5254 formCompactHashTable__Q3_7ibm_cde5query14JoinProbeTableXSP0SP1SP 100SP0_FUibCP13SQLO_MEM_POOL + 0xDC 0x0900000032FE08F4 managePart__Q3_7ibm_cde5query13JoinSpillInfoFUlN21Rl + 0x2F8 with: DATA #1 : String, 206 bytes AssertionFailedException: An assertion 'false' failed. Additional info: no space to insert key into CHT 85 0 Thrown at /view/db2_v105fp8_aix64_s160901_special_36402/vbs/engn/cde/group by/HashTable.hpp : 1522 DATA #2 : Function name in Library, 137 bytes ibm_cde::query::CompactHT<long,long,long,long,0,1,1>::lookupAndI nsertKey<1>(long *, KeyIndex *, long *, Uint, Uint32, Uint, bool, bool &) DATA #3 : File name, 80 bytes /view/db2_v105fp8_aix64_s160901_special_36402/vbs/engn/cde/group by/HashTable.hpp ... This fix will change the error produced from -901 to -955 as the problem is caused by insufficient hash buckets for the query to complete. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.07.2017 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |