Informix - Problem description
Problem IT07918 | Status: Closed |
USING DRDA PROTOCOL A SELECT INVOLVING INTERVAL TYPE CAN SOMETIMES CORRUPT LARGE AMOUNTS OF MEMORY DUE TO UNEXPECTED DATA | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The thread that was found to be corrupting memory was doing so in the following stack: memcpy() SqlPutDataCheck() drda_putcoldata_checksplit() drda_puttuple() exfetch() sql_nfetch() drda_nfetch() _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject() sqljsParse() do_drdamain() drdamain() spawn_thread() th_init_initgls() startup() It was running a query which had the following sub-select which was using the interval data type: select col1, (end_ts - begin_ts)::interval minute(9) to minute as total_time from tab1 It corrupted so much memory that several threads crashed simultaneously with then all kinds of different stack traces. When looking at the memory, it would appear as if the contents of the Informix shared memory had been shifted from 1 location to another. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * 12.10.XCX * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.XC6 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 12.10.XC6 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.03.2015 30.12.2015 30.12.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC6 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC6 |