Re: Core dump on 7.1.3 on Linux 2.2.19

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Core dump on 7.1.3 on Linux 2.2.19
Дата
Msg-id 4510.1005010300@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Core dump on 7.1.3 on Linux 2.2.19  (Barry Lind <barry@xythos.com>)
Список pgsql-hackers
Barry Lind <barry@xythos.com> writes:
> It happened to me this afternoon while running a 'vacuum analyze 
> verbose'.  I have attached the stack trace below.

That trace is certainly not from a vacuum operation.

I'd suggest rebuilding with --enable-debug; we won't be able to learn
much without that.  Until you do that, possibly it'd help to turn on
query logging so that we can learn what query is crashing.

I find the presence of EvalPlanQual in the backtrace suggestive.
I don't trust that code at all ;-) ... but without a lot more info
we're not going to be able to figure out anything.

BTW, EvalPlanQual is only called if the query is an UPDATE or DELETE
that tries to update a row that's already been updated by a
not-yet-committed transaction.  That probably explains why you don't
see the crash often --- if you deliberately set up the right
circumstances, you could perhaps reproduce it on-demand.
        regards, tom lane


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

Предыдущее
От: Barry Lind
Дата:
Сообщение: Core dump on 7.1.3 on Linux 2.2.19
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql