Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound
Date: 2026-10-16 15:44:10
Message-ID: CAGRkXqRU4Q9As7b==KZEhu+Z+-vB6vCzdD4e_oRwp=tjXh9eUg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

> In 2024, Prime Minister Rishi Sunak described the scandal as one of
> the greatest miscarriages of justice in British history.

Well, that escalated quickly. I was going for "someone misses a
paycheck", and you raised me "thirteen suicides and a Prime Minister
apologizing in Parliament". 😓

On the bright side, this particular 1-in-2^32 bug will not be sending
anyone to prison.

Looks like Heikki committed the fix before I finished reading
the Wikipedia article. Thanks Zsolt for finding it and Heikki for the
quick commit.

Thanks,
Shihao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-10-16 15:53:01 pgstat: don't assert on dropped entries when writing stats file
Previous Message Álvaro Herrera 2026-10-16 15:43:11 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData)