Re: Serious Crash last Friday
От | Henrik Steffen |
---|---|
Тема | Re: Serious Crash last Friday |
Дата | |
Msg-id | 00d101c228a4$1e6b6ee0$7100a8c0@topconcepts.net обсуждение исходный текст |
Ответ на | Re: Serious Crash last Friday ("Henrik Steffen" <steffen@city-map.de>) |
Ответы |
Re: Serious Crash last Friday
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-general |
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 --------------------------------------------------------
В списке pgsql-general по дате отправления: