Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bh9zA-0005TK-Ml for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Sep 2016 06:35:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bh9z9-0000Zc-Ai for pgadmin-hackers@arkaria.postgresql.org; Tue, 06 Sep 2016 06:35:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bh9yv-0000LO-Qb for pgadmin-hackers@postgresql.org; Tue, 06 Sep 2016 06:35:42 +0000 Received: from mail-yb0-x229.google.com ([2607:f8b0:4002:c09::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bh9ys-0002Sx-At for pgadmin-hackers@postgresql.org; Tue, 06 Sep 2016 06:35:40 +0000 Received: by mail-yb0-x229.google.com with SMTP id x93so66757110ybh.1 for ; Mon, 05 Sep 2016 23:35:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=+wiHjfJbQhn3l2pbbSiXoSUznKAjPMGRSR5kI9fYDPY=; b=GLZYvu/OPV2aiEphUzxcr3Bp1IGYSlyxVj+kkY+GXoYyu4qt1JyX4oWvqbtUV9MLqZ LNs/RLH5oUHpeAYDp8u2Yw9QhjAXz0O3UzIgvMaokIMQzB4+6Ag7chua5SSz3FID909X 9AMNn30Jarf3iYK/zTfdbFZJAg/YpVjug+Gx6l2huMpL9sRVR0JUrcUUG4hfRG4UD45N hZQ0+XCm69Wg2PCfqbk4aglvPDw6Vt+/SYsP7NeQU99Lk8NFYgkGUfm2TqMuMbHE3YCB OooUIJHfR7yTeItv8emmr21xSRNAZwxbbUG++IQ5tNUpXJ4zgGjB4EWOrluXFqYh+pVn +l1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=+wiHjfJbQhn3l2pbbSiXoSUznKAjPMGRSR5kI9fYDPY=; b=FVbl36HwWOPMR4e//tIZ/RRZv6g20vhPUM6mTulP/JogYyufDACNETCVA7f9q0Upal w4oL7agt4+tDfR7waLwr6FiOQXShlhxSweCHxHx+9GfyZe/p4GrGc2sDtEOkwsLZJWoW QIvvwc6i7mzJhkGjv44ZWlFrVCYeLN20MxA1hIzaYW0ktJtETqVjooB0PdSFOWU2TyzA 5jqSzCmCAUSlyO1kRP9basKvWcnIZ7FVJWEsiiTB5hqwsXeGkX2gDBMM59lfkVwGCY0w 5rnttlFemeeZzdfwQh/bRoFNvYoLNxs2umkQhhfwtdn5EvMtyTrEfFVW3BRuspNl6Kai mUJg== X-Gm-Message-State: AE9vXwMQ3vsOPtpDt/mKPuW4j3q/gB2iAERxATi/v2divR2ZILE06ppzo8o+BHLg1vEm/+pDw2YWeql4xBQVGYYM X-Received: by 10.36.64.138 with SMTP id n132mr28387442ita.10.1473143736871; Mon, 05 Sep 2016 23:35:36 -0700 (PDT) MIME-Version: 1.0 Received: by 10.36.19.206 with HTTP; Mon, 5 Sep 2016 23:35:36 -0700 (PDT) In-Reply-To: References: From: Akshay Joshi Date: Tue, 6 Sep 2016 12:05:36 +0530 Message-ID: Subject: Re: RM#1387 [Add-on PATCH] Bad handling of missing connection database server To: Dave Page Cc: Ashesh Vashi , pgadmin-hackers Content-Type: multipart/alternative; boundary=001a1134f58a23c501053bd10107 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --001a1134f58a23c501053bd10107 Content-Type: text/plain; charset=UTF-8 On Fri, Sep 2, 2016 at 7:49 PM, Dave Page wrote: > Akshay, can you review/commit this please? > Sure. > > Thanks. > > On Tue, Aug 30, 2016 at 5:05 PM, Ashesh Vashi < > ashesh.vashi@enterprisedb.com> wrote: > >> On Tue, Aug 30, 2016 at 7:16 PM, Ashesh Vashi < >> ashesh.vashi@enterprisedb.com> wrote: >> >>> Hi Dave, >>> >>> Please find the add-on patch on top of the current change. >>> >>> Can you please take a look at it? >>> This mainly works on the postgres driver to make an attempt to reconnect >>> the server. >>> >> >> One more attempt with some more corner cases handling. >> * Handled the connection-lost, and object gone error on client side >> during 'refresh' operation. >> * Handle the reconnection more consistently (even during cursor object >> creation). >> >> Please take a look at it. >> >> -- >> >> Thanks & Regards, >> >> Ashesh Vashi >> EnterpriseDB INDIA: Enterprise PostgreSQL Company >> >> >> >> *http://www.linkedin.com/in/asheshvashi* >> >> >>> >>> -- >>> >>> Thanks & Regards, >>> >>> Ashesh Vashi >>> EnterpriseDB INDIA: Enterprise PostgreSQL Company >>> >>> >>> >>> *http://www.linkedin.com/in/asheshvashi* >>> >>> >> >> > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- *Akshay Joshi* *Principal Software Engineer * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246* --001a1134f58a23c501053bd10107 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


On Fri, Sep 2, 2016 at 7:49 PM, Dave Page <dpage@pgadmin.org> wrote:
Akshay, can= you review/commit this please?=C2=A0

=C2=A0 =C2=A0 Sure.=C2=A0

Thanks.

On Tue, Aug 30, 2016 at 5= :05 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com&g= t; wrote:
<= div>On Tue, Aug 30, 2016 at 7:16 PM, Ashesh Vashi <ashesh.vash= i@enterprisedb.com> wrote:
Hi Dave,

Please f= ind the add-on patch on top of the current change.

Can you please take a look at it?
This mainly works on the postg= res driver to make an attempt to reconnect the server.

One more attempt with some more corner cases hand= ling.
* Handled the connection-lost, and object gone error on client si= de during 'refresh' operation.
* Handle the reconnection = more consistently (even during cursor object creation).

Please take a look at it.

<= span style=3D"font-style:italic">--

Thanks & Regards,

A= shesh Vashi
EnterpriseDB INDIA:=C2=A0Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi=


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi





--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

E= nterpriseDB UK: h= ttp://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
Akshay Joshi


<= b>Phone: +91 20-3058-9517
Mobile: +91 976-788= -8246
--001a1134f58a23c501053bd10107--