checkpointer code behaving strangely on postmaster -T

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: checkpointer code behaving strangely on postmaster -T
Date: 2012-03-30 16:31:56
Message-ID: 1333124720-sup-6193@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

Pressing Ctrl-C in the postmaster console at that point does not have
any effect.

--
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Roest 2012-03-30 16:40:44 Re: pg_dump incredibly slow dumping a single schema from a large db
Previous Message Marko Kreen 2012-03-30 16:30:24 Re: Speed dblink using alternate libpq tuple storage