Re: [HACKERS] missing pg_clog files ?

2003-09-23 Thread Patrick Welche
On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote: On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote: On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: I hope I guessed the right syntax... % pg_filedump -R

[HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
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

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Tom Lane
Patrick Welche [EMAIL PROTECTED] writes: 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 # ls -l pg_clog total 32 -rw--- 1

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
On Mon, Sep 22, 2003 at 10:50:22AM -0400, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: 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

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Tom Lane
Patrick Welche [EMAIL PROTECTED] writes: I hope I guessed the right syntax... % pg_filedump -R 71716 data/base/17148/283342 Yes, but this doesn't give all the available info. Add -i and -f options. A plain -d dump might be interesting too. regards, tom lane

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: I hope I guessed the right syntax... % pg_filedump -R 71716 data/base/17148/283342 Yes, but this doesn't give all the available info. Add -i and -f options. A plain -d dump might be

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Tom Lane
Patrick Welche [EMAIL PROTECTED] writes: Indeed, the plain -d dump says that I have a chunk of /var/mail/prlw1 in 1000-13ff. No wonder postgres complained! Yipes. We have seen this sort of thing once or twice in the past. I don't know whether you are looking at a disk drive fault (dropping the

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Alvaro Herrera
On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote: On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: Patrick Welche [EMAIL PROTECTED] writes: I hope I guessed the right syntax... % pg_filedump -R 71716 data/base/17148/283342 Yes, but this doesn't give all the