SQL error: Deadlock found when trying to get lock

View: New views
2 Messages — Rating Filter:   Alert me  

SQL error: Deadlock found when trying to get lock

by pennywise :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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






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

by Michael Parker :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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