Better way of dealing with pgstat wait timeout during buildfarm runs?

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Better way of dealing with pgstat wait timeout during buildfarm runs?
Date: 2014-12-25 19:13:08
Message-ID: 20141225191308.GI31801@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We quite regularly have buildfarm failures that are caused by 'WARNING:
pgstat wait timeout' at random points during the build. Especially on
some of the ARM buildfarm animals those are really frequent, to the
point that it's hard to know the actual state of the buildfarm without
looking at several animals. The ARM ones are probably affected more
frequently because they'll often run on sd cards and such.

So I think a better way to deal with that warning would be a good
idea. Besides somehow making the mechanism there are two ways to attack
this that I can think of, neither of them awe inspiring:

1) Make that WARNING a LOG message instead. Since those don't get send
to the client with default settings...
2) Increase PGSTAT_MAX_WAIT_TIME even further than what 99b545 increased
it to.

Does anybody have an actually good idea?

Greetings,

Andres Freund

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-12-25 19:36:42 Re: Better way of dealing with pgstat wait timeout during buildfarm runs?
Previous Message Jaime Casanova 2014-12-25 17:09:17 Re: pgaudit - an auditing extension for PostgreSQL