From: | "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com>, fabriziomello(at)gmail(dot)com, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Rahila Syed <rahila(dot)syed(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Minimal logical decoding on standbys |
Date: | 2022-12-10 08:09:27 |
Message-ID: | 09c26df0-c5f9-eae0-5a6a-10fb00b0522e@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 12/8/22 12:07 PM, Drouvot, Bertrand wrote:
> Hi,
>
> On 12/7/22 6:58 PM, Andres Freund wrote:
>> Hi,
>>
>> On 2022-12-07 10:00:25 +0100, Drouvot, Bertrand wrote:
>>>> Please find attached a new patch series:
>>>>
>>>> v27-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch
>>>> v27-0002-Handle-logical-slot-conflicts-on-standby.patch
>>>> v27-0003-Allow-logical-decoding-on-standby.patch
>>>> v27-0004-New-TAP-test-for-logical-decoding-on-standby.patch
>>>> v27-0005-Doc-changes-describing-details-about-logical-dec.patch
>>>> v27-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch
>>
>> This failed on cfbot [1]. The tap output [2] has the following bit:
>>
>> [09:48:56.216](5.979s) not ok 26 - cannot read from logical replication slot
>> [09:48:56.223](0.007s) # Failed test 'cannot read from logical replication slot'
>> # at C:/cirrus/src/test/recovery/t/034_standby_logical_decoding.pl line 422.
>> ...
>> Warning: unable to close filehandle GEN150 properly: Bad file descriptor during global destruction.
>> Warning: unable to close filehandle GEN155 properly: Bad file descriptor during global destruction.
>>
>> The "unable to close filehandle" stuff in my experience indicates an IPC::Run
>> process that wasn't ended before the tap test ended.
>>
>> Greetings,
>>
>> Andres Freund
>>
>> [1] https://cirrus-ci.com/task/5092676671373312
>> [2] https://api.cirrus-ci.com/v1/artifact/task/5092676671373312/testrun/build/testrun/recovery/034_standby_logical_decoding/log/regress_log_034_standby_logical_decoding
>
> Thanks for pointing out!
>
> Please find attached V29 addressing this "Windows perl" issue: V29 changes the way the slot invalidation is tested and adds a "handle->finish". That looks ok now (I launched several successful consecutive tests on my enabled cirrus-ci repository).
>
> V29 differs from V28 only in 0004 to workaround the above "Windows perl" issue.
>
> Regards,
>
Attaching V30, mandatory rebase due to 66dcb09246.
Regards,
--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
Attachment | Content-Type | Size |
---|---|---|
v30-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch | text/plain | 7.5 KB |
v30-0005-Doc-changes-describing-details-about-logical-dec.patch | text/plain | 2.1 KB |
v30-0004-New-TAP-test-for-logical-decoding-on-standby.patch | text/plain | 20.4 KB |
v30-0003-Allow-logical-decoding-on-standby.patch | text/plain | 11.5 KB |
v30-0002-Handle-logical-slot-conflicts-on-standby.patch | text/plain | 28.0 KB |
v30-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch | text/plain | 25.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ilya Gladyshev | 2022-12-10 08:18:32 | Progress report of CREATE INDEX for nested partitioned tables |
Previous Message | Drouvot, Bertrand | 2022-12-10 08:06:06 | Re: Generate pg_stat_get_* functions with Macros |