From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Troubleshoot "unexpected EOF on client connection" |
Date: | 2004-04-01 19:10:30 |
Message-ID: | 20040401191030.87488.qmail@web13809.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
PgODBC's logfiles don't have a time index, and you also can't change the output
location of the files unless you recompile the driver (unless you know
something that I don't). My C drive is strictly OS, and there's not much
breathing room there. I can't get PgODBC to build under VisualStudio.NET, so a
recompile to include timestamp and variable logfile location is out of my
ability. I don't know why, but I can not get a trace from the ODBC control
panel either. Can you help?
CG
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> On Wednesday 31 March 2004 15:24, Chris Gamache wrote:
> > Some of my ODBC connections are dying unexpectedly (and randomly) with the
> > Postgresql Log Message "unexpected EOF on client connection" ... It happens
> > about one in every 50K-100K queries.
>
> This is commonly the client crashing / timing out.
>
> > I would really appreciate some suggestions for a method to find the cause
> > of these dropped connections.
>
> You could turn logging on at the client end - there are settings in the odbc
> driver settings. Could be a big log-file though, if you have to wait 100,000
> queries.
>
> --
> Richard Huxton
> Archonet Ltd
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-04-01 20:18:17 | Re: Troubleshoot "unexpected EOF on client connection" |
Previous Message | PaulS | 2004-04-01 18:32:37 | stored procedures with parameters w/dotnet |