Re: Oninit from cron leaves engine in permanent fast recovery
Hi Dave
Forced residency is off. We are not using NOAGE as have moved to
VPCLASS. We have, however, switched it on in the cpu VPCLASS entry.
It is supported according to the release notes and will be set to the
default prioritx of 60 as the IFMX_CPUVP_PRIORITY environment variable
is not set.
I think I now have the wherewithall to get a stack dump from the oninit
core file. Trying now.
The engine is in Fast Recovery, but there were no open transactions.
There is no transaction logging on any of the databases!
There is NO difference between onstat l commands run at one (or two, or
any) minute intervals. Not even the uptime as this is not changing
while the instance is in FR mode.
onstat -g ath shows;
IBM Informix Dynamic Server Version 9.40.FC6 -- Fast Recovery -- Up
00:00:06 -- 1633776 Kbytes
Threads: tid tcb rstcb prty status
vp-class name
2 700000050d205f8 0 2 sleeping forever
5lio lio vp 0
3 700000050d4e1f8 0 2 sleeping forever
6pio pio vp 0
4 700000050d6e1f8 0 2 sleeping forever
7aio aio vp 0
5 700000050d8e1f8 0 2 sleeping forever
8msc msc vp 0
6 700000050dc61f8 0 2 sleeping forever
9aio aio vp 1
7 700000050de6418 700000050371028 4 sleeping secs: 1
1cpu main_loop()
8 700000050d6e500 0 2 sleeping forever
1cpu sm_poll
9 700000050e21aa8 0 2 running
10soc soctcppoll
10 700000050e32d88 0 2 running
11soc soctcppoll
11 700000050e4bd88 0 2 running
12soc soctcppoll
12 700000050e64d88 0 2 running
13soc soctcppoll
13 700000050e7dd88 0 2 cond wait muxcon_ava
1cpu sqlmuxlst
14 700000050e93b30 0 3 sleeping forever
1cpu sm_listen
15 700000050ec74f0 0 2 sleeping secs: 1
1cpu sm_discon
16 700000050ed42d0 0 3 sleeping forever
1cpu soctcplst
17 700000050eea570 0 3 sleeping forever
1cpu soctcplst
18 700000050f02780 0 3 sleeping forever
1cpu soctcplst
19 700000050f19a20 0 3 sleeping forever
1cpu soctcplst
20 700000050f312d0 700000050371850 2 sleeping forever
1cpu flush_sub(0)
21 700000050f315d8 700000050372078 2 sleeping forever
1cpu flush_sub(1)
22 700000050f318e0 7000000503728a0 2 sleeping forever
1cpu flush_sub(2)
23 700000050f31be8 7000000503730c8 2 sleeping forever
1cpu flush_sub(3)
24 700000050f61028 7000000503738f0 2 sleeping forever
1cpu flush_sub(4)
25 700000050f61330 700000050374118 2 sleeping forever
1cpu flush_sub(5)
26 700000050f61740 0 4 sleeping forever
1cpu kaio
27 700000051107798 700000050374940 3 sleeping forever
1cpu aslogflush
28 7000000511321c0 700000050375168 1 sleeping secs: 2
1cpu btscanner 0
29 700000051132c38 700000050375990 2 ready
1cpu fast_rec
30 7000000511969d8 7000000503761b8 2 sleeping secs: 1
1cpu bld_logrecs
31 700000051196c78 7000000503769e0 2 cond wait packet_con
1cpu logredo
32 7000000514678e8 700000050377208 2 cond wait packet_con
1cpu xchg_1.0
33 700000051467bf0 700000050377a30 2 cond wait packet_con
1cpu xchg_1.1
34 700000051491028 700000050378258 2 cond wait packet_con
1cpu xchg_1.2
35 700000051491330 700000050378a80 2 cond wait packet_con
1cpu xchg_1.3
36 700000051491638 7000000503792a8 2 cond wait packet_con
1cpu xchg_1.4
37 700000051491940 700000050379ad0 2 cond wait packet_con
1cpu xchg_1.5
38 700000051491c48 70000005037a2f8 2 cond wait packet_con
1cpu xchg_1.6
39 7000000514f1028 70000005037ab20 2 cond wait packet_con
1cpu xchg_1.7
40 7000000514f1330 70000005037b348 2 cond wait packet_con
1cpu xchg_1.8
41 7000000514f1638 70000005037bb70 2 cond wait packet_con
1cpu xchg_1.9
42 70000005152c550 70000005037c398 2 sleeping secs: 1
1cpu xchg_2.0
There is no change after ... any amount of time (that is reasonable to
test).
Same applies to onstat -p mate, apart from usercpu (going up) and
syscpu (fluctuating slightly +/-). The engine does not appear to be
doing anything!!!!
Thanks for the suggestions.
Gerry