From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Nikhil Shetty <nikhil.dba04@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: statement_timeout has no effect if sync standby is unavailable
Date: Wed, 01 Nov 2023 17:39:31 +0100
Message-ID: <e73f7d44c3f76455519b2286eef19b1d42d4884d.camel@cybertec.at> (raw)
In-Reply-To: <CAFpL5VzcQXxzbzkVAnRM87qVZnZX4VYh1YcWZVMqSz+jH2AErw@mail.gmail.com>
References: <CAFpL5VwpZ3Ey3SL=rtXDSVo-PfYT1x6z+9z69Ssu72mCmW9_yA@mail.gmail.com>
<CAFpL5VzcQXxzbzkVAnRM87qVZnZX4VYh1YcWZVMqSz+jH2AErw@mail.gmail.com>
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
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, nikhil.dba04@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: statement_timeout has no effect if sync standby is unavailable
In-Reply-To: <e73f7d44c3f76455519b2286eef19b1d42d4884d.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox