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

From Alvaro Herrera
Subject Re: Errors on missing pg_subtrans/ files with 9.3
Date
Msg-id 20131125164647.GD6597@eldon.alvh.no-ip.org
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  (J Smith <dark.panda+lists@gmail.com>)
List pgsql-hackers
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?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: MultiXact bugs
Next
From: Andres Freund
Date:
Subject: Re: MultiXact bugs