Re: START_REPLICATION SLOT causing a crash in an assert build

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: michael(at)paquier(dot)xyz
Cc: jkatz(at)postgresql(dot)org, andres(at)anarazel(dot)de, jcasanov(at)systemguards(dot)com(dot)ec, pgsql-hackers(at)postgresql(dot)org, john(dot)naylor(at)enterprisedb(dot)com
Subject: Re: START_REPLICATION SLOT causing a crash in an assert build
Date: 2022-10-06 05:10:46
Message-ID: 20221006.141046.2033876856853955342.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Thu, 6 Oct 2022 13:44:43 +0900, Michael Paquier <michael(at)paquier(dot)xyz> wrote in
> On Wed, Oct 05, 2022 at 11:24:57PM -0400, Jonathan S. Katz wrote:
> > On 10/5/22 8:44 PM, Andres Freund wrote:
> >> I have two ideas how to fix it. As a design constraint, I'd be interested in
> >> the RMTs opinion on the following:
> >> Is a cleaner fix that changes the stats format (i.e. existing stats will be
> >> thrown away when upgrading) or one that doesn't change the stats format
> >> preferrable?
> >
> > [My opinion, will let Michael/John chime in]
> >
> > Ideally we would keep the stats on upgrade -- I think that's the better user
> > experience.
>
> The release has not happened yet, so I would be fine to remain
> flexible and bump again PGSTAT_FILE_FORMAT_ID so as we have the
> cleanest approach in place for the release and the future. At the
> end, we would throw automatically the data of a file that's marked
> with a version that does not match with what we expect at load time,
> so there's a limited impact on the user experience, except, well,
> losing these stats, of course.

+1. FWIW, the atttached is an example of what it looks like if we
avoid file format change.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

Attachment Content-Type Size
v2-0001-If-we-avoid-file-format.patch text/x-patch 5.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-10-06 05:10:56 Re: Issue with pg_stat_subscription_stats
Previous Message Peter Smith 2022-10-06 05:07:52 Re: [DOCS] Stats views and functions not in order?