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

LOG: unexpected EOF on client connection

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: LOG: unexpected EOF on client connection
Date: 2004-04-12 20:33:24
Message-ID: 20040412203324.24537.qmail@web13804.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm still getting this message at every ODBC connection. I think that there
might be a problem. I am having issues with ODBC connections being terminated
without a disconnect issued. This isn't due to script error or to the script
terminating. PostgreSQL's log reads:

LOG:  could not receive data from client: Connection reset by peer
LOG:  unexpected EOF on client connection

I would love to track down the reason for the disconnects. 

Any assistance in this matter would be greatly appreciated. Thank you!

conn=48183040, PGAPI_DriverConnect(
in)='DRIVER={PostgreSQL};UID=adduser;PWD=xxxxx;DATABASE=xxxxx;SERVER=xxx.xxx.xxx.xxx;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;',
fDriverCompletion=0
Global Options: Version='07.03.0200', fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
conn=48183040, query=' '
conn=48183040, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.4.2 on i686-pc-linux-gnu,
compiled by GCC gcc (GCC) 3.3.2 20031218 (Gentoo Linux 3.3.2-r5,
propolice-3.3-7)' ]
    [ PostgreSQL version number = '7.4' ]
conn=48183040, query='set DateStyle to 'ISO''
conn=48183040, query='set geqo to 'OFF''
conn=48183040, query='set extra_float_digits to 2'
conn=48183040, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=48183040, query='select pg_client_encoding()'
    [ fetched 1 rows ]
    [ Client encoding = 'SQL_ASCII' (code = 0) ]
conn=48183040,
PGAPI_DriverConnect(out)='DRIVER={PostgreSQL};DATABASE=xxxxx;SERVER=xxx.xxx.xxx.xxx;PORT=5432;UID=adduser;PWD=xxxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=1;ShowOidColumn=1;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'
STATEMENT ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='can't
SQLSetDescField for this parameter number'
                 ------------------------------------------------------------
                 hdbc=48183040, stmt=48177616, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(NULL)'
                 stmt_with_params='(NULL)'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info -------------------------------
CONN ERROR: func=PGAPI_SetDescField, desc='', errnum=0, errmsg='(NULL)'
            ------------------------------------------------------------
            henv=48176920, conn=48183040, status=1, num_stmts=16
            sock=48176976, stmts=48177048, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=1324, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=48194040, buffer_out=48198144
            buffer_filled_in=63, buffer_filled_out=0, buffer_read_in=63


__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html

In response to

pgsql-odbc by date

Next:From: Sheeraz fazalDate: 2004-04-12 22:14:21
Subject: parameter to db function
Previous:From: Tom LaneDate: 2004-04-12 17:27:56
Subject: Re: @@IDENTITY (Was: Access - ODBC - serial problem)

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