On 2024-05-17 16:03:09 -0400, Peter Geoghegan wrote:
> On Fri, May 17, 2024 at 3:50 PM Andres Freund wrote:
> > You're saying that the data is correctly accessible on primaries, but broken
> > on standbys? Is there any difference in how the page looks like on the
> > primary
> > vs standby?
>
>
Hi
>
> Another question: Do you use pg_repack or such?
>
pg_repack was used for some tables, but I found broken tables, where
pg_repack was not used.
Regards
Pavel
>
> Greetings,
>
> Andres Freund
>
pá 17. 5. 2024 v 22:05 odesílatel Pavel Stehule
napsal:
>
>
> pá 17. 5. 2024 v 21:50 odesílatel Andres Freund
> napsal:
>
>> Hi,
>>
>> On 2024-05-17 15:12:31 +0200, Pavel Stehule wrote:
>> > after migration on PostgreSQL 16 I seen 3x times (about every week)
>> broken
>> > tables on replica
pá 17. 5. 2024 v 21:50 odesílatel Andres Freund napsal:
> Hi,
>
> On 2024-05-17 15:12:31 +0200, Pavel Stehule wrote:
> > after migration on PostgreSQL 16 I seen 3x times (about every week)
> broken
> > tables on replica nodes. The query fails with error
>
> Migrating from what version?
>
I
On Fri, May 17, 2024 at 3:50 PM Andres Freund wrote:
> You're saying that the data is correctly accessible on primaries, but broken
> on standbys? Is there any difference in how the page looks like on the primary
> vs standby?
There clearly is. The relevant infomask bits are different. I didn't
Hi,
On 2024-05-17 15:12:31 +0200, Pavel Stehule wrote:
> after migration on PostgreSQL 16 I seen 3x times (about every week) broken
> tables on replica nodes. The query fails with error
Migrating from what version?
You're saying that the data is correctly accessible on primaries, but broken
on
On Fri, May 17, 2024 at 1:18 PM Pavel Stehule wrote:
> pá 17. 5. 2024 v 18:02 odesílatel Peter Geoghegan napsal:
>> You've shown an inconsistency between the primary and standby with
>> respect to the heap tuple infomask bits related to freezing. It looks
>> like a FREEZE WAL record from the
pá 17. 5. 2024 v 18:02 odesílatel Peter Geoghegan napsal:
> On Fri, May 17, 2024 at 9:13 AM Pavel Stehule
> wrote:
> > after migration on PostgreSQL 16 I seen 3x times (about every week)
> broken tables on replica nodes. The query fails with error
> >
> > ERROR: could not access status of
On Fri, May 17, 2024 at 9:13 AM Pavel Stehule wrote:
> after migration on PostgreSQL 16 I seen 3x times (about every week) broken
> tables on replica nodes. The query fails with error
>
> ERROR: could not access status of transaction 1442871302
> DETAIL: Could not open file "pg_xact/0560": No
