https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7363
Fabian Wenk <fab...@wenks.ch> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |fab...@wenks.ch
--- Comment #9 from Fabian Wenk <fab...@wenks.ch> ---
Running with SpamAssassin 4.0.0 on FreeBSD 12.4 (out of FreeBSD Ports,
installed 12.03.2023) using bayes and AWL with SQL (MariaDB) backend.
It took my quite a while until I figured out what is wrong, as even sa-compile
and spamassassin --lint did hang.
Here the output from MariaDB 'show processlist;', in the "Time" column you see
that this update query did hang for 16+ hours, even many hours after I had
stopped all running spamd (sorry about long lines and possible line wrap):
root@localhost [(none)]> show processlist;
+--------+----------+-----------------+--------------+---------+-------+-----------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State
| Info
| Progress |
+--------+----------+-----------------+--------------+---------+-------+-----------------+------------------------------------------------------------------------------------------------------+----------+
| 886392 | spamd | localhost | spamassassin | Query | 59013 | init
for update | UPDATE bayes_token
SET ham_count = ham_count + '1',
at | 0.000 |
| 886397 | spamd | localhost | spamassassin | Query | 58920 |
Statistics | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 892689 | spamd | localhost | spamassassin | Query | 24528 |
Statistics | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 892694 | spamd | localhost | spamassassin | Query | 24488 |
Statistics | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 893918 | spamd | localhost | spamassassin | Query | 19201 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 893931 | spamd | localhost | spamassassin | Query | 19151 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 894258 | spamd | localhost | spamassassin | Query | 18462 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 894652 | spamd | localhost | spamassassin | Query | 16878 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 894811 | spamd | localhost | spamassassin | Query | 16175 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895086 | spamd | localhost | spamassassin | Query | 15386 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895204 | spamd | localhost | spamassassin | Query | 14768 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895222 | spamd | localhost | spamassassin | Query | 14584 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895231 | spamd | localhost | spamassassin | Query | 14449 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895344 | spamd | localhost | spamassassin | Query | 14192 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895355 | spamd | localhost | spamassassin | Query | 14118 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895356 | spamd | localhost | spamassassin | Query | 14090 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895377 | spamd | localhost | spamassassin | Query | 14015 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895383 | spamd | localhost | spamassassin | Query | 13899 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895613 | spamd | localhost | spamassassin | Query | 13007 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895682 | spamd | localhost | spamassassin | Query | 12723 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895697 | spamd | localhost | spamassassin | Query | 12587 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 895876 | spamd | localhost | spamassassin | Query | 11706 |
Opening tables | SELECT SUBSTR(token || ' ', 1, 5), spam_count, ham_count,
atime
FROM bayes_ | 0.000 |
| 899586 | root | localhost | NULL | Query | 0 |
starting | show processlist
| 0.000 |
+--------+----------+-----------------+--------------+---------+-------+-----------------+------------------------------------------------------------------------------------------------------+----------+
28 rows in set (0.067 sec)
root@localhost [(none)]>
--
You are receiving this mail because:
You are the assignee for the bug.
