Re: BUG #13559: WAL replay stuck after DROP VIEW

From: Maciek Sakrejda <maciek(at)heroku(dot)com>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13559: WAL replay stuck after DROP VIEW
Date: 2015-08-17 21:59:16
Message-ID: CAKwe89CSnfT49MM60Dt9JwqM71bXFvpoHm=7TWv4ZjHUAs6iaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message digoal 2015-08-18 07:52:05 BUG #13578: use cipher=NULL-SHA256 error when connect
Previous Message anmurray2014 2015-08-17 09:23:33 BUG #13577: password