public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daniele Varrazzo <[email protected]>
To: Akshay Joshi <[email protected]>
Cc: [email protected]
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel
Date: Tue, 30 Oct 2018 12:52:08 +0000
Message-ID: <CA+mi_8ZBYkPm7Kou8smEnDfXPPjVByw7o3M-nY3PvVEK_TN9nA@mail.gmail.com> (raw)
In-Reply-To: <CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com>
References: <CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com>
<CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@mail.gmail.com>
<CANxoLDesBkV9=qpg22-9nG=JYgvUuo3Xm+iDxSWwLVReTiEC7g@mail.gmail.com>
Taking a look. Thank you for the test.
On Tue, Oct 30, 2018 at 12:36 PM Akshay Joshi <[email protected]>
wrote:
> 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*
>
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], [email protected]
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel
In-Reply-To: <CA+mi_8ZBYkPm7Kou8smEnDfXPPjVByw7o3M-nY3PvVEK_TN9nA@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