From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | Chester Kustarz <chester(at)arbor(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Corrupted Data? |
Date: | 2004-09-15 01:38:41 |
Message-ID: | 20040915013841.GF18730@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Sep 14, 2004 at 08:01:13PM -0400, Matthew T. O'Connor wrote:
> Alvaro Herrera wrote:
> >On Tue, Sep 14, 2004 at 08:13:24AM -0400, Matthew T. O'Connor wrote:
> >You can create a pg_clog file (the one it's complaining about) filled
> >with zeros, using
> >dd if=/dev/zero bs=1k count=8 of=/path/to/data/pg_clog/0E3D
>
> Ok, I tried this, and it changed the error but hasn't fixed the problem
> now I get this:
>
> [dbmail2(at)dezeut dbmail2]$ psql
> Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
> dbmail2=# delete from messageblks where messageblk_idnr = 7718;
> ERROR: could not access status of transaction 3822646358
> DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/0E3D" at
> offset 139264: Success
Huh, sorry, the directions only created the first block of the file, but
you needed the 17th ...
dd if=/dev/zero bs=8k count=17 of=/path/to/data/pg_clog/0E3D
I may be subject of a fencepost problem here, so if it doesn't work try
with 18.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Limítate a mirar... y algun día veras"
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-09-15 01:49:21 | Re: disk performance benchmarks |
Previous Message | Matthew T. O'Connor | 2004-09-15 00:01:13 | Re: Corrupted Data? |