Re: recovering from "found xmin ... from before relfrozenxid ..."

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:	Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, MBeena Emerson <mbeena(dot)emerson(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject:	Re: recovering from "found xmin ... from before relfrozenxid ..."
Date:	2020-09-16 18:44:39
Message-ID:	1749805.1600281879@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-07-13 21:12:18 from Robert Haas <robertmhaas(at)gmail(dot)com>  2020-07-13 21:28:25 from Stephen Frost <sfrost(at)snowman(dot)net>   2020-07-13 22:15:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2020-07-14 00:41:22 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-07-14 01:29:10 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>      2020-07-14 14:09:05 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-07-14 07:08:22 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>      2020-07-14 11:51:27 from Robert Haas <robertmhaas(at)gmail(dot)com>       2020-07-14 19:41:59 from Andres Freund <andres(at)anarazel(dot)de>        2020-07-14 19:59:21 from Robert Haas <robertmhaas(at)gmail(dot)com>         2020-07-15 15:41:18 from Andres Freund <andres(at)anarazel(dot)de>          2020-07-16 14:00:40 from Robert Haas <robertmhaas(at)gmail(dot)com>           2020-07-16 16:14:35 from Robert Haas <robertmhaas(at)gmail(dot)com>            2020-07-24 09:05:08 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎             2020-07-26 17:54:35 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>              2020-07-27 04:36:54 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>               2020-07-28 08:22:47 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                2020-07-29 04:28:08 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                 2020-07-31 12:32:24 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                  2020-07-31 14:57:22 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>             2020-07-28 20:42:12 from MBeena Emerson <mbeena(dot)emerson(at)gmail(dot)com>              2020-07-29 04:37:49 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>               2020-07-31 12:52:23 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                2020-07-31 18:47:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2020-08-03 09:05:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                  2020-08-03 13:35:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2020-08-03 16:13:04 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                    2020-08-05 19:34:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2020-08-06 06:03:04 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                 2020-08-05 13:42:02 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                  2020-08-05 19:58:56 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2020-08-06 06:11:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                    2020-08-06 15:48:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                     2020-08-07 06:31:47 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                  2020-08-06 08:11:27 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                   2020-08-06 08:55:35 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>                    2020-08-07 07:15:17 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                   2020-08-06 09:05:42 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                    2020-08-06 09:19:20 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                     2020-08-06 13:23:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                      2020-08-07 15:50:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2020-08-11 07:38:48 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                        2020-08-11 14:03:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                         2020-08-11 14:47:30 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                       2020-08-12 13:26:52 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                        2020-08-13 07:06:14 from Asim Praveen <pasim(at)vmware(dot)com>                         2020-08-13 07:52:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                          2020-08-13 19:03:16 from Robert Haas <robertmhaas(at)gmail(dot)com>                        2020-08-14 04:36:55 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                         2020-08-17 06:05:06 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                          2020-08-18 08:16:48 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                           2020-08-18 11:21:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                          2020-08-18 16:14:53 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                           2020-08-19 04:27:25 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                           2020-08-24 13:45:42 from Robert Haas <robertmhaas(at)gmail(dot)com>                            2020-08-25 04:43:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                          2020-08-19 03:56:45 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                           2020-08-19 06:09:41 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                            2020-08-19 10:25:03 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                             2020-08-19 11:45:06 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                              2020-08-20 05:33:44 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                               2020-08-20 06:13:49 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                2020-08-21 13:24:58 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                                 2020-08-24 17:30:19 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                                  2020-08-25 04:57:44 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                 2020-08-25 08:08:53 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                  2020-08-25 12:17:05 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                   2020-08-25 18:21:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                                    2020-08-26 01:48:49 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                   2020-08-26 11:36:09 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                                    2020-08-26 15:49:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2020-08-27 02:26:21 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                      2020-08-27 20:14:02 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                       2020-08-28 02:52:50 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                       2020-08-28 08:06:27 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                        2020-08-28 14:38:56 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2020-09-01 09:16:06 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                                    2020-08-27 20:41:31 from Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>                                     2020-08-28 03:10:46 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                      2020-08-28 09:55:19 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                                       2020-08-28 14:08:55 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2020-09-10 15:21:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                        2020-09-10 17:54:24 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                        2020-09-12 22:00:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2020-09-14 10:26:07 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                                          2020-09-15 19:36:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                           2020-09-15 19:54:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2020-09-16 03:17:00 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                             2020-09-16 03:44:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                              2020-09-16 05:10:26 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                               2020-09-16 05:48:46 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> 📎                                                2020-09-16 15:13:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2020-09-16 15:48:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                  2020-09-16 18:34:37 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                                   2020-09-16 18:44:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                    2020-09-17 02:27:27 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                                     2020-09-18 17:27:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                      2020-09-18 22:32:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                       2020-09-19 12:28:14 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                        2020-09-19 14:52:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                         2020-09-19 20:19:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                          2020-09-20 17:13:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                           2020-09-21 02:39:20 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>                                                           2020-09-21 03:31:48 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                            2020-09-21 14:27:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2020-09-21 18:04:33 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                            2020-09-21 18:21:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                             2020-09-21 20:02:29 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                              2020-09-21 20:11:20 from Andres Freund <andres(at)anarazel(dot)de>                                                               2021-03-15 03:17:28 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                              2020-09-21 20:22:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2020-09-21 20:32:01 from Andres Freund <andres(at)anarazel(dot)de>                                                            2020-09-21 20:40:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                             2020-09-21 21:01:09 from Andres Freund <andres(at)anarazel(dot)de>                                                              2020-09-21 21:03:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                               2020-09-21 21:20:03 from Andres Freund <andres(at)anarazel(dot)de>                                                                2020-10-15 08:37:35 from Andres Freund <andres(at)anarazel(dot)de> 📎                                                                 2020-10-28 03:51:10 from Andres Freund <andres(at)anarazel(dot)de> 📎                                                                  2020-10-29 01:13:44 from Andres Freund <andres(at)anarazel(dot)de>                                                                   2020-10-29 02:09:14 from Andres Freund <andres(at)anarazel(dot)de>                                                                    2020-10-29 04:00:30 from Andres Freund <andres(at)anarazel(dot)de>                                                                     2020-10-29 04:57:22 from Andres Freund <andres(at)anarazel(dot)de>                                                                      2021-01-16 15:41:20 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                                                                       2021-01-18 13:54:10 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                        2021-01-18 14:25:38 from Michael Banck <michael(dot)banck(at)credativ(dot)de>                                                                         2021-01-18 14:54:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                        2021-01-18 15:58:04 from Andrey Borodin <x4mmm(at)yandex-team(dot)ru>                                  2020-08-25 12:38:38 from Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>  2020-07-13 22:28:36 from Peter Geoghegan <pg(at)bowt(dot)ie>   2020-08-18 11:29:05 from Chris Travers <chris(dot)travers(at)adjust(dot)com>    2020-08-18 12:18:23 from Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>  2020-07-13 22:38:22 from Andres Freund <andres(at)anarazel(dot)de>   2020-07-14 00:47:10 from Robert Haas <robertmhaas(at)gmail(dot)com>    2020-07-14 00:58:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2020-07-14 01:03:30 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-07-14 01:13:04 from Robert Haas <robertmhaas(at)gmail(dot)com>      2020-07-14 01:26:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2020-07-14 08:59:45 from Magnus Hagander <magnus(at)hagander(dot)net>        2020-07-14 11:52:35 from Robert Haas <robertmhaas(at)gmail(dot)com>         2020-07-14 12:25:35 from Magnus Hagander <magnus(at)hagander(dot)net>          2020-07-14 14:09:39 from Robert Haas <robertmhaas(at)gmail(dot)com>           2020-07-14 14:21:11 from Magnus Hagander <magnus(at)hagander(dot)net>            2020-07-14 14:36:25 from Stephen Frost <sfrost(at)snowman(dot)net>       2020-07-14 10:54:28 from Jochem van Dieten <jochemd(at)gmail(dot)com>    2020-07-14 01:10:11 from Andres Freund <andres(at)anarazel(dot)de>     2020-07-14 01:18:10 from Robert Haas <robertmhaas(at)gmail(dot)com>      2020-07-14 19:31:26 from Andres Freund <andres(at)anarazel(dot)de>   2020-07-14 17:20:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎    2020-07-14 19:36:55 from Andres Freund <andres(at)anarazel(dot)de>     2020-07-14 19:54:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>  2020-07-14 06:25:17 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>  2020-07-29 07:22:38 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>   2020-07-29 13:36:31 from Robert Haas <robertmhaas(at)gmail(dot)com>    2020-07-29 22:29:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: recovering from "found xmin ... from before relfrozenxid ..." at 2020-09-16 18:34:37 from Robert Haas

Responses

• Re: recovering from "found xmin ... from before relfrozenxid ..." at 2020-09-17 02:27:27 from Ashutosh Sharma

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Simon Riggs	2020-09-16 18:54:24	Re: Optimising compactify_tuples()
Previous Message	Tom Lane	2020-09-16 18:40:41	Re: pg_restore causing deadlocks on partitioned tables