Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxK4i-0000P3-QJ for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Sep 2018 22:45:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxK4h-0007Oq-87 for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Sep 2018 22:45:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxK4g-0007Oj-Rh for pgsql-hackers@lists.postgresql.org; Tue, 04 Sep 2018 22:45:31 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxK4Y-0000Qy-KS for pgsql-hackers@postgresql.org; Tue, 04 Sep 2018 22:45:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1536101122; x=1567637122; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=h1JNa38B3OBRUgMj9di0ialgLeSAJ8Ce4Psvt5fIINk=; b=AXbZas3NvkkIpEQQFk3VGHVBEFNOpDPIWRVwDrkm7f5D5PtqfJKe6W4v IW1PAHQRf9Dd2BLrJAel+THOcs9UnWfJo6MaTSHTd2ZKlxFoo15iQiD61 EEyua8Tx7HZYgx9VKv9yzyqe6AxJgRKaljsk8AV6ycju6n86o6kfzYlsE M=; X-IronPort-AV: E=Sophos;i="5.53,330,1531785600"; d="scan'208";a="695901796" Received: from iad6-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-1e-27fb8269.us-east-1.amazon.com) ([10.124.125.2]) by smtp-border-fw-out-2101.iad2.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 04 Sep 2018 22:45:21 +0000 Received: from EX13MTAUWA001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan2.iad.amazon.com [10.40.159.162]) by email-inbound-relay-1e-27fb8269.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id w84MjDuE048949 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Tue, 4 Sep 2018 22:45:19 GMT Received: from EX13D08UWB002.ant.amazon.com (10.43.161.168) by EX13MTAUWA001.ant.amazon.com (10.43.160.118) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Tue, 4 Sep 2018 22:45:18 +0000 Received: from EX13D08UWB001.ant.amazon.com (10.43.161.104) by EX13D08UWB002.ant.amazon.com (10.43.161.168) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Tue, 4 Sep 2018 22:45:18 +0000 Received: from EX13D08UWB001.ant.amazon.com ([10.43.161.104]) by EX13D08UWB001.ant.amazon.com ([10.43.161.104]) with mapi id 15.00.1367.000; Tue, 4 Sep 2018 22:45:17 +0000 From: "R, Siva" To: Peter Geoghegan , Alexander Korotkov CC: pgsql-hackers Subject: Re: Bug in ginRedoRecompress that causes opaque data on page to be overrun Thread-Topic: Bug in ginRedoRecompress that causes opaque data on page to be overrun Thread-Index: AQHURITWziSocye1S0ygUmXh1SVXsaTgquEAgAANUlE= Date: Tue, 4 Sep 2018 22:45:17 +0000 Message-ID: <1536101117759.63175@amazon.com> References: <1536091151804.6588@amazon.com>, In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.149] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Precedence: Bulk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Alexander!=0A= On Tue, Sep 4, 2018 at 09:16 PM, Alexander Korotkov wrote:=0A= > Do you have a test scenario for reproduction of this issue? We need=0A= > it to ensure that fix is correct.=0A= =0A= Unfortunately, I do not have a way of reproducing this issue.=0A= So far I have tried a workload consisting of inserts (of the=0A= same attribute value that is indexed), batch deletes of rows=0A= and vacuum interleaved with engine crash/restarts.=0A= =0A= Hi Peter!=0A= On Tue, Sep 4, 2018 at 09:55 PM, Peter Geoghegan wrote:=0A= > I wonder how you managed to detect it in the first place. Were you=0A= > using something like wal_consistency_checking=3Dall, with a custom=0A= > stress-test?=0A= =0A= We observed this corruption during stress testing and were=0A= able to isolate the corrupted page and WAL record changes=0A= leading up to the corruption using some internal diagnostic=0A= tools.=0A= =0A= Best=0A= Siva=