Horton

RE: error "can only drop stats once" brings down database

Floris Van Nee <florisvannee@optiver.com>

View thread View on postgr.es
From: Floris Van Nee <florisvannee@Optiver.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Andres Freund <andres@anarazel.de>, Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2024-06-05T10:31:04Z
Lists: pgsql-bugs 
> 
> The only reason why I did not do one or the other yet is that this is an
> improvement, hence I was waiting for v18 to open.  If somebody feels
> differently, feel free to proceed before that with the format you like.  Still I'd
> vote for the addition of the refcount to the patch proposed on this thread, to
> provide more debugging info to the information reported.

This patch would help in getting more info about this specific issue if it reoccurs, but in that case it's only helpful if it's backpatched.
Agree the refcount addition makes sense.

-Floris

Commits

  1. Add more debugging information when dropping twice pgstats entry