Informix - Problem description
Problem IT29185 | Status: Closed |
INSERT/DELETE MIX ON COMPRESSED INDEX CAN CAUSE "OFFSET >= CS->BC_KEYSIZE && OFFSET BC_SLOTLEN" MESSAGES | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When running a insert/delete mix on a compressed tables also using compressed indexes may result in error -271 and messages like this in the online.log 15:57:44 Assert Failed: Code assertion at rsbtcs.c:301 15:57:44 IBM Informix Dynamic Server Version 12.10.FC12 15:57:44 Who: Session(2619, holgerk@darkwood, 26640, 0x452b9988) Thread(3040, sqlexec, 452796a8, 8) File: rsdebug.c Line: 3910 15:57:44 Results: rowoff+BT_RIDL_FLAG_SIZE+2*sizeof(int4) bc_slotptr+cs->bc_slotlen 15:57:44 Action: Please notify IBM Informix Technical Support. 15:57:44 stack trace for pid 21498 written to /opt/informix/IBM/12.10.FC12/tmp/af.fc8bdd8 15:57:44 See Also: /opt/informix/IBM/12.10.FC12/tmp/af.fc8bdd8 15:57:45 Logical Log 638747 Complete, timestamp: 0x32a6afd0. 15:57:46 Code assertion at rsbtcs.c:301 15:57:46 Assert Failed: Code assertion at rsbtcs.c:473 15:57:46 IBM Informix Dynamic Server Version 12.10.FC12 15:57:46 Who: Session(2615, holgerk@darkwood, 26638, 0x452b9618) Thread(3039, sqlexec, 45274638, 9) File: rsdebug.c Line: 3910 15:57:46 Results: offset >= cs->bc_keysize && offset bc_slotlen 15:57:46 Action: Please notify IBM Informix Technical Support. 15:57:46 stack trace for pid 21501 written to /opt/informix/IBM/12.10.FC12/tmp/af.fc7bdd9 15:57:46 See Also: /opt/informix/IBM/12.10.FC12/tmp/af.fc7bdd9 Stack : 0x000000000141f989 (oninit) afstack 0x0000000001422961 (oninit) afhandler 0x0000000001423142 (oninit) affail_interface 0x0000000000e24d55 (oninit) rsam_assert 0x0000000000f5ce84 (oninit) ridl_ld_elem 0x0000000000f5aab0 (oninit) ridl_count 0x0000000000d8db5c (oninit) btsplslot 0x0000000000d96b92 (oninit) btsplit 0x0000000000d981e9 (oninit) btusearch 0x0000000000d9a03d (oninit) btadditem 0x0000000000d9c26f (oninit) rsbtadditem 0x000000000152517b (oninit) fm_idxinsert 0x00000000014fdba2 (oninit) fmwrite 0x00000000006ef06c (oninit) aud_sqiswrite 0x00000000008b282f (oninit) chkrowcons 0x0000000000851d00 (oninit) addone 0x0000000000856917 (oninit) insone_next 0x00000000008be8ad (oninit) doinsert 0x00000000005fbf68 (oninit) excommand | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * Insert/Delete mix on compressed index can cause "offset >= * * cs->bc_keysize && offset bc_slotlen" messages. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.05.2019 23.09.2019 23.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |