Package: spamassassin Version: 3.4.1-8 Severity: normal Tags: patch Dear Maintainer,
# Symptoms When Bayes is used with an SQL backend (PostgreSQL in the observed case), and autoexpiry is disabled, the bayes_expire table keeps growing for every sa-learn --force-expire call. # Analysis When Expiry is triggered a row gets inserted via set_running_expire_tok into the bayes_expire table. However it never get's delete, except: - if token to expire < 1000 - if $max_expire_mult would not expire any tokens # Effects on Runtime Because learner_is_scan_available calls $self->_opportunistic_calls(1); which calls $self->{store}->get_running_expire_tok(); every client will do a sequential scan on this table SELECT max(runtime) from bayes_expire WHERE id = ?"; which takes longer and longer as the bayes_expire table continues to grow. The problem is reported upstream and a patch commited. https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7340 Because of the longer release cycles we hope to get this small patch included in Debian. Thanks for your work Regards Noël -- System Information: Debian Release: buster/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 4.14.0-1-amd64 (SMP w/4 CPU cores) Locale: LANG=de_DE.utf8, LC_CTYPE=de_DE.utf8 (charmap=UTF-8), LANGUAGE=de_DE.utf8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages spamassassin depends on: ii adduser 3.116 ii init-system-helpers 1.51 ii libhtml-parser-perl 3.72-3+b2 ii libhttp-date-perl 6.02-1 ii libmail-dkim-perl 0.44-1 ii libnet-dns-perl 1.10-2 ii libnetaddr-ip-perl 4.079+dfsg-1+b2 ii libsocket6-perl 0.27-1+b3 ii libsys-hostname-long-perl 1.5-1 ii libwww-perl 6.29-1 ii lsb-base 9.20170808 ii perl 5.26.1-3 ii perl-modules-5.26 [libarchive-tar-perl] 5.26.1-3 ii w3m 0.5.3-34 Versions of packages spamassassin recommends: ii gnupg 2.2.3-1 ii libio-socket-inet6-perl 2.72-2 ii libmail-spf-perl 2.9.0-4 ii libperl5.26 [libsys-syslog-perl] 5.26.1-3 ii sa-compile 3.4.1-8 ii spamc 3.4.1-8 Versions of packages spamassassin suggests: ii libdbi-perl 1.637-1 pn libencode-detect-perl <none> pn libgeo-ip-perl <none> ii libio-socket-ssl-perl 2.052-1 pn libnet-patricia-perl <none> ii libperl5.26 [libcompress-zlib-perl] 5.26.1-3 pn pyzor <none> pn razor <none> -- no debconf information