[Bug 4749] New: spamassassin/spamd pause/wait when mysql dbase is locked

[bu...@bugzilla.spamassassin.org]

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: dev@spamassassin.apache.org
        ReportedBy: ivanp@yu.net


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.

[Bug 4749] spamassassin/spamd pause/wait when mysql dbase is locked

[bu...@bugzilla.spamassassin.org]

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4749


parkerm@pobox.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |parkerm@pobox.com






------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

[Bug 4749] spamassassin/spamd pause/wait when mysql dbase is locked

[bu...@bugzilla.spamassassin.org]

http://issues.apache.org/SpamAssassin/show_bug.cgi?id=4749





------- Additional Comments From parkerm@pobox.com  2007-11-24 09:08 -------
This is pretty much a function of the underlying library.

We could add wrap the DB calls in the Timeout code to help with this situation.



------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.