On Fri, Aug 22, 2025 at 11:55:18AM -0400, Tom Lane wrote:
> Nonetheless, I'm suspecting an interaction with the startup process,
> because there just isn't that much else that this process could be
> needing to deal with. Can you try strace'ing both the process doing
> the test query and the start
hubert depesz lubaczewski writes:
> On Fri, Aug 22, 2025 at 11:21:22AM -0400, Tom Lane wrote:
>> Interesting. That futex call is presumably caused by interaction
>> with some other process within the standby server, and the only
>> plausible candidate really is the startup process (which is repla
On Fri, Aug 22, 2025 at 11:21:22AM -0400, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > I got repeatable case today. Is is breaking on its own everyy
> > ~ 5 minutes.
>
> Interesting. That futex call is presumably caused by interaction
> with some other process within the standby serve
On Fri, Aug 22, 2025 at 08:39:21AM -0700, Adrian Klaver wrote:
> On 8/22/25 08:30, hubert depesz lubaczewski wrote:
> > On Fri, Aug 22, 2025 at 11:21:22AM -0400, Tom Lane wrote:
> > > hubert depesz lubaczewski writes:
> > > > I got repeatable case today. Is is breaking on its own everyy
> > > > ~
On 8/22/25 08:30, hubert depesz lubaczewski wrote:
On Fri, Aug 22, 2025 at 11:21:22AM -0400, Tom Lane wrote:
hubert depesz lubaczewski writes:
I got repeatable case today. Is is breaking on its own everyy
~ 5 minutes.
Interesting. That futex call is presumably caused by interaction
with som
On Fri, Aug 22, 2025 at 05:07:09PM +0200, Pavel Stehule wrote:
> > Any idea on what could it be?
> Few years ago I had a similar experience - some sec mystic lags - the
> problem was in virtualization.
While I can't discount this idea, after all it is aws ec2, so virtual
boxes, what makes me wonde
hubert depesz lubaczewski writes:
> I got repeatable case today. Is is breaking on its own everyy
> ~ 5 minutes.
Interesting. That futex call is presumably caused by interaction
with some other process within the standby server, and the only
plausible candidate really is the startup process (whi
pá 22. 8. 2025 v 17:03 odesílatel hubert depesz lubaczewski <
dep...@depesz.com> napsal:
> On Fri, Aug 22, 2025 at 07:33:03AM -0700, Adrian Klaver wrote:
> > On 8/22/25 05:37, hubert depesz lubaczewski wrote:
> > > On Thu, Aug 21, 2025 at 11:17:27AM -0700, Adrian Klaver wrote:
> > > > Have you loo
On Fri, Aug 22, 2025 at 07:33:03AM -0700, Adrian Klaver wrote:
> On 8/22/25 05:37, hubert depesz lubaczewski wrote:
> > On Thu, Aug 21, 2025 at 11:17:27AM -0700, Adrian Klaver wrote:
> > > Have you looked at?:
> > > https://www.pgbouncer.org/changelog.html#pgbouncer-124x
> > > To see if anything st
On 8/22/25 05:37, hubert depesz lubaczewski wrote:
On Thu, Aug 21, 2025 at 11:17:27AM -0700, Adrian Klaver wrote:
Have you looked at?:
https://www.pgbouncer.org/changelog.html#pgbouncer-124x
To see if anything stands out.
Then there is:
https://www.pgbouncer.org/config.html#max_prepared_statemen
On Thu, Aug 21, 2025 at 07:38:34PM +0100, Chris Wilson wrote:
> If all your queries are coming through pgBouncer, and only those hang (the
> server itself responds if you connect directly to it), then it might be
> this pgBouncer issue:
>
> https://github.com/pgbouncer/pgbouncer/issues/1054
>
> A
On Thu, Aug 21, 2025 at 11:17:27AM -0700, Adrian Klaver wrote:
> Have you looked at?:
> https://www.pgbouncer.org/changelog.html#pgbouncer-124x
> To see if anything stands out.
> Then there is:
> https://www.pgbouncer.org/config.html#max_prepared_statements
> The below may also be worth looking at:
On Thu, 2025-08-21 at 17:36 +0200, Karsten Hilbert wrote:
> PG 17 documentation says that using "WITH ADMIN" allows the
> role being added to another group role to grant/revoke
> membership in said group to other roles.
>
> Does this imply that an ADMIN role _must_ itself be a member
> of the grou
13 matches
Mail list logo
