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@topconcepts.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
--------------------------------------------------------