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-29 07:22:18
Message-ID: alpine.DEB.2.10.1604290916290.23279@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


An interesting complement about the previous failing test:

Although I disabled the "flushing" feature...

sh> grep flush_after xxx/postgresql.conf
bgwriter_flush_after = 0 # 0 disables,
backend_flush_after = 0 # 0 disables,
wal_writer_flush_after = 0 # 0 disables
checkpoint_flush_after = 0 # 0 disables,

the test still fails with "head":

...
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;

So this seem to suggest that there is an underlying issue independent from
the flushing file.

--
Fabien.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message m.giraldo 2016-04-29 10:35:46 BUG #14121: Constraint UNIQUE
Previous Message Magnus Hagander 2016-04-29 07:16:58 Re: streaming replication master can fail to shut down

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-04-29 07:40:24 Re: [sqlsmith] Failed assertion in BecomeLockGroupLeader
Previous Message Amit Kapila 2016-04-29 07:14:07 Re: [sqlsmith] Crash in apply_projection_to_path