[Bug debuginfod/30316] New: debuginfod server should checkpoint WAL manually

[Bug debuginfod/30316] New: debuginfod server should checkpoint WAL manually

[fche at redhat dot com]

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

            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 build
up quite a large debuginfod.sqlite-wal file.  If the server is filesystem space
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.

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

[Bug debuginfod/30316] debuginfod server should checkpoint WAL manually

[fche at redhat dot com]

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

Frank Ch. Eigler <fche at redhat dot com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #1 from Frank Ch. Eigler <fche at redhat dot com> ---
commit d16628bb7dc39a020e555e16bf56374fdac84e42
Author: Frank Ch. Eigler <fche@redhat.com>
Date:   Mon May 8 11:05:48 2023 -0400

    PR30316: debuginfod wal checkpointing

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