On Wednesday January 27 2010 23:28:46 Ed Kasky wrote: > I have been using Mysql for bayes storage for quite some time very > successfully for quite some time. After seeing a lot of spam coming > through since upgrading I though I had better check the scoring to > see what was going on. Here's what I found: > > Jan 27 10:16:27 yoda spamd[30357]: Issuing rollback() for database > handle being DESTROY'd without explicit disconnect() at > /usr/lib/perl5/site_perl/5.8.8/Mail/SpamAssassin/Plugin/Bayes.pm line > 1518, <GEN208> line 2. > > I did some searching on the error but could not find anything related > to SA. > bayes_store_module Mail::SpamAssassin::BayesStore::MySQL > auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
> running a lint comes up clean - no warnings > I went through the install docs again but can't find anything wrong > with my setup. Any suggestions as to where else to look? Assuming your database tables are of the type TYPE=InnoDB (as documented in ./sql/README.bayes) there does not appear to be anything unusual about your setup. I'm running a setup just like that (under amavisd and SpamAssassin 3.3.0, and bayes works fine with MySQL 5.1.42 . I suggest trying to reproduce the problem with a command-line spamassassin (with debugging enabled), and if that is not successful, turn on full debugging with spamd, then on hitting a problem examine back if there are any previous telltale signs leading to the problem. Mark