Re: pgstat wait timeout

From: Robert Schnabel <schnabelr(at)missouri(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pgstat wait timeout
Date: 2009-07-24 13:58:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Tom Lane wrote:
<blockquote cite="mid:22055(dot)1247067802(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Robert Schnabel <a class="moz-txt-link-rfc2396E" href="mailto:schnabelr(at)missouri(dot)edu">&lt;schnabelr(at)missouri(dot)edu&gt;</a> writes:
<blockquote type="cite">
<pre wrap=""> From a fresh server restart I have one process that will run one
processor 100% essentially forever. (I've let it go for about a week
just to see if it would ever stop and it didn't). Attached is a text
dump from ProcessExplorer. I have highlighted the relevant lines with
****. Also attached is the current postgresql log after a server
restart. You can see from the log that about every 70 seconds there is
an entry "WARNING: pgstat wait timeout". This will go on forever.
<pre wrap=""><!---->
Apparently the stats collector has gotten stuck in a loop and is failing
to update the stats file. The 'wait timeout' bleats are probably coming
from the autovacuum launcher process, which is waiting for an up-to-date
stats file to appear. Can you get a stack trace from the stats
collector process?

regards, tom lane
Sorry for the delayed response to this but I just had too many fires to
put out.&nbsp; In the mean time, this problem seems to have cured itself.&nbsp; I
rebooted my computer yesterday (Windows XP), the postgres service
started and I'm no longer having an issue.&nbsp; I had not rebooted since I
upgraded to 8.4 but it seems to have done the trick.&nbsp; Previously in
8.3.7 I would have this problem every time I would reboot.<br>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Wojciech Walczak 2009-07-26 20:49:01 Postgresql, ts_headline() adds space when parsing url problem
Previous Message Tom Lane 2009-07-24 13:25:05 Re: BUG #4939: error query result