Queries waiting on SyncRep even though synchronous_standby_names is absent

From: Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Queries waiting on SyncRep even though synchronous_standby_names is absent
Date: 2024-07-18 08:43:29
Message-ID: CAFpL5Vzs=+i3Oj96KN0PiP-iC__EOMtQRVC_ME5sr0vFOmGS=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

PostgreSQL : 13.6

I saw a strange behavior today. All write queries were stuck on the
'SyncRep' wait event so I reset the synchronous_standby_names.

postgres=# show synchronous_standby_names ;
> synchronous_standby_names
> ---------------------------
>
> (1 row)

We still saw many queries waiting on SyncRep

datid | datname | pid | leader_pid | usesysid | usename |
> application_name | client_addr | client_hostname | client_port | backend_start
> | xact_start | query_start
> | state_change | wait_event_type | wait_event |
> state | backend_xid | backend_xmin |
> query | backend_type
>
> -------+----------+-------+------------+----------+---------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+------------------------
>
> -------+-------------------------------+-----------------+------------+--------+-------------+--------------+-------------------------------------------------------------------------------------+----------------
> 16401 | repmgr | 24344 | | 16385 | postgres | psql
> | | | -1 | 2024-07-14
> 09:55:09.615682+00 | 2024-07-14 09:55:09.622254+00 | 2024-07-14 09:55:09.622
> 254+00 | 2024-07-14 09:55:09.622255+00 | IPC | SyncRep |
> active | 343975184 | 343974710 | UPDATE repmgr.sync_check SET
> row_update_time = (select timezone('UTC', now())) | client backend
> (1 row)

Has anyone faced this issue or have any inputs

Thank you,

Nikhil

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message khan Affan 2024-07-18 09:20:51 Re: Queries waiting on SyncRep even though synchronous_standby_names is absent
Previous Message Ron Johnson 2024-07-17 22:08:46 Re: Error; pg_upgrade 10 to 15