Informix - Problem description
Problem IT12202 | Status: Closed |
DEADLOCK BETWEEN LISTENER AND LOWMEMORYMGR CAN CAUSE THE INSTANCE TO GET STUCK IN WAITING FOR THE 'SESSION' MUTEX | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
If you have the LOW_MEMORY_MGR set to 1 in your $ONCONFIG file, the instance starts the LowMemoryMgr thread which looks for idle and memory consuming sessions and kills them. There is a small time window when the LowMemoryMgr thread can get into a deadlock situation with one of the listener threads (sotcplst, sm_listen, etc.). This can lead to the instance becoming unresponsive. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * low memory manager users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Turn off the LMM feature. To stop the LowMemoryMgr thread run: echo "execute function task('scheduler lmm disable')"|dbaccess sysadmin as the 'informix' user. To prevent it to be spawned next time the instance is started change the LOW_MEMORY_MRG parameter setting in your $ONCONFIG file to: LOW_MEMORY_MGR 0 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.11.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |