home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IC99929 Status: Closed

A SIMPLE SELECT ON A TABLE HAVING A FUNCTIONAL INDEX ON CRCOLS COLUMN
CDRTIME CAN CRASH THE SERVER OR LEAD TO -959/-172 ERRORS

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem description:
If you create a functional index on one of the crcol columns, 
namely 'cdrtime', 
and subsequently run a 'select * from <table>', 
this can crash the server with a stack like or similar to the 
following: 
 
(oninit) afstack 
(oninit) mt_ex_throw_sig 
(oninit) afsig_handler 
(Linux) <signal frame> 
(/lib64/libc-2.9.so) strlen 
(oninit) ddrindexes 
(oninit) readcats 
(oninit) readtab 
(oninit) ddgettable_hierarchy 
(oninit) ddgettable 
(oninit) aud_ddgettable 
(oninit) gettab 
(oninit) tlgetddtab 
(oninit) tlp2tnode 
(oninit) tbl2tab 
(oninit) sel2cb 
(oninit) qblk2cb 
(oninit) stmt2cb 
(oninit) p_sp2cb 
(oninit) parsecmd 
(oninit) sqcmd 
(oninit) sq_cmnd 
(oninit) sq_prepare 
(oninit) sqmain 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup 
 
Possibly you will also experience -959/-172 errors when trying 
to access the database afterwards.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Functional index on CRCOLS                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC4                                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IDS-12.10.xC4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
07.03.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC4.W1 FixList
12.10.xC5 FixList
12.10.xC5.W1 FixList