Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dpaN4-0005rq-3f for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2017 13:27:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dpaN2-0000PA-Fw for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2017 13:27:56 +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 1dpaN1-0000P0-Ml for pgsql-bugs@postgresql.org; Wed, 06 Sep 2017 13:27:55 +0000 Received: from smtprelay0031.b.hostedemail.com ([64.98.42.31] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dpaMt-0004SL-Kn for pgsql-bugs@postgresql.org; Wed, 06 Sep 2017 13:27:54 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay02.b.hostedemail.com (Postfix) with ESMTP id 41589D3995; Wed, 6 Sep 2017 13:27:46 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::::::::,RULES_HIT:1:41:355:379:599:965:966:967:973:988:989:1260:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1539:1575:1594:1595:1596:1711:1714:1730:1747:1764:1777:1792:2196:2199:2393:2525:2553:2560:2563:2682:2685:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3351:3865:3867:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4385:4390:4395:4605:5007:6261:7875:9025:9121:10004:10848:11026:11658:11914:12296:12663:13161:13229:13439:13894:13895:14658:14721:21080:21451:21627:30012:30029:30036:30054:30062:30070:30080:30090:30091,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:2,LUA_SUMMARY:none X-HE-Tag: jeans33_4389cf60e9f4b X-Filterd-Recvd-Size: 13448 Received: from alvin.alvh.no-ip.org (dynamic-194-228-13-113.ipv4.broadband.iol.cz [194.228.13.113]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf14.b.hostedemail.com (Postfix) with ESMTPA; Wed, 6 Sep 2017 13:27:44 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id CC02072B; Wed, 6 Sep 2017 15:27:38 +0200 (CEST) Date: Wed, 6 Sep 2017 15:27:38 +0200 From: Alvaro Herrera To: Michael Paquier Cc: Peter Geoghegan , "Wood, Dan" , "pgsql-bugs@postgresql.org" , Andres Freund Subject: Re: Old row version in hot chain become visible after a freeze Message-ID: <20170906132738.2dpwvnfcuevjofhl@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="d55dqzl435awcqkx" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) 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 --d55dqzl435awcqkx Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit Another thing is that if you're going through heap_copy_data, the tuple is only checked for DEAD, not RECENTLY_DEAD. Maybe there is no bug here but I'm not sure yet. I attach the patch as I have it now -- mostly comment tweaks, but also the change to not mark page as all-frozen when we skip freezing a recently read tuple. I also renamed the test case, because I think it may be possible to reach the problem code without involving a multixact. Haven't tried too hard though. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services --d55dqzl435awcqkx Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="0001-test-cases.patch"