http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4749
Summary: spamassassin/spamd pause/wait when mysql dbase is locked
Product: Spamassassin
Version: 3.1.0
Platform: All
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P5
Component: spamassassin
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Hi devel team,
I come upon this problem while playing with mysql replication. I have a couple
of nodes running sendmail/spamassassin using same mysql bayes/awl database.
Because we are using milter setup, high availability of mysql is crucial
otherwise mail is going by unchecked.
Here is what happens. If i lock mysql (flush with lock) spamd just hangs there,
milter timeouts and mail goes by. If I run SA in debug mode I can see that it
stops where bayes is pruned so i guess it tries to update bayes and tokens. If I
unlock dbase SA continue checking the message.
Why SA just not run along without bayes if there is something wrong with mysql?
Also DBI has db_(re/wr)itable function but i'm going to test if one can use it
to see is dbase is locked. Maybe it is a task for MySQL specific module?
Thanks for your great work and effort.
MySQL 4.1; DBD::MySQL 2.0097 and 3.002; SA 3.1.0
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
