Informix - Problem description
Problem IT37932 | Status: Closed |
EXCEPTION DURING QUERY OF SYSSQLSTAT TABLE MAY LEAD TO SESSION HANG | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
If an exception is raised during the processing of a query relating to the sysmaster table syssqlstat the clean up operation may result in a further exception resulting in a loop of the sqlexec thread. At the same time other threads may become blocked waiting on the session mutex. As the problem thread is in a running state the stack obtained via onstat may be unreliable. Use the onmode -X stack command or an OS command such as pstack to obtain a stack: sigprocmask() mt_sighold() mt_ex_throw_sig() mt_ex_end_keep_var() prsqlstat() pstread() rsread() fmread() readseq_single() gettupl() scan_next() next_row.part() get_first_row_from_producer() group_open() prepselect() open_cursor() sq_open() sqmain() spawn_thread() th_init_initgls() startup() This problem is first seen in versions where IT35916 is fixed. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.08.2021 02.11.2021 02.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |