There was debug code added as part of the fix for IT22695.
This can cause false detection of errors in the append cache.
Errors in db2diag.log file show similar to the following:
2018-08-13-06.33.22.515595-240 I144726A3393 LEVEL: Severe
PID : 6815792 TID : 38607 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-242 APPID: 10.12.151.118.33033.180812174458
AUTHID : DB2INST1 HOSTNAME: hostname
EDUID : 38607 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management,
sqldFindRidFromPageCacheComplex, probe:4623
MESSAGE : Error searching page cache.
DATA #1 : signed integer, 8 bytes
0
DATA #2 : unsigned integer, 8 bytes
2
DATA #3 : Hex integer, 8 bytes
0x0000000000000004
DATA #4 : unsigned integer, 8 bytes
2
DATA #5 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
163998
DATA #6 : Page ID, PD_TYPE_SQLB_PAGE_ID, 8 bytes
0
DATA #7 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
163999
DATA #8 : SQLD_PAGE_CACHE, PD_TYPE_SQLD_PAGE_CACHE, 96 bytes
SQLD_PAGE_CACHE: Address:a000203ebb65ec0, Size:x60, Size:96
x0000 pcFlags x4
- SQLD_PGCACHE_TEMPAPPEND
x0008 pcFirstObjPage 163998
x000C pcFirstPoolPage 746302
x0010 pcLocksPrefetchedPerPage 0
x0018 pcNumPages 2
x0028 pcLastPageWithSpace 0
x0030 pcPgInfoHeader a000203f19a0060
x0038 pcPgInfo a000203f19a0070
x0040 pcMaxPages 2
x0048 pcPgInfoToFree a000203f19b5ca0
x0050 pcEduIDofLastXLatch 0
x0058 pageCacheLatch a000203ebb65f80
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000DC2C2D4
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
TABLE_CACHET3 + 0x19BC
[1] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
[2] 0x090000000DC20A18
sqldSearchPageCache__FP13SQLD_DFM_WORKP15SQLD_PAGE_CACHEP16SQLD_
TABLE_CACHET3 + 0x32D8
[3] 0x090000000DC041D4 sqldInsertRow__FP13SQLD_DFM_WORKi + 0x1E0
[4] 0x090000000DC05900
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
0x22C
[5] 0x090000000DC0D4E8
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xBC
[6] 0x090000000DC0D790 sqlriisr__FP8sqlrr_cb + 0x1CC
[7] 0x090000000DDE849C
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x94
[8] 0x090000000DA95CA8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x1E98
[9] 0x090000000DA95218
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x1408
[10] 0x090000000DA949A0
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xB90
[11] 0x090000000DA9A9F4
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1168
[12] 0x090000000DA9A9F4
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x1168
[13] 0x090000000DA9A5E8
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xD5C
[14] 0x090000000F5D9174
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[15] 0x090000000F5D9C84
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8
[16] 0x090000000D284674 RunEDU__8sqeAgentFv + 0x4D060
[17] 0x090000000D213DA0 RunEDU__8sqeAgentFv + 0x124
[18] 0x090000000E42140C EDUDriver__9sqzEDUObjFv + 0x130
[19] 0x090000000D1F5AF8 sqloEDUEntry + 0x390
[20] 0x0900000000567E10 _pthread_body + 0xF0
[21] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2018-08-13-06.33.22.523263-240 I148120A570 LEVEL: Severe
PID : 6815792 TID : 38607 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-242 APPID: 10.12.151.118.33033.180812174458
AUTHID : DB2INST1 HOSTNAME: hostname
EDUID : 38607 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging function), probe:30
MESSAGE : SQLD_TCB:
DATA #1 : String, 42 bytes
Perm Table(x:x)=SCHEMA.TABLE
If the errors occur whilst an insert is being performed then the
insert may hang. |
