There is a small timing hole in which an insert into an index,
when run concurrently with other inserts/updates/deletes of the
same index, may result in a crash with the following message
written to db2diag.log file:
2012-05-04-07.18.32.018769+120 I37571951A5770 LEVEL: Severe
PID : 13107414 TID : 97419 PROC : db2sysc
0
INSTANCE: XXX NODE : 000 DB : XXX
APPHDL : 0-64999 APPID: XXX
AUTHID : XXX
EDUID : 97419 EDUNAME: db2agent (XXX) 0
FUNCTION: DB2 UDB, index manager, sqliNormalAddKey, probe:776
MESSAGE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
DATA #1 : String, 9 bytes
new_size:
DATA #2 : unsigned integer, 8 bytes
119
DATA #3 : String, 8 bytes
recSize:
DATA #4 : unsigned integer, 2 bytes
119
DATA #5 : String, 10 bytes
usable_sp:
DATA #6 : unsigned integer, 8 bytes
50
DATA #7 : String, 10 bytes
violAdded:
DATA #8 : Boolean, 4 bytes
false
DATA #9 : String, 13 bytes
insertOffset:
DATA #10: unsigned integer, 2 bytes
1
DATA #11: String, 19 bytes
newFreeSpaceOffset:
DATA #12: unsigned integer, 2 bytes
0
DATA #13: String, 18 bytes
olrMoveBothOnPage:
DATA #14: Boolean, 8 bytes
false
DATA #15: String, 15 bytes
olrOldSlotinfo:
DATA #16: SQLI_SLOT, PD_TYPE_SQLI_SLOT, 40 bytes
SQLI_SLOT: Address:700000de13f52b0, Size:x28, Size:40
x0000 slot 648518346480985592
x0020 prefixNumber 8
x0008 keydo 504403169627930656
x0010 databits x0
x0018 firstKDOffset 2586
DATA #17: SQLI_RID_LIST, PD_TYPE_SQLI_RID_LIST, 296 bytes
SQLI_RID_LIST: Address:700000de13f5350, Size:x128, Size:296
x0000 rlIsCompressionEnabled true
x0008 rlReverseScan true
x0010 rlCurrentKeydataSize 0
x0018 rlCurrentKDOffset 2304
x0020 rlCurKeydata
SQLI_LEAF_KEYDATA: Address:700000de13f5370, Size:x10, Size:16
x0000 tableRid Page=12288;
Slot=840; Dpid=1792
x0008 ridFlags x0
x0030 pRL_CurrentNode 700000df0550328
x0038 pRL_CurrentRecord 138501340
x0040 pRL_NextToRead 700000de13f5400
x0048 pRL_FirstKD_OnDisk NULL
x0050 pRL_EndOfRecord d7
x0058 encodedBuffer
0000 0000 0000 0004 0000 0018 0002 0071
0000 0001 3850 9C52 0000 0000 0000 0000
0700 000D E13F 56D8 0000 0000 0000 0000
0000 0001 3850 2300 0700 000D E13F 5550
x0098 encodedBufLen 1440870405781853181
x00A0 firstKD_Val
SQLI_LEAF_KEYDATA: Address:700000de13f53f0, Size:x10, Size:16
x0000 tableRid Page=1558;
Slot=56292; Dpid=2304
x0008 ridFlags x0
x00B0 pLastRID_OnDisk 700000de13f5550
x00B8 lastKD_Val
SQLI_LEAF_KEYDATA: Address:700000de13f5408, Size:x10, Size:16
x0000 tableRid Page=268476587;
Slot=38456; Dpid=2304
x0008 ridFlags x0
x00C8 rlFirstKDOffset 0
x00D0 pDeltaList 700000de13f5a50
x00D8 numOfRIDs 9521806018351202304
x00E0 uncompressedKeydataSize 648518346465338208
x00E8 ridPrimerSz 504403217879138032
x00F0 pPrimerList NULL
x00F8 numOfPrimers 0
x0100 deltaListLen 5239774314
x0108 rlFlags x7000002
- SQLI_RL_INSERT_NEW_FIRST_COMPRESSED_KD
x0110 deltaListSpToFree 504403169632944049
x0118 spaceToFree 1
x0120 deltaAfterDeltaToDel 0
DATA #18: SQLI_PREFIX_INSERT_CB, PD_TYPE_SQLI_PREFIX_INSERT_CB,
120 bytes
SQLI_PREFIX_INSERT_CB: Address:700000de13f52d8, Size:x78,
Size:120
x0000 insertFlags x1C02
- SQLI_PC_INSERT_WITH_NEW_PREFIX
- SQLI_PC_INSERT_FIRST_PREP_COMPLETE
x0008 pUncompressedRec 138509ad8
x0010 pPrefixToUse 700000de13f52f0
x0018 prefixData1
SQLI_INSERT_PREFIX_DATA: Address:700000de13f52f0, Size:x30,
Size:48
x0000 prefixRecLen 65
x0008 suffixRecLen 54
x0010 lastCommonKeyPartHasVarLength true
x0018 varLenData.pVarLenField 138509b0a
x0020 varLenData.kpLenInPrefix 13
x0028 varLenData.kpLenInSuffix 11
x0048 prefixData2
SQLI_INSERT_PREFIX_DATA: Address:700000de13f5320, Size:x30,
Size:48
x0000 prefixRecLen 42
x0008 suffixRecLen 77
x0010 lastCommonKeyPartHasVarLength true
x0018 varLenData.pVarLenField 138509af0
x0020 varLenData.kpLenInPrefix 16
x0028 varLenData.kpLenInSuffix 3
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x09000000077B2FB0 pdLog + 0xE0
[1] 0x09000000035F857C pdLog@glue41F + 0x454
[2] 0x0900000003C54094
@147@sqliNormalAddKey__FP7SQLI_CBP14SQLI_PAGE_DESCP9SQLI_SLOTP8S
QLD_KEYP12SQLI_KEYDATA + 0x420
[3] 0x09000000075DC1E0
sqliakn__FP7SQLI_CBP14SQLI_PAGE_DESCP9SQLI_SLOTP8SQLD_KEYP12SQLI
_KEYDATAPUc + 0xD0
[4] 0x09000000075D97D0
@147@addkeyToLeaf__FP7SQLI_CBP11SQLI_SAGLOBP9SQLI_SLOT + 0x98
[5] 0x09000000075D798C
.@147@procLeaf2Add.fdpr.clone.63__FP7SQLI_CBP11SQLI_SAGLOBP9SQLI
_SLOTiP12SQLI_KEYDATA + 0x710
[6] 0x0900000007608D80 sqlischa__FP7SQLI_CBP11SQLI_SAGLOBiUi +
0x2E4
[7] 0x0900000007608A30
@147@next_level__FP7SQLI_CBP11SQLI_SAGLOBiUi + 0x60
[8] 0x0900000007608C60 sqlischa__FP7SQLI_CBP11SQLI_SAGLOBiUi +
0x1C4
[9] 0x0900000007608A30
@147@next_level__FP7SQLI_CBP11SQLI_SAGLOBiUi + 0x60 |
