Skip site navigation (1) Skip section navigation (2)

Problem with connection dropping

From: "Jeff Wigal (Referee Assistant)" <jeff(at)referee-assistant(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem with connection dropping
Date: 2009-04-11 03:21:46
Message-ID: 3a1553070904102021u2a9ae1b4kbedd70123db5baba@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm seeing some intermittent issues with a client who is trying to connect
to my Postgres server using the ODBC driver.  I have about 15 customers who
are able to connect without issue, but one seems to be having problems.

Here's what I'm seeing in the server's log file

xx.xxx.xxx.xxx(1351) 2009-04-10 21:08:20 EDT LOG:  connection authorized:
user=xxx database=xxx
...
xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG:  could not receive data
from client: Connection timed out
xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG:  unexpected EOF on client
connection
xx.xxx.xxx.xxx(1089) 2009-04-10 21:25:49 EDT LOG:  process 24517 acquired
ShareLock on transaction 2282399 after 609040.428 ms
xx.xxx.xxx.xxx(1351) 2009-04-10 21:25:49 EDT LOG:  disconnection: session
time: 0:17:30.678 user=xxx database=xxx host=xx.xxx.xxx.xxx port=xxxx

My best guess is that they are connecting, something is getting hung up, and
when they try to reconnect, they aren't able to do so.

I'm somewhat stuck as to where to start looking for a solution.  Can anyone
assist?

Thanks in advance--

Jeff Wigal

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2009-04-11 03:27:51
Subject: Re: Problem with connection dropping
Previous:From: Richard BroersmaDate: 2009-04-09 14:14:23
Subject: Re: driver ODBC-PostreSQL, cursor and transaction isolation level

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group