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
