missing pg_clog files ?

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: missing pg_clog files ?
Date: 2003-09-22 13:02:06
Message-ID: 20030922140206.D12708@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

There was a thread on missing pg_clog files caused due to dodgy practices in
glibc *last year*. I am seeing something similar *now* with a server

PostgreSQL 7.4beta1 on i386-unknown-netbsdelf1.6X, compiled by GCC 2.95.3

accessed by a similar client and a client

PostgreSQL 7.4devel on i686-pc-linux-gnu, compiled by GCC 2.95.4

The following works:

select * from olddata02_03vac offset 2573718 limit 1;

however

select * from olddata02_03vac offset 2573719 limit 1;
ERROR: could not access status of transaction 1664158221
DETAIL: open of file "/usr/local/pgsql/data/pg_clog/0633" failed: No such file or directory

and

# ls -l pg_clog
total 32
-rw------- 1 postgres postgres 16384 Sep 22 13:12 0000
#

Is it true that the problem was with the server, so the fact that a glibc
client was connecting and possibly doing a vacuum is irrelevant?

What can I do now to fix it? Known problem with beta1 which is now old?

Cheers,

Patrick

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-22 14:50:22 Re: missing pg_clog files ?
Previous Message Eric Ridge 2003-09-22 05:46:15 Re: Can't Build 7.3.4 on OS X