Re: Losing records when server hang - Mailing list pgsql-general

From lec
Subject Re: Losing records when server hang
Date
Msg-id 41179491.8010004@streamyx.com
Whole thread Raw
In response to Losing records when server hang  (lec <limec@streamyx.com>)
Responses Re: Losing records when server hang  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
"Scott Marlowe" <smarlowe@qwest.net> writes: 
On Sun, 2004-08-08 at 21:26, Alvaro Herrera Munoz wrote:   
If this is only one backend, then I'd love to see how did he do that.     
 
Me too :-)   
Given a disk drive that lies about write complete (which is to to say,
most consumer-grade IDE gear), it's at least theoretically possible.
But it doesn't sound real likely, especially if the machine didn't
actually lose power. 
It's a SCSI, RAID-5 on a Dell server.
I was wondering what he meant by "hang", as well as what he meant by
"commit".  The overall lack of detail in the report is notable. 
The hardware actually "hang".  The Dell engineers came and replaced the motherboard but couldn't tell what the actual fault was.

Commit as in 'COMMIT'.  'Records' 1,2,3,4,5,6,7,8,9,10 are actually transactions.  I'm as puzzled as to why I lost the transactions in the middle but got the last transaction.
		regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

 

pgsql-general by date:

Previous
From: lec
Date:
Subject: Re: Losing records when server hang
Next
From: lec
Date:
Subject: Re: Losing records when server hang