Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb parallel has a deadlock detected in 9.5.4 - Mailing list pgsql-bugs

From huang
Subject Re: vacuumdb parallel has a deadlock detected in 9.5.4
Date
Msg-id 6827321f.f233.157766ad043.Coremail.foggyglass@163.com
Whole thread Raw
In response to Re: vacuumdb parallel has a deadlock detected in 9.5.4  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-bugs
Tree view 
CgpBdCAyMDE2LTA5LTI5IDE1OjU3OjU4LCAiRnJhbmNpc2NvIE9sYXJ0ZSIgPGZvbGFydGVAcGVv
cGxlY2FsbC5jb20+IHdyb3RlOgo+SGk6Cj4KPk9uIFdlZCwgU2VwIDI4LCAyMDE2IGF0IDEwOjM5
IFBNLCBBbHZhcm8gSGVycmVyYQo+PGFsdmhlcnJlQDJuZHF1YWRyYW50LmNvbT4gd3JvdGU6Cj4+
PiA+IFRoZXJlIGlzIGEgZXJyb3IgZGVhZGxvY2sgZGV0ZWN0ZWQgaW4gdmFjdXVtZGIgcGFyYWxs
ZWwgLgo+Pj4gPiBidXQgaWYgSSBkbyBub3QgdXNlIHBhcmFsbGVsICwgaXQgaGFzIG5vdCBkZWFk
bG9jayBkZXRlY3RlZCAuCj4+PiBtYW4gdmFjdXVtZGIgc2F5cyBhYm91dCAtaiBvcHRpb246Cj4+
Pgo+Pj4gPj4gTm90ZSB0aGF0IHVzaW5nIHRoaXMgbW9kZSB0b2dldGhlciB3aXRoIHRoZSAtZiAo
RlVMTCkgb3B0aW9uIG1pZ2h0IGNhdXNlCj4+PiA+PiBkZWFkbG9jayBmYWlsdXJlcyBpZiBjZXJ0
YWluIHN5c3RlbSBjYXRhbG9ncyBhcmUgcHJvY2Vzc2VkIGluIHBhcmFsbGVsLgo+Pj4gc28sIHdo
aWxlIEkgdW5kZXJzdGFuZCBpdCdzIG5vdCBwcmV0dHksIGl0J3Mgd2VsbCBkb2N1bWVudGVkLgo+
Pgo+PiBZZWFoLiAgSG93ZXZlciBJIHRoaW5rIHRoaXMgYmVoYXZpb3IgaXMgcmF0aGVyIHVuaGVs
cGZ1bC4gIE1heWJlIHdlCj4+IHNob3VsZCB0cnkgdG8gZml4IGl0IHNvbWVob3csIGJ1dCBJJ20g
bm90IHN1cmUgaG93LiAgV2UgY291bGQgc2F5IHRoYXQKPj4gcGdfY2F0YWxvZyB0YWJsZXMgY2Fu
IG9ubHkgYmUgcHJvY2Vzc2VkIG9uZSBhdCBhIHRpbWUsIGluc3RlYWQgb2YgdHJ5aW5nCj4+IHRv
IHBhcmFsZWxpemUgdGhlbT8gIEZvciBleGFtcGxlOiBoYXZlIHZhY3V1bWRiIGZpbGwgdHdvIGxp
c3RzIG9mCj4+IHRhYmxlcywgb25lIGZvciBwZ19jYXRhbG9nIGFuZCBvbmUgZm9yIHRhYmxlcyBp
biBvdGhlciBzY2hlbWFzLiAgRWFjaAo+PiB3b3JrZXIgY2hvb3NlcyBhIHRhYmxlIGZyb20gdGhl
IHBnX2NhdGFsb2cgbGlzdCBmaXJzdCBpZiBpdCdzIG5vdCBlbXB0eQo+PiBhbmQgdGhlcmUncyBu
byBvdGhlciB3b3JrZXIgZG9pbmcgb25lIG9mIHRoZXNlLCBvdGhlcndpc2Ugb25lIGZyb20gdGhl
Cj4+IG90aGVyIHRhYmxlLgo+Pgo+PiBJIHRoaW5rIHRoYXQnZCBmaXggaXQsIHdoaWxlIG5vdCBk
ZXN0cm95aW5nIHBhcmFsZWxpemFiaWxpdHkgdG9vIGJhZGx5Lgo+Cj5JIHdvdWxkIHByb3Bvc2Ug
YW5vdGhlciBiZWhhdmlvdXIsIHdoaWNoIEkgdGhpbmsgY2FuIHNvbHZlIHRoZSBwcm9ibGVtCj53
aXRob3V0IGludHJvZHVjaW5nIG1vcmUgY29tcGxleCBjb2RlLiBQdXQgYSBjb3VwbGUgb2YgZmxh
Z3MgdG8gdmFjdXVtCj5vbmx5IGNhdGFsb2cgdGFibGVzIC8gbm9uIGNhdGFsb2cgdGFibGVzICgg
SSBiZWxpZXZlIHRoaXMgY2FuIGJlCj5zZXJ2ZWQgYnkgaW5jbHVkZS9leGNsdWRlIHNjaGVtYXMg
dG9vLCB3aGljaCB3aWxsIGJlIGV2ZW4gbW9yZSB1c2VmdWwKPmZvciBvdGhlciB0aGluZ3MgKS4g
VGhpcyB3YXkgb25lIGNhbiBkbyBhIGZ1bGwgcGFyYWxlbGwgdmFjdXVtIG9mCj5ub24tY2F0YWxv
ZyBvYmplY3RzIGZvbGxvd2VkIGJ5IGEgc2VyaWFsIG9uZSBvbiBjYXRhbG9nIG9iamVjdHMgKAo+
d2hpY2ggc2hvdWxkIG5vdCBiZSB0b28gc2xvdyBvbiAnbm9ybWFsJyBkYXRhYmFzZXMgKSAoIEkg
cHJvcG9zZSB0aGlzCj5vcmRlciBiZWNhdXNlIElJUkMgbm9ybWFsIHZhY3V1bSB1cGRhdGVzIGNh
dGFsb2cgdGFibGVzIHNvIHRoZXkgZ2V0Cj52YWN1dW1lZCBhZnRlciB0byB0aWR5IHRoZW0gKQo+
Cgo+RnJhbmNpc2NvIE9sYXJ0ZQoKCgoKaGkgLCAKSSBqdXN0ICBob3BlICB0aGUgIHZhY3V1bWRi
ICBwYXJhbGxlbCBjYW4gcXVpY2tseSBmaW5pc2hpbmcgd29yayAgLiAgCm91ciBkYXRhYmFzZSBo
YXMgYSBsb3Qgb2YgdGFibGVzIC4KdGhleSBuZWVkIHZhY3V1bWRiIC4gYnV0IHRoZSB0aW1lIGlz
IHRvbyBsb25nIC4gCnNvICwgSSB1c2VkIHRoZSB2YWN1dW1kYiBwYXJhbGxlbCAuIAogCnRoYW5r
cyB0byBldmVyeW9uZSAuICAgOiApCgoKQmVzdCByZWdhcmRzLApUVAoyOC0wOS0yMDE2CgoKCg==

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BUG #14345: run multi-PG9.6 on One Host, hang when checkpoint
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #14344: string_agg(DISTINCT ..) crash