On 2012-09-17 08:23:01 -0400, Dave Page wrote:
> On Sun, Sep 16, 2012 at 12:44 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> >
> > On 09/16/2012 12:04 PM, Tom Lane wrote:
> >>
> >> It's annoying that the buildfarm animals running on older versions of
> >> Solaris randomly fail with "Connection refused" errors, such as in
> >> today's example:
> >>
> >> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=castoroides&dt=2012-09-15%2015%3A42%3A52
> >>
> >> I believe what's probably happening there is that the kernel has a small
> >> hard-wired limit on the length of the postmaster's accept queue, and you
> >> get this failure if too many connection attempts arrive faster than the
> >> postmaster can service them. If that theory is correct, we could
> >> probably prevent these failures by reducing the number of tests run in
> >> parallel, which could be done by adding say
> >> MAX_CONNECTIONS=5
> >> to the environment in which the regression tests run. I'm not sure
> >> though if that's "build_env" or some other setting for the buildfarm
> >> script --- Andrew?
> >>
> >>
> >
> >
> >
> > Yes, in the build_env section of the config file.
> >
> > It's in the distributed sample config file, commented out.
>
> I've added MAX_CONNECTIONS=5 to both Castoroides and Protosciurus.
I've just noticed (while checking whether backporting 4c8aa8b5aea caused
problems) that this doesn't seem to have fixed the issue. One further
thing to try would be to try whether tcp connections don't have the same
problem.
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services
