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
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 |