Better way of dealing with pgstat wait timeout during buildfarm runs?
От
Andres Freund
Тема
Better way of dealing with pgstat wait timeout during buildfarm runs?
Дата
Msg-id
20141225191308.GI31801@alap3.anarazel.de
Список
Дерево обсуждения
Better way of dealing with pgstat wait timeout during buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during buildfarm
runs? Noah Misch <noah@leadboat.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tv@fuzzy.cz>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tv@fuzzy.cz>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tv@fuzzy.cz>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Michael Paquier <michael.paquier@gmail.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Matt Kelly <mkellycs@gmail.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Michael Paquier <michael.paquier@gmail.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during buildfarm
runs? Noah Misch <noah@leadboat.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Noah Misch <noah@leadboat.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Noah Misch <noah@leadboat.com>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Andres Freund <andres@2ndquadrant.com>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Noah Misch <noah@leadboat.com>
Re: Re: Better way of dealing with pgstat wait timeout
during buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Robert Haas <robertmhaas@gmail.com>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tv@fuzzy.cz>
Re: Better way of dealing with pgstat wait timeout during buildfarm runs? Tom Lane <tgl@sss.pgh.pa.us>
Re: Better way of dealing with pgstat wait timeout during
buildfarm runs? Tomas Vondra <tv@fuzzy.cz>
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
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата: