simple_heap_update problem

Поиск
Список
Период
Сортировка
От nmueller@cs.wisc.edu
Тема simple_heap_update problem
Дата
Msg-id 200308102029.PAA29081@norm.cs.wisc.edu
обсуждение исходный текст
Ответы Re: simple_heap_update problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
For the last few weeks (still haven't figure out what changed before
this started) one of our apps has been generating this error message on
the backend one or two times a day. I'm pretty sure it's not an
application error since it can be successfully re-run with the same
inputs. The application does several queries and I'm not sure which one
causes the error. I searched the web and found this error being caused
by concurrent ANALYZE commands, but that's not happening here.

Aug 7 13:23:30 calchas postgres[27794]: [3] ERROR: simple_heap_update:
tuple concurrently updated Aug 7 13:23:30 calchas postgres[27794]: [4]
WARNING: AbortTransaction and not in in-progress state

Any ideas? I realize this isn't too much information -- what can I do
(besides logging queries, which I just started) to get more?
       --Nate


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: 7.4Beta1 hang?
Следующее
От: nmueller@cs.wisc.edu
Дата:
Сообщение: Re: simple_heap_update problem