Re: Errors on missing pg_subtrans/ files with 9.3 - Mailing list pgsql-hackers

From J Smith
Subject Re: Errors on missing pg_subtrans/ files with 9.3
Date
Msg-id CADFUPgfD_j1M3RP2QPKLZsE9MhAWN0L0LnY574C8KJXxd7TP_A@mail.gmail.com
Whole thread Raw
In response to Re: Errors on missing pg_subtrans/ files with 9.3  (J Smith <dark.panda+lists@gmail.com>)
Responses Re: Errors on missing pg_subtrans/ files with 9.3
List pgsql-hackers
On Tue, Nov 19, 2013 at 10:16 AM, J Smith <dark.panda+lists@gmail.com> wrote:
> Alright, we'll look into doing that heading into the weekend.
> Interestingly, we haven't experienced the issue since our main Java
> developer made some modifications to our backend system. I'm not
> entirely sure what the changes entail except that it's a one-liner
> that involves re-SELECTing a table during a transaction. We'll
> rollback this change and re-compile Postgres with google-coredumper
> and let it run over the weekend and see where we stand.
>

Okay, I've patched our Postgres install and added in a call for
coredumper to output a core dump. We'll let our processes run for the
next few days and hopefully we'll get something we can look at. I've
attached the patch just in case anyone would like to make sure I've
done it in a sane way and that I've inserted the call in the correct
location.

Cheers

Attachment

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Regress tests to improve the function coverage of schemacmds and user and tablespace files
Next
From: Tom Lane
Date:
Subject: Re: UNION ALL on partitioned tables won't use indices.