Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j2RTx-00081F-0z for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Feb 2020 03:17:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j2RTv-0004Ci-9u for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Feb 2020 03:17:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j2RTv-0004Cb-1Y for pgsql-bugs@lists.postgresql.org; Fri, 14 Feb 2020 03:17:31 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j2RTr-0004MW-Il for pgsql-bugs@lists.postgresql.org; Fri, 14 Feb 2020 03:17:30 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 85771BFEC9; Fri, 14 Feb 2020 03:17:24 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at emo04-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo04-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id OLUmAR-9d1Ng; Fri, 14 Feb 2020 03:17:24 +0000 (UTC) Received: from GW2017.grahamwideman.com (ip68-7-23-65.sd.sd.cox.net [68.7.23.65]) by mailout.easymail.ca (Postfix) with ESMTPA id 44609BFEA5; Fri, 14 Feb 2020 03:17:20 +0000 (UTC) X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Thu, 13 Feb 2020 19:16:40 -0800 To: Johan_Fredrik ,Michael Paquier From: Graham Wideman Subject: Re: BUG #16182: Error in logs from "renaming temporary statistics" Cc: pgsql-bugs@lists.postgresql.org In-Reply-To: References: <16182-06f613c9fd10f3bf@postgresql.org> <20200102140703.GA4841@paquier.xyz> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Message-Id: <20200214031724.85771BFEC9@mailout.easymail.ca> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I just wanted to add that this bug 16182 is the subject of a discussion here: https://www.postgresql.org/message-id/flat/CAPpHfds9trA6ipezK3BsuuOSQwEmESiqj8pkOxACFJpoLpcoNw@mail.gmail.com#9b04576b717175e9dbf03cc991977d3f ... which started in Nov 2017, and appears to be ongoing (latest message Jan 2020). Alexander Korotkov 2017-11-28 reports that the problem occurs in the absence of antivirus etc. Graham At 1/3/2020 12:06 PM, =?UTF-8?Q?Johan_Fredrik_=C3=98hman?= wrote: >--0000000000003cddfd059b41d8e9 >Content-Type: text/plain; charset="UTF-8" >Content-Transfer-Encoding: quoted-printable > >Thanks for this informative feedback. I was thinking that antivirus was an >explanation, but I am pretty sure the the PG data directory was on the >antivirus exclusion list. However, in light of this I will try to monitor >the processes that access this file and come back to you on the findings. >-- >JF > >On Thu, Jan 2, 2020 at 3:07 PM Michael Paquier wrote: > >> On Thu, Jan 02, 2020 at 06:55:37AM +0000, PG Bug reporting form wrote: >> > I have checked the permissions of the folder and files, and I can not s= >ee >> > why this occurs. >> >> This error would occur on Windows when a concurrent process, external >> to Postgres, has a file opened in non-shared mode while Postgres tries >> to work on it. In this case the work is done by pgrename() on >> Postgres side which is a custom wrapper in src/port/dirmod.c to handle >> this kind of scenarios with a retry-and-sleep logic, but it gives up >> after 10s (100 tries of 100ms each). >> >> This issue could be usually caused by an antivirus or something that >> scans the files of the disk where Postgres data is located. In this >> case, the best thing you could do is to prevent the concurrent >> activity from happening by filtering out Postgres data folder. Nobody >> can guess why this file is held opened that long though without >> looking at your server when the problem happens. >> -- >> Michael >> > > >--=20 >Johan Fredrik =C3=98hman