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

help / color / mirror / Atom feed
From: Gourish Singbal <gourish@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Fwd: vacuuming template0 gave ERROR
Date: Mon, 26 Dec 2005 18:02:44 +0530
Message-ID: <674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com> (raw)
In-Reply-To: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com>
References: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com>

---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Dec 26, 2005 5:04 PM
Subject: vacuuming template0 gave ERROR
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>


Guys,

Got the following ERROR when i was vacuuming the template0 database.
postgresql server version is 7.4.5 and stats info in postgresql.conf is

# - Query/Index Statistics Collector -

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = tue
#stats_reset_on_server_start = true

============================

step 1

update pg_database set datallowconn=TRUE where datname='template0';

step 2
\c template0
vacuum analyze verbose
......
.....
INFO:  vacuuming "pg_catalog.pg_statistic"
ERROR:  could not access status of transaction 1107341112
DETAIL:  could not open file "/home/postgres/data/pg_clog/0420": No such
file or directory

step 3
postgres@test1:~> /usr/local/pgsql/bin/psql database1 -c 'SELECT datname,
age(datfrozenxid) FROM pg_database';
  datname  |    age
-----------+------------
 template0 | 1112108248
 database1 | 1074511487
 template1 | 1073987669
(3 rows)

Files in the pg_clog are:-
postgres@test1:~/data/pg_clog> ls -lart
total 417
-rw-------  1 postgres postgres 262144 2005-12-26 02:09 0443
drwx------  2 postgres postgres     96 2005-12-26 02:17 ./
drwx------  6 postgres postgres    640 2005-12-26 03:22 ../
-rw-------  1 postgres postgres 163840 2005-12-26 03:23 0444

Problem: template0 is not getting vacuumed due to the above ERROR.. please
let me know whats the solution.
--
Best,
Gourish Singbal


--
Best,
Gourish Singbal

view thread (6+ messages)  latest in thread

Message-ID: <674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com>
Permalink:  ../674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com/
Also on:    postgresql.org/message-id/674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com

 · 

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-performance@postgresql.org
  Cc: gourish@gmail.com
  Subject: Re: Fwd: vacuuming template0 gave ERROR
  In-Reply-To: <674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com>

* 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