Re: Enquiry about long-running queries

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Enquiry about long-running queries
Дата
Msg-id CAKAnmm+A90ASkLETXVq8Yc1xs4JqOBY0W055t_fES-JVJWxT0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Enquiry about long-running queries  (Ashish Mukherjee <ashish.mukherjee@gmail.com>)
Список 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




В списке pgsql-general по дате отправления: