Re: BUG #13559: WAL replay stuck after DROP VIEW - Mailing list pgsql-bugs

From Maciek Sakrejda
Subject Re: BUG #13559: WAL replay stuck after DROP VIEW
Date
Msg-id CAKwe89CSnfT49MM60Dt9JwqM71bXFvpoHm=7TWv4ZjHUAs6iaw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13559: WAL replay stuck after DROP VIEW  (Greg Stark <stark@mit.edu>)
Responses Re: BUG #13559: WAL replay stuck after DROP VIEW  (Greg Stark <stark@mit.edu>)
List pgsql-bugs
hot_standby_feedback is on, vacuum_defer_cleanup_age is not set, and
max_standby_{streaming,archive}_delay are set to -1.

>If all of these are off/zero then this sounds like the standby replays
>an exclusive lock which blocks a query running in the standby, then
>hits a vacuum record in the WAL log which it stops replay because the
>blocked query has an old enough snapshot to see the record being
>cleaned up.

Shouldn't the replay proceed once the query finishes (or is canceled),
though?

pgsql-bugs by date:

Previous
From: anmurray2014@yandex.ru
Date:
Subject: BUG #13577: password
Next
From: digoal@126.com
Date:
Subject: BUG #13578: use cipher=NULL-SHA256 error when connect