| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Scott Frazer <sfrazer(at)couponcabin(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Help troubleshooting SubtransControlLock problems |
| Date: | 2018-03-07 21:50:34 |
| Message-ID: | 20180307215034.3b4rnruwlrxsqise@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Frazer wrote:
> Currently this seems to be happening when the server just starts taking
> connections. It doesn't even need time to scale up anymore (previously it
> took about 8 hours for the problem to re-appear)
>
> It's only happening on the read replicas, though. I've just set my master
> to handle all the traffic, but that's not really sustainable
I failed to notice at start of thread that these were replicas. I
suppose then you would have to be thinking about the range of XIDs in
the primary server. Maybe you left some old transaction open, or an
uncommitted prepared transaction there?
If not, I suppose you're up for some "perf" profiling ...
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tiffany Thang | 2018-03-07 23:05:16 | Prefixing schema name |
| Previous Message | Scott Frazer | 2018-03-07 21:20:30 | Re: Help troubleshooting SubtransControlLock problems |