Андрей (andy) wrote in changelog,
Андрей
andy
changelog

[ljcom] r10381: fix the deadlock happening because we se...

Committer: ailyin
fix the deadlock happening because we select a little too much rows
U   trunk/cgi-bin/LJ/TwitterDigest.pm
Modified: trunk/cgi-bin/LJ/TwitterDigest.pm
===================================================================
--- trunk/cgi-bin/LJ/TwitterDigest.pm	2011-04-12 08:42:02 UTC (rev 10380)
+++ trunk/cgi-bin/LJ/TwitterDigest.pm	2011-04-13 02:02:03 UTC (rev 10381)
@@ -181,6 +181,7 @@
         WHERE disabled       = 0
           AND next_post_time < UNIX_TIMESTAMP()
           AND locked_until   < UNIX_TIMESTAMP()
+        LIMIT 1
         FOR UPDATE
     });
 

Tags: andy, ljcom, pm
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments