Re: Enquiry about long-running queries

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Ashish Mukherjee <ashish(dot)mukherjee(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org
Subject: Re: Enquiry about long-running queries
Date: 2025-11-10 14:34:13
Message-ID: CAKAnmm+A90ASkLETXVq8Yc1xs4JqOBY0W055t_fES-JVJWxT0w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2025-11-10 15:33:20 Re: Pgbackrest setup for two sites with limited bandwidth
Previous Message Radu Radutiu 2025-11-10 12:22:38 Pgbackrest setup for two sites with limited bandwidth