Re: pgsql: Re-enable TAP tests of pg_receivewal for ZLIB on Windows

On 7/27/21 2:24 PM, Andrew Dunstan wrote:
> On 7/21/21 9:08 PM, Andrew Dunstan wrote:
>> On 7/21/21 8:00 PM, Michael Paquier wrote:
>>> On Wed, Jul 21, 2021 at 10:05:19AM -0400, Andrew Dunstan wrote:
>>>> drongo, an MSVC animal running on the same machine, doesn't seem to have
>>>> an issue, nor jacana which runs msys1, so this seems possibly
>>>> msys2-specific. I'll investigate on a similar instance I have.
>>> How is doing bowerbird? I was waiting for it to send an update before
>>> doing anything but there is no report yet. Is it getting stuck? I
>>> would feel honestly less sad about those tests if this proves to
>>> require temporarily a $is_msys2 rather than a $windows_os.
>>
>> Yeah, bowerbird got a SIGBREAK that caused the whole buildfarm run to
>> die, so it's even worse than fairywren.
>>
>>
>> Let's skip for $windows_os and do some more thorough investigation.
>>
>>
>
> I have got to the bottom of the issue on fairywren - it was caused by
> using a zlib I had build (and which is used on drongo) rather than the
> mingw64 zlib package. So I've switched that.
>
>
> While doing that I uncovered some more things that need to be fixed for
> portability both in TestLib and the pg_basebackup tests,
>
>
> Meanwhile I will now go and investigate what's happening with bowerbird.

It gets stuck in a loop like this:

ok 19 - one partial WAL segment was created
0/2001968
# Running: pg_receivewal -D H:/prog/bf/root/HEAD/pgsql.build/src/bin/pg_basebackup/tmp_check/t_020_pg_receivewal_primary_data/archive_wal --verbose --endpos 0/3000028 --compress 1
pg_receivewal: starting log streaming at 0/2000000 (timeline 1)
pg_receivewal: error: could not write 131072 bytes to WAL file "000000010000000000000002": Permission denied
pg_receivewal: error: could not close file "000000010000000000000002": Permission denied
pg_receivewal: disconnected; waiting 5 seconds to try again
pg_receivewal: starting log streaming at 0/2000000 (timeline 1)
pg_receivewal: error: could not write 131072 bytes to WAL file "000000010000000000000002": Permission denied
pg_receivewal: error: could not close file "000000010000000000000002": Permission denied
pg_receivewal: disconnected; waiting 5 seconds to try again
pg_receivewal: starting log streaming at 0/2000000 (timeline 1)
pg_receivewal: error: could not write 131072 bytes to WAL file "000000010000000000000002": Permission denied
pg_receivewal: error: could not close file "000000010000000000000002": Permission denied
pg_receivewal: disconnected; waiting 5 seconds to try again
pg_receivewal: starting log streaming at 0/2000000 (timeline 1)
pg_receivewal: error: could not write 131072 bytes to WAL file "000000010000000000000002": Permission denied
pg_receivewal: error: could not close file "000000010000000000000002": Permission denied
pg_receivewal: disconnected; waiting 5 seconds to try again
pg_receivewal: starting log streaming at 0/2000000 (timeline 1)
pg_receivewal: error: could not write 131072 bytes to WAL file "000000010000000000000002": Permission denied
pg_receivewal: error: could not close file "000000010000000000000002": Permission denied
pg_receivewal: disconnected; waiting 5 seconds to try again

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com