Re: Extended checkpoint times

Felix Koshy Mathews wrote: > anonymous wrote: > > > <snip> > > > We are trying to investigate a series of overly long checkpoints on one > > of our informix databases, here is > > a snippet of the online.log file detailing the events: > > > > <snip> > > > 21:55:42 Checkpoint Completed: duration was 3 seconds. > > 22:03:22 Checkpoint Completed: duration was 155 seconds. <snip> > I have seen even bigger problem "Blocked Checkpoint", we haven't got any > satisfactory solution for this yet. This blocked checkpoint waits for ever > !!!. This "Blocked Checkpoint" is not like any of the cases that we saw in > customer support registry. > <snip> Hi-There, Our "Blocked-Checkpoint" problem have been tracked down to a couple of mutex calls waiting for ever, they showup in "Locked mutexes" and "Mutexes with waiters". Why does it happen ??? neither we nor Informix-Support was able to figure out. Next time when it happens we will try to dump the stack info for those threads of those mutex calls and see whether it explains anything. -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com