Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZldgK-0001bE-KG for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2015 14:02:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZldgK-00019C-0C for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2015 14:02:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zlde3-0006zY-0b for pgsql-general@postgresql.org; Mon, 12 Oct 2015 14:00:07 +0000 Received: from mail-bl2on0063.outbound.protection.outlook.com ([65.55.169.63] helo=na01-bl2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zlddw-0001HO-4E for pgsql-general@postgresql.org; Mon, 12 Oct 2015 14:00:06 +0000 Received: from BLUPR11MB0676.namprd11.prod.outlook.com (10.163.216.146) by BLUPR11MB0097.namprd11.prod.outlook.com (10.160.36.28) with Microsoft SMTP Server (TLS) id 15.1.293.16; Mon, 12 Oct 2015 13:59:55 +0000 Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:cd86:e206:2a46:b183) by BLUPR11MB0676.namprd11.prod.outlook.com (10.163.216.146) with Microsoft SMTP Server (TLS) id 15.1.293.16; Mon, 12 Oct 2015 13:59:53 +0000 Subject: Re: Serialization errors despite KEY SHARE/NO KEY UPDATE To: Olivier Dony , Kevin Grittner References: <560ED745.3050009@BlueTreble.com> <1354271993.744124.1444079872314.JavaMail.yahoo@mail.yahoo.com> <5614026C.10404@odoo.com> CC: "pgsql-general@postgresql.org" From: Jim Nasby Message-ID: <561BBCD0.1060301@BlueTreble.com> Date: Mon, 12 Oct 2015 08:59:44 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: <5614026C.10404@odoo.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:cd86:e206:2a46:b183] X-ClientProxiedBy: BY1PR0501CA0019.namprd05.prod.outlook.com (25.162.139.29) To BLUPR11MB0676.namprd11.prod.outlook.com (25.163.216.146) X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0676; 2:IW46R0s3GHB0rxj1OcfxVQhjykqX3oQKukyn+4HZ4fkB5PfbypIbaOBH3dkBceI+NkcbOgNjIoEwQwlpESGSQtYOFBWfqj3MV76ySRQKV7PVVdWXn5Q2lhCHb1/UDY6OYauRiFIs6FOYLRUfVmecO6YznVaHMypRbnWe1oNKQaw=; 3:djppbRA6EyHmMi2Qvbd2tDa5oVa6P2D7/sIIdyMrnfJjJCfzO7hNINUvLuhBaCwpnziMVN0bsCvclLmn3nGUgVbvg5nEWg+iQbOVogON8zCOUkKS+4P4OGOdIHSygYMoWVxkQcr0ls1sxJnnwYobGQ==; 25:0/so9W4PoUJNgsUcwb8QJLi3mwwG6eZBnABP/XIHIqKXdze2N1cv0r99t/GjqVmKxmY/V2JwNiVYdnU4bb8tJVZZTR1YdJk38EMFhMrPQCxudvGnnPOo1CusjTTF+LanAAlcUWZt3MykvcvnrEa3yOs+XxTPFvqwC4qOkRaBd+eSq/zTg3sCP1Iqa23o7+2OzfFyabWEKxttnagEtWgyebq/by+oCjUApjJGrLISsF78XWQa6BvRiZ5o6zJMzdcQT/QnqrpNFJ0GBXjFEpEahQ== X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BLUPR11MB0676; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(520078)(5005006)(8121501046)(3002001); SRVR:BLUPR11MB0676; BCL:0; PCL:0; RULEID:; SRVR:BLUPR11MB0676; X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0676; 4:0aaigo7RH7dxAlAXaIFmGKJrmAzFCQ7nk/azx1xF+k9CgimnQ3prDSG8MZo95BgGH+Hdz3+K6aO3DJ39NhClabZOpJQeg8o3OtGdSO+T/seyp4uaA0Vge1OSqBMa5Is2FG+wmnCXOCeN6JQbxURqEU8kOCTJSCGAD8E1LNtsAcfwcCQpy9DeTXAF5iPJX9F3+x3KLG8Qk0zw8Mxi4JFgDo7n2cvQDSy3uoMDHEd7A2LCFJ/0O5fEXNjcscfe9jDYoBONzf6C4VEYewVv25LBkd7fS9lmIZJamqKPbNdBePxECzzYAV+uHW7Ygbwvf3r+4TjxP1loxI+DeL2wQzGlACBcDt5ShHACYI9Qx0c2sJo= X-Forefront-PRVS: 0727122FC6 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(189002)(377454003)(479174004)(24454002)(199003)(5007970100001)(77096005)(69596002)(5001960100002)(15975445007)(19580395003)(92566002)(101416001)(64126003)(189998001)(5004730100002)(105586002)(106356001)(47776003)(50466002)(64706001)(7110500001)(2950100001)(80316001)(59896002)(23676002)(122386002)(46102003)(65956001)(10710500005)(86362001)(83506001)(33656002)(50986999)(87976001)(5001770100001)(54356999)(40100003)(65806001)(97736004)(76176999)(87266999)(65816999)(53416004)(5008740100001)(2420400006)(4001350100001)(81156007)(36756003)(42186005)(3826002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:BLUPR11MB0676; H:decina.attlocal.net; FPR:; SPF:None; PTR:InfoNoRecords; MX:1; A:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtCTFVQUjExTUIwNjc2OzIzOjRFVERHU05ESHFlTFIxdTRyYVoycVJGVTJB?= =?utf-8?B?RlQ3Vkg2dEl0TmpmblhwTUZrOW1NRG8wamZSNkZCbWZBNlErSzh5TkdrNXFR?= =?utf-8?B?TjZnamFDV1BsNnBOSUxMZFcrQ2NjYUp2U2VEVU4yUUliRzh1d3VGM2RjME1y?= =?utf-8?B?MlhHeHhDVXQ2VEZlMmFPRlpzdjltZ0gwRkM1cDl0UExsQmRWa2dvd2JpVUsx?= =?utf-8?B?SE1UbzZDbnhUZEdINkFnN1pjWDdTc3VKczkvVHV4TE8rZEZJM21xZWVQak9w?= =?utf-8?B?MFZMVGtjYzNoUkI4TXFpNUpPTTFPQ0tWRkZkdDRUV3JuQ093elJZalp0YVdT?= =?utf-8?B?RUFZSWUxWWpPYUhicThYbXFtVThaa01Ic24wVm9sUlErN3JhTU1NVFhraTdM?= =?utf-8?B?N2gvK2lPRU5nQ0ZFS0QrZksyajF2dDFtWFZtNDMrWjM1cno5UXh0U013M0sv?= =?utf-8?B?RTk5WlJ3NW5DdS9pZ01IeW9FOU5hOWpUbmFmd1ZZTlg3UXpxR1dwWUUxVmNY?= =?utf-8?B?ZUREMVltNUlBM1FGWjZmUW5nWUplNTRtS3U0WGJiZVNkUkFNRlhsdytLS3lv?= =?utf-8?B?MklUMmZET3lxOWp3WUhGdVhiUncrb09zNXNkNDU4dUQvdjU5VGtCYUx2SG9s?= =?utf-8?B?L3N3ZklNWFlzNVB4OXJEcUV4UmkrcUgxemh3dlloVkxqMjFhREJsSHREK2ph?= =?utf-8?B?OFJEbHR1YzVIS0V2MEZiUW1RRUhsOFo1aU12cTUrWjNTUjFMcWNvYjRsTktS?= =?utf-8?B?VjdBVThUMTlBNk5vaFFVdXI4NmFKKzVNSzBKZERYdUFaTk9POHRMcVJRSXo0?= =?utf-8?B?Z24xV0ladUpGQTg5bE9iK3hwRXExeld3RUh3WWRXeXJUNlpJRXE1T3lzemNL?= =?utf-8?B?eGwvenVLNEZ3TWxYWmJsTUtZMDdld1NvTE5nWkVUdU1xcHJiemFIZ0ZqUVhk?= =?utf-8?B?dlVSMVJid0g2Z2Qxd0xWRDByUmI0RW5ZaW5kZ0pvRDV3SEdPWDJZQ0ovbnBi?= =?utf-8?B?Z3Q2Z1Zkci9hWEtoQzArV3NlZjdJWFVtbjJDRU5paGQrLzZpeG9aQUN1NTlP?= =?utf-8?B?MmFmZ0JxMlBnRzVPc0oxeEJ2Y2l4TDF3T2pTUVE2djVLYmxGa1RPQmJYQmJy?= =?utf-8?B?UkdVRkNYT0w3aWhhbk9pdDB4SlBJK1JUSlhRMjkzWDlKdExDTW5SVWE3bVBr?= =?utf-8?B?RFcydEVHYk5kSGtSZW9USjdxNTlNVGM5Sk1YOW1raXJmamNJSDl2ME1Ed2pY?= =?utf-8?B?UnpkdFRFeGczWHFBT1hrMjkxMzRoSlpPTkR6Q3ZMOGVueC9BRGt4eG04aEVR?= =?utf-8?B?MmJvNldBZkVmNWpTVmV1Z0FxWmEzN09ueTN3MytNZFByNDZZUm93QlNOZDAv?= =?utf-8?B?aldIZHRYYmxkY3UydnBqTUhaOHJqMlBIUkR6ZDM4MEE4OWxRclM2amtHRWw2?= =?utf-8?B?UmY2b1FqNE9vdFY5YmRFUFduNHU3U1U1T25uQ2F2SFVXNFNWM3kwQVY4Vjd3?= =?utf-8?B?MERqL0pwaWg3YldFb1QzZVNHWEEweEJnZmRsS2dzcVRZS0laZlU1YjZmMHBK?= =?utf-8?B?TE5Qajc4MmVYa29TQXdXbDV4aXBGODJQaFh1QnJXU2Zabjc4bHNEcjFLemJu?= =?utf-8?B?ZVg4YkxIQkJYeEx6NXBEdHJqNkIzTjFPSVRFY1p1ODJwK2ozR2cwVzVkZkow?= =?utf-8?B?VWFWeHgvdWVKWStJUzl4TThVcmMrcDBRUUJBQnNkbzNxOUdERnNBYmlaUnZP?= =?utf-8?B?cVVwQTI1ZHpiRFgvMER5N2VYWmRURkFGd0YwZWJmbW5SaE14a3BnSWJPa2Iv?= =?utf-8?B?LzBva09aT0ZTTmJWSkNwa2FYL09rTytuY2QvYUJjd0ZmVklacEVnMG4vN1p1?= =?utf-8?B?bVEzaXJQc243ZG1CUzgxSEdHSE1FdmhOaVVYeGczSDMrS0tYVVlQZ3hVaG9k?= =?utf-8?Q?5qRGK8oa11zC3+6T5czTy58TG8c56E=3D?= X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0676; 5:s+xIWrgV99bB/cUKKd95NjHB0cJI5FuAU0oOvNZJzv7z/iFZlxcjI4NODTLeQipaIxRfxcezY/a3ChpGVat8U5S4eUdV7NgPsSb7hjI/GoB5f8smeehjZaBFo0qO+g41K1j8gutKkUYTv1ArHUTYJQ==; 24:k2Q38o7d31M6ppRffjWIPcuGjUnSCPYaGoin5xdsXln+gkVo039ah0zwOwQ4nHY1zqQLIQ28h6yqOM+d1uxSyasRW6DrDOV2IFYvTpgKl4M=; 20:o0lAAOrCSLWTegCM/4+gX8zRoUGEqqr8FGrtKsK0HxlSaGFRTnxbwqDG9eUq8Gy6pKEgfs6LgQ0mH22x0LK2ng== SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-MS-Exchange-CrossTenant-OriginalArrivalTime: 12 Oct 2015 13:59:53.6356 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BLUPR11MB0676 X-Microsoft-Exchange-Diagnostics: 1; BLUPR11MB0097; 2:ve1PtzWUKBI8y7eBTK9NaL9kTm557aMTT/6s9IUeXgfSrt+h48gc8rnBFy/sDLnakSYLXPZuXA2tpFfsUu7Itd70ZWb5pslMiQdSDpjpinI+yrR9Y0RQbUTwtPJsV6MXd/t6RgCzaXU5ZbvzmHVmL4PYC3Gf7NnEKBIRKsyNi2c=; 23:gYIgrdUGb4qW2Nh14EjFGjhmE2Qy4bWN3eW097GQ92BtOXcvX+s9npswnAAAansenCaw6vAiMWhjV842LeVvK/24ru2memvMU5ziq7DB1/AAav0AM18KgCxfdvNo0DbO0aP+9Q/H/IyN5SGFhzFsiKyPqHOG+OYFl/20UgvxCY1avnCN2dYKzGLXxj7AuKZN X-OriginatorOrg: bluetreble.com X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 10/6/15 12:18 PM, Olivier Dony wrote: > > We would happily skip the micro-transactions (as a perf workaround) if > there was a way to detect this situation, but we couldn't find a way to > do that in 9.3. <9.3 we used SELECT FOR UPDATE NOWAIT to guard similar > cases. > > If there is any way I could help to make the back-patch happen, please > let me know! I'd say you should probably open a bug about this to make sure it's visible if you want it fixed. Or start a thread on -hackers. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general