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

Fwd: Problem with connection dropping

From: "Jeff Wigal (Referee Assistant)" <jeff(at)referee-assistant(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Fwd: Problem with connection dropping
Date: 2009-04-14 00:55:23
Message-ID: 3a1553070904131755j19fe577bkeefde273609fa753@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Not 100% sure what's going on with the network between here and there.  He's
on a Time Warner or Comcast residential network between his PC in Colorado
and my server down in Georgia.

He's not intentionally leaving a connection open.  When things go as they
should, the entire transaction lasts about 3-4 minutes from connection to
disconnect.  From a programming perspective, I'm pretty careful to
explicitly open and close connections with the program.

Any ideas?


On Fri, Apr 10, 2009 at 11:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Jeff Wigal (Referee Assistant)" <jeff(at)referee-assistant(dot)com> writes:
> > 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
>
> Is he allowing the connection to sit idle?  If so, this might represent
> a router timeout.  What network hardware is between your machine and
> this customer's?
>
>                        regards, tom lane
>

In response to

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2009-04-14 01:06:55
Subject: Re: Fwd: Problem with connection dropping
Previous:From: Adrian KlaverDate: 2009-04-13 14:19:14
Subject: Re: geeting error in installing iodbc

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