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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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