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

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
     });