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 |
