Re: Postgres 9.2.13 on AIX 7.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres 9.2.13 on AIX 7.1
Дата
Msg-id 585489.1629908370@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres 9.2.13 on AIX 7.1  (Rainer Tammer <pgsql@spg.schulergroup.com>)
Ответы Re: Postgres 9.2.13 on AIX 7.1  (Rainer Tammer <pgsql@spg.schulergroup.com>)
Список pgsql-bugs
Rainer Tammer <pgsql@spg.schulergroup.com> writes:
> It did run the server with auto vacuum disabled for ~ 24h - no server 
> shutdown.
> After re-enabling auto vacuum the server dies in less then 9 hours:

This is just speculation, but it fits the reported facts: somewhere
you've got something that tries to limit the resources consumed by
a background process, and when it decides the limit is exhausted
then it sends SIGINT.  Without autovacuum waking up every so often,
the time for PG-as-a-whole to hit the hypothetical limit would be
much longer.

> Would it be worth adding additional code before every signal to trace 
> the source ID and the target PID as well as the source/target process name?

I will be *mightily* astonished if the signal is coming from
within PG.  The more so since it appears to be happening while
the instance is entirely idle.

            regards, tom lane



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

Предыдущее
От: Rainer Tammer
Дата:
Сообщение: Re: Postgres 9.2.13 on AIX 7.1
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function