At least dewiki database is currupted on labs because some expected rows in categorylinks, imagelinks and so on are missing. But this problems affects the production wiki, too. API of de.wikipedia.org is returning the same wrong results, so i think the database replication is broken there, too.
Example:
http://de.wikipedia.org/w/index.php?title=All_inclusive&oldid=138210488 has four categories (three in source, one included from a template)
http://de.wikipedia.org/w/api.php?action=query&pageids=1106087&prop=categories does not show any category:
"query": {
"pages": {
"1106087": {
"pageid": 1106087,
"ns": 0,
"title": "All inclusive"
}
}
}
On toollabs:
$ mysql -hs5.labsdb -vvve "select * from categorylinks where cl_from=1106087" dewiki_p
--------------
select * from categorylinks where cl_from=1106087
--------------
Empty set (0.00 sec)
Bye
My bot is searching for articles without categories on dewiki. that is why i detected this error. There a currently about fifty articles with missing database rows on dewiki.categorylinks table and the number is still rising.. A Null-Edit on the wiki solves the error for a single article.