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 IC61367 Status: Closed

ASSERTION FAILURE OCCURS WHEN SELECTING A DELETED ROW USING THE LAST
COMMITTED OPTION

product:
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50
Problem description:
This problem will corrupt memory and can cause a segv or an 
assert failure to the engine. 
If the LAST COMMITTED option is used with the following query 
the engine will crash with 
various assertion failures. 
 
  set isolation to dirty read; 
  set lock mode to wait; 
  set PDQPRIORITY 10; 
  select max(col2) from customer; 
 
Here are two examples: 
 
oninit :: mt_shm_free_pool 
oninit :: destroy_session 
oninit :: sq_exit 
oninit :: sqmain 
oninit :: listen_verify 
oninit :: spawn_thread 
oninit :: startup 
 
oninit :: gather_records 
oninit :: rsread 
oninit :: fmread 
oninit :: readseq 
oninit :: gettupl 
oninit :: scan_next 
oninit :: producer_thread 
oninit :: startup
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User using 11.50 release                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query using LASTCOMMITTED isolation level can crash the    * 
* server if the row it accesses was deleted by another user.   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS 11.50.xC5 and above.                          * 
****************************************************************
Local Fix:
Solution
Problem is first fixed in IDS 11.50.xC5.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.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 FixList