public inbox for [email protected]
help / color / mirror / Atom feedFrom: Akshay Joshi <[email protected]>
To: [email protected]
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel
Date: Tue, 30 Oct 2018 18:06:24 +0530
Message-ID: <CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com> (raw)
In-Reply-To: <CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@mail.gmail.com>
References: <CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com>
<CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@mail.gmail.com>
Hi Team
I have created one sample application to replicate the issue. Attached is
the sample application, please read "README.txt" file to proceed further.
Can someone please suggest why poll() function hangs when run wrong query
with sshtunnel v0.1.4.
On Mon, Oct 8, 2018 at 12:19 PM Akshay Joshi <[email protected]>
wrote:
> Hi Team
>
> As one issue(*https://github.com/psycopg/psycopg2/issues/781
> <https://github.com/psycopg/psycopg2/issues/781>*) has already been
> created for conn.poll() function hangs when executes COPY command in async
> mode. Similarly conn.poll() functions hangs when we run wrong query in
> async mode using sshtunnel <https://pypi.org/project/sshtunnel/; v0.1.3.
>
> Can someone please suggest what went wrong when used sshtunnel, or the
> pointers/reason where poll() method hangs.
>
> On Fri, Sep 28, 2018 at 5:43 PM Akshay Joshi <
> [email protected]> wrote:
>
>> Hello
>>
>> I am using psycopg2 2.7.4 to connect to the PostgreSQL database server
>> using asynchronoussupport. It is working absolutely fine. I have used
>> sshtunnel <https://pypi.org/project/sshtunnel/; v0.1.3 in pgAdmin4. When
>> I connect the PostgreSQL database server using ssh tunnel and run the
>> valid/correct query it works fine, but when I run any wrong query(invalid
>> column of table) my application gets hang on conn.poll() function.
>>
>> Please refer the code how we use conn.poll() with timeouts
>> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=blob;f=web/pgadmin/utils/driver/psycopg2/connect...
>>
>> Can anyone please provide some pointers, suggestions?
>>
>> --
>> *Akshay Joshi*
>>
>> *Sr. Software Architect *
>>
>>
>>
>> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>>
>
>
> --
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>
--
*Akshay Joshi*
*Sr. Software Architect *
*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
Attachments:
[application/zip] Hang_Sample_Application.zip (158.1K, ../CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com/3-Hang_Sample_Application.zip)
download
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel
In-Reply-To: <CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox