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: Mon, 8 Oct 2018 12:19:14 +0530
Message-ID: <CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@mail.gmail.com> (raw)
In-Reply-To: <CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com>
References: <CANxoLDc4AosChXUhArLh2ufdon1BRwhCNRgGjyeCsYf9vHTmTw@mail.gmail.com>
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*
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: <CANxoLDf3ra5UaqFw_6A824_hAi5XPykySr+DJre2ZbprbxTCVA@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