NOTICE: AbortTransaction and not in in-progress

Поиск
Список
Период
Сортировка
Искать
От
Kristofer Munn
Тема
NOTICE: AbortTransaction and not in in-progress
Дата
Msg-id
Pine.LNX.4.04.9912011617550.5638-100000@dec.munn.com
Список
Дерево обсуждения
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>
Hi guys, thanks for all your great work on this system.  I'm really
hammering my copy of Postgres and that's probably the only reason I'm
seeing these errors.

PostgreSQL V6.5.2 on i686-pc-linux-gnu

I occasionally (twice a day) receive the error:
NOTICE: AbortTransaction and not in in-progress

And in the system log I see:
FATAL 1:  transaction commit failed on magnetic diskNOTICE:  AbortTransaction and not in in-progress

The connection to the backend drops.  I'm detecting the fatal error,
reconnecting and re-issuing the command right away and it goes through
fine the second time.

Any suggestions?

- K

Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * ICQ 352499 * www.munn.com


В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
От: Tom Lane
Дата:
FAQ