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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Floris Van Nee <florisvannee(at)optiver(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: error "can only drop stats once" brings down database
Date: 2024-06-04 05:04:00
Message-ID: Zl6gQNSeWoBdijxZ@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Jun 02, 2024 at 10:01:53PM +0000, Floris Van Nee wrote:
> Would it make sense to at least commit your patch to enhance the
> error message a bit?

FWIW, I am +1 for the improvement of this error message.

Note that there is a very similar proposal here:
https://www.postgresql.org/message-id/ZkM30paAD8Cr/Bix(at)ip-10-97-1-34(dot)eu-west-3(dot)compute(dot)internal

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.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2024-06-04 05:25:23 Re: BUG #17947: Combination of replslots pgstat issues causes error/assertion failure
Previous Message Michael Paquier 2024-06-04 04:53:04 Re: pg_rewind fails on Windows where tablespaces are used