Re: Losing records when server hang

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