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 <[EMAIL PROTECTED]> To: Jim Buttafuoco <[EMAIL PROTECTED]> Cc: "Joshua D. Drake" <[EMAIL PROTECTED]>, pgsql-hackers <pgsql-hackers@postgresql.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 (<[EMAIL PROTECTED]>) > "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 ------- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster