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

From: Tom Vijlbrief <tvijlbrief(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Subject: Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Date: 2020-11-02 09:30:54
Message-ID: CAOQrpVdd82ADYRJNHbGAzmMrEyamjczz=yb4tQ1kLWr5FkNH6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Op ma 2 nov. 2020 om 00:45 schreef Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> > PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

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