From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lars Ingebrigtsen Newsgroups: gmane.emacs.devel Subject: Re: sqlite3 Date: Sun, 19 Dec 2021 11:55:10 +0100 Message-ID: <87k0g0yicx.fsf@gnus.org> References: <87tufmjyai.fsf@gnus.org> <87mtl13vz2.fsf@gnus.org> <87ilvp3tzo.fsf@gnus.org> <83wnk5gduf.fsf@gnu.org> <87r1ab1y0r.fsf@gnus.org> <83sfurejs6.fsf@gnu.org> <871r2b1vu8.fsf@gnus.org> <83o85feitv.fsf@gnu.org> <87lf0jzifm.fsf@gnus.org> <83a6gze705.fsf@gnu.org> <87k0g2xsu9.fsf@gnus.org> <83v8zmb6pi.fsf@gnu.org> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="20506"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Cc: emacs-devel@gnu.org To: Eli Zaretskii Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sun Dec 19 11:56:36 2021 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mytrn-00057S-Hu for ged-emacs-devel@m.gmane-mx.org; Sun, 19 Dec 2021 11:56:35 +0100 Original-Received: from localhost ([::1]:49664 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mytrl-0006Yk-UC for ged-emacs-devel@m.gmane-mx.org; Sun, 19 Dec 2021 05:56:33 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:43020) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mytqW-0005l9-Rg for emacs-devel@gnu.org; Sun, 19 Dec 2021 05:55:16 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=57744 helo=quimby.gnus.org) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mytqV-0002Pc-BS; Sun, 19 Dec 2021 05:55:16 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:In-Reply-To:Date: References:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=SM4fxYKGA68Qy4J0Opt8VAVmE5pyr63UUoL0ArLJrhA=; b=Et7c6eev/Fw95TklqPOzgrIlxB vnoJB21Zy6/A35PL3dfEvFYE0TNt7nqUvp8ncPWP+uxEq69lDDhygVmZNmZnZ9NviGEDq2Z8CEnwV OFP/kQ/+fB2FTXh7lOitnDp53Qe0e/KTGW3IzszEjfhJuwBv1ImubRxKJoZi9fXg/2O4=; Original-Received: from [84.212.220.105] (helo=xo) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mytqQ-0002uI-Pl; Sun, 19 Dec 2021 11:55:13 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAD1BMVEVFOiAwKx1bUz6V inH///+pG/jHAAAAAWJLR0QEj2jZUQAAAAd0SU1FB+UMEwojLIznq7UAAAGGSURBVDjLnZPrcQMx CISR3AAoDSDUwBn67y2L7qXYTn5EMx7r+A4WaTmiz6tQkY/rT0AkwvOJy9wxgju4C59/EzC91iE5 wIsOH4A+SKP+HwC9mKUcq1o169nZARxPwkyEuOoCYoM+cdUKpBmZQCTChIpV1TJs2zUoxSOUhpmb sSNjEa/mIwYS+SpFEwRiYSOsmW+XRinDFcEijyy3LRkDFbxLrVAZNyDRlpta1chiO8+BX7e8CCsM gAyZgImpOU0gjP5OkM6MEf248lJvwAUn6KcZdwbjlvyMS9ULoK3dEryBKWiXeHqrGX94Z37eGpfj A/Va30dpip/kiazQ3eo5R4vZLVz0rRRanVoHOLYEG0Yt+7gd7e7T5/lC7XcGZ//CzfnIXUoVw7nc Wio84hSH82K9cDy/UK21Ua5rh4P25OEcZRVHzRIQHSZjg2Gst4YY3BqeJV+AWm8VQN4BpiOgldkr CE3glN+A0wpiDqiXdHjNGDYwapPVH6Xe13/AryuHZ7/Jn+sbputMyAgJJFsAAAAldEVYdGRhdGU6 Y3JlYXRlADIwMjEtMTItMTlUMTA6MzU6NDMrMDA6MDAH3KJMAAAAJXRFWHRkYXRlOm1vZGlmeQAy MDIxLTEyLTE5VDEwOjM1OjQzKzAwOjAwdoEa8AAAAABJRU5ErkJggg== X-Now-Playing: John and Beverley Martyn's _The Road to Ruin_: "Sorry To Be So Long" In-Reply-To: <83v8zmb6pi.fsf@gnu.org> (Eli Zaretskii's message of "Sat, 18 Dec 2021 11:30:49 +0200") X-Host-Lookup-Failed: Reverse DNS lookup failed for 2a01:4f9:2b:f0f::2 (failed) Received-SPF: pass client-ip=2a01:4f9:2b:f0f::2; envelope-from=larsi@gnus.org; helo=quimby.gnus.org X-Spam_score_int: -35 X-Spam_score: -3.6 X-Spam_bar: --- X-Spam_report: (-3.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-devel" Xref: news.gmane.io gmane.emacs.devel:282405 Archived-At: Eli Zaretskii writes: > With the current master, the test still fails for me about 20% of the > time. Seems like slightly less than before your recent changes, but > I'm not sure. Hm, that's disappointing. It's annoying that I can't reproduce the problem with any sort of reliability -- it only seems to happen, like, 1% of the times. > I think fsync should be necessary because we use temporary files, and > those are by default not fsync'ed when we close the descriptor to > which we wrote. At least on MS-Windows, I think this could mean other > processes might get a stale file contents. Right. Perhaps we should consider doing this without the rename on Windows? (And without fsync on non-Windows.) -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no