Informix - Problem description
Problem IT06474 | Status: Closed |
ERROR 246 ISAM 113 POSSIBLE ON QUERY WITH LOCK MODE SET TO WAIT AND ISOLATION LEVEL COMMITTED READ LAST COMMITTED | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Under certain timing conditions, it's possible for a query using committed read last committed and having lock mode set to wait to return a 246/113 error when it encounters an exclusive table level lock. If using just committed read isolation, the query would correctly wait for the table lock. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * users using last committed in 12.10.UCx * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IBM Informix Server 12.10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.01.2015 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.0 | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |