Postgres Pro
Downloads
Home   >   mailing lists

statement_timeout has no effect if sync standby is unavailable - Mailing list pgsql-admin

From Nikhil Shetty
Subject statement_timeout has no effect if sync standby is unavailable
Date
Msg-id CAFpL5VwpZ3Ey3SL=rtXDSVo-PfYT1x6z+9z69Ssu72mCmW9_yA@mail.gmail.com
Whole thread Raw
Responses Re: statement_timeout has no effect if sync standby is unavailable
List pgsql-admin
Tree view
Hi Team,

I am writing a monitoring tool to find if the database is hung.

One of the scenarios is to stop the standby but keep 'synchronous_standby_names=standby1' and 'synchronous_commit=remote_apply' unchanged on primary.

This way the DML queries on primary will be hung. I tried to use 'statement_timeout=5s' to timeout the query but it does not work.

Is there another way to timeout query and report an error ? and why is statement_timeout not working?

Thanks,
Nikhil

pgsql-admin by date:

Previous
From: B Liu
Date:
Subject: pgagent for windows download link missing
Next
From: SOzcn
Date:
Subject: On Replica - History issue