Re: Possible fix for occasional failures on castoroides etc

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Possible fix for occasional failures on castoroides etc
Дата
Msg-id 20140503192918.GK12715@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Possible fix for occasional failures on castoroides etc  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Possible fix for occasional failures on castoroides etc  (Dave Page <dpage@pgadmin.org>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Possible fix for occasional failures on castoroides etc
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: need of anonymous record