Bug 30316 - debuginfod server should checkpoint WAL manually
Summary: debuginfod server should checkpoint WAL manually
Status: RESOLVED FIXED
Alias: None
Product: elfutils
Classification: Unclassified
Component: debuginfod (show other bugs)
Version: unspecified
: P2 normal
Target Milestone: ---
Assignee: Not yet assigned to anyone
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-05 19:55 UTC by Frank Ch. Eigler
Modified: 2023-05-09 17:02 UTC (History)
1 user (show)

See Also:
Host:
Target:
Build:
Last reconfirmed:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Frank Ch. Eigler 2023-04-05 19:55:36 UTC 
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.
Comment 1 Frank Ch. Eigler 2023-05-09 17:02:41 UTC 
commit d16628bb7dc39a020e555e16bf56374fdac84e42
Author: Frank Ch. Eigler <fche@redhat.com>
Date:   Mon May 8 11:05:48 2023 -0400

    PR30316: debuginfod wal checkpointing