Thread: A successful SELECT 1; on failed connection
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?
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