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: (view raw, whole thread or download thread mbox)
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 2009-04-10 21:08:20 EDT LOG:  connection authorized:
user=xxx database=xxx
... 2009-04-10 21:25:49 EDT LOG:  could not receive data
from client: Connection timed out 2009-04-10 21:25:49 EDT LOG:  unexpected EOF on client
connection 2009-04-10 21:25:49 EDT LOG:  process 24517 acquired
ShareLock on transaction 2282399 after 609040.428 ms 2009-04-10 21:25:49 EDT LOG:  disconnection: session
time: 0:17:30.678 user=xxx database=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

Thanks in advance--

Jeff Wigal


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-2017 The PostgreSQL Global Development Group