Horton

Re: Fix possible overflow of pg_stat DSA's refcnt

Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>

View thread View on postgr.es
From: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2024-06-26T06:48:06Z
Lists: pgsql-hackers 
On Wed, Jun 26, 2024 at 7:40 AM Michael Paquier <michael@paquier.xyz> wrote:
>
> Very good catch!  It looks like you have seen that in the field, then.
> Sad face.

Yeah, this happened last week on one of our replicas (version 15.5)
last week that had 134 days uptime. We are doing a lot of parallel
queries on this cluster so the combination of high uptime plus
parallel workers creation eventually triggered the issue.

> Will fix and backpatch, thanks for the report!

Thanks for handling this and for the quick answer!

Regards,
Anthonin

Commits

  1. Fix overflow with pgstats DSA reference count