Re: Cannot read block 348938 of pdbsynchtable

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Utsav Turray <utsav(dot)turray(at)newgen(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot read block 348938 of pdbsynchtable
Date: 2010-04-08 16:45:42
Message-ID: o2t407d949e1004080945we228fb07y28e37f1f724f6390@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 8, 2010 at 7:12 AM, Utsav Turray <utsav(dot)turray(at)newgen(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Arevalo 2010-04-08 17:04:28 Re: C-language functions: SRF question
Previous Message Merlin Moncure 2010-04-08 16:18:55 Re: C-language functions: SRF question