[Bug 2073787] Re: apport-retrace needs more than 1 GB memory (when using sandbox)

[Benjamin Drung]

Benchmarks can be found nicely formatted on
https://github.com/bdrung/apport/blob/benchmark-databases/Benchmark.md

SQLite is the fastest on a Raspberry Pi Zero 2W and the only contender
for fixing this bug. For the different SQLite implementation variants:
You can trade creation time with saved disk space.

Since I was too curious I spend some nights on rewriting those SQLite
benchmarks in Rust (see https://github.com/bdrung/apport-rs). The Rust
implementation is obviously faster. Surprisingly the creation time for
the different database layouts is nearly the same. So I conclude that
increased creation times in Python are caused by the Python code (and
not by the more complex SQL statements).

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to apport in Ubuntu.
https://bugs.launchpad.net/bugs/2073787

Title:
  apport-retrace needs more than 1 GB memory (when using sandbox)

Status in Apport:
  Triaged
Status in apport package in Ubuntu:
  Triaged

Bug description:
  The system tests test_retrace_system_sandbox and
  test_retrace_jammy_sandbox fail on arm64, ppc64el, s390x, because
  apport-retrace is killed by the OOM killer. Example:

  autopkgtest kernel: Out of memory: Killed process 3597 (apport-
  retrace) total-vm:1512420kB, anon-rss:1241460kB, file-rss:2592kB,
  shmem-rss:0kB, UID:0 pgtables:2554kB oom_score_adj:0

  Log: https://autopkgtest.ubuntu.com/results/autopkgtest-oracular-
  bdrung-apport/oracular/s390x/a/apport/20240722_145904_d3c2f@/log.gz

  apport-retrace should be able to retrace crashes without needing
  multiple gigabytes of memory.

To manage notifications about this bug go to:
https://bugs.launchpad.net/apport/+bug/2073787/+subscriptions