Re: Errors on missing pg_subtrans/ files with 9.3

From: J Smith <dark(dot)panda+lists(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Errors on missing pg_subtrans/ files with 9.3
Date: 2013-11-25 18:04:35
Message-ID: CADFUPgeuq1o1NJAdzqKK_3CbAGzR8SS_zVGHJ-4+97N3ggDR=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 25, 2013 at 11:46 AM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> J Smith escribió:
>
>> We did have some long-running transactions, yes. We refactored a bit
>> and removed them and the problem ceased on our end. We ended up
>> reverting our changes for the sake of running this experiment over the
>> weekend and the errors returned. We've since restored our fix and
>> haven't had any problems since, so yeah, long-running transactions
>> appear to be involved.
>>
>> We can continue to experiment if you have any additional tests you'd
>> like us to run. We may have to keep the experiments to running over
>> the weekend, but they're definitely do-able.
>
> I am working on patches to get these bugs fixed. Would you be up for
> running a patched binary and see if the errors go away?

Sure, just give me a git commit hash and I can do a test build towards
the weekend. I'll include coredumper again just in case things go awry
and we can go from there.

Cheers

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2013-11-25 19:04:23 Re: [PATCH] SQL assertions prototype
Previous Message Andres Freund 2013-11-25 16:58:32 Re: MultiXact bugs