| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: logical decoding / rewrite map vs. maxAllocatedDescs |
| Date: | 2018-08-14 21:26:30 |
| Message-ID: | 094c73aa-4617-9f21-ee87-8e6ef3850277@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 8/14/18 10:05 AM, Tomas Vondra wrote:
> ...
>
> I take that back - I can reproduce the crashes, both with and without
> the patch, all the way back to 9.6. Attached is a bunch of backtraces
> from various versions. There's a bit of variability depending on which
> pgbench script gets started first (insert.sql or vacuum.sql) - in one
> case (when vacuum is started before insert) the crash happens in
> InitPostgres/RelationCacheInitializePhase3, otherwise it happens in
> exec_simple_query.
>
> Another observation is that the failing COPY is not necessary, I can
> reproduce the crashes without this (so even with wal_level=replica).
>
BTW I have managed to reproduce this on an old test server. If anyone
wants to take a look, I can arrange ssh access to that machine (for
trustworthy developers). Let me know.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shawn Debnath | 2018-08-14 21:35:00 | Proposal: SLRU to Buffer Cache |
| Previous Message | Peter Geoghegan | 2018-08-14 21:25:33 | Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes |