| Latest versions | fixlist |
| 15.0.xC1.2 |
 |
| 14.10.xC13.3 |
|
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |