Last modified: 2014-09-17 11:44:56 UTC
+----------------------+------+------+-------------+-----------------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+ | dbname | lang | name | family | url | size | slice | is_closed | has_echo | has_flaggedrevs | has_visualeditor | has_wikidata | +----------------------+------+------+-------------+-----------------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+ | bat_smgwiki | en | NULL | wikipedia | http://bat_smg.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | be_x_oldwiki | en | NULL | wikipedia | http://be_x_old.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | cbk_zamwiki | en | NULL | wikipedia | http://cbk_zam.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | centralauth | en | NULL | centralauth | NULL | 1 | s7.labsdb | 0 | 0 | 0 | 0 | 0 | | fiu_vrowiki | en | NULL | wikipedia | http://fiu_vro.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | map_bmswiki | en | NULL | wikipedia | http://map_bms.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | nds_nlwiki | en | NULL | wikipedia | http://nds_nl.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | roa_rupwiki | en | NULL | wikipedia | http://roa_rup.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | roa_rupwiktionary | en | NULL | wiktionary | http://roa_rup.wiktionary.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | roa_tarawiki | en | NULL | wikipedia | http://roa_tara.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | vewikimedia | en | NULL | wikimedia | http://ve.wikimedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | zh_classicalwiki | en | NULL | wikipedia | http://zh_classical.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 1 | 1 | 1 | | zh_min_nanwiki | en | NULL | wikipedia | http://zh_min_nan.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | | zh_min_nanwikibooks | en | NULL | wikibooks | http://zh_min_nan.wikibooks.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | zh_min_nanwikiquote | en | NULL | wikiquote | http://zh_min_nan.wikiquote.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | zh_min_nanwikisource | en | NULL | wikisource | http://zh_min_nan.wikisource.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | zh_min_nanwiktionary | en | NULL | wiktionary | http://zh_min_nan.wiktionary.org | 1 | s3.labsdb | 0 | 0 | 0 | 0 | 0 | | zh_yuewiki | en | NULL | wikipedia | http://zh_yue.wikipedia.org | 1 | s3.labsdb | 0 | 0 | 0 | 1 | 1 | +----------------------+------+------+-------------+-----------------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+ For the wikis reported above lang is 'en', name in NULL and URL is wrong (maybe this is the reason for the other missing information). For example isn't http://roa_tara.wikipedia.org but http://roa-tara.wikipedia.org For all the wikis, 'size' column is always 1. This information can be get from: * site_stats.ss_good_articles table of replica db, or * API /w/api.php?action=query&meta=siteinfo&format=json&siprop=statistics under "articles"
Yes, the URL being incorrect is likely the cause of the other errors. Looking into it.
Also 'is_closed' column is always 0, for all the wikis.
(In reply to comment #2) > Also 'is_closed' column is always 0, for all the wikis. That would be because we do not currently replicate any closed wikis. :-) For the other values, things should have been corrected now. Please check?
(In reply to comment #3) > (In reply to comment #2) > > Also 'is_closed' column is always 0, for all the wikis. > > That would be because we do not currently replicate any closed wikis. :-) Ah, ok! Alright :) > For the other values, things should have been corrected now. Please check? Now it seems ok, except for the 'size' column, is always 1 yet.
There was a typo that prevented the size column from being properly set. Fixed since.
The meta_p.wiki tables now contains only one row: centralauth. MariaDB [meta_p]> select * from wiki; +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+ | dbname | lang | name | family | url | size | slice | is_closed | has_echo | has_flaggedrevs | has_visualeditor | has_wikidata | +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+ | centralauth | en | NULL | centralauth | NULL | 1 | s7.labsdb | 0 | 0 | 0 | 0 | 0 | +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+ 1 row in set (0.00 sec)
Now the problem seems to be fixed.
Change 160945 had a related patch set uploaded by coren: Labs: Fix generation of meta_p.meta https://gerrit.wikimedia.org/r/160945
Change 160945 merged by coren: Labs: Fix generation of meta_p.meta https://gerrit.wikimedia.org/r/160945
