An assertion is written to the db2diag.log indicating that a
datatype conversion has failed, with the function
sqliLocateStopSlot in the callstack. No error will be reported
to the application. This is a non-fatal error and will not
cause wrong results or data corruption. It could impact the
efficiency of readahead prefetching since some pages may not be
prefetched. The query results will not be affected.
** Snippet of db2diag.log **
2014-11-09-01.26.45.191162-300 I3826925304A4817 LEVEL:
Severe
PID : 13041870 TID : 148091 KTID :
19399713
PROC : db2sysc 0
INSTANCE: db2 NODE : 000 DB : DB2DB
APPHDL : 1-43164 APPID: *N0.svtdbm4.1411092145172
AUTHID : DB2USER HOSTNAME: db2host
EDUID : 148091 EDUNAME: db2agnts (UCA500DB) 0
FUNCTION: DB2 UDB, data services, sqlrxcon, probe:219
DATA #1 : String, 117 bytes
ASSERTION FAILED!!!
ASSERTION EXPRESSION: convertNumRc == 0
SOURCE FILE NAME: sqlrxcon.C
SOURCE FILE LINE NUMBER: 208
DATA #2 : Codepath, 8 bytes
0
DATA #3 : String, 72 bytes
CONTACT DB2 SERVICE, assert a numeric conversion has
unexpectedly failed
DATA #4 : String, 13 bytes
convertNumRc:
DATA #5 : Hex integer, 4 bytes
0x80160008
DATA #6 : String, 23 bytes
datain zvalue and data:
DATA #7 : Hexdump with no ASCII beside it, 24 bytes
0x07000012A8D179A0 : 0003 0008 0000 0000 0700 0012 A8D1 79CC
0x07000012A8D179B0 : 0008 0000 0000 0000
DATA #8 : Hexdump with no ASCII beside it, 8 bytes
0x07000012A8D179CC : 3FDF FFF8 F053 CE6D
DATA #9 : String, 24 bytes
dataout zvalue and data:
DATA #10: Hexdump with no ASCII beside it, 24 bytes
0x0700000022FFAE68 : 0002 060D 0000 0000 0700 0000 22FF AE48
0x0700000022FFAE78 : CBCB CBCB CBCB CBCB
DATA #11: Hexdump with no ASCII beside it, 4 bytes
0x0700000022FFAE48 : CBCB CBCB
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000860EC10 pdLog + 0x2D0
[1] 0x0900000009859708 sqlrxcon2__FP8SQLRXNLSP10sqlz_valueT2 +
0x828
[2] 0x090000000AF02EB0
sqlrxcon_simple__FP8SQLRXNLSP10sqlz_valueT2 + 0xAF0
[3] 0x090000000AF03494
sqlv_deccompdec__FCPC14sqlrxCollationP10sqlz_valueT2Ui + 0x4D4
[4] 0x090000000AF03E38
sqlv_decncmp__FCPC14sqlrxCollationP10sqlz_valueT2Ui + 0x158
[5] 0x090000000AF042C0
keypartnd__FP7SQLI_CBP10sqlz_valuePPcP17COMP_FUNC_ELEMENTPl +
0x140
[6] 0x090000000AED5CB4
compare_keypart__FP7SQLI_CBPPcP10sqlz_valueP17COMP_FUNC_ELEMENTP
l + 0x154
[7] 0x090000000AED7128
sqliComparePrefixCompPg__FP7SQLI_CBP14SQLI_PAGE_DESCP8SQLD_KEYP1
2SQLI_KEYDATAP9SQLI_SLOTPlP14COMP_FUNC_VECTPclN28 + 0x13C8
[8] 0x090000000AED795C
sqliComparePrefixCompPg__FP7SQLI_CBP14SQLI_PAGE_DESCP8SQLD_KEYP1
2SQLI_KEYDATAP9SQLI_SLOTPlP14COMP_FUNC_VECTPc + 0xBC
[9] 0x090000000AEE3BD4
sqliBinSearchExactRidOrPrevPrefixCompPg__FP7SQLI_CBlN22P14SQLI_P
AGE_DESCP8SQLD_KEYP12SQLI_KEYDATAP9SQLI_SLOT + 0x3B4
[10] 0x090000000AEE482C
sqliBinSearchExactRidOrPrev__FP7SQLI_CBlN22P14SQLI_PAGE_DESCP8SQ
LD_KEYP12SQLI_KEYDATAP9SQLI_SLOT + 0xAC
[11] 0x090000000AEE693C
fetchko__FP7SQLI_CBP14SQLI_PAGE_DESCP8SQLD_KEYP9SQLI_SLOTi +
0x17C
[12] 0x090000000AEE6CB4
sqlilkey__FP7SQLI_CBiP14SQLI_PAGE_DESCP8SQLD_KEYP12SQLI_KEYDATAT
4T5P9SQLI_SLOTT2Ul + 0x2B4
[13] 0x090000000C0A5AE4
sqliLocateStopSlot__FP7SQLI_CBP14SQLI_PAGE_DESCP9SQLI_SLOTPl +
0x3A4
[14] 0x090000000C0B18B0
sqliPrefetchDataPagesForLeaf__FP7SQLI_CB + 0xCF0
[15] 0x090000000A41EF04
sqldSeqDetCheck__FUiUsP16SQLB_OBJECT_DESCP16SQLD_SEQDET_INFOT1P8
sqeAgentP7SQLI_CBT1 + 0x3E4
[16] 0x090000000A422214
sqldDataFetch__FP8SQLD_CCBP8SQLZ_RIDUlP7SQLI_CB + 0x12F4
[17] 0x090000000DAEBB30
sqliDataFetch__FP10SQLI_IXPCRP8SQLZ_RIDP7SQLI_CB + 0x3B0
[18] 0x090000000DB1D0F8
sqliScanLeaf2__FP7SQLI_CBP11SQLI_SFGLOB + 0x1F78
[19] 0x090000000DB20A14 sqlifnxt__FP7SQLI_CBP11SQLI_SFGLOB +
0x974
[20] 0x0900000008E793B4
sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_
KEYDATAP9sqli_scanPi + 0x11D4
[21] 0x090000000A40DAF0 sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID
+ 0x5D0
[22] 0x090000000A41A8A8
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT
3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x1748
[23] 0x090000000ABA4DE4
sqlriFetchPerm__FP8sqlrr_cbP9sqlri_taol + 0x104
[24] 0x090000000ABA5048 sqlriFetch__FP8sqlrr_cbP9sqlri_taol +
0x1E8
[25] 0x0900000012AEFC0C sqlriNljnNonPiped__FP8sqlrr_cb + 0xC6C
[26] 0x09000000098336EC
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm + 0x7EC
[27] 0x0900000009835F50
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x10F0
[28] 0x09000000128E2EEC sqlrr_smp_router__FP8sqlrr_cb + 0x4AC
[29] 0x09000000128EE108
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x1F88
[30] 0x0900000009942DA8
sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0xEA8
[31] 0x090000000995F668 sqleProcessSubRequest__FP8sqeAgent +
0x328
[32] 0x09000000089C167C RunEDU__8sqeAgentFv + 0x37C
[33] 0x090000000897CDBC EDUDriver__9sqzEDUObjFv + 0x23C
[34] 0x090000000897D11C sqlzRunEDU__FPcUi + 0x3C
[35] 0x09000000087D91B4 sqloEDUEntry + 0x7B4
[36] 0x09000000007BBD30 _pthread_body + 0xF0
[37] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |
