From mboxrd@z Thu Jan 1 00:00:00 1970 From: Robert Haas Subject: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation [and 2 more messages] Date: Wed, 14 Dec 2016 01:44:11 -0500 Message-ID: References: <1481307991-16971-1-git-send-email-ian.jackson@eu.citrix.com> <22606.47105.549023.301281@mariner.uk.xensource.com> <22607.56276.807567.924144@mariner.uk.xensource.com> <22608.6345.97849.783099@mariner.uk.xensource.com> <22608.14118.291149.821376@mariner.uk.xensource.com> Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Return-path: Received: from mail6.bemta3.messagelabs.com ([195.245.230.39]) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cH3IU-0004Bp-J8 for xen-devel@lists.xenproject.org; Wed, 14 Dec 2016 06:44:14 +0000 Received: by mail-qt0-f174.google.com with SMTP id w33so9181799qtc.3 for ; Tue, 13 Dec 2016 22:44:13 -0800 (PST) In-Reply-To: <22608.14118.291149.821376@mariner.uk.xensource.com> List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xen.org Sender: "Xen-devel" To: Ian Jackson Cc: xen-devel@lists.xenproject.org, "pgsql-hackers@postgresql.org" , Thomas Munro , Kevin Grittner List-Id: xen-devel@lists.xenproject.org T24gVHVlLCBEZWMgMTMsIDIwMTYgYXQgMTowMCBQTSwgSWFuIEphY2tzb24gPGlhbi5qYWNrc29u QGV1LmNpdHJpeC5jb20+IHdyb3RlOgo+IFRoZSBjb252ZXJzaW9uIGlzIGFzIGZvbGxvd3M6IGlm IGEgc2NlbmFyaW8gaXMgYWZmZWN0ZWQgYnkgdGhlIGNhdmVhdCwKPiBpbiB0aGVyZSBtdXN0IGJl IGF0IGxlYXN0IG9uZSB0cmFuc2FjdGlvbiBUIHdoaWNoIGZpcnN0bHkgcHJvZHVjZXMKPiAiaW1w b3NzaWJsZSIgcmVzdWx0cyBJLCBhbmQgaW4gd2hpY2ggc29tZSBsYXRlciBzdGF0ZW1lbnQgUyBw cm9kdWNlcyBhCj4gc2VyaWFsaXNhdGlvbiBmYWlsdXJlLgo+Cj4gVG8gZXhoaWJpdCB0aGUgY29y cmVzcG9uZGluZyB1bmF2b2lkYWJsZSBidWc6IEV4ZWN1dGUgYW4gaWRlbnRpY2FsCj4gc2NlbmFy aW8sIHdpdGggZXhhY3RseSB0aGUgc2FtZSBzZXF1ZW5jZSBvZiBzdGVwcyBpbiB0aGUgc2FtZSBv cmRlciwKPiB1cCB0byBTLiAgSG93ZXZlciwgaW5zdGVhZCBvZiBTLCBleGVjdXRlIFJPTExCQUNL LgoKSSBhbSBoYXZpbmcgYSBoYXJkIHRpbWUgdW5kZXJzdGFuZGluZyBleGFjdGx5IHdoYXQgdGhl IGFyZ3VtZW50IG9uCnRoaXMgdGhyZWFkIGlzIGFib3V0LCBidXQgSSB3YW50IHRvIGNvbW1lbnQg b24gdGhpcyBwb2ludC4KClNheWluZyB0aGF0IGEgc2V0IG9mIHRyYW5zYWN0aW9ucyBhcmUgc2Vy aWFsaXphYmxlIGlzIGVxdWl2YWxlbnQgdG8KdGhlIHN0YXRlbWVudCB0aGF0IHRoZXJlIGlzIHNv bWUgc2VyaWFsIG9yZGVyIG9mIGV4ZWN1dGlvbiB3aGljaCB3b3VsZApoYXZlIHByb2R1Y2VkIHJl c3VsdHMgZXF1aXZhbGVudCB0byB0aGUgYWN0dWFsIHJlc3VsdHMuICBUaGF0IGlzLAp0aGVyZSBt dXN0IGJlIGF0IGxlYXN0IG9uZSBzY2hlZHVsZSAoVDEsIC4uLiwgVG4pIHN1Y2ggdGhhdCBydW5u aW5nCnRoZSB0cmFuc2FjdGlvbnMgb25lIGFmdGVyIGFub3RoZXIgaW4gdGhhdCBvcmRlciB3b3Vs ZCBoYXZlIHByb2R1Y2VkCnRoZSBzYW1lIHJlc3VsdHMgdGhhdCB3ZXJlIG9idGFpbmVkIGJ5IHJ1 bm5pbmcgdGhlbSBjb25jdXJyZW50bHkuCkFueSB0cmFuc2FjdGlvbnMgdGhhdCByb2xsIGJhY2sg d2hldGhlciBkdWUgdG8gc2VyaWFsaXphdGlvbiBhbm9tYWxpZXMKb3IgbWFudWFsIHVzZXIgaW50 ZXJ2ZW50aW9uIG9yIGFueSBvdGhlciByZWFzb24gYXJlIG5vdCBwYXJ0IG9mIHRoZQpzY2hlZHVs ZSwgd2hpY2ggY29uc2lkZXJzIG9ubHkgc3VjY2Vzc2Z1bGx5IGNvbW1pdHRlZCB0cmFuc2FjdGlv bnMuClRoZSByb2xsZWQtYmFjayB0cmFuc2FjdGlvbnMgZWZmZWN0aXZlbHkgZGlkbid0IGhhcHBl biwgYW5kCnNlcmlhbGl6YWJpbGl0eSBhcyBhIGNvbmNlcHQgbWFrZXMgbm8gY2xhaW0gYWJvdXQg dGhlIGJlaGF2aW9yIG9mIHN1Y2gKdHJhbnNhY3Rpb25zLiAgVGhhdCdzIG5vdCBhIFBvc3RncmVT UUwgdGhpbmc6IHRoYXQncyBkYXRhYmFzZSB0aGVvcnkuCgpIb3dldmVyLCBpbiBwcmFjdGljZSwg dGhlIHNjZW5hcmlvIHRoYXQgeW91IG1lbnRpb24gc2hvdWxkIGdlbmVyYWxseQp3b3JrIGZpbmUg aW4gUG9zdGdyZVNRTCwgSSB0aGluay4gIElmIFQgcGVyZm9ybWVkIGFueSB3cml0ZXMsIHRoZQpy b2xsYmFjayB0aHJvd3MgdGhlbSBhd2F5LCBzbyBpbWFnaW5lIHJlbW92aW5nIHRoZSBhY3R1YWwg VCBmcm9tIHRoZQptaXggYW5kIHJlcGxhY2luZyBpdCB3aXRoIGEgc3Vic3RpdHV0ZSB2ZXJzaW9u IFQnIHdoaWNoIHBlcmZvcm1zIHRoZQpzYW1lIHJlYWRzIGJ1dCBubyB3cml0ZXMgYW5kIHRoZW4g dHJpZXMgdG8gQ09NTUlUIHdoZXJlIFQgdHJpZWQgdG8KUk9MTEJBQ0suICBUJyB3aWxsIHN1Y2Nl ZWQsIGJlY2F1c2Ugd2UgbmV2ZXIgcm9sbCBiYWNrIGEgcmVhZC1vbmx5CnRyYW5zYWN0aW9uIGF0 IGNvbW1pdCB0aW1lLiAgSWYgaXQgd2VyZSB0byBmYWlsLCBpdCB3b3VsZCBoYXZlIHRvIGZhaWwK KndoaWxlIHBlcmZvcm1pbmcgb25lIG9mIHRoZSByZWFkcyosIG5vdCBsYXRlci4KCkJ1dCBpbWFn aW5lIGEgaHlwb3RoZXRpY2FsIGRhdGFiYXNlIHN5c3RlbSBpbiB3aGljaCBhbm9tYWxpZXMgYXJl Cm5ldmVyIGRldGVjdGVkIHVudGlsIGNvbW1pdCB0aW1lLiAgV2Ugc29tZWhvdyB0cmFjayB0aGUg Z2xvYmFsCm11c3QtaGFwcGVuLWJlZm9yZSBncmFwaCBhbmQgcmVmdXNlIHRoZSBjb21taXQgb2Yg YW55IHRyYW5zYWN0aW9uCndoaWNoIHdpbGwgY3JlYXRlIGEgY3ljbGUuICBMZXQncyBhbHNvIHN1 cHBvc2UgdGhhdCB0aGlzIHN5c3RlbSB1c2VzCnNuYXBzaG90cyB0byBpbXBsZW1lbnQgTVZDQy4g IEluIHN1Y2ggYSBzeXN0ZW0sIHJlYWQtb25seSB0cmFuc2FjdGlvbnMKd2lsbCBzb21ldGltZXMg ZmFpbCBhdCBjb21taXQgdGltZSBpZiB0aGV5J3ZlIHNlZW4gYSB2aWV3IG9mIHRoZSB3b3JsZAp0 aGF0IGlzIGluY29uc2lzdGVudCB3aXRoIHRoZSBvbmx5IHJlbWFpbmluZyBwb3NzaWJsZSBzZXJp YWwKc2NoZWR1bGVzLiAgRm9yIGV4YW1wbGUsIHN1cHBvc2UgVDEgdXBkYXRlcyBBIC0+IEEnIGFu ZCByZWFkcyBCLgpDb25jdXJyZW50bHksIFQyIHVwZGF0ZXMgQiAtPiBCJzsgdGh1cywgVDEgbXVz dCBwcmVjZWRlIFQyLiAgTmV4dCwgVDIKY29tbWl0cy4gIE5vdywgVDMgYmVnaW5zIGFuZCByZWFk cyBCJywgc28gdGhhdCBUMiBtdXN0IHByZWNlZGUgVDMuCk5leHQgVDEgY29tbWl0cy4gIFQzLCB3 aGljaCB0b29rIGl0cyBzbmFwc2hvdCBiZWZvcmUgdGhlIGNvbW1pdCBvZiBUMSwKbm93IHJlYWRz IEEuICBUaHVzIFQzIGhhcyB0byBwcm9jZWVkIFQxLiAgVGhhdCdzIGEgY3ljbGUsIHNvIFQzIHdv bid0CmJlIGFsbG93ZWQgdG8gY29tbWl0LCBidXQgeWV0IGl0J3MgZG9uZSBhIGNvdXBsZSBvZiBy ZWFkcyBhbmQgaGFzbid0CmZhaWxlZCB5ZXQuLi4gIGJlY2F1c2Ugb2YgYW4gaW1wbGVtZW50YXRp b24gZGV0YWlsIG9mIHRoZSBzeXN0ZW0uClRoYXQncyBwcm9iYWJseSBhbm5veWluZyBmcm9tIGEg dXNlciBwZXJzcGVjdGl2ZSAtLSBpZiBhIHRyYW5zYWN0aW9uCmlzIGNlcnRhaW5seSBnb2luZyB0 byBmYWlsIHdlJ2QgbGlrZSB0byByZXBvcnQgdGhlIGZhaWx1cmUgYXMgZWFybHkgYXMKcG9zc2li bGUgLS0gYW5kIGl0J3MgcHJvYmFibHkgY3J1c2hpbmdseSBzbG93LCBidXQgYWNjb3JkaW5nIHRv IG15CnVuZGVyc3RhbmRpbmcgaXQncyB1bmFyZ3VhYmx5IGEgY29ycmVjdCBpbXBsZW1lbnRhdGlv biBvZgpzZXJpYWxpemFiaWxpdHkgKGFzc3VtaW5nIHRoZXJlIGFyZSBubyBidWdzKSwgeWV0IGl0 IGRvZXNuJ3QgZGVsaXZlcgp0aGUgZ3VhcmFudGVlIHlvdSdyZSBhc2tpbmcgZm9yIGhlcmUuCgpJ IGhhdmUgbm90IHJlYWQgYW55IGRhdGFiYXNlIGxpdGVyYXR1cmUgb24gdGhlIGludGVyYWN0aW9u IG9mCnNlcmlhbGl6YWJpbGl0eSB3aXRoIHN1YnRyYW5zYWN0aW9ucy4gIFRoaXMgc2VlbXMgdmVy eSB0aG9ybnkuClN1cHBvc2UgVDEgcmVhZHMgQSBhbmQgQiBhbmQgdXBkYXRlcyBBIC0+IEEnIHdo aWxlIGNvbmN1cnJlbnRseSBUMgpyZWFkcyBBIGFuZCBCIGFuZCB1cGRhdGVzIEIgLT4gQicuICBU aGlzIGlzIG9idmlvdXNseSBub3QKc2VyaWFsaXphYmxlOyBpZiBlaXRoZXIgdHJhbnNhY3Rpb24g aGFkIGV4ZWN1dGVkIGJlZm9yZSB0aGUgb3RoZXIgaW4gYQpzZXJpYWwgc2NoZWR1bGUsIHRoZSBz ZWNvbmQgdHJhbnNhY3Rpb24gaW4gdGhlIHNjaGVkdWxlIHdvdWxkIGhhdmUgaGFkCnRvIGhhdmUg c2VlbiAoQSwgQicpIG9yIChBJywgQikgcmF0aGVyIHRoYW4gKEEsIEIpLCBidXQgdGhhdCdzIG5v dAp3aGF0IGhhcHBlbmVkLiAgQnV0IHdoYXQgaWYgZWFjaCBvZiBUMSBhbmQgVDIgZGlkIHRoZSBy ZWFkcyBpbiBhCnN1YnRyYW5zYWN0aW9uLCByb2xsZWQgaXQgYmFjaywgYW5kIHRoZW4gZGlkIHRo ZSB3cml0ZSBpbiB0aGUgbWFpbgp0cmFuc2FjdGlvbiBhbmQgY29tbWl0dGVkPyAgVGhlIGRhdGFi YXNlIHN5c3RlbSBoYXMgdHdvIG9wdGlvbnMuCkZpcnN0LCBpdCBjb3VsZCBhc3N1bWUgdGhhdCB0 aGUgdG9wbGV2ZWwgdHJhbnNhY3Rpb24gbWF5IGhhdmUgcmVsaWVkCm9uIHRoZSByZXN1bHRzIG9m IHRoZSBhYm9ydGVkIHN1YnRyYW5zYWN0aW9uLiAgQnV0IGlmIGl0IGRvZXMgdGhhdCwKdGhlbiBh bnkgc2VyaWFsaXphdGlvbiBmYWlsdXJlIHdoaWNoIGFmZmxpY3RzIGEgc3VidHJhbnNhY3Rpb24g bXVzdApuZWNlc3NhcmlseSBhbHNvIGtpbGwgdGhlIG1haW4gdHJhbnNhY3Rpb24sIHdoaWNoIHNl ZW1zIHBlZGFudGljIGFuZAp1bmhlbHBmdWwuICBJZiB5b3UnZCB3YW50ZWQgdGhlIHRvcGxldmVs IHRyYW5zYWN0aW9uIHRvIGJlIGtpbGxsZWQsCnlvdSB3b3VsZG4ndCBoYXZlIHVzZWQgYSBzdWJ0 cmFuc2FjdGlvbiwgcmlnaHQ/ICBTZWNvbmQsIGl0IGNvdWxkCmFzc3VtZSB0aGF0IHRoZSB0b3Bs ZXZlbCB0cmFuc2FjdGlvbiBpbiBubyB3YXkgcmVsaWVkIG9uIG9yIHVzZWQgdGhlCnZhbHVlcyBv YnRhaW5lZCBmcm9tIHRoZSBhYm9ydGVkIHN1YnRyYW5zYWN0aW9uLiAgSG93ZXZlciwgdGhhdApk ZWZlYXRzIHRoZSB3aG9sZSBwdXJwb3NlIG9mIGhhdmluZyBzdWJ0cmFuc2FjdGlvbnMgaW4gdGhl IGZpcnN0CnBsYWNlLiAgV2hhdCdzIHRoZSBwb2ludCBvZiBiZWluZyBhYmxlIHRvIHN0YXJ0IHN1 YnRyYW5zYWN0aW9ucyBpZiB5b3UKY2FuJ3Qgcm9sbCB0aGVtIGJhY2sgYW5kIHRoZW4gZGVjaWRl IHRvIGRvIHNvbWV0aGluZyBlbHNlIGluc3RlYWQ/ICBJdApzZWVtcyB0byBtZSB0aGF0IHdoYXQg dGhlIGRhdGFiYXNlIHN5c3RlbSBzaG91bGQgZG8gaXMgbWFrZSB0aGF0CnNlY29uZCBhc3N1bXB0 aW9uLCBhbmQgd2hhdCB0aGUgdXNlciBzaG91bGQgZG8gaXMgdW5kZXJzdGFuZCB0aGF0IHRvCnRo ZSBkZWdyZWUgdGhhdCB0cmFuc2FjdGlvbnMgZGVwZW5kIG9uIHRoZSByZXN1bHRzIG9mIGFib3J0 ZWQKc3VidHJhbnNhY3Rpb25zLCB0aGVyZSBtYXkgYmUgc2VyaWFsaXphdGlvbiBhbm9tYWxpZXMg dGhhdCBnbwp1bmRldGVjdGVkLiAgQW5kIHRoZSB1c2VyIHNob3VsZCBwdXQgdXAgd2l0aCB0aGF0 IGJlY2F1c2UgdGhlIGN1cmUgaXMKd29yc2UgdGhhbiB0aGUgZGlzZWFzZS4gIE1heWJlIHRoZXJl J3MgYSBtb3JlIGZvcm1hbGx5IHNhdGlzZnlpbmcKYW5zd2VyIHRoYW4gdGhhdCBidXQgSSdtIG5v dCByZWFsbHkgc2VlaW5nIGl0Li4uCgotLSAKUm9iZXJ0IEhhYXMKRW50ZXJwcmlzZURCOiBodHRw Oi8vd3d3LmVudGVycHJpc2VkYi5jb20KVGhlIEVudGVycHJpc2UgUG9zdGdyZVNRTCBDb21wYW55 CgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpYZW4tZGV2 ZWwgbWFpbGluZyBsaXN0Clhlbi1kZXZlbEBsaXN0cy54ZW4ub3JnCmh0dHBzOi8vbGlzdHMueGVu Lm9yZy94ZW4tZGV2ZWwK