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 | |
12.10.xC5 | |
12.10.xC5.W1 |