Re: A successful SELECT 1; on failed connection
| От | Marko Kreen |
|---|---|
| Тема | Re: A successful SELECT 1; on failed connection |
| Дата | |
| Msg-id | CACMqXCJ-ctCkbcaUuzUS2WDSvh9v_B1retk4qdSd=ZLs-FzeGA@mail.gmail.com обсуждение исходный текст |
| Ответ на | A successful SELECT 1; on failed connection (Croepha <croepha@gmail.com>) |
| Список | psycopg |
On Thu, Sep 29, 2011 at 10:34 PM, Croepha <croepha@gmail.com> wrote:
> I am developing a network appliance application that uses psycopg2 to
> connect to a database through an OpenVPN connection. The application has two
> modes that it switches between, an online mode and a disconnected mode. It
> periodically tries to reconnect once it is in a disconnected mode. It tests
> the connection by doing a connection.cursor().execute('SELECT 1;'). The
> application log reports coming online and then going back offline,
> but during this time the OpenVPN log reports being offline...
> There may be a bug in my application, but I thought I would ask and see if
> anyone else has seen anything like this?
You would need both connect_timeout and tcp keepalive
for reconnect to be reliable. But otherwise its probably app problem.
--
marko
В списке psycopg по дате отправления: