Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication timeout problem - Mailing list pgsql-hackers

From Fabrice Chapuis
Subject Re: Logical replication timeout problem
Date
Msg-id CAA5-nLAVrBZtZ_o-tzbyizFOP3d9mAiG3XUOskShDW01ewfMgw@mail.gmail.com
Whole thread Raw
In response to RE: Logical replication timeout problem  (Tang, Haiying/唐 海英 <tanghy.fnst@fujitsu.com>)
Responses Re: Logical replication timeout problem
List pgsql-hackers
Tree view
Thanks Tang for your script. 
Our debugging environment will be ready soon. I will test your script and we will try to reproduce the problem by integrating the patch provided by Amit. As soon as I have results I will let you know.

Regards

Fabrice

On Thu, Sep 30, 2021 at 3:15 AM Tang, Haiying/唐 海英 <tanghy.fnst@fujitsu.com> wrote:

On Friday, September 24, 2021 12:04 AM, Fabrice Chapuis <fabrice636861@gmail.com> wrote:

>

> Thanks for your patch, we are going to set up a lab in order to debug the function.

 

Hi

 

I tried to reproduce this timeout problem on version10.18 but failed.

In my trial, I inserted large amounts of data at publisher, which took more than 1 minute to replicate.

And with the patch provided by Amit, I saw that the frequency of invoking

WalSndKeepaliveIfNecessary function is raised after I inserted data.

 

The test script is attached. Maybe you can try it on your machine and check if this problem could happen.

If I miss something in the script, please let me know.

Of course, it will be better if you can provide your script to reproduce the problem.

 

Regards

Tang

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: More business with $Test::Builder::Level in the TAP tests
Next
From: Bharath Rupireddy
Date:
Subject: Re: Improve the HINT message of the ALTER command for postgres_fdw