Re: Very slow queries followed by checkpointer process killed with signal 9

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Very slow queries followed by checkpointer process killed with signal 9
Дата
Msg-id ZCrPPJs7Z3vZeOC2@squirrel.exwg.net
обсуждение исходный текст
Ответ на Re: Very slow queries followed by checkpointer process killed with signal 9  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
## Tom Lane (tgl@sss.pgh.pa.us):

> Jason McLaurin <jason@jcore.io> writes:
> > I'm troubleshooting an issue where about once a week, a database appears to
> > lock up and then the PostgreSQL process crashes and recovers. When this
> > happens, a few queries will be logged, but there is no pattern to which
> > queries are executing when the crash happens, and the queries logged don't
> > appear to be queries that would consume a lot of resources.
> 
> Hmm, is it always the checkpointer that gets the OOM kill?  That seems
> quite odd.

Are you sure it's OOM? That's a frequent source of SIGKILLs, but
SIGKILL is not exclusive to oomkiller. Maybe something in the
container stack (some cgroup resource limiting? would be in line
with slowdown at least; or a hard ulimit on cpu time?) or maybe even
some "anti virus" thingy ("It's been 0 days since AV ate the database").

Regards,
Christoph

-- 
Spare Space.



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

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: DEFINER / INVOKER conundrum
Следующее
От: Ron
Дата:
Сообщение: Re: Patroni vs pgpool II