From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <sourceware-bugzilla@sourceware.org>
Received: by sourceware.org (Postfix, from userid 48)
	id 384053857703; Wed,  5 Apr 2023 19:55:37 +0000 (GMT)
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 384053857703
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sourceware.org;
	s=default; t=1680724537;
	bh=BJQtX/NU2CfGkWgRwEuYg+qNXKRjYy9jtST6fo8wbn8=;
	h=From:To:Subject:Date:From;
	b=f6XgmB2dZrDgMXCS57wDS7YEVDRHoXPpKP7Gck2pCc6ofbQk2Oyq0PFiuSbGHaEiX
	 1FqbiucyjJJH8pghbxt7Pj0LLxYXBECCTdtYOK6k0aFUqgvaIG5rQX0EsIV/6cgqIQ
	 oOB1K1b4fHGlQTL6EkJOUN2yPChVt1hx53EaZdP0=
From: "fche at redhat dot com" <sourceware-bugzilla@sourceware.org>
To: elfutils-devel@sourceware.org
Subject: [Bug debuginfod/30316] New: debuginfod server should checkpoint WAL
 manually
Date: Wed, 05 Apr 2023 19:55:36 +0000
X-Bugzilla-Reason: CC
X-Bugzilla-Type: new
X-Bugzilla-Watch-Reason: None
X-Bugzilla-Product: elfutils
X-Bugzilla-Component: debuginfod
X-Bugzilla-Version: unspecified
X-Bugzilla-Keywords: 
X-Bugzilla-Severity: normal
X-Bugzilla-Who: fche at redhat dot com
X-Bugzilla-Status: NEW
X-Bugzilla-Resolution: 
X-Bugzilla-Priority: P2
X-Bugzilla-Assigned-To: unassigned at sourceware dot org
X-Bugzilla-Target-Milestone: ---
X-Bugzilla-Flags: 
X-Bugzilla-Changed-Fields: bug_id short_desc product version bug_status
 bug_severity priority component assigned_to reporter cc target_milestone
Message-ID: <bug-30316-10460@http.sourceware.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Bugzilla-URL: http://sourceware.org/bugzilla/
Auto-Submitted: auto-generated
MIME-Version: 1.0
List-Id: <elfutils-devel.sourceware.org>

https://sourceware.org/bugzilla/show_bug.cgi?id=3D30316

            Bug ID: 30316
           Summary: debuginfod server should checkpoint WAL manually
           Product: elfutils
           Version: unspecified
            Status: NEW
          Severity: normal
          Priority: P2
         Component: debuginfod
          Assignee: unassigned at sourceware dot org
          Reporter: fche at redhat dot com
                CC: elfutils-devel at sourceware dot org
  Target Milestone: ---

On a very large corpus, initial scan operations can take a long time, and b=
uild
up quite a large debuginfod.sqlite-wal file.  If the server is filesystem s=
pace
constrained, this .sqlite + .sqlite-wal combined file may get too large to =
fit.

Suggestion: debuginfod should inject a periodic

    pragma wal_checkpoint(truncate);

into the traverse loop, as the default autocheckpoint stuff does not appear=
 to
operate reliably.

--=20
You are receiving this mail because:
You are on the CC list for the bug.=