Re: checkpointer code behaving strangely on postmaster -T

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: checkpointer code behaving strangely on postmaster -T
Date: 2012-05-10 06:27:32
Message-ID: 20840.1336631252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> I noticed while doing some tests that the checkpointer process does not
> recover very nicely after a backend crashes under postmaster -T (after
> all processes have been kill -CONTd, of course, and postmaster told to
> shutdown via Ctrl-C on its console). For some reason it seems to get
> stuck on a loop doing sleep(0.5s) In other case I caught it trying to
> do a checkpoint, but it was progressing a single page each time and then
> sleeping. In that condition, the checkpoint took a very long time to
> finish.

Is this still a problem as of HEAD? I think I've fixed some issues in
the checkpointer's outer loop logic, but not sure if what you saw is
still there.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2012-05-10 06:32:52 Re: bgwriter idle-mode behavior (was Re: Latch for the WAL writer)
Previous Message Robert Haas 2012-05-10 06:01:29 Re: libpq URL syntax vs SQLAlchemy