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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-04-14 01:06:55 | Re: Fwd: Problem with connection dropping |
Previous Message | Adrian Klaver | 2009-04-13 14:19:14 | Re: geeting error in installing iodbc |