Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there - Mailing list pgsql-bugs

From Raphael Hertzog
Subject Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Date
Msg-id 20171107162320.7auot3koc6fkcaoq@home.ouaza.com
Whole thread Raw
In response to Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
On Tue, 07 Nov 2017, Andres Freund wrote:
> > The time
> > to get a fix there is also relatively long. If they work on a fix quickly,
> > it might get merged for Linux 3.15 which we will not have in Kali before
> > 2-3 months too.
> 
> So the same timeframe as a new PG release?

Yes, looks like so.

> > For now, I have added an ugly work-around that creates a file in the
> > pg_commit_ts directory (and immediately drops it) just before starting
> > PostgreSQL:
> > http://git.kali.org/gitweb/?p=packages/kali-defaults.git;a=commitdiff;h=f4287fd774f8d0686ba919f57355215a6b9633e3
> 
> Hm. The comment:
> +    # Ensure the directory is copied over in the tmpfs
> suggests that the overlay isn't persistent? If that's indeed the case,
> you could just disable fsyncs alltogether.

Well, it's the case by default with no persistence. But some users enable
persistence and then it's no longer a tmpfs which is used.

The problem also exists when you enable persistence but start with an
empty upper layer so disabling fsyncs is not really an option.

Cheers,
-- 
Raphaël Hertzog ◈ Debian Developer

Support Debian LTS: https://www.freexian.com/services/debian-lts.html
Learn to master Debian: https://debian-handbook.info/get/


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] Fails to work on live images due to fsync() onpg_commit_ts before doing any write there
Next
From: Alexander Korotkov
Date:
Subject: Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug