MIME-Version: 1.0
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Wed, 22 May 2019 10:41:53 +0530
Message-ID: 
 <CAM9w-_kxFJjKOXeTLnYqvoYA8ZbFt2NxEUDVqj29GAu730pRoA@mail.gmail.com>
Subject: [pgAdmin][RM4263] "Not connected to the server or the connection to
 the server has been closed." returned with some queries
To: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000001327700589730351"
Precedence: bulk

--0000000000001327700589730351
Content-Type: multipart/alternative; boundary="00000000000013276d058973034f"

--00000000000013276d058973034f
Content-Type: text/plain; charset="UTF-8"

Hi Hackers,

Attached is the quick fix for the issue. The problem was with parsing
failure of JSON result in explain plan code. I have added an api test case
to check length of result format to match with JS code expectations for
explain plan.

Kindly review.
-- 
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

--00000000000013276d058973034f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Hi Hackers,</div><div class=3D"gmail_default" style=3D"font-fam=
ily:verdana,sans-serif"><br>Attached is the quick fix for the issue. The pr=
oblem was with parsing failure of JSON result in explain plan code. I have =
added an api test case to check length of result format to match with JS co=
de expectations for explain plan.</div><div class=3D"gmail_default" style=
=3D"font-family:verdana,sans-serif"><br></div><div class=3D"gmail_default" =
style=3D"font-family:verdana,sans-serif">Kindly review.</div>-- <br><div di=
r=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div=
 dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><font size=3D"2" c=
olor=3D"#000000" face=3D"verdana, sans-serif">Thanks and Regards,</font><di=
v><span style=3D"background-color:rgb(255,255,255)"><font size=3D"2" color=
=3D"#000000" face=3D"verdana, sans-serif">Aditya Toshniwal</font></span></d=
iv><div><font face=3D"verdana, sans-serif"><span style=3D"background-color:=
rgb(255,255,255)"><font size=3D"2" color=3D"#000000">Software Engineer |=C2=
=A0EnterpriseDB India |=C2=A0</font></span><span style=3D"color:rgb(0,0,0)"=
>Pune</span></font></div><div><font color=3D"#38761d" face=3D"verdana, sans=
-serif" size=3D"1">&quot;Don&#39;t Complain about Heat, Plant a TREE&quot;<=
/font></div></div></div></div></div></div></div></div>

--00000000000013276d058973034f--

--0000000000001327700589730351
Content-Type: application/octet-stream; name="RM4263.patch"
Content-Disposition: attachment; filename="RM4263.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_jvyrsp5o0>
X-Attachment-Id: f_jvyrsp5o0

ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NxbGVkaXRvci9zdGF0aWMvanMvc3FsZWRp
dG9yLmpzIGIvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9yL3N0YXRpYy9qcy9zcWxlZGl0b3Iu
anMKaW5kZXggZmNjMzFjZjMuLjQxNDU4NDQ1IDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi90b29s
cy9zcWxlZGl0b3Ivc3RhdGljL2pzL3NxbGVkaXRvci5qcworKysgYi93ZWIvcGdhZG1pbi90b29s
cy9zcWxlZGl0b3Ivc3RhdGljL2pzL3NxbGVkaXRvci5qcwpAQCAtMjQyNCw3ICsyNDI0LDcgQEAg
ZGVmaW5lKCd0b29scy5xdWVyeXRvb2wnLCBbCiAKICAgICAgICAgICAgIGlmKGRhdGEudHlwZXNb
MF0gJiYgZGF0YS50eXBlc1swXS50eXBuYW1lID09PSAnanNvbicpIHsKICAgICAgICAgICAgICAg
LyoganNvbiBpcyBzZW50IGFzIHRleHQsIHBhcnNlIGl0ICovCi0gICAgICAgICAgICAgIGV4cGxh
aW5fZGF0YV9qc29uID0gSlNPTi5wYXJzZShkYXRhLnJlc3VsdFswXSk7CisgICAgICAgICAgICAg
IGV4cGxhaW5fZGF0YV9qc29uID0gSlNPTi5wYXJzZShkYXRhLnJlc3VsdFswXVswXSk7CiAgICAg
ICAgICAgICB9CiAKICAgICAgICAgICAgIGlmIChleHBsYWluX2RhdGFfanNvbiAmJiBleHBsYWlu
X2RhdGFfanNvblswXSAmJgpkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9y
L3Rlc3RzL3Rlc3RfZXhwbGFpbl9wbGFuLnB5IGIvd2ViL3BnYWRtaW4vdG9vbHMvc3FsZWRpdG9y
L3Rlc3RzL3Rlc3RfZXhwbGFpbl9wbGFuLnB5Cm5ldyBmaWxlIG1vZGUgMTAwNjQ0CmluZGV4IDAw
MDAwMDAwLi45ZjlkMTM4NAotLS0gL2Rldi9udWxsCisrKyBiL3dlYi9wZ2FkbWluL3Rvb2xzL3Nx
bGVkaXRvci90ZXN0cy90ZXN0X2V4cGxhaW5fcGxhbi5weQpAQCAtMCwwICsxLDcyIEBACisjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIworIworIyBwZ0FkbWluIDQgLSBQb3N0Z3JlU1FMIFRvb2xzCisjCisjIENv
cHlyaWdodCAoQykgMjAxMyAtIDIwMTksIFRoZSBwZ0FkbWluIERldmVsb3BtZW50IFRlYW0KKyMg
VGhpcyBzb2Z0d2FyZSBpcyByZWxlYXNlZCB1bmRlciB0aGUgUG9zdGdyZVNRTCBMaWNlbmNlCisj
CisjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
IyMjIyMjIyMjIyMjIyMjIyMjIworCitpbXBvcnQganNvbgorCitmcm9tIHBnYWRtaW4uYnJvd3Nl
ci5zZXJ2ZXJfZ3JvdXBzLnNlcnZlcnMuZGF0YWJhc2VzLnRlc3RzIGltcG9ydCB1dGlscyBhcyBc
CisgICAgZGF0YWJhc2VfdXRpbHMKK2Zyb20gcGdhZG1pbi51dGlscy5yb3V0ZSBpbXBvcnQgQmFz
ZVRlc3RHZW5lcmF0b3IKK2Zyb20gcmVncmVzc2lvbiBpbXBvcnQgcGFyZW50X25vZGVfZGljdAor
ZnJvbSByZWdyZXNzaW9uLnB5dGhvbl90ZXN0X3V0aWxzIGltcG9ydCB0ZXN0X3V0aWxzIGFzIHV0
aWxzCisKKworY2xhc3MgVGVzdEV4cGxhaW5QbGFuKEJhc2VUZXN0R2VuZXJhdG9yKToKKyAgICAi
IiIgVGhpcyBjbGFzcyB3aWxsIHRlc3QgdGhlIGV4cGxhaW4gcGxhbiByZXR1cm4gZm9ybWF0LiAi
IiIKKworICAgIGRlZiBydW5UZXN0KHNlbGYpOgorICAgICAgICBkYXRhYmFzZV9pbmZvID0gcGFy
ZW50X25vZGVfZGljdFsiZGF0YWJhc2UiXVstMV0KKyAgICAgICAgc2VsZi5zZXJ2ZXJfaWQgPSBk
YXRhYmFzZV9pbmZvWyJzZXJ2ZXJfaWQiXQorCisgICAgICAgIHNlbGYuZGJfaWQgPSBkYXRhYmFz
ZV9pbmZvWyJkYl9pZCJdCisgICAgICAgIGRiX2NvbiA9IGRhdGFiYXNlX3V0aWxzLmNvbm5lY3Rf
ZGF0YWJhc2Uoc2VsZiwKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICB1dGlscy5TRVJWRVJfR1JPVVAsCisgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgc2VsZi5zZXJ2ZXJfaWQsCisgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgc2VsZi5kYl9pZCkKKyAgICAgICAgaWYgbm90
IGRiX2NvblsiaW5mbyJdID09ICJEYXRhYmFzZSBjb25uZWN0ZWQuIjoKKyAgICAgICAgICAgIHJh
aXNlIEV4Y2VwdGlvbigiQ291bGQgbm90IGNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlLiIpCisKKyAg
ICAgICAgIyBJbml0aWFsaXplIHF1ZXJ5IHRvb2wKKyAgICAgICAgdXJsID0gJy9kYXRhZ3JpZC9p
bml0aWFsaXplL3F1ZXJ5X3Rvb2wvezB9L3sxfS97Mn0nLmZvcm1hdCgKKyAgICAgICAgICAgIHV0
aWxzLlNFUlZFUl9HUk9VUCwgc2VsZi5zZXJ2ZXJfaWQsIHNlbGYuZGJfaWQpCisgICAgICAgIHJl
c3BvbnNlID0gc2VsZi50ZXN0ZXIucG9zdCh1cmwpCisgICAgICAgIHNlbGYuYXNzZXJ0RXF1YWxz
KHJlc3BvbnNlLnN0YXR1c19jb2RlLCAyMDApCisKKyAgICAgICAgcmVzcG9uc2VfZGF0YSA9IGpz
b24ubG9hZHMocmVzcG9uc2UuZGF0YS5kZWNvZGUoJ3V0Zi04JykpCisgICAgICAgIHNlbGYudHJh
bnNfaWQgPSByZXNwb25zZV9kYXRhWydkYXRhJ11bJ2dyaWRUcmFuc0lkJ10KKworICAgICAgICAj
IFN0YXJ0IHF1ZXJ5IHRvb2wgdHJhbnNhY3Rpb24KKyAgICAgICAgdXJsID0gJy9zcWxlZGl0b3Iv
cXVlcnlfdG9vbC9zdGFydC97MH0nLmZvcm1hdChzZWxmLnRyYW5zX2lkKQorICAgICAgICByZXNw
b25zZSA9IHNlbGYudGVzdGVyLnBvc3QoCisgICAgICAgICAgICB1cmwsIGRhdGE9anNvbi5kdW1w
cyh7CisgICAgICAgICAgICAgICAgInNxbCI6ICJTRUxFQ1QgMSIsCisgICAgICAgICAgICAgICAg
ImV4cGxhaW5fcGxhbiI6IHsKKyAgICAgICAgICAgICAgICAgICAgImZvcm1hdCI6ICJqc29uIiwK
KyAgICAgICAgICAgICAgICAgICAgImFuYWx5emUiOiBGYWxzZSwKKyAgICAgICAgICAgICAgICAg
ICAgInZlcmJvc2UiOiBGYWxzZSwKKyAgICAgICAgICAgICAgICAgICAgImNvc3RzIjogRmFsc2Us
CisgICAgICAgICAgICAgICAgICAgICJidWZmZXJzIjogRmFsc2UsCisgICAgICAgICAgICAgICAg
ICAgICJ0aW1pbmciOiBGYWxzZSwKKyAgICAgICAgICAgICAgICAgICAgInZlcmJvc2UiOiBGYWxz
ZQorICAgICAgICAgICAgICAgIH0KKyAgICAgICAgICAgIH0pLCBjb250ZW50X3R5cGU9J2h0bWwv
anNvbicpCisKKyAgICAgICAgc2VsZi5hc3NlcnRFcXVhbHMocmVzcG9uc2Uuc3RhdHVzX2NvZGUs
IDIwMCkKKworICAgICAgICAjIFF1ZXJ5IHRvb2wgcG9sbGluZworICAgICAgICB1cmwgPSAnL3Nx
bGVkaXRvci9wb2xsL3swfScuZm9ybWF0KHNlbGYudHJhbnNfaWQpCisgICAgICAgIHJlc3BvbnNl
ID0gc2VsZi50ZXN0ZXIuZ2V0KHVybCkKKyAgICAgICAgc2VsZi5hc3NlcnRFcXVhbHMocmVzcG9u
c2Uuc3RhdHVzX2NvZGUsIDIwMCkKKyAgICAgICAgcmVzcG9uc2VfZGF0YSA9IGpzb24ubG9hZHMo
cmVzcG9uc2UuZGF0YS5kZWNvZGUoJ3V0Zi04JykpCisKKyAgICAgICAgIyBDaGVjayB0aGUgb3Vw
dXQgb2YgZXhwbGFpbiBwbGFuCisgICAgICAgIHNlbGYuYXNzZXJ0RXF1YWxzKGxlbihyZXNwb25z
ZV9kYXRhWydkYXRhJ11bJ3Jlc3VsdCddKSwgMSkKKyAgICAgICAgc2VsZi5hc3NlcnRFcXVhbHMo
bGVuKHJlc3BvbnNlX2RhdGFbJ2RhdGEnXVsncmVzdWx0J11bMF0pLCAxKQorCisgICAgICAgICMg
RGlzY29ubmVjdCB0aGUgZGF0YWJhc2UKKyAgICAgICAgZGF0YWJhc2VfdXRpbHMuZGlzY29ubmVj
dF9kYXRhYmFzZShzZWxmLCBzZWxmLnNlcnZlcl9pZCwgc2VsZi5kYl9pZCkK
--0000000000001327700589730351--