Re: crash during autovacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: crash during autovacuum
Дата
Msg-id 21518.1546010774@sss.pgh.pa.us
обсуждение исходный текст
Ответ на crash during autovacuum  (wambacher@posteo.de)
Список pgsql-admin
wambacher@posteo.de writes:
> this morning my database crashed, because of a problem during autovacuum.
> this is the second time during the last 2 month and i can't find out why.

Can you get a stack trace from the crash?

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

The evidence may be gone by now for your current crash, but if so, make
sure you are prepared to capture info from the next one.

The other respondent might be right that this ultimately traces to
data corruption, but it's hard to be sure without more info.

            regards, tom lane


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

Предыдущее
От: ZongtianHou
Дата:
Сообщение: Schema and Namespace Oid confusion
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Schema and Namespace Oid confusion