Last modified: 2014-11-18 00:28:29 UTC
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.
Sync in progress. Cause is not yet confirmed, with https://mariadb.atlassian.net/browse/MDEV-6551 a possibility. Very interested to hear if anyone observes this with recent (<1week) data.
Today this happened again with http://de.wikipedia.org/wiki/Matw%C3%A9_Middelkoop (pageid: 8468612) article has categories, no replag, but no entries in categorylinks table. purge and nulledit does not help.
some more: http://de.wikipedia.org/wiki/Edition_Staub (page_id 8472288) http://de.wikipedia.org/wiki/S%C3%B3lja_Eidisgard (page_id 8469208) http://de.wikipedia.org/wiki/Funakoshi_Gichin (page_id 17956)
