Re: [BUGS] Breakage with VACUUM ANALYSE + partitions - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Date
Msg-id alpine.DEB.2.10.1604290916290.23279@sto
Whole thread Raw
In response to Re: [BUGS] Breakage with VACUUM ANALYSE + partitions  (Fabien COELHO <coelho@cri.ensmp.fr>)
List 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.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [sqlsmith] Crash in apply_projection_to_path
Next
From: Amit Kapila
Date:
Subject: Re: [sqlsmith] Failed assertion in BecomeLockGroupLeader