Re: Blocked:CKPT

Hi Micha, Do you have details about SQL orders of these processes in critic= al section (onstat -g sql) ? We used to have the same problem with one of our application, after installing application patches. We removed the patches and the problem disappears, but I still not know why? We also upgraded to 7.30.UC6 but the problem was still remaining. David... Micha Meier a =E9crit : > This happened already the second time but I still don't have > a clue what is wrong. The DB hangs in CKPT: > Informix Dynamic Server Version 7.30.UC2 -- On-Line (CKPT REQ) --= Up 11 days 01:02:58 -- 151488 > Kbytes Blocked:CKPT > > There are 2 oninits which make a busy loop, consume cpu > time and do nothing, this IMHO does not look like being > blocked?? I closed all connections from outside, netstat > shows no open ifx sockets, but the sessions still show > in onstat -u and onstat -g ses as if they existed. > Four of them were in critical sections, so that may be a reason > for blocking: > > 57c693d0 G-BPX-- > 57c69884 --BPX-- > 57c69d38 ---P--D > 57c6a6a0 G-BPX-- > 57c6ab54 G-BPX-- > 57c6b4bc C--P--- > > but I don't understand why oninits make busy loops and why > the sessions do not disappear. All of them were LOCK MODE > WAIT 10, so they should not be blocking infinitely, either. > > Cheers, > > --Micha