Re: A successful SELECT 1; on failed connection

On Thu, Sep 29, 2011 at 10:34 PM, Croepha <croepha(at)gmail(dot)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