PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15896
PG Version
OS
Opened2019-07-05 12:51:01+00
Reported by
StatusNew

Body of first available message related to this bug follows.

Am Freitag, den 05.07.2019, 09:59 +0000 schrieb PG Bug reporting form:
> 12beta2:
> SELECT * FROM phone ORDER BY name;
> TRAP: FailedAssertion(»!(metad->btm_version >= 3)«, Datei:
> »/build/postgresql-12-3URvLF/postgresql-12-
> 12~beta2/build/../src/backend/access/nbtree/nbtpage.c«,
> Zeile: 665)
> 2019-07-05 11:34:35.040 CEST [14325] LOG:  Serverprozess (PID 14376)
> wurde
> von Signal 6 beendet: Abgebrochen
> 2019-07-05 11:34:35.040 CEST [14325] DETAIL:  Der fehlgeschlagene
> Prozess
> führte aus: SELECT * FROM phone ORDER BY name;

Additional note from me after a short test:

It works if you upgrade to PG11 first _and_ have touched the index in a
way it has rewritten the metapage to version 3, e.g. adding new pages
to the index.

Thanks

	Bernd

Messages

DateAuthorSubject
2019-07-05 12:51:01+00Bernd HelmleRe: BUG #15896: pg_upgrade from 10-or-earlier: TRAP: =?ISO-8859-1?Q?FailedAssertion=28=BB!=28meta?= =?ISO-8859-1?Q?d-=3Ebtm=5Fversion?= >= =?ISO-8859-1?Q?3=29=AB?=
2019-07-05 15:49:08+00Alvaro HerreraRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=
2019-07-06 13:11:18+00Christoph BergRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=
2019-07-11 08:15:53+00Michael PaquierRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=
2019-07-16 08:13:46+00Christoph BergRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=
2019-07-18 09:30:37+00Christoph BergRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=
2019-07-18 20:57:50+00Alvaro HerreraRe: BUG #15896: =?iso-8859-1?Q?pg=5Fupgrad?= =?iso-8859-1?Q?e_from_10-or-earlier=3A_TRAP=3A_FailedAssertion=28=BB!=28m?= =?iso-8859-1?B?ZXRhZC0+YnRtX3ZlcnNpb24gPj0gMymr?=