https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7363

Michael <ph...@rogers.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ph...@rogers.com

--- Comment #10 from Michael <ph...@rogers.com> ---
Similarly, seeing a deadlock between these queries, which never seems to get
resolved, ultimately needing the database to be killed.  Using MySQL with
Spamassassin 4.0.

INSERT INTO bayes_token (id, token, spam_count, ham_count, atime) VALUES
('1','i^\5        ?','0','1','1722269232') ON DUPLICATE KEY UPDATE spam_count =
GREATEST(spam_count + '0', 0), ham_count = GREATEST(ham_count + '1', 0), atime
= GREATEST(atime, '1722269232')
UPDATE bayes_token SET atime = '1722269306' WHERE id = '1' AND token IN (...)
AND atime < '1722269306'
UPDATE bayes_token SET atime = '1722269376' WHERE id = '1' AND token IN (...)
AND atime < '1722269376'
UPDATE bayes_token SET atime = '1722269378' WHERE id = '1' AND token IN (...)
AND atime < '1722269378'

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to