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: Sat, 18 Dec 2021 08:41:50 +0100 Message-ID: <87k0g2xsu9.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> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="32313"; 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 Sat Dec 18 08:43:13 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 1myUN7-0008Gg-7U for ged-emacs-devel@m.gmane-mx.org; Sat, 18 Dec 2021 08:43:13 +0100 Original-Received: from localhost ([::1]:52396 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1myUN5-00071T-PZ for ged-emacs-devel@m.gmane-mx.org; Sat, 18 Dec 2021 02:43:11 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:60576) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1myULz-0006Ke-Q0 for emacs-devel@gnu.org; Sat, 18 Dec 2021 02:42:03 -0500 Original-Received: from [2a01:4f9:2b:f0f::2] (port=43100 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 1myULy-00028l-7t; Sat, 18 Dec 2021 02:42:03 -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=cZ46QPz/Ivo4lLmwR1DKzyjitBg+48cxbD1I0Rou/TI=; b=gRR6DOCiasutz88FAcuc0shyH0 tgXGwrjAoQGrJMkLGhywOD14iFZJr9boA1XfiV+0PdUfb1nuGGyK2YfThCEIo+qLpZqXgxJZRjiue lZkWQVfJpftta9kfPyN6s577hCaKr8Ywbg4rO4j9w1B9ECvHJETQKthBKeep5bOgdOMI=; 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 1myULp-00073k-Qf; Sat, 18 Dec 2021 08:41:57 +0100 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAABGdBTUEAALGPC/xhBQAAACBj SFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAAGFBMVEV9fmOGhYlNTUx2 dhCCgRWAfhOvx8b///8EnAsbAAAAAWJLR0QHFmGI6wAAAAd0SU1FB+UMEgcXNJTFNCIAAAGsSURB VDjLdZJbkuMgDEUFU9XfwArgUvnvQbCBuLKBxux/KyORdAd73DeOLesg9MBkvDfOeSJ5+pfUICIn f0PfcvNuPM0lbl4Hkf9FJ2CugfPJmUvgUkhnEGRpoPg/sEnhNSDnL4GBDMBegATyFJJbgCN4GyPB 2JDgfZLCBQQbIqyFNYgKjOwJI8BCZRGD3G2SLAEhkXn6nwyEiBiD/Cj++KMToMtSEJPE8Q0wwXwo sO+9NMcE0QqQamf4M0pDnKYjyEHOvFN/vdcKgKo5DBcx+RMxi5G5yHiYPmFj+xLQFELBV/xwmQpY lDtzUYPnq6SixvvG3Iaodx5D/bIK1LDd1N9H51XEKFm8U4t/UJVCtvryt5+wRnwH7vmhCVYJkALv eJTGJ6A9F9Ryk4i2gj9zFBXo7RBEPSNDr8oNC5IGc9aJ4MYV2wr2nFGkhMZ1rYC4yqTKXtB6le0W 0HYBTWZZ8glIx5v0v8lWBzAnqifSdpzB4L4h93KsSme+j54fteQDGC/1VnK/AkNa3d7jojEW0uex vpIvQOu7Alpee4N3Ejl5Hoc+nh9P4/Vz+AcsorMXoWMPvwAAACV0RVh0ZGF0ZTpjcmVhdGUAMjAy MS0xMi0xOFQwNzoyMzo1MiswMDowMO+FcF4AAAAldEVYdGRhdGU6bW9kaWZ5ADIwMjEtMTItMThU MDc6MjM6NTIrMDA6MDCe2MjiAAAAAElFTkSuQmCC X-Now-Playing: Joni Mitchell's _The Hissing Of Summer Lawns_: "Shades Of Scarlett Conquering" In-Reply-To: <83a6gze705.fsf@gnu.org> (Eli Zaretskii's message of "Fri, 17 Dec 2021 14:43:54 +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:282260 Archived-At: Eli Zaretskii writes: > Which sounds like a problem different from what you saw? It may stem from the (incomplete) fix I added for the original problem, though. > Adding (sleep-for 3) after call-process doesn't entirely fix the > problem, although it becomes more rare. > > I've installed a change in multisession.el that makes the problem much > more rare by forcing 'fsync' when we close the value file. The > problem is not yet gone entirely, though: it happens with about 25% > probability here. I think it could be related to the fact that > 'rename-file' is not an atomic operation on MS-Windows. But that's a > wild guess, I have no basis for it. Right. I'll do some further testing, but the real fix is to add some backoff logic when the file is locked, which I'll do now. (And in that case, I think the `fsync' should be unnecessary.) -- (domestic pets only, the antidote for overdose, milk.) bloggy blog: http://lars.ingebrigtsen.no