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
обсуждение исходный текст
Ответы Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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
Дата:
Сообщение: Re: [ADMIN] When postgres will be faster?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] NOTICE: AbortTransaction and not in in-progress