Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring

Поиск
Список
Период
Сортировка
От Tom Vijlbrief
Тема Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Дата
Msg-id CAOQrpVdd82ADYRJNHbGAzmMrEyamjczz=yb4tQ1kLWr5FkNH6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения

Op ma 2 nov. 2020 om 00:45 schreef Tom Lane <tgl@sss.pgh.pa.us>:
> PG Bug reporting form <noreply@postgresql.org> writes:
>> This looks to me like a low level issue with Postgres13 and TOAST objects of
>> a specific size and or compression behavior.

After looking at it some more, I'm pretty sure that these issues could
explain your problem, though it's possible there's an additional
contributing issue.  If you're in a position to apply a patch and
see whether it fixes the problem, please try

https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=2330f4d3a87ac43b6ecd31bfd698384888ed03cb


Yes, this patch fixes the problem.

Thanks,
Tom

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: BUG #16486: Prompted password is ignored when password specified in connection string
Следующее
От: Jurko Gospodnetić
Дата:
Сообщение: Re: BUG #16660: 64-bit build fails when run on a subst drive (resend)