|
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
|
 |
