Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bfpJG-0008Jz-Tv for pgadmin-hackers@arkaria.postgresql.org; Fri, 02 Sep 2016 14:19:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bfpJG-0004DL-Fd for pgadmin-hackers@arkaria.postgresql.org; Fri, 02 Sep 2016 14:19:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bfpJF-0004C0-PN for pgadmin-hackers@postgresql.org; Fri, 02 Sep 2016 14:19:09 +0000 Received: from mail-it0-x233.google.com ([2607:f8b0:4001:c0b::233]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bfpJB-0001sg-Ug for pgadmin-hackers@postgresql.org; Fri, 02 Sep 2016 14:19:09 +0000 Received: by mail-it0-x233.google.com with SMTP id e124so39030898ith.0 for ; Fri, 02 Sep 2016 07:19:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=agFSqTe+VGCSXMx4GIRofRXxEzbOUaT+/Q/57sx7qpQ=; b=aFLKop/QouTIhQKOHWuF5Yr91fchBFcf4NgE/f44IzmMgEDGig6qp8FOiqrbhx2ZZq Kdts0yTYuE5yCG8IdkGsz8KJamRAY5BHSCAc2XEHt72+EQiW97sOGF2SQy9HS1wCw8Hj Ab+PTWrLmRKaIWG2nkGPfStP596rdxFfrWpGX5mqTf0Vp8D+uEvMBioS5kNZ8HNW4eHa xDaQdjEU+lhfAxu4D72CpYV2U9x4j2k3B59yalneRkaNufzf+mzSINXOOTrc+tWXz64W V7MSpsOvPVEV155Bgj/aY/ehXYUfDtnSnp7nltqYE8r29rY0aqI9W+O8FBZX0JFk+pQV wGQQ== 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=agFSqTe+VGCSXMx4GIRofRXxEzbOUaT+/Q/57sx7qpQ=; b=DANEnzqabq3OjQfJEYwLA/Y1ocGr1g+MEvxcxyyJNmG3o3MvF8FDVCghDFDG7I7awJ iIPYXbIr4CmKWSd+iKmTda8gRHABz0hXpfEN1OnYsFYpVBy0kowQh+L9fnNZqo/+3zLJ 6Kwg7aGDAvZTXDyaV4AEtQ0WSlXTGU1loNhfNbm2PnxYSD/Ow9pcdkWgQRB0QG4Ws+gP iVcTFvQaU3gu8f6U38TNBXhFb6J0GE1VO1hsKGXgpjKt3u0TduR4w9s09/6tw2amsBUK nqrMZB2zYnNwSKhnb1YSqicYHpEYu7rb3XyOzIRCXX3aBvmPrO40BvJ7rxC7yCeI/795 AXYQ== X-Gm-Message-State: AE9vXwNWHI0Yx3lzmjtB/veBU0VnbaM8B602N1OYowpN7Hc07RbSWIFqGUa0e9ngtqyJr4Y/Boh/pi85df6szA== X-Received: by 10.36.129.193 with SMTP id q184mr5072757itd.35.1472825944001; Fri, 02 Sep 2016 07:19:04 -0700 (PDT) MIME-Version: 1.0 Received: by 10.64.1.203 with HTTP; Fri, 2 Sep 2016 07:19:03 -0700 (PDT) In-Reply-To: References: From: Dave Page Date: Fri, 2 Sep 2016 15:19:03 +0100 Message-ID: Subject: Re: RM#1387 [Add-on PATCH] Bad handling of missing connection database server To: Ashesh Vashi Cc: pgadmin-hackers , Akshay Joshi Content-Type: multipart/alternative; boundary=94eb2c08bc7e356d44053b870320 X-Pg-Spam-Score: -2.6 (--) 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 --94eb2c08bc7e356d44053b870320 Content-Type: text/plain; charset=UTF-8 Akshay, can you review/commit this please? Thanks. On Tue, Aug 30, 2016 at 5:05 PM, Ashesh Vashi 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 --94eb2c08bc7e356d44053b870320 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Akshay, can you review/commit this please?=C2=A0

<= /div>
Thanks.

On Tue, Aug 30, 2016 at 5:05 PM, Ashesh Vashi <ash= esh.vashi@enterprisedb.com> wrote:
On Tue, Aug 30, 2016 at 7:16= PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com><= /span> 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 t= he connection-lost, and object gone error on client side during 'refres= h' operation.
* Handle the reconnection more consistently (ev= en during cursor object creation).

Please take a l= ook at it.

--

Thanks & Regards,
Ashesh Vash= i
E= nterpriseDB INDIA:=C2=A0Enterprise PostgreSQL Company


<= /span>

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.bl= ogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com<= br>The Enterprise PostgreSQL Company
--94eb2c08bc7e356d44053b870320--