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 1rwLKH-0015uG-5K for pgsql-admin@arkaria.postgresql.org; Mon, 15 Apr 2024 12:20:45 +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 1rwLKF-00CeIW-69 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Apr 2024 12:20:43 +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 1rwLKE-00CeIL-RU for pgsql-admin@lists.postgresql.org; Mon, 15 Apr 2024 12:20:42 +0000 Received: from smtp-190b.mail.infomaniak.ch ([185.125.25.11]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwLKB-0014E0-KT for pgsql-admin@lists.postgresql.org; Mon, 15 Apr 2024 12:20:42 +0000 Received: from smtp-3-0000.mail.infomaniak.ch (smtp-3-0000.mail.infomaniak.ch [10.4.36.107]) by smtp-4-3000.mail.infomaniak.ch (Postfix) with ESMTPS id 4VJ5q95fNQzYqN; Mon, 15 Apr 2024 14:20:37 +0200 (CEST) Received: from unknown by smtp-3-0000.mail.infomaniak.ch (Postfix) with ESMTPA id 4VJ5q9207qzZlp; Mon, 15 Apr 2024 14:20:37 +0200 (CEST) Message-ID: Date: Mon, 15 Apr 2024 14:20:36 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes Content-Language: en-US To: Oracle People , pgsql-admin@lists.postgresql.org References: From: Adrien Nayrat Autocrypt: addr=adrien.nayrat@anayrat.info; keydata= xsBNBFq2NEMBCAC/W92hl6qJyXV5CkWQOt3WuKA3PwlNbVY8Cuu6BN4mzT56djDn+tTcOD15 L6ExsIbL7p6y/w4lPtMM6Vmy6ByKVAZWNHFpvS6DvTaTDf/mfm1WwixOx5qLg4WyYuiohlCd 8BebhrhS8Lav+Rn29cRUefQHQcnSyc0bX/6ebDgY7hTAvV/f9BJ+XT6uHfrmby0STORIO+Du xekN6rU8ZIORxsdvE9dda3zbQcNLtVe6Y3GJvz/AShI9HYvGkrJchsWeR8aiGmfaX5E/jEme Oe4T6nd/NmoZ8cEjF3rsbE3SYNjAsWmZOZ8HzDZ1gWSY4VtqpIMgF4jJpCu0dyogGLipABEB AAHNKkFkcmllbiBOYXlyYXQgPGFkcmllbi5uYXlyYXRAYW5heXJhdC5pbmZvPsLAlQQTAQgA PwIbAwYLCQgHAwIGFQgCCQoLBBYCAwECHgECF4AWIQQQX3VDo29CNmHcAhoktQFHcMXNFwUC ZH2miQUJD2xp3QAKCRAktQFHcMXNFz9RB/0ddaJECoc5DmEdrVOl2KTL/y/2z12U8k5fsCq+ jOkLMz+AL2qnbtltdm7IZDyJ2yuYQg/0TWoYTl5LRvryEZGPy2gNhQJzsToTreDERw0IZxB4 6x2+mtmIFPtk/d/9dTqsmYgoXEPViVs0Prl6YVk3ZyHmIqGoEFimuCAuKeOEfbMjMIIivrHL LwTtrrChqmm7t8EQf9nYFYMM37/YIn1VP2t7uwIkL+47haAY2qgbMVybXC1GabH3vNotFRci 6aQCuwlmEuY98BMRcVgiEHuDqtWvvRdQ5OTuXOIr+cMOsPohK3Ig/k42txKoRvaCvGl3PSO2 36TfulOilpuDBVCczsBNBFq2NEMBCACrk3pVPDk6XhBKgkVqmAX8uyqd3lfTZwXtkOpMLxzp iT3a6MWatHk1N9+SSTRl7KzLoOPoWDUMOE/l5OHDsLJN0JWnwQhazhFiujtePmdUVeAWkvvn SPaMKB/1UcRjuGuwSrVnZQc9faHi1fFhqCH00MntQ+/XJViQXWt92L2cw6VsBXM0ixVRTc7f vvQA1+sMBP5yAONgtRgOZxPH9MvL+Dw8Tae63kE6HwiymrrkHEi4AUhaqKGULj32a8FWgm42 b4PIujE0w4wANrpct4t/aVDkdQ09Qd3ciXV7S+G80aP683ygplRFkZWwIJzwcNeHrJPyMDi9 1i8rDNWe9PDxABEBAAHCwHwEGAEIACYCGwwWIQQQX3VDo29CNmHcAhoktQFHcMXNFwUCZH2q +wUJDx1P3QAKCRAktQFHcMXNF+LMB/9rWlIafKLfUqWLRhzzMEjq7j8Xuhv6VNDsO7+YCJq5 YGtqAuvImxmrNtPCZqtoD+JUCMacGSjh/L7XhSy72zMkwDeFqj7IvrN3+CStCLV1lTPsE/AO yQzSaE6A8WfKLjEcZo+4yc33i/rfb0bCRj2Xm68g4XFw2EZIiUgR73L5n4+ga1gzAXnHEyfP iHB1jCwZtzjE74z6msmhAnlMDV5nKPKXsjP06kC9RCTzxJe+12od7V7sNLolqYy4upYxRowb 9EWgWsbRNzbQTTZeTfTCBZUbwk3b1HcKCRQr66WY7vDERYuSUMlodiyL3oXQDXbiLWkMHxTj 1aH1EzXQiGC7 In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Infomaniak-Routing: alpha List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, On 4/15/24 11:30 AM, Oracle People wrote: > We have a few Postgres 16.2 servers running on VMs (RHEL 9.3) created on > VMware vSphere (7.0.3).  3PAR LUNs are used as their storages. > > On a couple of the PostgreSQL servers, there are errors such as: > > ERROR:  could not read block 1264 in file "base/16520/59258": read only > 0 of 8192 bytes > > The errors occured when trying to insert rows to the tables. It looks like the same bug as https://www.postgresql.org/message-id/flat/1878547.tdWV9SEqCh%40aivenlaptop Maybe you can try to rebuild FSM : https://wiki.postgresql.org/wiki/Free_Space_Map_Problems#Cleanup_of_broken_FSM_files FYI, a fix has been committed : https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=93582974315174d544592185d797a2b44696d1e5 Regards, -- Adrien NAYRAT