search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

Toast issue after upgrade of subscriber from 9.5 to 9.6 #77

Closed jfinzel closed 7 years ago

jfinzel commented 7 years ago

I wonder if this could be related to this issue: https://github.com/2ndQuadrant/pglogical/issues/25

We upgraded a subscriber from 9.5 to 9.6. We successfully resumed replication for 2 out of 4 provider databases. Upon resuming replication for one of our replication sets point to the 3rd database, we saw nothing in the logs to indicate that it worked. To troubleshoot, I ran pg_logical_slot_peek_changes, which gives me this error at the 664th line of the logical decoding stream:

ERROR:  missing chunk number 0 for toast value 10395772 in pg_toast_25165
CONTEXT:  slot "pgl_audit_providerb04e3bc_eis_audi302ddac", output plugin "pglogical_output", in the change callback, associated LSN 39B/6D3207A8

Any help is much appreciated. Here is provider info:

1: 9.4 - successfully back in replication 2: 9.5 - successfully back in replication 3: 9.4 - broken

Thanks.

jfinzel commented 7 years ago

If I understand the other post correctly, the issue is that I shouldn't use format JSON. At this point, I'm not sure what the problem actually was. I ended up advancing the origin, and all of a sudden replication started working again. The issue I had initially was that upon enabling the subscription, just nothing happened. It was showing as enabled = t in the table, but nothing was being consumed. Has that issue been seen before?