Re: CKPT REQ for 30 minutes

> From: "Pegierski, Micha?" <Michal.Pegierski@wor.tvp.com.pl> > To: "'informix-list@rmy.emory.edu'" <IMCEAX400-c=PL+3Ba=+20+3Bp=TVP+3Bo=WOR+3Bdda+3ASMTP=informix-list+40rmy+2Eemory+2Eedu+3B@tvp.com.pl> > Subject: CKPT REQ for 30 minutes > Date: Thu, 6 Feb 1997 13:43:05 +0100 > Reply-to: "Pegierski, Micha?" <Michal.Pegierski@wor.tvp.com.pl> > Hi, > > We have CKPT REQ for about 30 minutes and I have to shutdown (all > processes were waiting for checkpoint). I did tbstat -o and afterwards > tried to analyze. I don't find anything special. > > We have OnLine 5.05.UC1. > > Any ideas ? We have similar problem several weeks ago. On line 7.11 UC1 Situation looked like this System blocked (CKPT REQ ) - but in the same moment - or before - long transaction fullfilled logical logs system did not aborted long transaction LBU PRESERVE =1 Ltapedev /dev/null and i could not forced checkpoint - long transaction was in critical section - logical logs could not be released I decided to shutdown system but while doing fast recovery it got to the same point. Our informix support told me that it is strange I tried to decrease LTHX... to 20/30 to forced it to abort long trans. I could not get to On line It stayed in fast recovering with the same status Blocked: CKPT REQ . After two-three hours i inicialized it once more , increase Phys.log (to 1/3 of LLs) and decrease LTXHWM/LTXEHWM(50/60). katarina > > Thanks, > > Michal > > -- Katarina Hamzova Voice : +42 7 5384324 SWH s.r.o Bratislava Slovakia Internet : Katarina.Hamzova@swh.sk