Re: statement_timeout has no effect if sync standby is unavailable

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Re: statement_timeout has no effect if sync standby is unavailable
Дата
Msg-id CAFpL5VwFGojDpgaN18c1v-y2XLRRJMrDRU7ZgtXovz-zV0P3Tw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: statement_timeout has no effect if sync standby is unavailable  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: statement_timeout has no effect if sync standby is unavailable  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi Laurenz

I need to check the process state but statement_timeout should timeout such queries, no?

Thanks,
Nikhil

On Wed, 1 Nov 2023 at 22:09, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2023-11-01 at 15:44 +0530, Nikhil Shetty wrote:
> We have also seen this scenario when we froze the data mount point and run a DML
>
> Freeze mountpoint 
> date;fsfreeze --freeze /postgres
> The statement is just stuck even thought statement_timeout is set
>
> datid        | 14175
> datname      | postgres
> pid          | 5789
> leader_pid   |
> usesysid     | 10
> usename      | postgres
> application_name | hang_monitor
> client_addr  | 127.0.0.1
> client_hostname |
> client_port  | 37440
> backend_start| 2023-11-01 10:05:51.090023+00
> xact_start   | 2023-11-01 10:05:51.167816+00
> query_start  | 2023-11-01 10:05:51.167816+00
> state_change | 2023-11-01 10:05:51.167817+00
> wait_event_type | IO
> wait_event   | WALWrite
> state        | active
> backend_xid  | 43242183
> backend_xmin |
> query        | update HEARTBEAT set last_updated_time = timezone('UTC', now()) where ID = 1;
> backend_type | client backend

Check with "ps": perhaps the backend process is in uninterruptible sleep, waiting
for I/O.

Yours,
Laurenz Albe

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

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Re: Error in log
Следующее
От: Tom Lane
Дата:
Сообщение: Re: statement_timeout has no effect if sync standby is unavailable