pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Steve Jones <Steve.Jones@codeweavers.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
Date: Thu, 25 Mar 2010 12:01:37 -0400
Message-ID: <19228.1269532897@sss.pgh.pa.us> (raw)
In-Reply-To: <89B26B749E941749A0A5D173B4F86C3B0164BF25@MX01.jigsawhq.com>
References: <89B26B749E941749A0A5D173B4F86C3B0164BD69@MX01.jigsawhq.com>
	<28922.1269359012@sss.pgh.pa.us>
	<89B26B749E941749A0A5D173B4F86C3B0164BE01@MX01.jigsawhq.com>
	<651.1269361151@sss.pgh.pa.us>
	<89B26B749E941749A0A5D173B4F86C3B0164BE05@MX01.jigsawhq.com>
	<825.1269361733@sss.pgh.pa.us>
	<89B26B749E941749A0A5D173B4F86C3B0164BE0C@MX01.jigsawhq.com>
	<1730.1269363770@sss.pgh.pa.us>
	<C535DAC0-82B1-49C6-8E25-A366F44D69E8@codeweavers.net>
	<4438.1269370293@sss.pgh.pa.us>
	<89B26B749E941749A0A5D173B4F86C3B0164BE3D@MX01.jigsawhq.com>
	<20694.1269439886@sss.pgh.pa.us>
	<89B26B749E941749A0A5D173B4F86C3B0164BF25@MX01.jigsawhq.com>

[ re-including the mailing list ]

"Steve Jones" <Steve.Jones@codeweavers.net> writes:
> For your information, this is what I did last night.

> Restarted the stats collector process, by issuing a kill -9 against it.
> As you said, postgres started up a new collector process immediately.  I
> tried a few vacuums and the stats still weren't being updated.

> I then restarted postgres in the hope this would help.  It didn't.

> I finally had to reboot the whole server which fixed the problem.  As
> you said, I have to run two manual vacuums before the stats are showing
> up.  This possible points a finger towards FreeBSD now?  Would
> appreciate your thoughts.

If restarting Postgres didn't fix it then the problem has to have been
at the operating system level.  I can hardly think what the problem
would have been exactly.  It's not hard to imagine something going
wrong in the kernel state for the UDP socket we use to send messages to
the stats collector process; but restarting Postgres should have torn
down that socket and created a new one.  Perhaps something wrong in
global state for all local UDP transfers?  I dunno.  But it seems like
time to call in some FreeBSD hackers.

			regards, tom lane



view thread (3+ messages)

Message-ID: <19228.1269532897@sss.pgh.pa.us>
Permalink:  ../19228.1269532897@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/19228.1269532897@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, Steve.Jones@codeweavers.net
  Subject: Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
  In-Reply-To: <19228.1269532897@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox