Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress
От
Tom Lane
Тема
Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress
Дата
Msg-id
26153.944090813@sss.pgh.pa.us
Ответ на
NOTICE: AbortTransaction and not in in-progress (Kristofer Munn)
Список
Дерево обсуждения
NOTICE: AbortTransaction and not in in-progress Kristofer Munn <kmunn@munn.com>
Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress Tom Lane <tgl@sss.pgh.pa.us>
Kristofer Munn writes: > And in the system log I see: > FATAL 1: transaction commit failed on magnetic disk > NOTICE: AbortTransaction and not in in-progress Ugh. As near as I can tell, the "transaction commit failed" message can only come out if fsync() returns a failure indication. And that basically shouldn't be happening, unless you've got flaky disk hardware. > Any suggestions? I'll bet it stops happening if you run with -o -F (no fsync) ;-). But as for non-band-aid solutions, I haven't a clue. Anyone? regards, tom lane
В списке pgsql-hackers по дате отправления
От: Hiroshi Inoue
Дата: