Re: Cannot read block 348938 of pdbsynchtable - Mailing list pgsql-general

From Greg Stark
Subject Re: Cannot read block 348938 of pdbsynchtable
Date
Msg-id o2t407d949e1004080945we228fb07y28e37f1f724f6390@mail.gmail.com
Whole thread Raw
In response to Cannot read block 348938 of pdbsynchtable  ("Utsav Turray" <utsav.turray@newgen.co.in>)
List pgsql-general
On Thu, Apr 8, 2010 at 7:12 AM, Utsav Turray <utsav.turray@newgen.co.in> wrote:
> Even if If i try to pad the file  25205.3  using DD command I am not able to
> calculate the bytes to be padded as the total count of the blocks is comming
> out to be 521228 and the error is coming cannot read the 348938 block.

Assuming 25205 is the right file for this table then block 348938
would be in 25205.2 and be bytes 694,352kB - 694,360kB.

try

 dd if=25205.2 of=/tmp/data  bs=8192 skip=$(( 348938 - 2 * 128 * 1024)) count=1

see if you get the same error. If you do and you're happy to zero out
the bad block, deleting any data on it you could do something like:

 dd if=/dev/zero of=25205.2   bs=8192 seek=$(( 348938 - 2 * 128 *
1024)) count=1

--
greg

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: C-language functions: SRF question
Next
From: Jorge Arevalo
Date:
Subject: Re: C-language functions: SRF question