Troubleshoot "unexpected EOF on client connection"

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.

I would really appreciate some suggestions for a method to find the cause of
these dropped connections.

CG

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Troubleshoot "unexpected EOF on client connection"

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: Troubleshoot "unexpected EOF on client connection"

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 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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: Troubleshoot "unexpected EOF on client connection"

On Thursday 01 April 2004 20:10, Chris Gamache wrote:
> 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?

Well - you could turn up the logging on the PG end, but that's not going to
help you if the client is crashing (unless it's always after a particular
query).

If you can't log at the client, I don't think there's much you can do to
diagnose this. I'd be tempted to move some stuff out of C: and make space for
the logs, just while you're looking at this.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: Troubleshoot "unexpected EOF on client connection"

Chris,

You should be able to trace from ODBC, but, regardless of how the
control panel applet appears, you must close the applet after starting
the log in order for the log to be generated. Then you have to reopen
the applet to stop the log. Pretty crummy, eh? I have done this when a
query I was running from Access was failing.

Hope this helps.

-- Matt

Chris Gamache wrote:

>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 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/
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: Troubleshoot "unexpected EOF on client connection"

--- Richard Huxton wrote:
> On Thursday 01 April 2004 20:10, Chris Gamache wrote:
> If you can't log at the client, I don't think there's much you can do to
> diagnose this. I'd be tempted to move some stuff out of C: and make space for
> the logs, just while you're looking at this.

Whatabout the lack of a time index? I'm pretty quick, but the WebApplication
only fails under load, and I'm not THAT quick... So there would be no other way
to find the failure except for a timeindex, yes? I've seen it fail on many
different queries. I believe that they are all Select queries, though... No
Insert, Update, or Deletes...

If its not a bug, it is probably as simple as an improper setting. Here's my
connection string in case someone sees a glaring error...

Provider=MSDASQL.1;Password=XXX;Persist Security Info=True;User
ID=XXX;Mode=ReadWrite;Extended
Properties="DRIVER={PostgreSQL};DATABASE=XXX;SERVER=XXX.XXX. XXX.XXX;PORT=5432;UID=XXX;PWD=XXX;READONLY=0;PROTOCOL=6.4;FA KEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLE S=0;CONNSETTINGS="

Am I missing a critical setting for 7.03.01.00 ?

CG

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org