Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXd3p-00CIji-SI for pgsql-general@arkaria.postgresql.org; Fri, 04 Jul 2025 09:50:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uXd3n-0002Mo-Sl for pgsql-general@arkaria.postgresql.org; Fri, 04 Jul 2025 09:50:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXd3n-0002Mg-Fu for pgsql-general@lists.postgresql.org; Fri, 04 Jul 2025 09:50:24 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uXd3l-005ft3-2Z for pgsql-general@lists.postgresql.org; Fri, 04 Jul 2025 09:50:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1751622620; x=1752227420; i=shammat@gmx.net; bh=k2weG4zr2VbrymRF9VedjDRPoJkotuivLsMDME3gH9k=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=Bo5U89Jes56C0Ttw/UaoJjWHZBkumil5DBFL6o/JKvnNq8p5ws3rNOE36MWkwiLL LpSu6XQsWpNLyf5S8VSbtaNNvKYDqGYrYw3PKgvrkQ3umkBIU6NVkmwA8NrlOCnYE 15OcTwCqcwT/AqgDYK8Pq1Al0ByE0DXwDbHuZbdslf/VaIzqoiJAtoFjqDhKd9Hgk d9FZuRLgxRSZ2oHkwqqo0xCTzmYsSQkNnGghZLQtoEbvHOHwcmtcPR9I/7jUVgFd/ 75C2RR/PYdevfJSPB+KIFO6lyN8UH9jsnayNq8KjMR4XU6Bnmn+EO18IMTeQTfbKM nnkQni/kczYU0HwAuQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.1.77] ([185.40.248.10]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MiaYJ-1v9BKW3WwZ-00qF0D for ; Fri, 04 Jul 2025 11:50:19 +0200 Message-ID: <6833523d-8e84-4749-952a-dcbfe9246d19@gmx.net> Date: Fri, 4 Jul 2025 11:50:19 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Corrupt btree index includes rows that don't match To: pgsql-general@lists.postgresql.org References: Content-Language: de-DE, en-US From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Nr88WL2MxO9jznW5+e06eEZuocK6r8N6UUcCn5CUZAhClmeJRXD stKC3qXoTCL5sy6+gSYlLhe9yRj07VR1Zq1LQdLSDNsDgl+iIWM9YZRAq0aaNO7xB6HIP0q 7k6h6VO0urVsMD72Snqo0r3dRGxKDM79ofU1I/m353bknv3d98DPGXLVoRzswY03TTiTmNm 7dycURi00+uVJ5JpXGq1A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:N88a+jyjAnw=;myacIjicEe1hTyp6FEjz7Bh+lnT 7uxjt513rUXXhM6nHHOwcmtpECsaTtPaIYZ5/jZVQXeJo58sk81WTigEkF576DBExrze8K02o D77qyINBRAz8Zo6nI/QMj5mp+D17LLfnsTXu9tDL2xlPD3wQsyoCUBJ7qCjdZPPvjc3MXDhXK kD56VcwiWp+eZROTMv7joqU7fWllJE8BtrSsXu20U07MyuXO8yl8t/gOkYzJmeHh6pDJIV6dX RP23/bU0IjMIxY8l1ZnHtxN0+s5xjl+eNQLHZecqx741aRwBlTcRxtJaEaaw2MhYHazSxfTuT 8y/fYkNu6qNN4BRZfiyhaU/Dfk62je0pVfsjNWMid5b29IjjKO+WCrntRtocz3t/kqnO1IJk4 iyUSP2O9q+FYdzdXZSCEqbko59NKF94oNM81My7CiVu9tSDbPNomrdehuJBaftK98mev3s+Bm clM14KLCGjC+RS2JStS+SwuIFZXp+XG42VtJdCRZzbpeb784gHxp4J+s9xhqwjZwWzEPF0Jyp oKiJoRvLbhi7USULHg54HGYliukbe+YHo/Bv882ua8cHbTES4ifnUkOE/FNzg5Cy47ykgOI6+ dWiTXfEySG2ZbSKYewixQISYjBxYpoFuOniZtWTyHYByqqkNMebek7OXX1tZ9ShmOiLG75On3 BlVAGplMR6GIcsaGFpWaZLJUW3kJdpTI2zMDrSBAKU2R1ZnQCMUhmzC7DedLO/NZr4AgGbjXc EK5BdmWxhGSkmv9/Nbozhns7vgOrBfe5k9fWrOsc1STDedVATjtfPgThopw06OF2wHW+U1rNh ZgiC25KowySW+4c7WXwsgcchJC0laZaNLVkXn0JinKKV5wmnkkwhspY739F8fx8bM/lbUpm01 veZLodEMRYZOQv9MSQy52WXkUAmrLyyuFbHPzLHHQEeQbh8kvL5z7k63zZcYCM7iMhJmXe+OC 7O+ZV4hbKScwJrdiGDfGntApxBmfi+MGj3z+JODfSlbZ0RNM4+XzV1ywge/0wx4YkjM7ueZ2P 7jQq9SUWwbGLH+35x4s9+xIHFABu/N4zweio6X//oPP93BeUp1XvVCSpn4StiAFGQZDueGIw5 Wmo+44KB/R/AvEQxkIldsb81rBLfS0WqQgs/ngwFHtkaHv5GpGpau7JsmVwbcC4CDzUWN+z5O 0E1vR4EpjKmYqusMrjV4WCuD84FtWsudSkcH7MZixGMMe5lMPbAq0/ATnVP5YHdfP6YnVAu7Q dq+wna7K9SmsxdD6/+mcmRtFbhaIyvoDN1iDGYQYJhkUk/YJXW1GzW6Bkd1oEjUp6e5zr6dkW yi7FT8H9pTCaiZMJRC1gmRbI7cmnuixm9dMRrq498Q8CStT5lxOAlxsEAVq1OAQM6nqWtEi5M 5wVLpYkvQsgX1zkAM+TqoBu07KvR7WmXTjHpdfJ6GQlLTn7/ieZ+43v830MeU944aVn15hPQi xEapQReWUzzplmndfvsyhpMOQ8ymZ1V9c5TFWCVYtZgbAaYgkVY3cax7ztM7yyMfn1wiPYcRv whHGtYl5WwfBRr5oMpqRimWc7Rkfi9G8u0UJAjtZ3g+YQbHGPTT00znCYnNUzvjPOkBZYg8aA M5zeXxueoqrn4HBifYLDRVmtnisHmutgAKq8LsskhTdEfM8Io95x+OmuXI4EFXzwy2xb5BipI stdGCO57g7Hc/WPZixHja5+isvuDC6PBUC4ik+0PBd5scRft3Atzb6cLs6X/Y8+sKjxjjOyat uhfYpa19CvjBo1XzW2mlOtvUqbyatXPPkpleZX+I/iFBu2NZzyRgJ26b76AxTn7rMt+QByx0j DvrBZqWui91MJOh7HzMfng0Us+lhV6j+v/Ft+OdMS79qco2WsxoD4QnoEpRpcCTiMLW16vOH7 e6+scCwdiAmsHs9k0VlzjarPySdG+aJTdyAIgm2bIlnyqnclfJ1yPCnpjZIWouNX1BWQw/5KE g9O7auxOn6sM9/6uySL5KsV4rRCw2WUupI78Y5L2nhBUGdc2HXqNE0bpq4KhMysg5HSNXk+Rs ndz98qnj+x/diUAe70cMjrr+yuPLHZj3jXgFszz+hBZf0Jfw+NiIhJc6xmyNltTXv5dhQbGIU lcqdpJfSjhax+oowZqsrnV+wXNBCturoXeu5NFZ5OU0yGJgtXqLPN64EJgQHJzzTRvEvgvouB uS0W8/AiKCuSYmGZgUfEBKo4wRlAizJD9rWQJ+TmVV30LNKOTsD7QlvcFhWzWZ8eV6ETjCRh+ yogB7lsaSF5YsESDADkKvmvaZ8cwr3hkm1sqrIadDxbPRfZJEShBeZMkS7mscjBMPKnyNC1XK eWSUbS5EJTRVhxY8BygBWdPYtr9eSClg9MDPbTNdjy/JDQLdCaREVLIxUHz8WV5c6ft5ASYYv qV8UEdkncZSVVdFb9ViltFo9Bv/X4CQoksy/+hQ0444kta8KMNSMDvriM1b/iA3jz2AuCtG9N 1VQrYL5qAM6Zhe8WS6Lvjkb67DCFrFI7VpmNWXZ5NsIkPkFJlUvysul1NkgpYPzwQcY2LxMl+ ZNQ+0V/t1yZ0fTTDb/qE/kBetXC/7N2phRHYgoTavnB9cbeBA3f6hgSjpx5M/BNfIVr75nc4g FrQvMLKcj3p64gfsCNA2ncrPDruoE4wUV2HkL9vapK/D5158ELovit2PzAORN4sNdhjOUHZJg HuJvsnuJCiyy979XfKeOOCoN83kHibfpCtprz3UkSqPZF+3XWTmdt15mAcnZxdLMLiE68P37g i73lQVZq2B2vBWHrUaE5p65LRtEYi12GnQDLqACNbuDvOCklEaGAseKEqlcN52tj20VcnjUn/ MI/Yrebh+0xLESUORU1RTl+VYmzTqIrQSsucpSawpJUI21uNhgEpOlW3VYXImEFLKWgiE30Y4 X73X4kujBp+CyqDc8IfuxDATy9cWCsR8890xWstjOq7bAg2fp01P7dpJ8lWtSG+BoLvNRMzYv VP7paWaMKFJdN4sydoC1odRBoGlmlXWX2v84otjoDX3ZTeiDEXX/G7lRQqFo1tnauBLjgm9M8 wUc7+VYk5xOJqRRqZxtXJjo5/zICm91HbokWmSHowtbq4oqdiqP3zFsyVdwn0Mhxs+RSBBd3z EiM71L9yAN3z7OfyWzsIOeBFdm8pxzL2PjmqozZIIjIANHBHirseZ22i6UK+dCOjFStjpSfdn gRul/KzFJ3LLK6cKv+hbNeOEGVsXGHuyYIWKFLDZud/IWtnRaSgvZLQznKxlE8OxphggTYMr5 UWKZmXzeEOinaM5r1Gv84z8E5yun//5AQyr9eGVo06Et0mZahFDHcccPuOM= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > One coincidence is that we started seeing the first symptoms of this > around the same time as libicu was updated with a security patch. > However, postgres hasn=E2=80=99t been restarted and doesn=E2=80=99t refe= rence the > new version in its process maps. Plus state groups are integers > anyway. We also use the C locale, not ICU. Sounds as if you are hit by locale changes: https://wiki.postgresql.org/wiki/Locale_data_changes I think you will need to upgrade to prevent future problems like that:=20 Postgres 15 introduced some mechanisms to track and validate version discr= epancies after an OS update.=20 Postgres 17 added a "built-in" collation provider which is independent of = glibc