Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index - Mailing list pgsql-bugs

From Feng Chen
Subject Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Date
Msg-id 0D1719326D64BD4E9F92A0C120237678029B8957@eserv.covergence.com
Whole thread Raw
In response to Re: BUG #3484: Missing pg_clog file / corrupt index  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
List pgsql-bugs
VERSION =3D PostgreSQL 8.1.2

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]=20
Sent: Friday, August 24, 2007 10:02 AM
To: Feng Chen
Cc: Gregory Stark; Marc Schablewski; Decibel!; pgsql-bugs@postgresql.org
Subject: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

Feng Chen wrote:
> We also have the same exact problem - every 5 to 10 days when the data
> get to some size, PostgreSQL complains about missing pg_clog files, and
> invalid page headers during either vacuum or reindex operations.

What PG version is this?

> 2007-08-13T10:12:15+00:00  ERROR:  could not access status of
> transaction 0
> 2007-08-13T10:12:15+00:00  DETAIL:  could not create file
> "pg_subtrans/0201": File exists

Huh???

--=20
Alvaro Herrera                          Developer, http://www.PostgreSQL.or=
g/
"Aprende a avergonzarte m=E1s ante ti que ante los dem=E1s" (Dem=F3crito)

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #3484: Missing pg_clog file / corrupt index
Next
From: Andrew Sullivan
Date:
Subject: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index