Long text values destroys logical replication slots

From: Adam Dratwiński <adam(dot)dratwinski(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Krzysiek Kotlarski <kotlarski(dot)krzysztof(at)gmail(dot)com>
Subject: Long text values destroys logical replication slots
Date: 2015-10-28 18:51:18
Message-ID: CAKg6ypLd7773AOX4DiOGRwQk1TVOQKhNwjYiVjJnpq8Wo+i62Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I recently encountered a bug on my production postgres which results in
killing replication slot. It happens when there is an UPDATE statement
called on a record having text column with a very long value (about 1mb).
The problem can be easily reproduced by this query:

https://gist.github.com/adwinsky/f7a6dc4382776fb9ea60

Here I am using decoderbufs decoder https://github.com/krzychk/decoderbufs
but it doesn't seems to be related with this plugin as it also happen on
the postgres test decoder.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2015-10-28 20:54:34 Re: Long text values destroys logical replication slots
Previous Message Tom Lane 2015-10-28 14:57:34 Re: BUG #13742: postgres deletes needed files in pg_clog