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 1uXdKs-00COoC-JW for pgsql-general@arkaria.postgresql.org; Fri, 04 Jul 2025 10:08:02 +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 1uXdKq-0008oB-ME for pgsql-general@arkaria.postgresql.org; Fri, 04 Jul 2025 10:08:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXdKq-0008o3-Ar for pgsql-general@lists.postgresql.org; Fri, 04 Jul 2025 10:08:00 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uXdKo-005WMq-2E for pgsql-general@lists.postgresql.org; Fri, 04 Jul 2025 10:08:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1751623676; x=1752228476; i=shammat@gmx.net; bh=popKYU6KmJwavgwKUH1O9WHWXbmKmKUil+he/86MHrc=; 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=TfziTxB0w85UPIbgKvGj2tyBHR3MabitOLYyYVvGvhgw353R4B6Y6GJIsREurWUV KwJVTNofo/zCtIkPiSUHdbsFEsPLFMW3MT4/LYdugziSCLP/LNv6oGRusnxt/tSuK izH3Q6I7pRosMwToMTAmxLZPR/f3fnDBpGM3MbbAg6McPE6K8vtkRiLF8+NPgbTqD k147x9nQQWqTzxkEj/Eayr0HSbFe1OacTVukX0+KX5cZ+WzpheRyLKW4EMVFUXkM/ qvak+UbBDSeha/bPHqhndz+z1pMowclawUxI1bPgwZ9oB0g2wtYmZvfZ6Zy2KfEBa 0hkJKgPHvagcFIZzNA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.1.77] ([185.40.248.10]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1M7b6b-1ucsWP078H-00FsPq for ; Fri, 04 Jul 2025 12:07:56 +0200 Message-ID: Date: Fri, 4 Jul 2025 12:07:55 +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: <6833523d-8e84-4749-952a-dcbfe9246d19@gmx.net> Content-Language: de-DE From: shammat@gmx.net In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:leEl7Qmh3cZLKEEpbSQrZyKad43mDw2oHWDkmYeBjVQyOF57Jm4 ZxYzRQ0lqF2CSCetfqXEqx3bdUM6+fFEkWGAys8FyTREwqTSZvuNM2yaA6LdgmSJbRq3Awz PeyI8ODHwOdv6Dxhu4sn8ytSqceXyTCiDBhb4QPRT4uDHj7TMmHeu35lxlPot4cd4A7mn8f 7gQQ3LqeJnxDFljgFMM8g== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:9Ty8Ruy0q8Q=;3P3Zj1KvnIXgkUQPLRhy+apM2yc Dx6rzmEL4sw4Zu4G/82Ifno//AnQU4bTuUeF239UQO6lRUWIjoJCqHe32es1nBybiRdcoEwsI XGIANiNGkPSq68Oz1zTuZjFj6Jy9wxlxPcq4GeaAQ96lJSPcYBX79pEPOKHCBgYqa1usTLdaq H4T8GHpr+uNjnWFGlEoZa7zSgEGvVgdVG1Fx5uZqUL43ZBMbW5boykuU5J0GTtrcfFe23rISG VY3otmNFRdM9k+cWUAvBGcthPgJlb9AwZRNwI2KbE6d17QWSnVAbrlkMkJpAFJJEQG/oy0RxJ Z5CBGI+DRu9e1slcLx/JZNSYNRz8lPy2fVKMtIFQba3mt5yqf0IzPHyQC7ATcS1hag4LaaYzJ QKKcaySiQv4Uey7bsp/TKhVCD+4uvowNS/C5wk8sVEH5LHO+Q5JXiuLZhQarWkktLbwHrj5Ex 4tsNj6PESOBH87yzf0BgDmY8/h8YRkvz4z8hlRElvq9eIHkfZ1DSlduxVNDI4ci5G0kBEtc0m NXXqhwoj3hANG/E0Vis00uchBAiAicnhFP/g/7kHEFrLujk5es1qMlWs6doN6VDBpsQ8H7Qai 4i4FI/ywvjufmE5M6eHxmi39bD0cU1ewL4kN8Upc8UoN8ZBGYND0v6a8COU1yiGfNjq1TxcrI mgcrdGyKw+7zfGy7y/8QoVAm1Llx866EmOtBf7yzn0aD3hrgWRmG5iMLNYNNAGOvLW9YQ4the MZVRpfpQO0Ps2TWquh7tbtf3dWLmulqUKK08VLMk3kGC5iIb6vdSAPMOgcfbfrHiktrZeM6vL KpZKHn4ZVnqeTnn4Lw0dD2TX84K51ENXpj0wGZKi+UZs5Y+pO2g25P4PbcXYVFL0wcX33M4Dg RWNfnfBybGMplpYoVJTGJIhsglavvp7usAlcI2PtxKkuNa7fspUCfaJtDuJmweU3qItJ+CizC YkEws0zvS17AaUOPhsEcTnNesY9FWu+5Pb1uiKWkig4lnZEXHnzVAIVjnbaivnxFMjZVcY7h3 qO4YVY2ThfhO/XfuYKaZhof1AYxwYEeEYpJXSO58ZXct07eHySyxNNVOF7PG5isfHeEshH0qP 8JJHvjdQhmvrK5BPwceilyVnvtdvwVRLtlGP3dK4kgE8JLHYHq46rlV5gLE1PaFS9RHJSO7k0 PLQONJu0LBCNiRrkyz065pjAqx78xUj1mdmOlJnUw7t3QynOLv0FYme7AdJI7N1bWYPsccNXa IsQB+V6WCQjqo5aNGQdctb/cRfk6XfQkJ0/taRmGnjkbwzwFs1qnzTxyMZaTzPbdhJOQJCupD z4jh4mt4cOA48IdaDmAwlp0vWg7ARP1n+36tWAo4T/S4lg515fhfS88/xfipMZ7KMZ84q4g7y PG+hncnCNHBldM1Ty86pa+8q1YWb8dhvt8b0E5+j1x4O7CdFS4H5PporHHIRWme3lDhJyGkOw 5F4l9FOyqi+pJR6bQs9ws65KE4mbL+c3LE1MQrhe9U8MX5rin/r32yRzftdtmIf61fw3HzZ2B VXtDHCEhJGvqRCAWCx+r6RYnPXGKK1IoZ1dMiH2K+AHQfTEVaG0SQ/MFmiMPXbXJn9vO1lbnB VG6XBgETNqJ2DQtv69lBJSvTxy0y0VcvJ93ntVvQwhXXzBKSBh17+/9MfeY314oevQMWVv79P lP1rZS+mOcyYIfnoxZM67q5cvJyP6V6lh/Jn20M2XQb1CKBfq4ArIXf9AzT9lLtV44yeuwypR eI/7ofjF/T3XJ8zKNNg1F8VkOKQAvJLkvW2fUQybkf0hCWoPP8YcTzptyhpRiLZbCyytjIvyZ Bb9+UQdLHIlCovj5q12m/UvaSiWOa8Zq8UGpPuJ4PjvOvhPj7gpyLFjog9C67yKjRCOBHQwDy kfkSK29biHq8jdC9Z3/z6B3x95mV6xIf2k81CEC7F2LthwKZVxTr2uR3PKEKV/aXYfG1oZuuf 3aM/MfX12hqG1vRUN2rOTF2lQCz+99Dkp6/SfMVEAo0V3KEIUarq2Sfiqpa0hSevCsJDx57dO oGGqitwER6RzSI6YUAqnXKo4PSPoAkxXY8etST4XZxhYksG5I+kIET0+5zBGHU52IwxVT6Q2i MfBMWTncQ4Ctvo5P7htO8OG6IvCH9G5OysP+JB6DEyg8WSi5+k422mh9gQJnaHCwna+RfsjeF c76u38UHZ16/O7qex5oJvLZAlj+sspKLykgBPg/Plp827dpa8j6YgH2z/xzBDF1SvjdsDAQzo gcTOhi7z3F8VAN79te4GO3EFROZkuSZcozvtAjGFCKkZkXSD0s0rs3WOFW8zEBxZoKGw9qJlT dvtPdQ9z4hFq7u++Mzwverldq6vJElWqGPrLSFSho1NHfwBR/BZNJK1VCXR8S/21AVBB7PMFw bnVOEfXTNLQPsCPpi+Y7N4Rvn+UrDx1t0WXqVsQuORIRMVyo9S7s0BmzsSBOhgIxWfjz2r/lk x674LoKeFdVdrinwJhjp0euuQ3RJKPdCNf7pAECIj61DZfiVUrOt9TkDVyDofx5zodJ4L3T5w 4xdEA9ozSWFeJRIz0wN2qsQ4g00Lo4pIhXjHx64PjKKRNw0ItH/SubZrf2L7ZnSUT1op1HWIB G1/OSlhRk5a4MLQXM/Otix4f1Gh24jd7TOEsGZ56QQZrpL0f6XL3FF+8lPuTo9WfrkPCn9qCe 5AY3/uauK2XzryMt3qyBn4tFLO4S7BPI82LZrJSQ11/rKx+8SM9sNjnCQ/va00HpYMw+T0QHs gN5ydlC46UkKKLGb+TCkl1FjZTq9NfxqGpQblqKoh1nWm7FQfrvS6PZePm80vPiS0BzYSzlVx uy16uZh6X4FdMYu+HS4HjcLEkGQVJsOzLYnFifa/Mm7JE/UxkISr1kx0/s7bnBkBxnycyQTmN 5Q43pbqJThTMzqjP486C4ENvxsSmDrn1jYEscIa7chMujmM935Cj4Wkn4vAUjKbmMESYxCQ8c PAwV9Goz4Q0LwjOIUcDKVOw2/DvpeI9qvhZZhiL9sMz2XNkNgx7EzBzEXOW3rI3mUk5F/TRfm 0M7ZabM/d548J77a8ai47Qt5FGd54eijE1+7yUyzhD7XUmwfNXIEScNaAnqV42s0fOC8mz2sY cR0FpAGvRQZ0HPj5mKk4wo+Z55k4nT/Mk2Q/7Nbl5dxQ+QXy217XrX8syjSHmRJK5noeJcmNt kXbLFF0Z7RpzTgBAJIoto3hRR5UXG/Yiwa3HEZMOG+fIE8pMgTz4u0u9V+2es1+YPiGa9zGSf 2YrBs2qyCxJOuhcwq7NibVVvm2YJ1U8tHJ1slP+BD5K3g7WiBa5hCcPRZ4sOjsBeKv5Rm6kiR vXeXQLQ List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Ron Johnson schrieb am 04.07.2025 um 12:05: > On Fri, Jul 4, 2025 at 5:50=E2=80=AFAM > wrote: >=20 > > One coincidence is that we started seeing the first symptoms of th= is > > around the same time as libicu was updated with a security patch. > > However, postgres hasn=E2=80=99t been restarted and doesn=E2=80=99= t reference 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: >=20 > https://wiki.postgresql.org/wiki/Locale_data_changes >=20 > Why?=C2=A0 Locale only cares about strings, and=C2=A0"Plus state groups = are integers anyway." Ah, I misread it to be about the the room_id.