Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group