On 19 Oct 2010, at 17:05, Micah Anderson wrote: > > Hello, > > I'm running a busy mail server. We've got a bayes database on its own > server, with InnoDB tables.
What is your total DB size / server RAM? Could you include a snapshot of the output of top from the DB server? I would guess that your problem is indexing/tuning or server capacity MySQL side rather than in SA, but without more data it is just a guess. > > I'm seeing a number of these entries in my log files and am struggling > to determine what could be causing them and how to fix them: > > Oct 19 07:02:10 spamd3 spamd[27474]: learn: exceeded time limit in pms learn > Oct 17 06:30:12 spamd3 spamd[25651]: plugin: eval failed: bayes: (in learn) > __alarm__ignore__(15190) > Oct 17 06:30:42 spamd3 spamd[25598]: plugin: eval failed: bayes: (in learn) > child processing timeout at /usr/sbin/spamd line 1283, <GEN1295> line 185. > > I get quite a few of these: > > Oct 19 07:02:19 spamd3 spamd[18746]: Issuing rollback() for database handle > being DESTROY'd without explicit disconnect() at > /usr/share/perl5/Mail/SpamAssassin/Plugin/Bayes.pm line 1516, <GEN19133> line > 2. > If the processing timeout above occurs inside an uncommitted transaction, you will get this. > and a few of these, although not that many: > > Oct 17 12:02:29 spamd3 spamd[6367]: prepare_cached(SELECT max(runtime) from > bayes_expire WHERE id = ?) statement handle DBI::st=HASH(0xadbb060)still > Active at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 722 Try an EXPLAIN SELECT max(runtime) from bayes_expire WHERE id = <some value>; as you know it to be slow it might give a clue where to look to improve performance. Or try turning the general query log on for a while and see what queries are taking up time. MonYog is quite a nice frontend to this, but you can do it by hand fairly simply. > > Oct 19 05:33:13 spamd3 spamd[1630]: bayes: db_seen corrupt: > value='1287482415' for 5d6fb52248450ee7528848c3a78b5a0650a24...@sa_generated, > ignored at /usr/share/perl5/Mail/SpamAssassin/Plugin/Bayes.pm line 397, > <GEN18675> line 112. > > thanks for any insights! > micha Dominic