Re: buildfarm instance bichir stuck

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Robins Tharakan <tharakan(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: buildfarm instance bichir stuck
Date: 2023-07-29 23:33:18
Message-ID: CA+hUKGK2eubAdK3TjrbRMf=htWegcL-09EPNh5xJrp6ZGSgPTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 9, 2021 at 6:11 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> On Wed, Apr 7, 2021 at 7:31 PM Robins Tharakan <tharakan(at)gmail(dot)com> wrote:
> > Correct. This is easily reproducible on this test-instance, so let me know if you want me to test a patch.
>
> From your description it sounds like signals are not arriving at all,
> rather than some more complicated race. Let's go back to basics...

I was looking into the portability of SIGURG and OOB socket data for
something totally different (hallway track discussion from PGCon,
could we use that for query cancel, like FTP does, instead of opening
another socket?), and lo and behold, someone has figured out a
workaround for this latch problem:

https://github.com/microsoft/WSL/issues/8619

I don't really want to add code to scrape uname() ouput detect
different kernels at runtime as shown there, but it doesn't seem to
make a difference on Linux if we just always do what was suggested. I
didn't look too hard into whether that is the right place to put the
call, or really understand *why* it works, and since I am not a
Windows user and we don't have a WSL1 CI, I can't confirm that it
works or explore whether there is some other ordering of operations
that would be better but still work, but if that does the trick then
maybe we should just do something like the attached.

Thoughts?

Attachment Content-Type Size
0001-Work-around-signalfd-oddity-on-WSL1.patch text/x-patch 1.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2023-07-30 00:00:31 Re: logical decoding and replication of sequences, take 2
Previous Message José Neves 2023-07-29 23:07:24 CDC/ETL system on top of logical replication with pgoutput, custom client