Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Increase the statement_timeout value used in the prepared_xacts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Increase the statement_timeout value used in the prepared_xacts
Date: 2008-04-29 04:12:43
Message-ID: 24074.1209442363@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
>> Increase the statement_timeout value used in the prepared_xacts
>> regression test.  We have seen some buildfarm failures that seem
>> to be due to this limit being unexpectedly exceeded when the machine
>> is under load.

> Just as a data point, I thought I saw fennec in the list of machines
> exhibiting this problem, and I can safely vouch that it extremely unlikely
> the machine was under load at the time.

Yeah, I'm not totally sold that this is a "fix" either --- although
there's at least one prior case of an intermittent buildfarm failure
that went away when we increased the timeout sufficiently.

I think a 2-line change is an appropriate amount of effort for now.
If we keep seeing the failure then we'll know we need to look closer.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Bryce NesbittDate: 2008-04-29 04:43:59
Subject: Re: [HACKERS] Proposed patch - psql wraps at window width
Previous:From: Greg Sabino MullaneDate: 2008-04-29 04:00:33
Subject: Re: [COMMITTERS] pgsql: Increase the statement_timeout value used in the prepared_xacts

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2008-04-29 13:00:23
Subject: pgsql: Fix volatility marking for the generate_series and
Previous:From: Greg Sabino MullaneDate: 2008-04-29 04:00:33
Subject: Re: [COMMITTERS] pgsql: Increase the statement_timeout value used in the prepared_xacts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group