Dne 6.11.2014 v 21:05 Marieke Janssen napsal(a):
flooded with: warn: Issuing rollback() due to DESTROY without explicit disconnect() of D│Nov 6 15:28:49.798 [12681] warn: Issuing rollback() due to DESTROY without explicit disconnect() of D BD::mysql::db handle sa_bayes:localhost at /usr/lib64/perl5/vendor_perl/5.18.2/Mail/SpamAssassin/Plugi│BD::mysql::db handle sa_bayes:localhost at /usr/lib64/perl5/vendor_perl/5.18.2/Mail/SpamAssassin/Plugi<n/Bayes.pm line 1590, <GEN2272> line 3.Can you please confirm that it's not something that I should care about?I have it once in a while, if the server "has gone away". Don't know why, it's only a few times a day. Something like this: mysql> select * from bla; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... But I don't get flooded. I don't know your definition of flooded so I assume it's every incoming mail or every few seconds or so.
Around 20 per minute.
I suppose Bayes has a persistent connection to mysql, so it should never disconnect() (except of shutdown of SA). I can think of a few things, you are probably disconnected all the time: wait_timeout in mysql is low,your query is not valid, you don't have the DSN defined in local.cf properly setup in mysql, mysql tables are corrupt, the rights to /var/run/mysqld/mysqld.sock are wrong or mysql is kicking you for other reasons. Did you check the mysql logs? (see http://dev.mysql.com/doc/refman/5.5/en/gone-away.html)
+---------------------------------------------------+----------+ | Variable_name | Value | +---------------------------------------------------+----------+ | innodb_lock_wait_timeout | 120 | | innodb_spin_wait_delay | 6 | | lock_wait_timeout | 31536000 | | performance_schema_events_waits_history_long_size | 10000 | | performance_schema_events_waits_history_size | 10 | | wait_timeout | 28800 | +---------------------------------------------------+----------+ bayes_store_module Mail::SpamAssassin::BayesStore::MySQL bayes_sql_dsn DBI:mysql:sa_bayes:localhost bayes_sql_username sa_user bayes_sql_password ebayes bayes_sql_override_username qscand MySQL check is OK, mysqld.err show no errors. ~ # ls -l /var/run/mysqld/mysqld.sock srwxrwxrwx 1 mysql mysql 0 Nov 6 21:16 /var/run/mysqld/mysqld.sock Database structure attached. I also tried mariadb as Jari mentioned, but nothing has changed either. Any other ideas? Thanks for help! Jan
/MJ
sa_bayes.sql
Description: application/sql
smime.p7s
Description: Elektronicky podpis S/MIME
