public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Ashish Mukherjee <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: Enquiry about long-running queries
Date: Mon, 10 Nov 2025 09:34:13 -0500
Message-ID: <CAKAnmm+A90ASkLETXVq8Yc1xs4JqOBY0W055t_fES-JVJWxT0w@mail.gmail.com> (raw)
In-Reply-To: <CACgMzfx0m=R8QrvQ19+AOv6Y6eu31bqp+881mzAdX8rK28ggyQ@mail.gmail.com>
References: <CACgMzfwJQy8QmOFWdb3B1QNBchxC=4PjpBYMk4zgQz_WY8qmLQ@mail.gmail.com>
<[email protected]>
<CACgMzfx0m=R8QrvQ19+AOv6Y6eu31bqp+881mzAdX8rK28ggyQ@mail.gmail.com>
Wow, 9 days is a long time. The fact that it is not responding to
pg_terminate_backend means it's not even calling CHECK_FOR_INTERRUPTS
inside the WaitForParallelWorkersToFinish loop, so something is seriously
wrong. If the PID is still there, please do what Laurenz suggested:
strace -tp 356274
Is the problem reproducible, and has it happened more than once?
Cheers,
Greg
view thread (6+ messages)
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]
Subject: Re: Enquiry about long-running queries
In-Reply-To: <CAKAnmm+A90ASkLETXVq8Yc1xs4JqOBY0W055t_fES-JVJWxT0w@mail.gmail.com>
* 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