Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpe71-00013x-QH for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2017 17:27:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dpe70-0003R6-On for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2017 17:27:38 +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.84_2) (envelope-from ) id 1dpe6J-0002Bj-Dh for pgsql-bugs@postgresql.org; Wed, 06 Sep 2017 17:26:55 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dpe67-0001Gd-IO for pgsql-bugs@postgresql.org; Wed, 06 Sep 2017 17:26:54 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1504718803; x=1536254803; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=GeqgDSznROHHLQFQwmeOZTTHR2I0t2crHk/aWOXvaDA=; b=LftVS7SH0EEaU+8ruAO3hvkqnvLlz3Vcn/naUUcoXczFgzWPGxiI5sYm eUXpbS4Yj9FQ8hWH/3Eac5r51Z8FpDF/oVEykZ0BxFFVHdD8QiYq5Fpr5 L2i5LCCSp5mgAJc1GUFqR7j2vsUcC7ojRs18v8JSQzmPCx12HlD0penYX E=; X-IronPort-AV: E=Sophos;i="5.42,354,1500940800"; d="scan'208";a="564609799" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-71007.iad55.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9102.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 06 Sep 2017 17:24:54 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan2.iad.amazon.com [10.40.159.162]) by email-inbound-relay-71007.iad55.amazon.com (8.14.7/8.14.7) with ESMTP id v86HOKYA023179 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Wed, 6 Sep 2017 17:24:24 GMT Received: from EX13D11UWC004.ant.amazon.com (10.43.162.101) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Wed, 6 Sep 2017 17:24:24 +0000 Received: from EX13D11UWC002.ant.amazon.com (10.43.162.174) by EX13D11UWC004.ant.amazon.com (10.43.162.101) with Microsoft SMTP Server (TLS) id 15.0.1104.5; Wed, 6 Sep 2017 17:24:23 +0000 Received: from EX13D11UWC002.ant.amazon.com ([10.43.162.174]) by EX13D11UWC002.ant.amazon.com ([10.43.162.174]) with mapi id 15.00.1104.000; Wed, 6 Sep 2017 17:24:23 +0000 From: "Wood, Dan" To: Alvaro Herrera , Michael Paquier CC: Peter Geoghegan , "pgsql-bugs@postgresql.org" , Andres Freund Subject: Re: Old row version in hot chain become visible after a freeze Thread-Topic: [BUGS] Old row version in hot chain become visible after a freeze Thread-Index: AQHTIqmfEH9T5bMCDUufad1KxDA7S6KfXpOAgAAF9QCABt+egIABAJKAgABvBwD///uLgA== Date: Wed, 6 Sep 2017 17:24:23 +0000 Message-ID: <779404FF-3AE2-476A-86C4-9B0DE553EF97@amazon.com> References: <20170906104020.jhmfnb6wchwaq6cn@alvherre.pgsql> In-Reply-To: <20170906104020.jhmfnb6wchwaq6cn@alvherre.pgsql> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.245] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 Precedence: Bulk List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org Rmlyc3QgbmV3IHJlcGx5DQoNCk9uIDkvNi8xNywgMzo0MSBBTSwgIkFsdmFy byBIZXJyZXJhIiA8YWx2aGVycmVAYWx2aC5uby1pcC5vcmc+IHdyb3RlOg0K DQogICAgTWljaGFlbCBQYXF1aWVyIHdyb3RlOg0KICAgIA0KICAgID4gSSBo YXZlIGFsc28gc3BlbnQgYSBjb3VwbGUgbW9yZSBob3VycyBsb29raW5nIGF0 IHRoZSBwcm9wb3NlZCBwYXRjaA0KICAgID4gYW5kIGV5ZS1iYWxsaW5nIHRo ZSBzdXJyb3VuZGluZyBjb2RlLCBhbmQgbXkgc3VnZ2VzdGlvbiBhYm91dA0K ICAgID4gaGVhcF90dXBsZV9uZWVkc19mcmVlemUoKSBpcyBwcm92aW5nIHRv IGJlIHdyb25nLiBTbyBJIGFtIGFycml2aW5nIGF0DQogICAgPiB0aGUgY29u Y2x1c2lvbiB0aGF0IHlvdXIgcGF0Y2ggaXMgdGFraW5nIHRoZSByaWdodCBh cHByb2FjaCB0byBza2lwDQogICAgPiBmcmVlemluZyBjb21wbGV0ZWx5IGlm IHRoZSB0dXBsZSBpcyBub3QgdG8gYmUgcmVtb3ZlZCB5ZXQgaWYgaXQgaXMg Zm9yDQogICAgPiB2YWN1dW0gZWl0aGVyIERFQUQgb3IgUkVDRU5UTFlfREVB RC4NCiAgICANCiAgICBJIHRoaW5rIGluIHRoZSAidHVwa2VlcCIgY2FzZSB3 ZSBtdXN0IG5vdCBtYXJrIHRoZSBwYWdlIGFzIGZyb3plbiBpbiBWTTsNCiAg ICBpbiBvdGhlciB3b3JkcyBJIHRoaW5rIHRoYXQgYmxvY2sgbmVlZHMgdG8g bG9vayBsaWtlIHRoaXM6DQogICAgDQogICAgICAgICAgICAgICAgLy8gdHVw Z29uZSA9IGZhbHNlDQogICAgICAgICAgICAgICAgew0KICAgICAgICAgICAg ICAgICAgICBib29sICAgICAgICB0dXBsZV90b3RhbGx5X2Zyb3plbjsNCiAg ICANCiAgICAgICAgICAgICAgICAgICAgbnVtX3R1cGxlcyArPSAxOw0KICAg ICAgICAgICAgICAgICAgICBoYXN0dXAgPSB0cnVlOw0KICAgIA0KICAgICAg ICAgICAgICAgICAgICAvKg0KICAgICAgICAgICAgICAgICAgICAgKiBFYWNo IG5vbi1yZW1vdmFibGUgdHVwbGUgdGhhdCB3ZSBkbyBub3Qga2VlcCBtdXN0 IGJlIGNoZWNrZWQNCiAgICAgICAgICAgICAgICAgICAgICogdG8gc2VlIGlm IGl0IG5lZWRzIGZyZWV6aW5nLiAgTm90ZSB3ZSBhbHJlYWR5IGhhdmUgZXhj bHVzaXZlDQogICAgICAgICAgICAgICAgICAgICAqIGJ1ZmZlciBsb2NrLg0K ICAgICAgICAgICAgICAgICAgICAgKi8NCiAgICAgICAgICAgICAgICAgICAg aWYgKCF0dXBrZWVwICYmDQogICAgICAgICAgICAgICAgICAgICAgICBoZWFw X3ByZXBhcmVfZnJlZXplX3R1cGxlKHR1cGxlLnRfZGF0YSwgRnJlZXplTGlt aXQsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIE11bHRpWGFjdEN1dG9mZiwNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgJmZyb3plbltuZnJv emVuXSwNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgJnR1cGxlX3RvdGFsbHlfZnJvemVuKSkNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICBmcm96ZW5bbmZyb3plbisrXS5vZmZzZXQg PSBvZmZudW07DQogICAgDQogICAgICAgICAgICAgICAgICAgIGlmICh0dXBr ZWVwIHx8ICF0dXBsZV90b3RhbGx5X2Zyb3plbikNCiAgICAgICAgICAgICAg ICAgICAgICAgIGFsbF9mcm96ZW4gPSBmYWxzZTsNCiAgICAgICAgICAgICAg ICB9DQogICAgDQogICAgT3RoZXJ3aXNlLCB3ZSByaXNrIG1hcmtpbmcgdGhl IHBhZ2UgYXMgYWxsLWZyb3plbiwgYW5kIGl0IHdvdWxkIGJlDQogICAgc2tp cHBlZCBieSB2YWN1dW0uICBJZiB3ZSBuZXZlciBjb21lIGFyb3VuZCB0byBI T1QtcHJ1bmluZyB0aGUgcGFnZSwgYQ0KICAgIG5vbi1wZXJtYW5lbnQgeGlk IChvciBhIG11bHRpeGFjdD8gbm90IHN1cmUgdGhhdCB0aGF0IGNhbiBoYXBw ZW47DQogICAgcHJvYmFibHkgbm90KSB3b3VsZCBsaW5nZXIgdW5ub3RpY2Vk IGFuZCBjYXVzZSBhIERvUyBjb25kaXRpb24gbGF0ZXINCiAgICAoImNhbm5v dCBvcGVuIGZpbGUgcGdfY2xvZy8xMjM0Iikgd2hlbiB0aGUgdHVwbGUgaGVh ZGVyIGlzIHJlYWQuDQogICAgDQogICAgTm93LCBpdCBpcyBwb3NzaWJsZSB0 aGF0IEhPVCBwcnVuaW5nIHdvdWxkIGZpeCB0aGUgcGFnZSBwcm9tcHRseSB3 aXRob3V0DQogICAgY2F1c2luZyBhbiBhY3R1YWwgRG9TLCBidXQgbm9uZXRo ZWxlc3MgaXQgc2VlbXMgZGFuZ2Vyb3VzIHRvIGxlYXZlDQogICAgdGhpbmdz IGxpa2UgdGhpcy4NCiAgICANCiAgICAtLSANCiAgICDDgWx2YXJvIEhlcnJl cmEgICAgICAgICAgICAgICAgaHR0cHM6Ly93d3cuMm5kUXVhZHJhbnQuY29t Lw0KICAgIFBvc3RncmVTUUwgRGV2ZWxvcG1lbnQsIDI0eDcgU3VwcG9ydCwg UmVtb3RlIERCQSwgVHJhaW5pbmcgJiBTZXJ2aWNlcw0KICAgIA0KDQoKLS0g ClNlbnQgdmlhIHBnc3FsLWJ1Z3MgbWFpbGluZyBsaXN0IChwZ3NxbC1idWdz QHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJz Y3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYv cGdzcWwtYnVncwo=