Bug#1014201: spamprobe hangs in libdb; use MySQL instead?
Package: spamprobe
Version: 1.4d-14+b2
Severity: important
Tags: upstream
I posted this upstream at https://sourceforge.net/p/spamprobe/bugs/40/, but as expected got no reaction there.
Is anyone here maintaining spamprobe anymore, or am I on my own?
---
I had used spamprobe for many years without major problems. But recently it started hanging.
strace shows it blocks on a futex call which is strange enough since it's single-threaded and no other instances were running at the same time.
Once it happens, it seems to happen every time. Rebuilding the database helped, but only for a short while. After few days, it would hang again.
gdb shows the offending calls come from some libdb functions. Since I don't feel like debugging libdb, and you might not either, this got me thinking if using a file-based DB such as Berkeley is really the best option here.
Using a DB server such as MySQL might, apart from hopefully avoiding such locking bugs, be better for performance since it doesn't have to load the whole DB on each invocation, but can cache it if used frequently, as it normally does.
I see a similar request was made recently (well, 17 years ago ;) in https://sourceforge.net/p/spamprobe/feature-requests/23/ (with yet another reason), but got no replies.
-- System Information:
Debian Release: 11.3
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable-debug'), (500, 'proposed-updates-debug'), (500, 'proposed-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 5.10.0-14-amd64 (SMP w/24 CPU threads)
Kernel taint flags: TAINT_WARN
Locale: LANG=de_DE, LC_CTYPE=de_DE (charmap=ISO-8859-1), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages spamprobe depends on:
ii debconf [debconf-2.0] 1.5.77
ii libc6 2.31-13+deb11u3
ii libdb5.3 5.3.28+dfsg1-0.8
ii libgcc-s1 [libgcc1] 10.2.1-6
ii libgif7 5.1.9-2
ii libjpeg62-turbo 1:2.0.6-4
ii libpng16-16 1.6.37-3
ii libstdc++6 10.2.1-6
Versions of packages spamprobe recommends:
ii procmail 3.22-26
spamprobe suggests no packages.
-- debconf-show failed
Reply to: