Re: Serious Crash last Friday

Hello Tom,

I now did a "pg_filedump -R 1048595 16584" on the file
/var/lib/pgsql/data/base/16556/16584

It delivered the following output. Can you read anything from it?

*****************************************************************
* PostgreSQL File/Block Formatted Dump Utility
*
* File: 16584
* Options used: -R 1048595
*
* Dump created on: Thu Jul 11 08:13:47 2002
*****************************************************************

Block 1048595 ******************************************************
<Header> -----
Block Offset: 0x00026000 Offsets: Lower 156 (0x009c)
Block Size: 8192 Upper 200 (0x00c8)
LSN: logid 0 recoff 0x00982b4c Special 8192 (0x2000)
Items: 34 Free Space: 44
Length (including item array): 160

<Data> ------
Item 1 -- Length: 613 Offset: 7576 (0x1d98) Flags: USED
Item 2 -- Length: 61 Offset: 7512 (0x1d58) Flags: USED
Item 3 -- Length: 83 Offset: 7428 (0x1d04) Flags: USED
Item 4 -- Length: 109 Offset: 7316 (0x1c94) Flags: USED
Item 5 -- Length: 405 Offset: 6908 (0x1afc) Flags: USED
Item 6 -- Length: 61 Offset: 6844 (0x1abc) Flags: USED
Item 7 -- Length: 397 Offset: 6444 (0x192c) Flags: USED
Item 8 -- Length: 61 Offset: 6380 (0x18ec) Flags: USED
Item 9 -- Length: 729 Offset: 5648 (0x1610) Flags: USED
Item 10 -- Length: 61 Offset: 5584 (0x15d0) Flags: USED
Item 11 -- Length: 881 Offset: 4700 (0x125c) Flags: USED
Item 12 -- Length: 457 Offset: 4240 (0x1090) Flags: USED
Item 13 -- Length: 61 Offset: 4176 (0x1050) Flags: USED
Item 14 -- Length: 345 Offset: 3828 (0x0ef4) Flags: USED
Item 15 -- Length: 61 Offset: 3764 (0x0eb4) Flags: USED
Item 16 -- Length: 329 Offset: 3432 (0x0d68) Flags: USED
Item 17 -- Length: 61 Offset: 3368 (0x0d28) Flags: USED
Item 18 -- Length: 457 Offset: 2908 (0x0b5c) Flags: USED
Item 19 -- Length: 61 Offset: 2844 (0x0b1c) Flags: USED
Item 20 -- Length: 485 Offset: 2356 (0x0934) Flags: USED
Item 21 -- Length: 61 Offset: 2292 (0x08f4) Flags: USED
Item 22 -- Length: 61 Offset: 2228 (0x08b4) Flags: USED
Item 23 -- Length: 61 Offset: 2164 (0x0874) Flags: USED
Item 24 -- Length: 61 Offset: 2100 (0x0834) Flags: USED
Item 25 -- Length: 321 Offset: 1776 (0x06f0) Flags: USED
Item 26 -- Length: 61 Offset: 1712 (0x06b0) Flags: USED
Item 27 -- Length: 168 Offset: 1544 (0x0608) Flags: USED
Item 28 -- Length: 88 Offset: 1456 (0x05b0) Flags: USED
Item 29 -- Length: 97 Offset: 1356 (0x054c) Flags: USED
Item 30 -- Length: 61 Offset: 1292 (0x050c) Flags: USED
Item 31 -- Length: 157 Offset: 1132 (0x046c) Flags: USED
Item 32 -- Length: 801 Offset: 328 (0x0148) Flags: USED
Item 33 -- Length: 61 Offset: 264 (0x0108) Flags: USED
Item 34 -- Length: 61 Offset: 200 (0x00c8) Flags: USED

*** End of Requested Range Encountered. Last Block Read: 1048595 ***

I still get the following error, even on the old renamed temp-table:
ERROR: cannot open segment 1 of relation pg_toast_16584 (target block
1048595): No such file or directory

Why is that? The file 16584 exists. The target block exists, though it seems
to be the last
existing block in this particular file.

I even tried the -d option on pg_filedump ... it delivers a 36 MB file...
I can send it to you privately if you want.

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------