Informix - Problem description
Problem IC61332 | Status: Closed |
SYSMASTER:SYSENVSES QUERY CORRUPTS MEMORY | |
product: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problem description: | |
A query on sysmaster:sysenvses like select envses_name, envses_value from sysmaster:sysenvses where envses_sid = ? corrupts the server's memory. This stays mostly undetected. But some queries containing group by, hash joins or sorts are sensitive to this and can abend the server: 0x0000000100065210 (oninit)afstack 0x000000010005df00 (oninit)mt_ex_throw_sig 0x000000010004aa9c (oninit)afsig_handler 0x000000010097e3d4 (oninit)hash_nextgrprow 0x07000000ac69a930 (*nosymtab*)0x7000000ac69a930 0x0000000100981578 (oninit)unordered_group_by_next .... 0x0000000100065210 (oninit)afstack 0x000000010005df00 (oninit)mt_ex_throw_sig 0x000000010004aa9c (oninit)afsig_handler 0x00000001000d5718 (oninit)ldlong 0x0000000000000000 (*nosymtab*)0x0 0x0000000000000000 (*nosymtab*)0x0 0x0000000100428464 (oninit)srtcompare 0x00000001004309a0 (oninit)srtquick_90_7 0x0000000100429c04 (oninit)psrtloop 0x0000000100b7c5ec (oninit)startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users querying the sysmaster tables sysenvses or sysenv * **************************************************************** * PROBLEM DESCRIPTION: * * Querying sysmaster tables sysenvses or sysenv corrupted one * * byte of memory, which in some cases could lead to a failure * * and server shutdown later on. * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.50.xC5 and above. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem first fixed in IDS 11.50.xC5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2009 19.01.2010 19.01.2010 |
Problem solved at the following versions (IBM BugInfos) | |
11.50.xC5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.50.xC5 |