Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index

From: "Feng Chen" <fchen(at)covergence(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Marc Schablewski" <ms(at)clickware(dot)de>, "Decibel!" <decibel(at)decibel(dot)org>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Date: 2007-08-24 14:06:56
Message-ID: 0D1719326D64BD4E9F92A0C120237678029B8957@eserv.covergence.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

VERSION = PostgreSQL 8.1.2

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Friday, August 24, 2007 10:02 AM
To: Feng Chen
Cc: Gregory Stark; Marc Schablewski; Decibel!; pgsql-bugs(at)postgresql(dot)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???

--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Sullivan 2007-08-24 14:11:06 Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Previous Message Alvaro Herrera 2007-08-24 14:01:58 Re: BUG #3484: Missing pg_clog file / corrupt index