Skip site navigation (1) Skip section navigation (2)

Re: BUG #3484: Missing pg_clog file / corrupt index

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Feng Chen <fchen(at)covergence(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: BUG #3484: Missing pg_clog file / corrupt index
Date: 2007-08-24 14:01:58
Message-ID: 20070824140158.GM31461@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

pgsql-bugs by date

Next:From: Feng ChenDate: 2007-08-24 14:06:56
Subject: Re: [SPAM] Re: BUG #3484: Missing pg_clog file / corrupt index
Previous:From: Stefan KaltenbrunnerDate: 2007-08-24 13:57:08
Subject: Re: BUG #3484: Missing pg_clog file / corrupt index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group