« Return to Thread: SQL error: Deadlock found when trying to get lock

SQL error: Deadlock found when trying to get lock

by pennywise :: Rate this Message:

Reply to Author | View in Thread

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





 « Return to Thread: SQL error: Deadlock found when trying to get lock