My bot searches for articles without categories on dewiki. But the database returns wrong results because of missing entries:
mysql -hs5.labsdb -vve "select * from dewiki_p.categorylinks where cl_from=8389350";
select * from dewiki_p.categorylinks where cl_from=8389350
Empty set (0.00 sec)
But the articles has four categories added since 9. September 2014, 21:28:40 :
http://de.wikipedia.org/w/index.php?title=Eberhard_R%C3%B6ssler&diff=133880251&oldid=133879668 , so there are four rows missing.
and there is no replag:
mysql -hs5.labsdb -ve "select rc_timestamp from dewiki_p.recentchanges order by rc_timestamp desc limit 1";
+----------------+
rc_timestamp |
+----------------+
20140911122626 |
+----------------+
Please add the missing entries at categorylinks table and prevent such error for the future.
Version: unspecified
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=72226
https://bugzilla.wikimedia.org/show_bug.cgi?id=71084