Re: Serious Crash last Friday

Поиск
Список
Период
Сортировка
От Henrik Steffen
Тема Re: Serious Crash last Friday
Дата
Msg-id 01da01c228e7$42de0c40$7100a8c0@topconcepts.net
обсуждение исходный текст
Ответ на Re: Serious Crash last Friday  ("Henrik Steffen" <steffen@city-map.de>)
Список pgsql-general
aha! no, i didn't check the mem yet. but it seems like it's worth to
buy new ECC-RAM chips, if only ONE SINGLE FAULTY BIT can cause such
trouble!!

thanks for the detailed examination!

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
--------------------------------------------------------

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Henrik Steffen" <steffen@city-map.de>
Sent: Thursday, July 11, 2002 3:50 PM
Subject: Re: [GENERAL] Serious Crash last Friday


> oh, ignore previous message --- it's still too early in the morning.
>
> What you seem to have here is a single bit flip:
>
>  Item 109 -- Length:   16  Offset: 6432 (0x1920)  Flags: USED
>   Block Id: 1048595  linp Index: 3  Size: 16
>   Has Nulls: 0   Has Varlenas: 0
>
>   1920: 10001300 03001000 d1930100 02000000  ................
>
> Judging from the surrounding items, the block id in this entry should
> have been 19 (hex 00000013) ... but it's actually 00100013.  Everything
> else looks fine on the whole page.
>
> My bet is that you have a bad RAM chip that allowed the bit to flip
> while the index page was in memory.  Single-bit changes aren't usually
> what I'd expect from either software bugs or disk-related hardware
> failures.
>
> Have you done anything yet with that memory test program that some other
> folks recommended?
>
> regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Frank Joerdens
Дата:
Сообщение: providing feedback about query progress to the client app
Следующее
От: Uros Gruber
Дата:
Сообщение: Re: What is better any why