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 |