public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andrey M. Borodin <[email protected]>
To: Thom Brown <[email protected]>
Cc: Michael Paquier <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: vignesh C <[email protected]>
Cc: Andrew Borodin <[email protected]>
Cc: Yura Sokolov <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Gilles Darold <[email protected]>
Cc: Alexander Korotkov <[email protected]>
Cc: Daniel Gustafsson <[email protected]>
Cc: Kyotaro Horiguchi <[email protected]>
Cc: pgsql-hackers mailing list <[email protected]>
Subject: Re: MultiXact\SLRU buffers configuration
Date: Thu, 31 Oct 2024 21:32:42 +0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAA-aLv5PzDqYV0zyP=zYfvMrN9DiLo6vsDe04PUJoYXRGVa=rQ@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<CAA-aLv4h=58ggum1-ChLEH3STPXrC4K_cbqYxQ2i2aYMfdwLzA@mail.gmail.com>
	<CAA-aLv7AcTh+O9rnoPVbck=Fw8atMOYrUttk5G9ctFhXOsqQbw@mail.gmail.com>
	<[email protected]>
	<CAA-aLv5PzDqYV0zyP=zYfvMrN9DiLo6vsDe04PUJoYXRGVa=rQ@mail.gmail.com>



> On 31 Oct 2024, at 17:29, Thom Brown <[email protected]> wrote:
> 
> On Thu, 31 Oct 2024 at 10:47, Andrey M. Borodin <[email protected]> wrote:
>> 
>> 
>> 
>>> On 29 Oct 2024, at 21:45, Thom Brown <[email protected]> wrote:
>>> 
>>> It clearly checks for interrupts, but when I saw this issue happen, it
>>> wasn't interruptible.
>> 
>> Perhaps, that was different multixacts?
>> When I was observing this pathology on Standby, it was a stream of different reads encountering different multis.
>> 
>> Either way startup can cancel locking process on it's own. Or is it the case that cancel was not enough, did you actually need termination, not cancel?
> 
> Termination didn't work on either of the processes.

How did you force the process to actually terminate?
Did you observe repeated read of the same multixact?
Was offending process holding any locks while waiting?


Best regards, Andrey Borodin.

view thread (10+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: MultiXact\SLRU buffers configuration
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox