pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
"global/pgstat.stat" corrupt 3+ messages / 2 participants [nested] [flat]
* "global/pgstat.stat" corrupt @ 2012-06-22 18:46 David Kerr <dmk@mr-paradox.net> 2012-06-22 19:49 ` Re: "global/pgstat.stat" corrupt Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: David Kerr @ 2012-06-22 18:46 UTC (permalink / raw) To: pgsql-performance Howdy, I just restored a DB from a cold backup (pg_ctl stop -m fast) When starting the DB I see: LOG: corrupted statistics file "global/pgstat.stat" When I look at the filesystem I don't see a global/pgstat.stat file but i do see a pg_stat_tmp/pgstat.stat is that PG rebuilding the corrupt file? Are those stats related to pg_stats style statistics? Any idea why that pgstats.stat file would be corrupt after a relativly clean backup like that? ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "global/pgstat.stat" corrupt 2012-06-22 18:46 "global/pgstat.stat" corrupt David Kerr <dmk@mr-paradox.net> @ 2012-06-22 19:49 ` Tom Lane <tgl@sss.pgh.pa.us> 2012-06-22 20:11 ` Re: "global/pgstat.stat" corrupt David Kerr <dmk@mr-paradox.net> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2012-06-22 19:49 UTC (permalink / raw) To: David Kerr <dmk@mr-paradox.net>; +Cc: pgsql-performance David Kerr <dmk@mr-paradox.net> writes: > I just restored a DB from a cold backup (pg_ctl stop -m fast) > When starting the DB I see: > LOG: corrupted statistics file "global/pgstat.stat" Is that repeatable? It wouldn't be too surprising to see this once when starting from a filesystem backup, if you'd managed to capture a partially written stats file in the backup. > When I look at the filesystem I don't see a global/pgstat.stat file but i do see a > pg_stat_tmp/pgstat.stat This is normal --- global/pgstat.stat is only supposed to exist when the system is shut down. Transient updates are written into pg_stat_tmp/ > Are those stats related to pg_stats style statistics? No, this file is for the stats collection subsystem, http://www.postgresql.org/docs/9.1/static/monitoring-stats.html regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "global/pgstat.stat" corrupt 2012-06-22 18:46 "global/pgstat.stat" corrupt David Kerr <dmk@mr-paradox.net> 2012-06-22 19:49 ` Re: "global/pgstat.stat" corrupt Tom Lane <tgl@sss.pgh.pa.us> @ 2012-06-22 20:11 ` David Kerr <dmk@mr-paradox.net> 0 siblings, 0 replies; 3+ messages in thread From: David Kerr @ 2012-06-22 20:11 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance On Fri, Jun 22, 2012 at 03:49:00PM -0400, Tom Lane wrote: - David Kerr <dmk@mr-paradox.net> writes: - > I just restored a DB from a cold backup (pg_ctl stop -m fast) - - > When starting the DB I see: - > LOG: corrupted statistics file "global/pgstat.stat" - - Is that repeatable? It wouldn't be too surprising to see this once when - starting from a filesystem backup, if you'd managed to capture a - partially written stats file in the backup. hmm, possibly. it's somewhat worrysome if that file isn't written out what else isn't getting written out. our backups are SAN based snapshots, maybe i need to "sync" prior to the snapshot even with the DB being down. - > When I look at the filesystem I don't see a global/pgstat.stat file but i do see a - > pg_stat_tmp/pgstat.stat - - This is normal --- global/pgstat.stat is only supposed to exist when the - system is shut down. Transient updates are written into pg_stat_tmp/ ah ok - > Are those stats related to pg_stats style statistics? - - No, this file is for the stats collection subsystem, - http://www.postgresql.org/docs/9.1/static/monitoring-stats.html - - regards, tom lane - Oh, hmm thanks. I had looked at that before but must not have fully understood what was going on. That's interesting! Dave ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-06-22 20:11 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-06-22 18:46 "global/pgstat.stat" corrupt David Kerr <dmk@mr-paradox.net> 2012-06-22 19:49 ` Tom Lane <tgl@sss.pgh.pa.us> 2012-06-22 20:11 ` David Kerr <dmk@mr-paradox.net>
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