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

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
Message-ID: 4A69BE08.9040707@missouri.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
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:
  </pre>
  <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>
  </blockquote>
  <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
  </pre>
</blockquote>
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>
<br>
Bob<br>
<br>
</body>
</html>


Attachment: unknown_filename
Description: text/html (1.8 KB)

In response to

pgsql-bugs by date

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

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