DB2 - Problem description
Problem IT16955 | Status: Closed |
SQL0901N INCORRECTLY REPORTED INSTEAD OF SQL0955 WHILE PROCESSING QUERY USING COLUMN ORGANIZED TABLES | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
SQL0901 returned instead of SQL0955 if Sort Memory cannot be allocated to process the statement involving column organized tables. -901 will create binary dump and add a similar message in db2diag.log with stack traceback as follows: 2015-10-19-13.40.16.498520-240 I1001789A3360 LEVEL: Error PID : 30343234 TID : 33689 PROC : db2sysc INSTANCE: xx NODE : 000 DB : xx APPHDL : 0-1585 APPID: *LOCAL.xxxxx.xxxxxxxxxx AUTHID : SVTDBM2 HOSTNAME: xxx EDUID : 33689 EDUNAME: db2agntcol (XXX) FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:286 DATA #1 : String, 364 bytes AssertionFailedException: An assertion '(bSharedMemorySortHeap == 1) && ((pagesGranted + reservedPages) 0))' fai led. Additional info: sort heap reservation failed: bSharedMemorySortHeap: 1 pagesGranted: 0 pagesRequested: 263 reservedPages: 1 mHeapLimit: 32768 minPages: 263 Thrown at JoinSpillInfo.cpp : 286 DATA #2 : Function name in Library, 53 bytes ibm_cde::query::QueryMemMgmt::reserve(Sint64, Sint64) DATA #3 : File name, 17 bytes JoinSpillInfo.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x0900000015BA6F84 traceData__Q3_7ibm_cde8services6TracerFCQ3_7ibm_cde8services11Co mponentIDCQ3_7ibm_cde8services16CommonTraceLevelCQ4_7ibm_cde8se + 0x908 [1] 0x0900000016968E50 traceException__Q3_7ibm_cde8services13BaseExceptionCFQ3_7ibm_cde 8services11ComponentIDPCc + 0x1E4 [2] 0x090000001706CF94 constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8ser + 0x1F4 [3] 0x0900000017062FC4 constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8ser + 0x7C [4] 0x0900000017B0773C reserve__Q3_7ibm_cde5query12QueryMemMgmtFlT1 + 0x8B4 [5] 0x09000000169179C0 reserveMore__Q3_7ibm_cde5query12QueryMemMgmtFlUlT1 + 0x22C [6] 0x0900000016919DD4 configSpillScheme__Q3_7ibm_cde5query13JoinSpillInfoFUlN41 + 0x21C4 [7] 0x0900000017838128 prepBuildHashTables__Q3_7ibm_cde5query23BuildHashTableEvaluatorF v + 0x6C4 [8] 0x09000000178398D8 @21@preProcessBoundary__Q3_7ibm_cde5query23BuildHashTableEvaluat orFv + 0x638 [9] 0x0900000017179BA8 preProcessBoundary__Q3_7ibm_cde5query17EvaluationRoutineFUi@AF56 9_112 + 0xE8 [10] 0x0900000017179734 waitForBoundary__Q3_7ibm_cde5query9SchedulerFRQ2_3std6_PtritXTUi TlTPCUiTRCUiTPUiTRUi_PQ3_7ibm_cde5query17EvaluationRoutine + 0x3D4 [11] 0x090000001717AD8C runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x2D0 [12] 0x09000000151BDFD8 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0 [13] 0x0900000015397DB0 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0x1E4 [14] 0x090000000AA6D008 sqlriInvokeCde__FP8sqlrr_cb + 0x9C [15] 0x090000000CA2B60C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x74 [16] 0x090000000D8F7D94 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x52F4 [17] 0x090000000D8CF34C sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xD94 [18] 0x090000000D8CFCF4 @82@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x234 [19] 0x090000000C2260A8 RunEDU__8sqeAgentFv + 0x31E80 [20] 0x090000000C29A754 RunEDU__8sqeAgentFv + 0x128 [21] 0x090000000D05A3F0 EDUDriver__9sqzEDUObjFv + 0x134 [22] 0x090000000C28E1AC sqloEDUEntry + 0x394 [23] 0x090000000057AD30 _pthread_body + 0xF0 [24] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 2015-10-19-13.40.16.628386-240 I1012007A921 LEVEL: Severe PID : 30343234 TID : 33689 PROC : db2sysc INSTANCE: xxx NODE : 000 DB : xxx APPHDL : 0-1585 APPID: *LOCAL.svtdbm2.151019173919 AUTHID : SVTDBM2 HOSTNAME: xxxx EDUID : 33689 EDUNAME: db2agntcol (XXX) FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 41 sqlerrmc: unexpected error at JoinSpillInfo.cpp:286 sqlerrp : SQLCT001 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFEE2 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: -------Frame------ ------Function + Offset------ 0x0900000000592F54 pthread_kill + 0xD4 0x090000000E8599E8 sqloDumpEDU + 0xC4 0x090000000E879698 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x110 0x090000000D4F6724 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x5FC 0x090000000D4F5FB0 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28 0x090000000C91BDE4 sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0x234 0x090000000C91B578 sqlrrSqlCode + 0xA4 0x0900000014D11B58 done__Q3_7ibm_cde8services24AssertionFailedExceptionFv + 0x1290 0x090000001706CFA0 constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv ices16CdeOStringStr eam + 0x200 0x0900000017062FC4 constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv ices16CdeOStringStr eam@glue77 + 0x7C 0x0900000017B0773C reserve__Q3_7ibm_cde5query12QueryMemMgmtFlT1 + 0x8B4 0x09000000169179C0 reserveMore__Q3_7ibm_cde5query12QueryMemMgmtFlUlT1 + 0x22C 0x0900000016919DD4 configSpillScheme__Q3_7ibm_cde5query13JoinSpillInfoFUlN41 + 0x21C4 0x0900000017838128 prepBuildHashTables__Q3_7ibm_cde5query23BuildHashTableEvaluatorF v + 0x6C4 0x09000000178398D8 @21@preProcessBoundary__Q3_7ibm_cde5query23BuildHashTableEvaluat orFv + 0x638 0x0900000017179BA8 preProcessBoundary__Q3_7ibm_cde5query17EvaluationRoutineFUi@AF56 9_112 + 0xE8 0x0900000017179734 waitForBoundary__Q3_7ibm_cde5query9SchedulerFRQ2_3std6_PtritXTUi TlTPCUiTRCUiTPUiTRUi_PQ3_7ibm_cde5query17EvaluationRoutine + 0x3D4 0x090000001717AD8C runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x2D0 0x09000000151BDFD8 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0 0x0900000015397DB0 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0x1E4 0x090000000AA6D008 sqlriInvokeCde__FP8sqlrr_cb + 0x9C 0x090000000CA2B60C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x74 0x090000000D8F7D94 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x52F4 0x090000000D8CF34C sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xD94 0x090000000D8CFCF4 @82@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x234 0x090000000C2260A8 RunEDU__8sqeAgentFv + 0x31E80 0x090000000C29A754 RunEDU__8sqeAgentFv + 0x128 0x090000000D05A3F0 EDUDriver__9sqzEDUObjFv + 0x134 0x090000000C28E1AC sqloEDUEntry + 0x394 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fixpack 8 * **************************************************************** | |
Local Fix: | |
Increase memory resources | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.09.2016 01.03.2017 01.03.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |