Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring - Mailing list pgsql-bugs

From Tom Vijlbrief
Subject Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Date
Msg-id CAOQrpVdd82ADYRJNHbGAzmMrEyamjczz=yb4tQ1kLWr5FkNH6g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
List pgsql-bugs
Tree view

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 by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: BUG #16486: Prompted password is ignored when password specified in connection string
Next
From: Jurko Gospodnetić
Date:
Subject: Re: BUG #16660: 64-bit build fails when run on a subst drive (resend)