IT37932: EXCEPTION DURING QUERY OF SYSSQLSTAT TABLE MAY LEAD TO SESSION HANG

APAR status

• Closed as program error.

Error 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.
  

Local fix

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.          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.10.xC7.
  

Temporary fix

Comments

APAR Information

• 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