Informix - Problembeschreibung
Problem IT27557 | Status: Geschlossen |
SQLEXEC (S) ARE HANGING IN RA_TERMINATE_REQ() | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC12. * **************************************************************** * PROBLEM DESCRIPTION: * * Sqlexec(s) are hanging in ra_terminate_req(). * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.12.2018 04.10.2019 04.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC12 | |
Problem behoben lt. FixList in der Version |