APAR status
Closed as program error.
Error description
When dealing with the removal of entries from the data dictionary it is possible to get into a state whereby one or more threads wait forever on a mutex. An example output from the onstat -g wmx command: Mutexes with waiters: mid addr name holder lkcnt waiter waittime 3598 c0000000110ca2f0 ddh chain 2 0 2147483647 60 1236 59 1236 57 1236 61 1236 58 1236 55 1193 56 1132 54 752 The value 2147483647 for lkcnt is invalid which results in the thread(s) waiting forever. A typical stack for a thread in this state: yield_processor_mvp mt_lock_wait mt_lock_helper mt_lock decrrefcount_trace rmdiclink_trace closecb close_cb_subtree_r close_cb_subtree closesdb doreleasesdb sq_release_workhorse sq_release sqmain listen_verify spawn_thread th_init_initgls A restart of the Informix server is necessary to resolve this problem.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server 14.10.xC7*. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC8. * ****************************************************************
Problem conclusion
Fixed in Informix Server 14.10.xC8.
Temporary fix
Comments
APAR Information
APAR number
IT40221
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
E10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-03-09
Closed date
2022-04-08
Last modified date
2022-04-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]
Document Information
Modified date:
09 April 2022