Re: pg_clog problem (PG version 7.4.5)

Alvaro,

Thanks for the reply. here is an "ls" of my pg_clog directory. The 0402 file, I created as per Joshua's directions.
I might have created one too small. If so, what size do you think I should use.

Jim

bda1:/usr/local/pgsql/data# ls -l pg_clog
total 992
-rw------- 1 postgres dba 262144 Sep 7 10:12 0000
-rw------- 1 postgres dba 262144 Nov 12 09:57 0001
-rw------- 1 postgres dba 262144 Dec 7 17:31 0002
-rw------- 1 postgres dba 204800 Jan 22 13:11 0003
-rw-r--r-- 1 postgres dba 8192 Jan 22 12:05 0402

---------- Original Message -----------
From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Jim Buttafuoco <jim(at)contactbda(dot)com>
Cc: "Joshua D. Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Sent: Sat, 22 Jan 2005 15:07:35 -0300
Subject: Re: [HACKERS] pg_clog problem (PG version 7.4.5)

> On Sat, Jan 22, 2005 at 12:06:46PM -0500, Jim Buttafuoco wrote:
> > didn't work.
> >
> >
> > ERROR: could not access status of transaction 1076101119
> > DETAIL: could not read from file "/usr/local/pgsql/data/pg_clog/0402" at offset 57344: Success
> >
> > any more ideas?
>
> You need to extend the file further than byte 57344. So repeat the dd
> command, with count=8.
>
> Anyway, this situation is suspect anyway. There were bugs related to
> pg_clog files not being there, but AFAIR they were triggered on segment
> edges, not in the middle like this one.
>
> What other files there are in the pg_clog directory? If they are
> nowhere near the 0402 vicinity, you may have a memory or disk
> corruption problem.
>
> FWIW, 1076101119 is 1000000001000111111111111111111 in binary. Taking
> the highest 1 yeilds Xid 2359295. So, what files do you have?
>
> --
> Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
> "La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
> Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
------- End of Original Message -------