Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1xQb-0006fs-QM for pgsql-general@arkaria.postgresql.org; Sun, 04 Dec 2022 22:25:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p1xQY-00064K-Bu for pgsql-general@arkaria.postgresql.org; Sun, 04 Dec 2022 22:25:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1xQX-00064A-WE for pgsql-general@lists.postgresql.org; Sun, 04 Dec 2022 22:25:38 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p1xQU-0002Mu-Ui for pgsql-general@lists.postgresql.org; Sun, 04 Dec 2022 22:25:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1670192729; bh=IRLMZ7Lm+UJjemXBaOIowCV0u7sYbT3BAaKxiaGhV3c=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=Jh1lJsbjzh+vh5iIX581Lq2pKeNWSHElFgXUMN14IIqLf/+/AvKpDULiAKnTZyDE+ q/y1LL2Qitt8IJrk3ELcOwMZE3V5IfzTaphOem7w4wiE/kUyfoWNd9yAQI/R47pN6m R3EWHWn5OX62aMzlOj2MKMq+J+HFUY/2AQAsbLq46LIGLJfj96WpWnHFGmdyoCTPeW sk2fFlaSRUbqPNtd9FAtAyy1Bov2+E34Z6/1g9iWAA63kefyh9gOFK6JXEpG1kTpbK SqWclJ8W80WTH1duVMwwuFHbiQQ0rV8VWN2zHowIGJkK+HF7M3lAp9VHpgzPab60vT f/JEmritl3Swg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.201.66]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1N6sn7-1ouk6w1x0R-018H8l; Sun, 04 Dec 2022 23:25:29 +0100 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1p1xQN-0000dO-Kd; Sun, 04 Dec 2022 23:25:27 +0100 Date: Sun, 4 Dec 2022 23:25:27 +0100 From: Karsten Hilbert To: Adrian Klaver Cc: pgsql-general@lists.postgresql.org Subject: Re: Q: error on updating collation version information Message-ID: References: <954702a5-3552-640e-6df9-a03ab5fbc339@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <954702a5-3552-640e-6df9-a03ab5fbc339@aklaver.com> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:HVUAt9bKwNkKtamlULxW11CIW/kZI/ZKzmBkIOoytxino5xwOKo 4L59OjVRqEu7UTghkIWdeEksPIMhswf3MOAZC2UZqbv4cQ4HHIDV3khVYNx/vRVGRLDvF9N 4T3snqlXfQqm2ef927qlrDXhnHf8SqjT3KqM+3vt0LsxEISVBsyGyNIyPLahV60WugJooSk auxkMsZccJXlPATS5rwsw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:T6MVOi+e2l8=;V6Hv4DTeYaafKmxHPZ3RUwVzFe5 ofdWo2B3ezoC0WtLC2Tocr8Itx4fm1rJBp1yG1O2nSY461jTkKY9titGeJ7CYsM4qk8RUR1xI 4F0QrxbkIrGY6/8F1CbV1AUNU6utBNFp22TUa6CDbILjepAeaODnb6wOmV06sXAYB1ZGFtaH3 M3x6/M+pHN4BrO70iLpVI5W56s6NNq/gp2Yg+rufl+HKdHCotaEgDZpaumWoKPVnFle8Yu5av oZa6LxpSYDV+ss7IZL8mCvoq+7AFa0oaDwf0PMNrL9I/dLVXuNes7jkBiGIKOTsHSkwdT0ZjV PNk09JYY6TJtIOXV38HIdHx2Ydb6uETglZhqVDrFkheVWAn8FBkcdi+P7fxWykGU3t9XvyPHY rYbQCkKicSUDc4cxVtd4cRgiXq17vXJbjuTazMia7eIiHy0hjMIFb6cZHawEqvzbNlnFr1HiS X+Cs8ugo7guHmjGuG00wM0xR/S9WyLXsYsJcq75gItRAUob/glPQr6i4LDZ0ysjT+vCkxjvrA bshY2GSgudeP+dUs2GhdN4fwc4d+TkhUbuSEIOaCVnLN3E6qY8ql/t3iA8wa++roczOnAigDF ndv6e/7oc+9kNQoWlqdqLlSpp74OT0c8tFIogrXlqCBsGYWkLw9E2NKi/4aqHBFHYQ75jP+o/ C+f6gG7QVatVvo40GlUzcb3ZhZcvWspBnyUr7gst+YXvl5ZCINHOb4YQaeotPMEVXM9dVkUAI D72daeLuYQbB/sMINmp/fihuDppJwz7MMiemoS5E7boOeszBBMB4AERZOAm7t82qsNbJ3vW5G C9gymJ1hK0e50LBxXXAU6clxlUEyUduNuTtIb31ORAc3B/A75N8qoqbzML6/audpflkYiGZZb yi9jv/iqlQKilqyqKcphqXmOzIUEsM4v2rihEZgPABH3KWlkK09ZNK+ULU9ymfru5SzYjBCrY StxF/w== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Sun, Dec 04, 2022 at 10:09:47AM -0800 schrieb Adrian Klaver: > >>following an ICU upgrade, collations in a stock Debian PG 15.1 > >>cluster now have divergent version information in pg_collations. > > > >Correction: this is following a libc upgrade 2.35 -> 2.36 > > So to be clear this database is not using ICU, but collations from libc? Sorry for the confusion. This database carries collations from _both_ libc and ICU in pg_collations. The collation in question (br_FR@euro) is _not_ in use (as in being depended on by any in-database object). > How was the database installed? stock Debian apt-get install postgresql-15 (which gives 15.1) followed by CREATE DATABASE "gnumed_v22" with owner =3D "redacted :-)" template =3D "= template1" encoding =3D 'unicode'; as "postgres". > In first post you had: > > gnumed_v22=3D> select *, pg_encoding_to_char(collencoding) from pg_colla= tion where > collname =3D 'br_FR@euro'; > -[ RECORD 1 ]-------+----------- > oid | 12413 > collname | br_FR@euro > collnamespace | 11 > collowner | 10 > collprovider | c > collisdeterministic | t > collencoding | 16 > collcollate | br_FR@euro > collctype | br_FR@euro > colliculocale | > collversion | 2.35 > pg_encoding_to_char | LATIN9 > > where collprovider c means libc and collversion 2.35. Yeah, that's when I figured that I misspoke about the ICU upgrade. Yes, there was an ICU upgrade, and yes, it did affect collations. Those I was able to fix up (the "reindex / revalidate constraint / refresh collation version" dance). There also was a libc upgrade which also affected locales. Most of them were fixable by that dance but some popped up (such as br_FR@euro) to not be "correctable" showing the "does not exist for encoding" error. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B