Re: Possible fix for occasional failures on castoroides etc - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Possible fix for occasional failures on castoroides etc
Date
Msg-id 20140503192918.GK12715@awork2.anarazel.de
Whole thread Raw
In response to Re: Possible fix for occasional failures on castoroides etc  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Possible fix for occasional failures on castoroides etc  (Dave Page <dpage@pgadmin.org>)
List pgsql-hackers
On 2014-05-03 13:25:32 -0400, Tom Lane wrote:
> Andres Freund <andres@2ndquadrant.com> writes:
> > On 2012-09-17 08:23:01 -0400, Dave Page wrote:
> >> 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.
> 
> I did some googling on this, and found out that people have seen identical
> behavior on Solaris with mysql and other products, so at least we're not
> alone.

Yea, I found a couple report of that as well.

>  Googling also reminded me that we could have a look at the source
> (duh), which is still available from hg.openindiana.org.

I didn't get that far ;)

I think we should try whether the problem disappears if tcp connections
are used. That ought to be much more heavily used in the real
world. Thus less likely to be buggy.

While It's not documented as such, passing --host=localhost to
pg_regress seems to have the desired effect. Dave, could you make your
animal specify that?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible fix for occasional failures on castoroides etc
Next
From: Craig Ringer
Date:
Subject: Re: need of anonymous record