RE: long-standing data loss bug in initial sync of logical replication

From:	"Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To:	PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc:	"Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Nitin Motiani <nitinmotiani(at)google(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Subject:	RE: long-standing data loss bug in initial sync of logical replication
Date:	2025-03-13 05:29:30
Message-ID:	OSCPR01MB1496603D576E249557B277F12F5D32@OSCPR01MB14966.jpnprd01.prod.outlook.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2023-11-17 14:36:25 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎  2023-11-18 01:54:43 from Andres Freund <andres(at)anarazel(dot)de>   2023-11-18 02:54:45 from Andres Freund <andres(at)anarazel(dot)de>    2023-11-18 10:56:47 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>     2023-11-18 18:12:57 from Andres Freund <andres(at)anarazel(dot)de>      2023-11-18 20:45:35 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>       2023-11-18 21:05:19 from Andres Freund <andres(at)anarazel(dot)de>        2023-11-19 01:15:33 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>         2023-11-19 02:18:30 from Andres Freund <andres(at)anarazel(dot)de>          2024-01-16 10:24:02 from Vadim Lakt <vadim(dot)lakt(at)gmail(dot)com> 📎          2024-06-24 10:54:38 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2024-06-24 14:36:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>            2024-06-25 05:04:58 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>             2024-06-26 11:27:17 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>              2024-06-27 03:08:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>               2024-07-01 05:20:52 from vignesh C <vignesh21(at)gmail(dot)com> 📎                2024-07-09 11:35:04 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                 2024-07-09 14:43:42 from vignesh C <vignesh21(at)gmail(dot)com> 📎                  2024-07-10 06:58:41 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                   2024-07-10 16:37:29 from vignesh C <vignesh21(at)gmail(dot)com> 📎                    2024-07-10 17:52:36 from Nitin Motiani <nitinmotiani(at)google(dot)com> 📎                     2024-07-11 12:49:36 from Nitin Motiani <nitinmotiani(at)google(dot)com> 📎                      2024-07-15 10:00:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                       2024-07-15 18:12:45 from vignesh C <vignesh21(at)gmail(dot)com> 📎                        2024-07-15 19:18:19 from Nitin Motiani <nitinmotiani(at)google(dot)com>                         2024-07-16 03:59:46 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                          2024-07-16 06:29:04 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                           2024-07-16 13:24:07 from vignesh C <vignesh21(at)gmail(dot)com> 📎                            2024-07-17 06:24:45 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                             2024-07-17 11:55:04 from vignesh C <vignesh21(at)gmail(dot)com>                              2024-07-18 09:35:26 from Nitin Motiani <nitinmotiani(at)google(dot)com>                               2024-07-18 09:55:05 from Nitin Motiani <nitinmotiani(at)google(dot)com>                                2024-07-18 10:00:41 from Nitin Motiani <nitinmotiani(at)google(dot)com>                                 2024-07-18 10:17:26 from Nitin Motiani <nitinmotiani(at)google(dot)com>                              2024-07-25 04:53:31 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                               2024-07-30 21:56:25 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                2024-07-31 04:06:06 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                 2024-07-31 05:47:00 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>                                  2024-08-08 10:54:22 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                   2024-08-09 11:20:31 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                    2024-09-10 04:25:24 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                    2024-09-26 06:09:33 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                     2024-09-26 11:53:07 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                      2024-09-27 11:24:46 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                       2024-09-30 10:03:42 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                        2024-09-30 11:25:48 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                         2024-10-03 05:53:04 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>                                        2024-10-03 05:42:47 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                         2024-10-03 10:15:38 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                          2024-10-04 07:22:51 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                           2024-10-07 11:15:03 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                            2024-10-08 03:11:35 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                             2024-10-08 05:41:12 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                              2024-12-11 03:43:32 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                               2025-02-24 11:18:50 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                                2025-02-28 11:17:50 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                     2024-09-30 04:58:17 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                   2024-08-15 16:00:32 from vignesh C <vignesh21(at)gmail(dot)com> 📎                                    2024-08-20 10:40:22 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                     2024-08-20 12:19:25 from vignesh C <vignesh21(at)gmail(dot)com>                                     2024-08-30 09:35:48 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                      2024-09-02 04:42:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2024-09-09 05:11:36 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                        2024-09-13 05:27:17 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>                                       2024-09-09 05:21:43 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                     2024-09-02 15:49:41 from Nitin Motiani <nitinmotiani(at)google(dot)com>                                      2024-09-05 10:34:16 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                       2024-09-10 08:50:50 from Nitin Motiani <nitinmotiani(at)google(dot)com>                                2024-10-08 09:51:38 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>                                 2024-12-10 06:27:29 from Michael Paquier <michael(at)paquier(dot)xyz>                                  2024-12-10 21:50:16 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                   2024-12-10 23:55:11 from Michael Paquier <michael(at)paquier(dot)xyz>                                 2024-12-11 07:06:26 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                  2025-02-24 09:49:49 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                   2025-02-27 08:14:01 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com> 📎                                    2025-02-28 00:44:59 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                     2025-02-28 04:15:17 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                      2025-02-28 06:42:12 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                       2025-02-28 08:28:13 from Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com> 📎                                        2025-03-03 07:41:08 from "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>                                         2025-03-03 09:03:44 from Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com>                                       2025-03-13 05:29:30 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                        2025-03-13 08:02:50 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                         2025-03-13 08:42:07 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>                                          2025-03-15 06:24:40 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                           2025-03-17 01:22:59 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                            2025-03-17 05:41:39 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> 📎                                             2025-03-17 08:37:33 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                              2025-03-18 04:20:20 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                            2025-03-17 11:26:34 from "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> 📎                                             2025-03-18 09:55:39 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                              2025-04-08 10:10:03 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                               2025-04-10 09:45:27 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                2025-04-10 12:51:07 from Tomas Vondra <tomas(at)vondra(dot)me>                                              2025-04-22 17:26:51 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                               2025-04-23 06:31:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                2025-04-23 16:58:20 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                 2025-04-24 09:09:24 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                                  2025-04-25 05:15:39 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                                   2025-04-25 09:08:51 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                  2025-02-25 10:26:29 from Benoit Lobréau <benoit(dot)lobreau(at)dalibo(dot)com>                                   2025-02-25 10:42:10 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>                                  2025-02-26 03:51:29 from Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> 📎                                   2025-02-26 09:54:37 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>   2023-11-18 10:30:53 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v18-0001-Distribute-invalidatons-if-change-in-catalog-tab.patch	application/octet-stream	15.6 KB

In response to

• Re: long-standing data loss bug in initial sync of logical replication at 2025-02-28 06:42:12 from Amit Kapila

Responses

• RE: long-standing data loss bug in initial sync of logical replication at 2025-03-13 08:02:50 from Hayato Kuroda (Fujitsu)

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Ashutosh Sharma	2025-03-13 05:44:47	Re: Orphaned users in PG16 and above can only be managed by Superusers
Previous Message	Peter Smith	2025-03-13 05:22:41	Re: Commitfest Manager for March