|
Problem IT27557
|
Status: Closed |
SQLEXEC (S) ARE HANGING IN RA_TERMINATE_REQ()
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC12. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Sqlexec(s) are hanging in ra_terminate_req(). *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.12.2018
04.10.2019
04.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC12
|
| Problem solved according to the fixlist(s) of the following version(s) |
