|
|
Sponsor |
LOG: unexpected EOF on client connection: msg#00087db.postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: @@IDENTITY (Was: Access - ODBC - serial problem), Tom Lane |
|---|---|
| Next by Date: | parameter to db function, Sheeraz fazal |
| Previous by Thread: | Re: @@IDENTITY (Was: Access - ODBC - serial problem), Tom Lane |
| Next by Thread: | Re: @@IDENTITY (Was: Access - ODBC - serial problem), Dave Page |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website.
|