Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cX60T-0006rf-3V for pgsql-admin@arkaria.postgresql.org; Fri, 27 Jan 2017 12:51:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cX60S-0006ch-JI for pgsql-admin@arkaria.postgresql.org; Fri, 27 Jan 2017 12:51:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cX60S-0006cS-1X for pgsql-admin@postgresql.org; Fri, 27 Jan 2017 12:51:56 +0000 Received: from mta09.3.doruk.net.tr ([212.58.5.122] helo=mta09.doruk.net.tr) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cX60O-0001kS-5Y for pgsql-admin@postgresql.org; Fri, 27 Jan 2017 12:51:54 +0000 Received: from cmail19.webkontrol.doruk.net.tr ([212.58.6.99]) by mta09.doruk.net.tr with esmtp (Exim 4.86) (envelope-from ) id 1cX5zi-00046w-Qj for pgsql-admin@postgresql.org; Fri, 27 Jan 2017 15:51:10 +0300 Received: from DESKTOPM80CG12 ([82.222.117.36]) by cmail19.webkontrol.doruk.net.tr (IceWarp 11.1.2.0) with ASMTP id 201701271553494655; Fri, 27 Jan 2017 15:53:49 +0300 From: =?utf-8?B?RXJ0YW4gS8O8w6fDvGtvxJ9sdQ==?= To: "'Thomas Kellerer'" , References: <007601d27887$736d80c0$5a488240$@1nar.com.tr> In-Reply-To: Subject: Re: Failed to set up event for socket: error code 10038 Date: Fri, 27 Jan 2017 15:51:46 +0300 Message-ID: <008c01d2789c$1e19bc00$5a4d3400$@1nar.com.tr> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQGFLjc2OFYsSBaGPk+Jh+Is32ym4QH5rZL5odcNTeA= Content-Language: tr X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > > Ertan K=C3=BC=C3=A7=C3=BCko=C4=9Flu schrieb am 27.01.2017 um 11:23: > > I read a FATAL marked line in postgresql log file at exact same second: > > 2017-01-27 12:47:41 +03 FATAL: failed to set up event for socket:=20 > > error code 10038 > >=20 > > Application is self-closing upon receiving such error. I instantly=20 > > re-run it (to continue my code tests) and sometimes it is 3-4 times=20 > > until I can get my application running. > >=20 > > I am using latest version of Devart Universal Database Access=20 > > Components > > (UniDAC) for performing database operations. As far as I know, these=20 > > components make direct connection to PostgreSQL. Nothing in between=20 > > like ODBC or anything. If that is relevant. > >=20 > > When I was investigating my problem, I also read following lines in=20 > > the postgresql log file: > > 2017-01-27 12:22:34 +03 LOG: using stale statistics instead of=20 > > current ones because stats collector is not responding > > 2017-01-27 12:27:35 +03 LOG: using stale statistics instead of=20 > > current ones because stats collector is not responding > > 2017-01-27 12:29:51 +03 LOG: using stale statistics instead of=20 > > current ones because stats collector is not responding > > 2017-01-27 12:30:51 +03 LOG: using stale statistics instead of=20 > > current ones because stats collector is not responding > > 2017-01-27 12:32:35 +03 LOG: using stale statistics instead of=20 > > current ones because stats collector is not responding > >=20 > > My questions are: > > 1- I understand that PostgreSQL is closing the connection. What may=20 > > cause for such a connection error, and how to solve it? > > 2- These "stale statistics" messages in log file, are they anything=20 > > important? Is there a way to stop them being logged because they seem=20 > > to grow log file. > >=20 > Try to disable your Anti-Virus for a test.=20 >=20 > If things then work, configure your Anti-Virus to not scan the Postgres d= ata directory and to not check postgres.exe >=20 > Thomas Disabling Anti-Virus did not work for me. I continue to have connection pro= blems. --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin