SQL error: Deadlock found when trying to get lock
Hello together!
I ´ve got following problem with my spamassassin which I couldn´t solve.....
When I use
su vscan -c '/usr/local/bin/sa-learn -D --force-expire --sync'
I got this error message:
[72597] dbg: bayes: token_expiration: SQL error: Deadlock found when trying to get lock; try restarting transaction
expired old bayes database entries in 161 seconds
26158500 entries kept, 0 deleted
token frequency: 1-occurrence tokens: 2.80%
token frequency: less than 8 occurrences: 0.91%
[72597] dbg: bayes: expiry completed
This is my Server:
FreeBSD 6.0
mysql-server-4.1.16 (innoDB)
amavisd-new-2.5.2,1
p5-Mail-SpamAssassin-3.2.3
Can anybody help me? Thanks for your help.
Best regards,
Pennywise