INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Every few hours the instance comes to a nearly complete hang.

I see a lot of threads in either "yield time" or "yield forever"
with this stacks:

Stack for thread: 225119 sqlexec
 base: 0x00000000c464a000
  len:   135168
   pc: 0x000000000140e8a6
  tos: 0x00000000c46693b0
state: sleeping
   vp: 9

(oninit) yield_processor_mvp
(oninit) mt_yield
(oninit) ra_terminate_req
(oninit) ra_free_req
(oninit) opfree
(oninit) rsclose
(oninit) fm_closefrags
(oninit) fmclose
(oninit) sqisclose
(oninit) closerel
(oninit) scan_free
(oninit) close_cb_subtree_r
(oninit) close_cb_subtree
(oninit) closesdb
(oninit) doreleasesdb


Stack for thread: 224360 sqlexec
 base: 0x0000000134448000
  len:   135168
   pc: 0x000000000140e8a6
  tos: 0x0000000134465cf0
state: sleeping
   vp: 9:n

(oninit) yield_processor_mvp
(oninit) mt_yield
(oninit) mt_get_ticket
(oninit) get_db_from_sproccache
(oninit) get_sysdbprocids
(oninit) ddopen
(oninit) dbopen
(oninit) find_db
(oninit) sqopendb
(oninit) sq_dbopen
(oninit) sqmain


All readahead are waiting for a buffer. Buffer is owned by ffff
which is readahead.


Stack for thread: 526 readahead_0
 base: 0x0000000059bd9000
  len:   69632
   pc: 0x000000000140e8a6
  tos: 0x0000000059be9550
state: sleeping
   vp: 12

(oninit) yield_processor_mvp
(oninit) mt_yield
(oninit) bf_bfwait
(oninit) buffget
(oninit) readahead_daemon
(oninit) th_init_initgls
(oninit) startup

Userthreads
address          flags   sessid   user     tty      wait
tout locks nreads   nwrites

59958208         B--PR-D 390      informix -        4fd4638d8
0    0     16356266 0
5996a008         B--PR-D 2811     informix -        4d9e7a638
0    0     16041865 0
637705c8         B--PR-D 3526     informix -        4e1bae398
0    0     2640715  0
637b3f38         B--PR-D 4648     informix -        4e2394058
0    0     2582332  0
5997c6f8         B--PR-- 27962    afv      -        4e211d978
0    1     56       0

Buffers
address           userthread        flgs pagenum
memaddr           nslots pgflgs xflgs owner             waitlist

Buffer pool page size: 2048
4d9e7a638        0                84   79:15494719
5e1cdf800        6      801    80    ffffffffffffffff 5996a008
4e1bae398        0                84   4:12733239
645f77000        7      801    80    ffffffffffffffff 637705c8
4e211d978        0                84   7:12939304
64a508800        3      801    80    ffffffffffffffff 5997c6f8
4e2394058        0                84   7:12849830
64c48e000        56     801    80    ffffffffffffffff 637b3f38

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC12.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Sqlexec(s) are hanging in ra_terminate_req().                *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.12.2018
04.10.2019
04.10.2019

12.10.xC12