You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by pennywise <ai...@web.de> on 2007/09/19 10:07:20 UTC

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






-- 
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.

Re: SQL error: Deadlock found when trying to get lock

Posted by Michael Parker <pa...@pobox.com>.
pennywise wrote:
> 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

Generally these are harmless, but its possible that the code isn't
handling the "try restarting transaction" bits correctly.

Can you please file a bug?  http://issues.apache.org/SpamAssassin/

Thanks
Michael

> 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
> 
> 
> 
> 
> 
>