Re: Subscription sometimes loses txns after initial table sync

2024-12-10 Thread Shlok Kyal
On Tue, 10 Dec 2024 at 07:24, Zhijie Hou (Fujitsu) wrote: > > On Monday, December 9, 2024 9:21 PM Pritam Baral > wrote: > > To: pgsql-hackers > > Subject: Subscription sometimes loses txns after initial table sync > > > > This was discovered when testing the

RE: Subscription sometimes loses txns after initial table sync

2024-12-09 Thread Zhijie Hou (Fujitsu)
On Monday, December 9, 2024 9:21 PM Pritam Baral wrote: > To: pgsql-hackers > Subject: Subscription sometimes loses txns after initial table sync > > This was discovered when testing the plan for a major version upgrade via > logical replication. Said plan requires that some t

Re: Subscription sometimes loses txns after initial table sync

2024-12-09 Thread Pritam Baral
On 09/12/24 18:50, Pritam Baral wrote: > A reproducer script is attached. Apologies. The aforementioned script is broken. It was a poor port from an internal application. A corrected reproducer script is attached. -- #!/usr/bin/env regards Chhatoi Pritam Baral sub-loss-repro2.sh Descriptio

Subscription sometimes loses txns after initial table sync

2024-12-09 Thread Pritam Baral
This was discovered when testing the plan for a major version upgrade via logical replication. Said plan requires that some tables be synced before others. So I implemented it using ALTER PUBLICATION ... ADD TABLE ... followed by ALTER SUBSCRIPTION ... REFRESH PUBLICATION. A test for correctness re