Re: [BUGS] Breakage with VACUUM ANALYSE + partitions

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Date: 2016-04-28 19:36:56
Message-ID: alpine.DEB.2.10.1604282127590.8824@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


> createdb: database creation failed: ERROR: checkpoint request failed
> HINT: Consult recent messages in the server log for details.

Attached is a simpler/faster version, based on the previous script, I just
added a CHECKPOINT after the EXPLAIN ANALYSE.

It fails on head with:

HINT: Consider increasing the configuration parameter "max_wal_size".
ERROR: canceling autovacuum task
CONTEXT: automatic vacuum of table "fabien.public.pgbench_accounts"
ERROR: canceling autovacuum task
CONTEXT: automatic analyze of table "fabien.public.pgbench_accounts_1"
ERROR: canceling autovacuum task
CONTEXT: automatic analyze of table "fabien.public.pgbench_accounts_2"
ERROR: could not fsync file "base/16384/16397.1": No such file or directory
ERROR: checkpoint request failed
HINT: Consult recent messages in the server log for details.
STATEMENT: CHECKPOINT;

I tried it on pg prior to the flushing patches and it did not fail, so it
seems to be related somehow. Probably the fix is similar, just some
conditions to check when dealing with a file which has been removed by a
large DELETE.

--
Fabien.

Attachment Content-Type Size
xxx.sh application/x-sh 174 bytes
xxx.sql application/x-sql 1.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2016-04-28 20:29:10 Re: Add jsonb_compact(...) for whitespace-free jsonb to text
Previous Message Simon Riggs 2016-04-28 19:32:37 Re: 9.6 and fsync=off

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-04-29 01:10:38 Re: BUG #14107: Major query planner bug regarding subqueries and indices
Previous Message Mathias Kunter 2016-04-28 19:07:00 Re: BUG #14107: Major query planner bug regarding subqueries and indices