Re: Further stabilization of isolationtester's timeouts test - Mailing list pgsql-hackers

From Mikael Kjellström
Subject Re: Further stabilization of isolationtester's timeouts test
Date
Msg-id e77a840a-efab-40af-9028-f8d16bee27fa@mksoft.nu
Whole thread Raw
In response to Further stabilization of isolationtester's timeouts test  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 2016-05-27 04:06, Tom Lane wrote:

> In this case the process seems to have gone to sleep for just short of a
> minute rather than the expected 5 seconds.  Presumably that just reflects
> overload on the buildfarm member rather than anything really exciting,
> but it explains the failure nicely: by the time we got to postgres.c's
> ProcessInterrupts(), both the lock and statement timeouts had expired,
> and the code there preferentially reports "lock timeout" in that case.

Just wanted to chip in and say that it's almost certain due to 
overloading.  It's a virtual server (VMWare) that runs 4 build animals 
and they all where scheduled to run at the same time and it's on 
spinning rust (i.e. HDD) so it will get overloaded easilly.

I've changed the schedules of the 4 animals so that they shouldn't 
overloap so from now on it should hopefully be much better.

/Mikael



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Question and suggestion about application binary compatibility policy
Next
From: Craig Ringer
Date:
Subject: Re: foreign table batch inserts