Re: row filtering for logical replication

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 logrep_rowfilter.zip
Archive: logrep_rowfilter.zip
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 logrep_rowfilter_2_nodes.sh
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.

thanks,

Erik Rijkers