A successful SELECT 1; on failed connection

From: Croepha <croepha(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: A successful SELECT 1; on failed connection
Date: 2011-09-29 19:34:31
Message-ID: CANm61jf4ccA9QcLsY17s-Oi-jpu_iG56=ZX9Dn0D2Nc_UQ896w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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?

Responses

Browse psycopg by date

  From Date Subject
Next Message Marko Kreen 2011-09-30 05:54:14 Re: Cursor copy_from with server crash
Previous Message Grant McKenzie 2011-09-29 14:36:38 Cursor copy_from with server crash