MIME-Version: 1.0
References: 
 <CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com>
 <CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@mail.gmail.com>
 <CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com>
 <CA+mi_8ZBYkPm7Kou8smEnDfXPPjVByw7o3M-nY3PvVEK_TN9nA@mail.gmail.com>
 <CA+mi_8boc=n4jZnX+20-UYwZYd4wse+wrnZWf6zG-1nMhDLmnA@mail.gmail.com>
 <CANxoLDfDw=9oAePwZk0Su9PLB3ni_NQdJ5Lj1k21GzYe07sY8Q@mail.gmail.com>
 <CA+mi_8ZfYM9Mqp18z7cTC5Hh8TEPxS+LrotTmWTnS3=wmcMJnA@mail.gmail.com>
 <CANxoLDemxzjQitt_4K_3-Ear08898ug7bryHz0eYyWas5j_xxw@mail.gmail.com>
 <CANxoLDccOOqJk2Q9--SnOhFpaV+r7Aq2euo5-hu-i7D-aeFFpg@mail.gmail.com>
In-Reply-To: 
 <CANxoLDccOOqJk2Q9--SnOhFpaV+r7Aq2euo5-hu-i7D-aeFFpg@mail.gmail.com>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Tue, 30 Oct 2018 16:07:25 +0000
Message-ID: 
 <CA+mi_8ZWW-NsDmAkT0adTgO8uHnAJRYU2fJ=6yuLTeL5J-cQaA@mail.gmail.com>
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel
To: Akshay Joshi <akshay.joshi@enterprisedb.com>
Cc: psycopg@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Precedence: bulk

On Tue, Oct 30, 2018 at 3:57 PM Akshay Joshi
<akshay.joshi@enterprisedb.com> wrote:
>
> I have one more observation when i run this application one out of 10 times it works. I have logged one more issue as COPY command hangs, so thought it is the problem in psycopg2

The problem with COPY was a different one: we just didn't manage the
state resulting by running COPY through execute, and ended up looping
forever on fake results returned by the libpq. The condition was
detected and handled for COPY BOTH (resulting by replication
statements) but not for the normal COPY TO/FROM. See
<https://github.com/psycopg/psycopg2/issues/781>.

This is a different story but, as described in
<https://github.com/pahaz/sshtunnel/issues/135> it seems that even if
we are doing something not entirely legit with
isBusy/consumeInput/getResult, it only becomes a problem through the
sshtunnel module, not through ssh -L.

-- Daniele