Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

SQL error: Deadlock found when trying to get lock

From: pennywise <aishe_1(at)web.de>
Date: Wed Sep 19 2007 - 04:07:20 EDT

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.

Do you need help?X

Best regards,
Pennywise

-- 
View this message in context: 
http://www.nabble.com/SQL-error%3A-Deadlock-found-when-trying-to-get-lock-tf4479377.html#a12772535
Sent from the SpamAssassin - Users mailing list archive at Nabble.com.
Received on Wed Sep 19 04:08:01 2007

This archive was generated by hypermail 2.1.8 : Sat Oct 27 2007 - 07:19:12 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library