From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ian Jackson Subject: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation [and 2 more messages] Date: Tue, 13 Dec 2016 18:00:06 +0000 Message-ID: <22608.14118.291149.821376__24662.7875873402$1481652102$gmane$org@mariner.uk.xensource.com> 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> Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Return-path: Received: from mail6.bemta6.messagelabs.com ([193.109.254.103]) by lists.xenproject.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cGrNA-0004PT-4e for xen-devel@lists.xenproject.org; Tue, 13 Dec 2016 18:00:16 +0000 In-Reply-To: List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xen.org Sender: "Xen-devel" To: Kevin Grittner Cc: xen-devel@lists.xenproject.org, Thomas Munro , "pgsql-hackers@postgresql.org" List-Id: xen-devel@lists.xenproject.org S2V2aW4gR3JpdHRuZXIgd3JpdGVzICgiUmU6IFtIQUNLRVJTXSBbT1NTVEVTVCBQQVRDSCAwLzFd IFBvc3RncmVTUUwgZGI6IFJldHJ5IG9uIGNvbnN0cmFpbnQgdmlvbGF0aW9uIFthbmQgMiBtb3Jl IG1lc3NhZ2VzXSIpOgo+IFt2YXJpb3VzIHRoaW5nc10KCkkgZ2V0IHRoZSBmZWVsaW5nIGZyb20g eW91ciBtZXNzYWdlIHRoYXQgSSBoYXZlIGlycml0YXRlZCB5b3UuICBJJ20Kc29ycnkgaWYgSSBo YXZlLiAgSW4gcGFydGljdWxhciwgSSB3YW50ZWQgdG8gc2F5IHRoYXQgSSBjZXJ0YWlubHkKZG9u J3QgZXhwZWN0IGJ1Z3MgdG8gYmUgZml4ZWQgaW1tZWRpYXRlbHkuICBJIGFwcHJlY2lhdGUgeW91 cgphdHRlbnRpb24gdG8gZGV0YWlsLiAgSSBhbHNvIGFwcHJlY2lhdGUgeW91IHRha2luZyB0aGUg dGltZSB0byBkZWFsIG9uCnlvdXIgLWhhY2tlcnMgbGlzdCB3aXRoIHNvbWVvbmUgd2hvIHJlYWxs eSBpc24ndCBhIGRhdGFiYXNlIGhhY2tlciEKCkkgc3RpbGwgaG9wZSB0byBiZSBhYmxlIHRvIGNv bnZpbmNlIHlvdSB0aGF0IHRoZSBkZWZpbml0aW9uIG9mClNFUklBTElaQUJMRSAoaW4gdGhlIHBn c3FsIGRvY3MpIG91Z2h0IHRvIGJlIGEgc3Ryb25nZXIgdmVyc2lvbiwgd2hpY2gKY292ZXJzIGV2 ZW4gbm9uLWNvbW1pdHRlZCB0cmFuc2FjdGlvbnMuCgoKPiBbSWFuIEphY2tzb246XQo+ID4gQnV0 IEkgaGF2ZSBqdXN0IGRlbW9uc3RyYXRlZCBhIGNvbXBsZXRlbHkgZ2VuZXJhbCB0ZWNobmlxdWUg d2hpY2ggY2FuCj4gPiBiZSB1c2VkIHRvIGNvbnZlcnQgYW55ICJzcHVyaW91cyIgY29uc3RyYWlu dCBmYWlsdXJlIGludG8gYSBub25zZW5zZQo+ID4gdHJhbnNhY3Rpb24gYWN0dWFsbHkgY29tbWl0 dGVkIHRvIHRoZSBkYXRhYmFzZS4KPiAKPiBSZWFsbHk/ICBJIHNlZSBhIGxvdCBvZiBkYXlsaWdo dCBiZXR3ZWVuICJ5b3UgbXVzdCBkaXNjYXJkIGFueQo+IHJlc3VsdHMgZnJvbSBhIHRyYW5zYWN0 aW9uIHdoaWNoIGxhdGVyIHRocm93cyBhIHNlcmlhbGl6YXRpb24KPiBmYWlsdXJlIiBhbmQgImlm IHlvdSBjYXRjaCB0aGUgZXhjZXB0aW9uIGZyb20gYSBjb25zdHJhaW50Cj4gdmlvbGF0aW9uIHdp dGhpbiBhIHN1YnRyYW5zYWN0aW9uIGl0IGlzIHBvc3NpYmxlIHRvIGNyZWF0ZSBhCj4gc2VyaWFs aXphdGlvbiBhbm9tYWx5Ii4gIEkgZG9uJ3QgYWN0dWFsbHkgc2VlIGhvdyBvbmUgcmVsYXRlcyB0 bwo+IHRoZSBvdGhlci4gIFdoYXQgYW0gSSBtaXNzaW5nPwoKSSBkb24ndCB0aGluayBpdCBjYW4g YmUgdXNlZnVsIHRvIHN0YXRlIChpbiB0aGUgcGdzcWwgZG9jcykgdGhlIGNhdmVhdAp5b3UgcHJv cG9zZSwgdG8gd2l0OgogICJ5b3UgbXVzdCBkaXNjYXJkIGFueSByZXN1bHRzIGZyb20gYSB0cmFu c2FjdGlvbiB3aGljaCBsYXRlciB0aHJvd3MKICAgYSBzZXJpYWxpemF0aW9uIGZhaWx1cmUiCgpJ IHRoaW5rIGFueSBzY2VuYXJpbyB3aGVyZSB0aGlzIGNhdmVhdCBkZWNsYXJlcyBhIGJlaGF2aW91 ciB0byBiZSAibm90CmEgYnVnIiwgY2FuIGJlIGNvbnZlcnRlZCBpbnRvIGEgc2NlbmFyaW8gd2hl cmUgdGhlcmUgaXMgdW5kb3VidGVkbHkgYQpidWcuICBTbyB0aGlzIGNhdmVhdCBkb2VzIG5vdCBh Y3R1YWxseSByZWR1Y2UgdGhlIGRpZmZpY3VsdHkgb2YKaW1wbGVtZW50aW5nIHRoZSBwcm9taXNl cyBtYWRlIGJ5IHRoZSBkb2N1bWVudGF0aW9uLgoKVGhlIGNvbnZlcnNpb24gaXMgYXMgZm9sbG93 czogaWYgYSBzY2VuYXJpbyBpcyBhZmZlY3RlZCBieSB0aGUgY2F2ZWF0LAppbiB0aGVyZSBtdXN0 IGJlIGF0IGxlYXN0IG9uZSB0cmFuc2FjdGlvbiBUIHdoaWNoIGZpcnN0bHkgcHJvZHVjZXMKImlt cG9zc2libGUiIHJlc3VsdHMgSSwgYW5kIGluIHdoaWNoIHNvbWUgbGF0ZXIgc3RhdGVtZW50IFMg cHJvZHVjZXMgYQpzZXJpYWxpc2F0aW9uIGZhaWx1cmUuCgpUbyBleGhpYml0IHRoZSBjb3JyZXNw b25kaW5nIHVuYXZvaWRhYmxlIGJ1ZzogRXhlY3V0ZSBhbiBpZGVudGljYWwKc2NlbmFyaW8sIHdp dGggZXhhY3RseSB0aGUgc2FtZSBzZXF1ZW5jZSBvZiBzdGVwcyBpbiB0aGUgc2FtZSBvcmRlciwK dXAgdG8gUy4gIEhvd2V2ZXIsIGluc3RlYWQgb2YgUywgZXhlY3V0ZSBST0xMQkFDSy4KCk5vdyB0 aGlzIGFub21hbG91cyB0cmFuc2FjdGlvbiBUJyBpcyBub3QgImEgdHJhbnNhY3Rpb24gd2hpY2gg bGF0ZXIKdGhyb3dzIGEgc2VyaWFsaXphdGlvbiBmYWlsdXJlIi4gIFRoZXJlIGlzIG5vIHJlcXVp cmVtZW50IHRvIGRpc2NhcmQKdGhlICJpbXBvc3NpYmxlIiByZXN1bHRzIEkuICBUaGUgcmVzdWx0 cyBJIGFyZSBzdXBwb3NlZCB0byBiZSBjb3JyZWN0LApidXQgdGhleSBhcmUgbm90LgoKKEkgYW0g bWFraW5nIHRoZSBob3BlZnVsbHktd2FycmFudGVkIGFzc3VtcHRpb24gdGhhdCBST0xMQkFDSyBj YW5ub3QKaXRzZWxmIGNhdXNlIGEgc2VyaWFsaXNhdGlvbiBmYWlsdXJlLikKCkluIHRoZW9yeSB0 aGlzIGFyZ3VtZW50IGRvZXMgbm90IHByb3ZlIHRoYXQgZXZlcnkgYnVnIHdoaWNoIHRoZSBjYXZl YXQKaXMgdHJ5aW5nIHRvIGFkZHJlc3MsIGlzIGFzIGltcG9ydGFudCBhcyB0aGUgc2FtZSBidWcg d2l0aG91dCB0aGUKY2F2ZWF0LiAgVGhpcyBpcyBiZWNhdXNlIHBlcmhhcHMgVCcgaXMgYW4gdW5y ZWFsaXN0aWMgdHJhbnNhY3Rpb24Kc29tZWhvdy4KCkJ1dCBJIGRvbid0IHJlYWxseSB0aGluayB0 aGF0IHRoZSBwcmltYXJ5IGRvY3VtZW50YXRpb24gc2hvdWxkIGJlCmNvbXBsaWNhdGVkLCBhbmQg c2hvdWxkIGdpdmUgd2Vha2VyIHN0YXRlbWVudHMgYWJvdXQgdGhlIHN5c3RlbQpiZWhhdmlvdXIs IHNpbXBseSBhcyBhbiBhaWQgdG8gYnVnIHByaW9yaXRpc2F0aW9uLgoKCj4gPiAxLiBEZWNsYXJl IHRoYXQgYWxsIHNwdXJpb3VzIGZhaWx1cmVzLCBpbiBTRVJJQUxJWkFCTEUgdHJhbnNhY3Rpb25z LAo+ID4gYXJlIGJ1Z3MuCj4gCj4gSXQncyBub3QgY2xlYXIgdG8gbWUgd2hhdCB5b3UgbWVhbiBo ZXJlLgoKSSBtZWFuIHRoYXQgdGhlIHBnc3FsIGRvY3VtZW50YXRpb24gc2hvdWxkIHNpbXBseSBz YXkgdGhhdCBmb3IKU0VSSUFMSVpBQkxFIHRyYW5zYWN0aW9ucywgdGhlcmUgaXMgYWx3YXlzIGEg Y29oZXJlbnQgc2VyaWFsaXNhdGlvbi4KRXZlbiBpZiB0aGUgdHJhbnNhY3Rpb24gZmFpbGVkIGR1 ZSB0byBhIGNvbnN0cmFpbnQgdmlvbGF0aW9uLCBvcgpzZXJpYWxpc2F0aW9uIGZhaWx1cmUsIG9y IGRhdGFiYXNlIGRpc2Nvbm5lY3Rpb24sIG9yIHdoYXRldmVyLgoKSSB0aGluayB0aGVyZSBpcyBu byAidXNlZnVsIiB3ZWFrZXIgZ3VhcmFudGVlLgoKQnkgd2hpY2ggSSBtZWFuIHRoYXQgZm9yIGFu eSByZWFzb25hYmxlIHdlYWtlciBndWFyYW50ZWU6IGFueSBzY2VuYXJpbwppbiB3aGljaCBwZ3Nx bCB2aW9sYXRlcyB0aGUgc3Ryb25nZXIgZ3VhcmFudGVlLCBjYW4gYmUgY29udmVydGVkIGludG8K YSBzY2VuYXJpbyB3aGVyZSBwZ3NxbCB2aW9sYXRlcyB0aGUgd2Vha2VyIGd1YXJhbnRlZS4KCkNv bnZlcnNlbHksIGFueSBjb3JyZWN0IGltcGxlbWVudGF0aW9uIG9mIHRoZSB3ZWFrZXIgZ3VhcmFu dGVlCm5lY2Vzc2FyaWx5IGltcGxlbWVudHMgdGhlIHN0cm9uZ2VyIGd1YXJhbnRlZSB0b28uICBT byB0aGUgd2Vha2VyCmd1YXJhbnRlZSBkb2VzIG5vdCBtYWtlIGltcGxlbWVudGF0aW9uIGVhc2ll ci4gIEFsbCBpdCBkb2VzIGlzCmNvbXBsaWNhdGUgYXBwbGljYXRpb24gY29kZS4KCgo+ID4gMi4g U3RhdGUgdGhhdCB0aGUgU0VSSUFMSVpBQkxFIGd1YXJhbnRlZSBpbiBQb3N0Z3Jlc3FsIG9ubHkg YXBwbGllcyB0bwo+ID4gdHJhbnNhY3Rpb25zIHdoaWNoIChhKSBjb21wbGV0ZSBzdWNjZXNzc2Z1 bGx5IGFuZCAoYikgY29udGFpbiBvbmx5Cj4gPiB2ZXJ5IHNpbXBsZSBwZ3NxbCBjb25zdHJ1Y3Rz Lgo+IAo+IEFib3V0IDI0IGhvdXJzIGFnbyB5b3UgcmVwb3J0ZWQgYSBidWcgd2hpY2ggd2FzIGhh cmQgZW5vdWdoIHRvIGhpdAo+IHRoYXQgaXQgdG9vayA1IHllYXJzIGZvciBhbnlvbmUgdG8gZmlu ZCBpdC4KCldlbGwsIG9mIGNvdXJzZSBJIGhhdmUgYSBzbGlnaHRseSBkaWZmZXJlbnQgcG9pbnQg b2Ygdmlldy4KClRoZSBmYWN0IHRoYXQgcGdzcWwgbWlnaHQgZ2VuZXJhdGUgInNwdXJpb3VzIiBj b25zdHJhaW50IHZpb2xhdGlvbnMsCmV2ZW4gaW4gU0VSSUFMSVpBQkxFIHRyYW5zYWN0aW9ucywg aGFzIGJlZW4ga25vd24gZm9yIG1hbnkgeWVhcnMuICBTZWUKdGhlIFVSTHMgZXRjLiBpbiBteSBw YXRjaCwgd2hpY2ggaW5jbHVkZSBhIHJlZmVyZW5jZSBmcm9tIDIwMDkuICBNYW55CnBlb3BsZSBo YXZlIGFsd2F5cyByZWdhcmRlZCB0aGlzIGFzIGEgYnVnLiAgVGhlIHBnc3FsIGF1dGhvcnMgaGF2 ZSBub3QKYWdyZWVkLgoKRnJvbSBteSBwb2ludCBvZiB2aWV3LCBJIGhhdmUgZGV2ZWxvcGVkIGEg dHJpY2sgd2hpY2ggYWxsb3dzIG1lIHRvCmNvbnZpbmNlIHlvdSB0aGF0IGl0IGhhcyBiZWVuIGEg YnVnIGFsbCBhbG9uZyA6LSkuCgoKPiBUaGUgYmVoYXZpb3Igd2UgaGF2ZSBiZWVuIHByb3ZpZGlu ZywgbW9kdWx1cyB0aGUgYnVnIHlvdSBqdXN0IGZvdW5kCj4gYW5kIGFueSByZWxhdGVkIGJ1Z3Mg b2YgdGhlIHNhbWUgaWxrLCBpcyAid2UgZG9uJ3QgYWxsb3cKPiBzZXJpYWxpemF0aW9uIGFub21h bGllcyBpbnRvIHRoZSBkYXRhYmFzZSBvciBpbiByZXN1bHRzIGZyb20KPiBzZXJpYWxpemFibGUg dHJhbnNhY3Rpb25zIHdoaWNoIGNvbW1pdC4iICBUaGF0IGlzIGVub3VnaCB0byBiZSB2ZXJ5Cj4g dXNlZnVsIHRvIG1hbnkuCgpBcyBJIGV4cGxhaW4sIEkgdGhpbmsgdGhhdCBpZiB5b3UgbWFrZSB0 aGF0IHByb21pc2UsIHlvdSB3aWxsIGhhdmUgdG8KZG8gYWxsIHRoZSB3b3JrIG5lY2Vzc2FyeSB0 byBtYWtlIHRoZSBzdHJvbmdlciBwcm9taXNlIGFueXdheS4KClNvIHlvdSBtYXkgYXMgd2VsbCBt YWtlIHRoZSBzdHJvbmdlciAoYW5kIG1vcmUgY29tcHJlaGVuc2libGUhKQpwcm9taXNlLgoKCj4g PiBPZiBjb3Vyc2UgSSB1bmRlcnN0YW5kIHRoYXQgdGhlc2UgcHJvYmxlbXMgbWF5IGJlIGhhcmQg dG8gc29sdmUuICBCdXQsCj4gPiBJIHRoaW5rIGl0IG5lZWRzIHRvIGJlIHJlY29nbmlzZWQgdGhh dCB0aGVzZSBwcm9ibGVtcyBhcmUgYWxsIGJ1Z3MuCj4gCj4gWWVzLCB3aGVuIHRoZXkgYXJlIHNo b3duIHRvIGFsbG93IHNlcmlhbGl6YXRpb24gYW5vbWFsaWVzLCB0aGV5Cj4gY2VydGFpbmx5IGFy ZSBidWdzLiAgVGhhdCBoYXMgbm93IGhhcHBlbmVkLgoKSSB0aGluayBhbGwgc2NlbmFyaW9zIG9m IHRoaXMga2luZCBjYW4gYmUgc2hvd24gdG8gYWxsb3cgc2VyaWFsaXNhdGlvbgphbm9tYWxpZXMu CgoKPiA+ICJJZiB5b3UgZG8gbm90IHVzZSBmZWF0dXJlcyBYIG9yIFksIHRoZXNlIGJ1Z3Mgd2ls bCBub3QgYWZmZWN0IHlvdSIgaXMKPiA+IGEgdXNlZnVsIHRoaW5nIHRvIHBlcmhhcHMgc2F5LCBl dmVuIGlmIFggb3IgWSBpcyBhcyBnZW5lcmFsIGFzICJJTlNFUlQKPiA+IC4uLiBPTiBDT05GTElD VCIgb3IgIi4uLiBFWENFUFRJT04gV0hFTiAuLi4iLgo+IAo+IFdlbGwsIGlmIHRoZXkgYXJlIG5v dCBmaXhlZCBzb29uLCBpdCBtaWdodCBiZSB3b3J0aCBhZGRpbmcKPiBzb21ldGhpbmcgdG8gdGhl IGRvY3M7IGJ1dCBhcyBmYXIgYXMgSSBjYW4gc2VlLCB0aGUgc3BlY2lmaWNzIHdvdWxkCj4gYmUg bW9yZSBsaWtlICJJZiB5b3UgY2F0Y2ggZXJyb3JzIGdlbmVyYXRlZCBieSBkZWNsYXJhdGl2ZQo+ IGNvbnN0cmFpbnRzIG9yIHVuaXF1ZSBpbmRleCBpbnNlcnRpb24gd2l0aGluIGEgc3VidHJhbnNh Y3Rpb24sIGFuZAo+IHRoZW4gZGlzY2FyZCB0aGUgd29yayBvZiB0aGUgc3VidHJhbnNhY3Rpb24g d2l0aG91dCB0aHJvd2luZyBhbnkKPiBlcnJvciwgeW91IG1pZ2h0IGNyZWF0ZSBhIHNlcmlhbGl6 YXRpb24gYW5vbWFseSwgZGVwZW5kaW5nIG9uIHdoYXQKPiBlbHNlIHlvdSBkbyB3aXRoaW4gdGhl IHRyYW5zYWN0aW9uLiIgIEhhdmUgeW91IHNlZW4gYW55dGhpbmcgdGhhdAo+IHN1Z2dlc3RzIHRo YXQgdGhpcyBpcyBub3QgYSBjb21wbGV0ZSBkZXNjcmlwdGlvbiBvZiB0aGUgc2NvcGUgb2YKPiB0 aGUgaXNzdWU/ICBJIGRvbid0IHNlZSBhbnkgcG9pbnQgaW4gYSBzdGF0ZW1lbnQgdGhhdCB0aGVy ZSBtaWdodAo+IGJlIHVuZGlzY292ZXJlZCBidWdzIGluIHRoZSBzb2Z0d2FyZSwgZWl0aGVyIGlu IGdlbmVyYWwgb3IgcmVsYXRpdmUKPiB0byBhbnkgcGFydGljdWxhciBmZWF0dXJlLgoKSSdtIGFm cmFpZCBJIGhhdmUgbm8gaWRlYS4gIEJ1dCBpZiB0aGF0IGlzIGEgY29tcGxldGUgZGVzY3JpcHRp b24gb2YKdGhlIGJ1ZyAoaWYgaXQgZG9lc24ndCBhZmZlY3QgIklOU0VSVCAuLi4gT04gQ09ORkxJ Q1QiIGZvciBleGFtcGxlKQp0aGVuIHRoYXQgaXMgZ29vZC4KClRoYW5rcywKSWFuLgoKX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KWGVuLWRldmVsIG1haWxp bmcgbGlzdApYZW4tZGV2ZWxAbGlzdHMueGVuLm9yZwpodHRwczovL2xpc3RzLnhlbi5vcmcveGVu LWRldmVsCg==