https://bugzilla.wikimedia.org/show_bug.cgi?id=70711

            Bug ID: 70711
           Summary: missing database entries at categorylinks table on
                    dewiki db
           Product: Wikimedia Labs
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Infrastructure
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected], [email protected],
                    [email protected], [email protected]
            Blocks: 48930, 67556
       Web browser: ---
   Mobile Platform: ---

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to