From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Jeremy Haile <jhaile(at)fastmail(dot)fm>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stats collector frozen? |
Date: | 2007-01-26 09:46:11 |
Message-ID: | 20070126094611.GC30416@svr2.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Jeremy Haile wrote:
> >> If anyone else is experiencing similar problems, please post your
> >> situation.
>
> > All the Windows buildfarm machines are, apparently.
>
> Can't anyone with a debugger duplicate this and get a stack trace for
> us? If the stats collector is indeed freezing up, a stack trace showing
> where it's stuck would be exceedingly helpful.
Another update - what broke it was not the enabling of autovacuum, it
was the enabling of row level stats. If I disable stats_row_level,
parallel tests pass again.
That doesn't actually tell us *why* it's broken, I think, but it does
tell us why the autovac patch caused it.
I don't have 8.1 or 8.2 around on win32, but it'd be interesting to see if the
same issue happens if you run the tests on that with stats_row_level
enabled. Most likely the same thing happens.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2007-01-26 09:55:57 | Re: Stats collector frozen? |
Previous Message | Magnus Hagander | 2007-01-26 09:23:05 | Re: Stats collector frozen? |