| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | vyegorov(at)gmail(dot)com |
| Subject: | BUG #15313: Waiting `startup` process on a streaming replica |
| Date: | 2018-08-07 13:35:59 |
| Message-ID: | 153364895911.1304.15728787618787302401@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15313
Logged by: Victor Yegorov
Email address: vyegorov(at)gmail(dot)com
PostgreSQL version: 10.4
Operating system: Ubuntu 14.04.5 LTS (trusty)
Description:
We have one customer, that get one of their HotStandby replicas to be stuck
via `startup` process deadlock against session.
Case can be reproduced, we've installed dbg packages and collected
backtraces (I will attach them in a followup e-mail).
This happens during schema changes on the master. Processes is being far
from optimal, as they re-create all triggers,
views and materialized views in the scope. We've recommended this customer
to avoid such heavy schema changes.
Still, as we have evidence at hands, here comes the report.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Yegorov | 2018-08-07 13:40:49 | Re: BUG #15313: Waiting `startup` process on a streaming replica |
| Previous Message | Erich Schubert | 2018-08-07 11:58:11 | Re: BUG #15307: Low numerical precision of (Co-) Variance |