[Bug 2073787] Re: apport-retrace needs more than 1 GB

[Benjamin Drung]

Benchmark results on a Raspberry Pi Zero 2W:

Creating a database with only jammy-proposed (fits into memory):

* pickle: 43s for creation, 5s for querying (including pickling)
* SQLite: 45s for creation, 1s for querying
* DBM (GNU): 123s for creation, 1s for querying
* DBM (NDBM): 208s for creation, 1-2s for querying

Creating a database with jammy (does not fit into memory):

* pickle: not tested (but test_retrace_jammy_sandbox took 16075.58s = 4.5h)
* SQLite: 14m19s for creation, 1.6s for querying
* DBM (GNU): manually aborted after 10h
* DBM (NDBM): manually aborted after several hours (did not check the clock)

So DBM is disqualified and SQLite is the only remaining contender.

-- 
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

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/ubuntu/+source/apport/+bug/2073787/+subscriptions