IT09280: SDS SQLEXEC THREAD CAN ASSERT FAIL WITH MESSAGE "THREAD EXITED WITH ## BUFFERS HELD" AFTER UPDATE STATS RUN ON PRIMARY OF SDS P

APAR status

• Closed as program error.

Error description

• It is possible for a thread running on a SDS secondary to assert
  fail comparable to:
  
  11:34:00  Assert Failed: Thread exited with 43 buffers held.
  
  11:34:00  IBM Informix Dynamic Server Version 12.10.FC4W1XB
  11:34:00   Who: Session(48447, informix@\ufffd.bE, 4870,
  0x44ce6bd8)
                  Thread(48477, sqlexec, 44cb64a8, 8)
                  File: rsshmem.c Line: 2082
  11:34:00   Results: Dynamic Server must abort
  11:34:00  stack trace for pid 12689 written to
  /opt/informix/tmp/af.c1452c77
  11:34:00   See Also:
  /work2/laube/pmrs/43731_082_000/tmp/af.c1452c77
  11:34:01  Thread ID 48477 will NOT be suspended because
            it is holding a buffer.
  
  Stack for thread: 48477 sqlexec
   base: 0x0000000050e55000
    len:   69632
     pc: 0x0000000001a9a4b1
    tos: 0x0000000050e64610
  state: running
     vp: 8
  
  (oninit) mt_system
  (oninit) afhandler
  (oninit) afcrash_interface
  (oninit) rstcb_cleanup
  (oninit) destroy_session
  (oninit) sq_exit
  (oninit) sqmain
  (oninit) listen_verify
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  
  The problem seems to be related to running update statistics
  high on the primary of a PRI/SDS pair while accessing pages in
  the buffer pool for the sysdistrib table on the SDS secondary.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * informix users                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6
  

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

  IFMX ULT WHSE E

• Fixed component ID

  IM0019BOS

Applicable component levels

• RC10 PSY

     UP