Re: row filtering for logical replication

From: Erik Rijkers <er(at)xs4all(dot)nl>
To: Euler Taveira <euler(at)timbira(dot)com(dot)br>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Suzuki Hironobu <hironobu(at)interdb(dot)jp>, a(dot)kondratov(at)postgrespro(dot)ru
Subject: Re: row filtering for logical replication
Date: 2019-09-02 23:08:25
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2019-09-02 01:43, Euler Taveira wrote:
> Em dom, 1 de set de 2019 às 06:09, Erik Rijkers <er(at)xs4all(dot)nl>
> escreveu:
>> The first 4 of these apply without error, but I can't get 0005 to
>> apply.
>> This is what I use:
> Erik, I generate a new patch set with patience diff algorithm. It
> seems it applies cleanly.

It did apply cleanly, thanks.

But I can't get it to correctly do the partial replication in the
attached pgbench-script (similar versions of which script I also used
for earlier versions of the patch, last year).

There are complaints in the log (both pub and sub) like:
ERROR: trying to store a heap tuple into wrong type of slot

I have no idea what causes that.

I attach a zip:

$ unzip -l
Length Date Time Name
--------- ---------- ----- ----
17942 2019-09-03 00:47 logfile.6525
10412 2019-09-03 00:47 logfile.6526
6913 2019-09-03 00:47
3371 2019-09-03 00:47 output.txt
--------- -------
38638 4 files

That bash script runs 2 instances (as compiled on my local setup so it
will not run as-is) and tries for one minute to get a slice of the
pgbench_accounts table replicated. One minute is short but I wanted
short logfiles; I have tried the same up to 20 minutes without the
replication completing. I'll try even longer but in the meantime I hope
you can figure out why these errors occur.


Erik Rijkers

Attachment Content-Type Size application/zip 6.1 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2019-09-02 23:11:30 Re: [PATCH] kNN for btree
Previous Message Thomas Munro 2019-09-02 23:04:43 Re: XPRS