X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 115D79DCB75 for ; Mon, 26 Dec 2005 08:32:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51289-08 for ; Mon, 26 Dec 2005 07:32:46 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by postgresql.org (Postfix) with ESMTP id C40459DCB74 for ; Mon, 26 Dec 2005 08:32:41 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1173208nzn for ; Mon, 26 Dec 2005 04:32:45 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=AqZpbtTSDhbAnYqgQ174+GXZbBGtMmysc2bPcJD2kWmL0CYibdCg/GI73kT/Z/GS9R0X34QgBwuSROhsQZk6baCt+pjSHhGqWK6qV6QI72/6GkqKJPvOQpBUJU6pK2KTV7VDQwgSAIInJGaIHErYPnKgrYEYWDnIbSsCQgs44MU= Received: by 10.36.227.70 with SMTP id z70mr3230025nzg; Mon, 26 Dec 2005 04:32:45 -0800 (PST) Received: by 10.36.72.7 with HTTP; Mon, 26 Dec 2005 04:32:44 -0800 (PST) Message-ID: <674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com> Date: Mon, 26 Dec 2005 18:02:44 +0530 From: Gourish Singbal To: pgsql-performance@postgresql.org Subject: Fwd: vacuuming template0 gave ERROR In-Reply-To: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1290_12015338.1135600364977" References: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.16 required=5 tests=[AWL=0.159, HTML_MESSAGE=0.001] X-Spam-Score: 0.16 X-Spam-Level: X-Archive-Number: 200512/614 X-Sequence-Number: 16435 ------=_Part_1290_12015338.1135600364977 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ---------- Forwarded message ---------- From: Gourish Singbal Date: Dec 26, 2005 5:04 PM Subject: vacuuming template0 gave ERROR To: "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 =3D true stats_command_string =3D true stats_block_level =3D true stats_row_level =3D tue #stats_reset_on_server_start =3D true =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D step 1 update pg_database set datallowconn=3DTRUE where datname=3D'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 ------=_Part_1290_12015338.1135600364977 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

---------- 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><= br>
 
Guys,
 
Got the following ERROR when i was vacuuming the template0 database. <= /div>
postgresql server version is 7.4.5 and stats info in postgresql.conf i= s

# - Query/Index Statistics Collector -

stats_start_collector =3D true
stats_command_string =3D true
stats= _block_level =3D true
stats_row_level =3D tue
#stats_reset_on_server_= start =3D true

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D

step 1

update pg_database set datallowconn=3DTRUE where datname=3D'template0';<= /p>

 
step 2
\c template0
vacuum analyze verbose
......
.....
INFO:  vacuuming "pg_catalog.pg_statistic"
ERROR:&nb= sp; could not access status of transaction 1107341112
DETAIL:  coul= d not open file "/home/postgres/data/pg_clog/0420": No such file = or directory=20
 
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 postg= res 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-1= 2-26 03:23 0444
 
Problem: template0 is not getting vacuumed due to the above ERROR.. pl= ease let me know whats the solution.
--
Best,
Gourish Singbal

--
Best,
Gourish Singbal=20 ------=_Part_1290_12015338.1135600364977--