Informix - Problem description
Problem IT45391 | Status: Closed |
ASSERT FAILURE WHEN USING HASH INDEX AND SPL | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Assert failure like: 14:31:36 Assert Failed: item_to_hashval called with improper item 14:31:36 IBM Informix Dynamic Server Version 14.10.FC10 14:31:36 Who: Session(12906, informix@hostname, 2505911, 0x5c75af80) Thread(13915, sqlexec, 45998e70, 10) File: rsshash.c Line: 71 14:31:36 stack trace for pid 1501294 written to /External/prods/14.10/FC10/tmp/af.3a437c97 14:31:36 See Also: /External/prods/14.10/FC10/tmp/af.3a437c97, shmem.3a437c97.0 14:31:48 item_to_hashval called with improper item 14:31:48 Please run 'oncheck -cI testcases:"informix".htl_rp_mod#htl_rp_mod_k_idx01' 14:31:48 Assert Failed: Code assertion at rsbtcs.c:349 14:31:48 IBM Informix Dynamic Server Version 14.10.FC10 14:31:48 Who: Session(12906, informix@hostname, 2505911, 0x5c75af80) Thread(13915, sqlexec, 45998e70, 10) File: rsdebug.c Line: 3604 14:31:48 Results: rowoff (0x4cab1023) + BT_RIDL_FLAG_SIZE (1) + sizeof(int4) (4) > cs->bc_slotptr (0x4cab1018) + cs->bc_slotlen (12) 14:31:48 Action: Please notify IBM Informix Technical Support. 14:31:48 stack trace for pid 1501294 written to /External/prods/14.10/FC10/tmp/af.3a437c97 14:31:48 See Also: /External/prods/14.10/FC10/tmp/af.3a437c97 14:31:56 Code assertion at rsbtcs.c:349 14:31:56 Please run 'oncheck -cI testcases:"informix".htl_rp_mod#htl_rp_mod_k_idx01' 14:31:56 Assert Failed: Code assertion at rsbtcs.c:349 on a query like: select distinct rp_key from htl_rp_mod base where base.htl_key = prop_key('LONCH') and not exists ( select * from htl_rp_mas hrm where hrm.htl_key = base.htl_key and hrm.rp_key = base.rp_key ) and a hash index for table htl_rp_mas and SPL prop_key(). If the SPL prop_key is removed or if not using hash then no AF for query. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC11. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC11. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC11. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.01.2024 07.06.2024 07.06.2024 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |