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 1m8Z93-0003pW-00 for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Jul 2021 02:18:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m8Z90-0001Oj-Rb for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Jul 2021 02:18:02 +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 1m8Z90-0001Ob-9K for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 02:18:02 +0000 Received: from email.ftc.ru ([194.85.126.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m8Z8o-0001Pl-EY for pgsql-bugs@lists.postgresql.org; Wed, 28 Jul 2021 02:18:00 +0000 Received: from mail.cft.ru (nut-exch-2.ftc.ru [172.29.95.82]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mail-gate-1.ftc.ru (Postfix) with ESMTPS id 8BB3D2C10C8; Wed, 28 Jul 2021 09:17:42 +0700 (+07) DKIM-Filter: OpenDKIM Filter v2.11.0 mail-gate-1.ftc.ru 8BB3D2C10C8 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cft.ru; s=relay; t=1627438662; bh=SwhHX1HAEXn7/voEX4W7Cjw7fkyDdcSTeQIH5s3Bo0Q=; h=From:To:CC:Subject:Date:Message-ID:From:Sender:To:CC:Subject: Message-Id:Date; b=HwtsPtXOBqtosLPnhI+rttDMPVmlS2Nyo9/1RG4A7dcOPnYXfHeo8tZ1qp+kGtNml gpudn3gBwN/VcgJT0PDhG7mPVoz00o0OMrFltzzQfgqL+47n6SQ7BvLKmuYXKi+vW7 zcnq1DSUh7srLn8u1i80kqavcCZ/Kd6AIemGbNZ0= Received: from nut-exch-1.win.ftc.ru (172.29.95.118) by NUT-EXCH-2.win.ftc.ru (172.29.95.82) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.858.15; Wed, 28 Jul 2021 09:17:42 +0700 Received: from nut-exch-1.win.ftc.ru ([fe80::eca3:338b:8a83:2440]) by nut-exch-1.win.ftc.ru ([fe80::eca3:338b:8a83:2440%5]) with mapi id 15.02.0858.015; Wed, 28 Jul 2021 09:17:42 +0700 From: Orishich Aleksey To: Daniel Gustafsson CC: "pgsql-bugs@lists.postgresql.org" Subject: RE: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes Thread-Topic: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" at offset 253952: read too few bytes Thread-Index: Add4W/xNfkxl7v0tR+iRna69jnUYEAKf8wVg//+Qd4D//pqksA== Date: Wed, 28 Jul 2021 02:17:42 +0000 Message-ID: <76ead10fde7a4f13b02c5afeeae049b6@cft.ru> References: <909f68c697ab4d45a10ea6fc5957d1a5@cft.ru> <44f273afed1e4ba3ba75b056eb65e829@cft.ru> In-Reply-To: Accept-Language: ru-RU, en-US Content-Language: ru-RU X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.94.8] Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 165288 [Jul 28 2021] X-KLMS-AntiSpam-Version: 5.9.20.0 X-KLMS-AntiSpam-Envelope-From: a.orishich@cft.ru X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Auth: dkim=none X-KLMS-AntiSpam-Info: LuaCore: 449 449 5db59deca4a4f5e6ea34a93b13bc730e229092f4, {Tracking_b2b_test_cert_from_list}, {Tracking_uf_ne_domains}, {Tracking_from_domain_doesnt_match_to}, vmware.com:7.1.1;cft.ru:7.1.1;127.0.0.199:7.1.2;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;mail.cft.ru:7.1.1 X-MS-Exchange-Organization-SCL: -1 X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, bases: 2021/07/28 00:37:00 X-KLMS-AntiVirus: Kaspersky Security for Linux Mail Server, version 8.0.3.30, bases: 2021/07/27 23:37:00 #16991787 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =EF=EB, what logs do you need? -----Original Message----- From: Daniel Gustafsson =20 Sent: Tuesday, July 27, 2021 6:58 PM To: =EF=D2=C9=DB=C9=DE =E1=CC=C5=CB=D3=C5=CA =F0=C5=D4=D2=CF=D7=C9=DE Cc: pgsql-bugs@lists.postgresql.org Subject: Re: Postgresql12: ERROR: Could not read from file "pg_act/02 F 4" = at offset 253952: read too few bytes > On 27 Jul 2021, at 13:38, Orishich Aleksey wrote: > Do you have a result on my problem? Troubleshooting why a file on your filesystem was corrupt/torn after the fa= ct when no logs or traces of evidence exists is next to impossible. In thi= s case there isn't even an errno set from the system. A good place to star= t would be to upgrade your system as you are several bugfix releases behind= . > This is critical for us. The PostgreSQL website lists several professional services companies who of= fer support contracts with SLA's which this list doesn't, and who can be ha= nds-on to investigate should this ever happen again.=20 -- Daniel Gustafsson https://vmware.com/