Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS

From:	Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To:	Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc:	Bruce Momjian <bruce(at)momjian(dot)us>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Anthony Iliopoulos <ailiop(at)altatus(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Catalin Iacob <iacobcatalin(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Date:	2018-04-05 23:37:42
Message-ID:	87po3di5vd.fsf@news-spur.riddles.org.uk
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-03-28 02:23:46 from Craig Ringer <craig(at)2ndquadrant(dot)com>  2018-03-28 03:53:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2018-03-29 02:30:59 from Michael Paquier <michael(at)paquier(dot)xyz>    2018-03-29 02:48:27 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>     2018-03-29 05:00:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎      2018-03-29 05:06:22 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>       2018-03-29 05:25:51 from Craig Ringer <craig(at)2ndquadrant(dot)com>        2018-04-21 19:21:39 from Gasper Zejn <zejn(at)owca(dot)info>     2018-03-29 05:32:43 from Craig Ringer <craig(at)2ndquadrant(dot)com>    2018-03-29 05:35:47 from Craig Ringer <craig(at)2ndquadrant(dot)com>   2018-03-29 05:58:45 from Craig Ringer <craig(at)2ndquadrant(dot)com>    2018-03-29 12:07:56 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>     2018-03-29 13:15:10 from Craig Ringer <craig(at)2ndquadrant(dot)com>     2018-03-29 16:20:00 from Catalin Iacob <iacobcatalin(at)gmail(dot)com>      2018-03-29 21:18:14 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>       2018-03-31 13:24:28 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>        2018-03-31 16:13:09 from Craig Ringer <craig(at)2ndquadrant(dot)com>         2018-03-31 16:38:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2018-04-01 00:20:38 from Michael Paquier <michael(at)paquier(dot)xyz>          2018-04-01 01:14:46 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>           2018-04-02 18:13:46 from Andres Freund <andres(at)anarazel(dot)de>            2018-04-02 18:53:20 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>             2018-04-02 19:32:45 from Andres Freund <andres(at)anarazel(dot)de>              2018-04-02 20:38:06 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>               2018-04-02 20:58:08 from Stephen Frost <sfrost(at)snowman(dot)net>                2018-04-02 23:05:44 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                 2018-04-02 23:23:24 from Andres Freund <andres(at)anarazel(dot)de>                 2018-04-02 23:27:35 from Craig Ringer <craig(at)2ndquadrant(dot)com>                  2018-04-03 00:03:39 from Christophe Pettus <xof(at)thebuild(dot)com>                   2018-04-03 00:05:09 from Andres Freund <andres(at)anarazel(dot)de>                    2018-04-03 00:07:41 from Christophe Pettus <xof(at)thebuild(dot)com>                    2018-04-03 00:48:00 from Peter Geoghegan <pg(at)bowt(dot)ie>             2018-04-03 02:54:26 from Robert Haas <robertmhaas(at)gmail(dot)com>              2018-04-03 03:45:30 from Peter Geoghegan <pg(at)bowt(dot)ie>              2018-04-03 10:35:39 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>               2018-04-03 11:26:05 from Greg Stark <stark(at)mit(dot)edu>                2018-04-03 13:36:47 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                 2018-04-03 14:37:30 from Greg Stark <stark(at)mit(dot)edu>                  2018-04-03 16:52:07 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>               2018-04-03 21:47:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                2018-04-04 00:56:37 from Bruce Momjian <bruce(at)momjian(dot)us>                 2018-04-04 01:54:50 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                  2018-04-04 02:05:19 from Bruce Momjian <bruce(at)momjian(dot)us>                   2018-04-04 02:14:28 from Bruce Momjian <bruce(at)momjian(dot)us>                    2018-04-04 02:44:22 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                     2018-04-04 05:29:28 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                      2018-04-04 06:00:21 from Craig Ringer <craig(at)2ndquadrant(dot)com>                       2018-04-04 07:32:04 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                        2018-04-04 13:49:38 from Bruce Momjian <bruce(at)momjian(dot)us>                         2018-04-04 15:23:51 from Craig Ringer <craig(at)2ndquadrant(dot)com>                          2018-04-04 17:51:03 from Bruce Momjian <bruce(at)momjian(dot)us>                          2018-04-05 23:37:42 from Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>                           2018-04-06 01:27:05 from Craig Ringer <craig(at)2ndquadrant(dot)com>                            2018-04-06 02:53:56 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> 📎                             2018-04-06 03:20:22 from Craig Ringer <craig(at)2ndquadrant(dot)com>                              2018-04-08 02:16:07 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                               2018-04-08 02:33:37 from Bruce Momjian <bruce(at)momjian(dot)us>                                2018-04-08 02:37:47 from Christophe Pettus <xof(at)thebuild(dot)com>                               2018-04-08 03:27:45 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                2018-04-08 03:37:06 from Peter Geoghegan <pg(at)bowt(dot)ie>                                2018-04-08 03:46:17 from Christophe Pettus <xof(at)thebuild(dot)com>                                 2018-04-08 10:30:31 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                  2018-04-08 16:38:03 from Christophe Pettus <xof(at)thebuild(dot)com>                                   2018-04-08 22:29:16 from Bruce Momjian <bruce(at)momjian(dot)us>                                    2018-04-08 23:10:24 from Christophe Pettus <xof(at)thebuild(dot)com>                                    2018-04-08 23:16:25 from Andres Freund <andres(at)anarazel(dot)de>                                     2018-04-08 23:27:57 from Christophe Pettus <xof(at)thebuild(dot)com>                                      2018-04-09 01:55:10 from Andres Freund <andres(at)anarazel(dot)de>                                     2018-04-09 02:00:41 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                      2018-04-09 02:06:12 from Andres Freund <andres(at)anarazel(dot)de>                                       2018-04-09 03:15:01 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                      2018-04-09 13:54:19 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                    2018-04-09 01:35:06 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                    2018-04-09 13:42:35 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                     2018-04-09 13:47:03 from Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>                                     2018-04-09 18:02:21 from Gasper Zejn <zejn(at)owca(dot)info>                                     2018-04-17 21:29:17 from Bruce Momjian <bruce(at)momjian(dot)us>                                      2018-04-17 21:34:53 from Andres Freund <andres(at)anarazel(dot)de>                                       2018-04-18 09:52:22 from Bruce Momjian <bruce(at)momjian(dot)us>                                     2018-04-17 21:32:45 from Bruce Momjian <bruce(at)momjian(dot)us>                                      2018-04-17 21:41:42 from Andres Freund <andres(at)anarazel(dot)de>                                       2018-04-18 11:56:57 from Bruce Momjian <bruce(at)momjian(dot)us> 📎                                2018-04-08 09:41:06 from Andreas Karlsson <andreas(at)proxel(dot)se>                                 2018-04-08 10:31:24 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                2018-04-08 21:23:21 from Greg Stark <stark(at)mit(dot)edu>                                 2018-04-08 21:28:43 from Christophe Pettus <xof(at)thebuild(dot)com>                                  2018-04-09 01:31:56 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                 2018-04-08 21:47:04 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                  2018-04-09 08:45:40 from Greg Stark <stark(at)mit(dot)edu>                                   2018-04-09 10:50:41 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                    2018-04-09 12:03:28 from Geoff Winkless <pgsqladmin(at)geoff(dot)dj>                                     2018-04-09 12:31:27 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                      2018-04-09 13:33:18 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                       2018-04-09 14:22:06 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                        2018-04-09 15:29:36 from Greg Stark <stark(at)mit(dot)edu>                                         2018-04-09 19:26:21 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                          2018-04-09 19:29:16 from Andres Freund <andres(at)anarazel(dot)de>                                           2018-04-09 19:44:31 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                          2018-04-09 19:37:03 from Andres Freund <andres(at)anarazel(dot)de>                                           2018-04-09 19:51:12 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                           2018-04-09 19:54:05 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                            2018-04-09 20:04:20 from Andres Freund <andres(at)anarazel(dot)de>                                             2018-04-09 20:30:00 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                              2018-04-09 20:37:31 from Andres Freund <andres(at)anarazel(dot)de>                                               2018-04-10 01:59:03 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                                2018-04-10 02:00:59 from Andres Freund <andres(at)anarazel(dot)de>                                                2018-04-10 16:54:40 from Greg Stark <stark(at)mit(dot)edu>                                                 2018-04-10 18:58:37 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                                                  2018-04-10 19:51:01 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                                                   2018-04-10 20:57:34 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                                                  2018-04-11 12:23:49 from Greg Stark <stark(at)mit(dot)edu>                                                 2018-04-17 21:19:53 from Bruce Momjian <bruce(at)momjian(dot)us>                                                  2018-04-18 10:04:30 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                                   2018-04-18 11:46:15 from Bruce Momjian <bruce(at)momjian(dot)us>                                                    2018-04-18 12:45:53 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                                     2018-04-18 23:31:50 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>                                                      2018-04-19 00:44:33 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                                     2018-04-20 20:49:08 from Bruce Momjian <bruce(at)momjian(dot)us>                                        2018-04-09 19:47:44 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                        2018-04-09 22:33:16 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                                         2018-04-10 00:32:20 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                                    2018-04-09 12:16:38 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                     2018-04-09 12:54:16 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                      2018-04-09 19:41:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                       2018-04-09 19:59:34 from Andres Freund <andres(at)anarazel(dot)de>                                        2018-04-10 01:44:59 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                         2018-04-10 01:52:21 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                                     2018-04-09 16:45:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                                      2018-04-09 17:26:24 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                                       2018-04-09 18:29:42 from Mark Dilger <hornschnorter(at)gmail(dot)com>                                        2018-04-09 19:22:58 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                      2018-04-09 19:02:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2018-04-09 19:13:14 from Andres Freund <andres(at)anarazel(dot)de>                                        2018-04-09 19:25:33 from Peter Geoghegan <pg(at)bowt(dot)ie>                                         2018-04-17 21:49:42 from Bruce Momjian <bruce(at)momjian(dot)us>                                        2018-04-09 20:25:54 from Mark Dilger <hornschnorter(at)gmail(dot)com>                                         2018-04-09 20:34:15 from Andres Freund <andres(at)anarazel(dot)de>                                         2018-04-09 20:43:03 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                          2018-04-09 20:55:29 from Mark Dilger <hornschnorter(at)gmail(dot)com>                                           2018-04-09 21:08:29 from Andres Freund <andres(at)anarazel(dot)de>                                            2018-04-09 21:25:52 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                             2018-04-09 21:33:29 from Mark Dilger <hornschnorter(at)gmail(dot)com>                                         2018-04-10 01:54:30 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                        2018-04-10 15:15:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2018-04-10 15:40:05 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>                                          2018-04-10 16:38:27 from Greg Stark <stark(at)mit(dot)edu>                                          2018-04-11 12:05:27 from Jonathan Corbet <corbet(at)lwn(dot)net>                                           2018-04-11 14:29:09 from Andres Freund <andres(at)anarazel(dot)de>                                            2018-04-11 14:40:31 from Jonathan Corbet <corbet(at)lwn(dot)net>                                       2018-04-10 05:04:13 from Michael Paquier <michael(at)paquier(dot)xyz>                                        2018-04-10 05:37:19 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                         2018-04-10 06:10:21 from Michael Paquier <michael(at)paquier(dot)xyz>                                          2018-04-10 12:15:15 from Craig Ringer <craig(at)2ndquadrant(dot)com> 📎                                           2018-04-18 10:19:28 from Craig Ringer <craig(at)2ndquadrant(dot)com>                                         2018-04-10 15:28:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2018-04-10 00:41:10 from Andreas Karlsson <andreas(at)proxel(dot)se>                                      2018-04-10 02:02:48 from Craig Ringer <craig(at)2ndquadrant(dot)com>                         2018-04-04 17:23:58 from Gasper Zejn <zejn(at)owca(dot)info>                       2018-04-04 07:51:53 from Craig Ringer <craig(at)2ndquadrant(dot)com>                        2018-04-04 14:00:15 from Craig Ringer <craig(at)2ndquadrant(dot)com>                         2018-04-04 14:09:09 from Craig Ringer <craig(at)2ndquadrant(dot)com>                          2018-04-04 14:25:47 from Bruce Momjian <bruce(at)momjian(dot)us>                           2018-04-04 14:42:18 from Craig Ringer <craig(at)2ndquadrant(dot)com>                            2018-04-04 15:23:31 from Antonis Iliopoulos <ailiop(at)altatus(dot)com>                         2018-04-04 21:28:09 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                          2018-04-04 22:14:24 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>                2018-04-04 02:40:16 from Craig Ringer <craig(at)2ndquadrant(dot)com>                 2018-04-04 13:53:01 from Bruce Momjian <bruce(at)momjian(dot)us>              2018-04-03 14:29:10 from Craig Ringer <craig(at)2ndquadrant(dot)com>         2018-04-01 00:58:22 from Anthony Iliopoulos <ailiop(at)altatus(dot)com>       2018-04-01 18:24:51 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>        2018-04-02 15:03:42 from Craig Ringer <craig(at)2ndquadrant(dot)com>         2018-04-03 01:29:28 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>          2018-04-03 23:59:27 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>  2018-04-05 07:09:57 from Craig Ringer <craig(at)2ndquadrant(dot)com>   2018-04-05 08:46:08 from Craig Ringer <craig(at)2ndquadrant(dot)com>   2018-04-05 19:33:14 from Bruce Momjian <bruce(at)momjian(dot)us>  2018-04-23 20:14:48 from Andres Freund <andres(at)anarazel(dot)de>   2018-04-24 00:09:23 from Bruce Momjian <bruce(at)momjian(dot)us>    2018-04-27 01:18:55 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>   2018-04-26 02:16:52 from Craig Ringer <craig(at)2ndquadrant(dot)com>    2018-04-30 04:55:22 from Craig Ringer <craig(at)2ndquadrant(dot)com>
Lists:	pgsql-hackers

In response to

• Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS at 2018-04-04 15:23:51 from Craig Ringer

Responses

• Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS at 2018-04-06 01:27:05 from Craig Ringer

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Alexander Korotkov	2018-04-05 23:43:18	Re: [HACKERS] [PATCH] Incremental sort
Previous Message	Thomas Munro	2018-04-05 23:36:39	Re: Checkpoint not retrying failed fsync?