Pages like https://tools.wmflabs.org/guc/?user=KrinkleBot are missing headings and have broken links because .url is NULL for many rows (292 of 862).
This is a regression since last month. Possibly triggered by T103663.
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| maintain-replicas: Also look at wikipedia.dblist | operations/software | master | +2 -1 |
Related Objects
Related Objects
- Mentioned In
- T142759: New entries in meta_p.wiki are missing a URL
T107618: relatedchanges.php MySQL errors
T107081: create database view for azbwiki and add domain azbwiki.labsdb to nameserver
T107062: Email notifications for reassigning/claim should be consistent with web interface - Mentioned Here
- T106989: Provide and maintain "pattern" to extract configuration information from operations/mediawiki-config
T106963: SiteMatrix API returns unexpected null for 'wiki.url' field of Wikipedia project
T103663: Update meta_p to contain accurate canonical server endpoints
Event Timeline
Comment Actions
Ew, it tries to parse InitialiseSettings: https://github.com/wikimedia/operations-software/blob/master/maintain-replicas/maintain-replicas.pl#L395-L406
Comment Actions
(Not sure if it is already possible or worthy of a RFE task, but if there was an "API" to InitialiseSettings.php independent of actual MediaWiki start-up, i. e. if something like:
require('mediawiki/includes/this.php');
require('mediawiki/includes/that.php');
require('path/to/InitialiseSettings.php');
foreach($argv as $wiki) {
print(json_encode($wiki, getConfigSetting($wiki, 'wgSomething')));
}would (always) work, that would be tremendously helpful in this and other cases.)
Comment Actions
Change 226939 had a related patch set uploaded (by Alex Monk):
Also look at wikipedia.dblist
Comment Actions
"Unbreak Now!"
MariaDB [(none)]> SELECT dbname, lang, name, family, url FROM meta_p.wiki WHERE family = 'wikipedia' ORDER BY dbname; +------------------+------+------+-----------+------+ | dbname | lang | name | family | url | +------------------+------+------+-----------+------+ | aawiki | en | NULL | wikipedia | NULL | | abwiki | en | NULL | wikipedia | NULL | | acewiki | en | NULL | wikipedia | NULL | | afwiki | en | NULL | wikipedia | NULL | | akwiki | en | NULL | wikipedia | NULL | | alswiki | en | NULL | wikipedia | NULL | | amwiki | en | NULL | wikipedia | NULL | | angwiki | en | NULL | wikipedia | NULL | | anwiki | en | NULL | wikipedia | NULL | | arcwiki | en | NULL | wikipedia | NULL | | arwiki | en | NULL | wikipedia | NULL | | arzwiki | en | NULL | wikipedia | NULL | | astwiki | en | NULL | wikipedia | NULL | | aswiki | en | NULL | wikipedia | NULL | | avwiki | en | NULL | wikipedia | NULL | | aywiki | en | NULL | wikipedia | NULL | | azbwiki | en | NULL | wikipedia | NULL | | azwiki | en | NULL | wikipedia | NULL | | barwiki | en | NULL | wikipedia | NULL | | bat_smgwiki | en | NULL | wikipedia | NULL | | bawiki | en | NULL | wikipedia | NULL | | bclwiki | en | NULL | wikipedia | NULL | | bewiki | en | NULL | wikipedia | NULL | | be_x_oldwiki | en | NULL | wikipedia | NULL | | bgwiki | en | NULL | wikipedia | NULL | | bhwiki | en | NULL | wikipedia | NULL | | biwiki | en | NULL | wikipedia | NULL | | bjnwiki | en | NULL | wikipedia | NULL | | bmwiki | en | NULL | wikipedia | NULL | | bnwiki | en | NULL | wikipedia | NULL | | bowiki | en | NULL | wikipedia | NULL | | bpywiki | en | NULL | wikipedia | NULL | | brwiki | en | NULL | wikipedia | NULL | | bswiki | en | NULL | wikipedia | NULL | | bugwiki | en | NULL | wikipedia | NULL | | bxrwiki | en | NULL | wikipedia | NULL | | cawiki | en | NULL | wikipedia | NULL | | cbk_zamwiki | en | NULL | wikipedia | NULL | | cdowiki | en | NULL | wikipedia | NULL | | cebwiki | en | NULL | wikipedia | NULL | | cewiki | en | NULL | wikipedia | NULL | | chowiki | en | NULL | wikipedia | NULL | | chrwiki | en | NULL | wikipedia | NULL | | chwiki | en | NULL | wikipedia | NULL | | chywiki | en | NULL | wikipedia | NULL | | ckbwiki | en | NULL | wikipedia | NULL | | cowiki | en | NULL | wikipedia | NULL | | crhwiki | en | NULL | wikipedia | NULL | | crwiki | en | NULL | wikipedia | NULL | | csbwiki | en | NULL | wikipedia | NULL | | cswiki | en | NULL | wikipedia | NULL | | cuwiki | en | NULL | wikipedia | NULL | | cvwiki | en | NULL | wikipedia | NULL | | cywiki | en | NULL | wikipedia | NULL | | dawiki | en | NULL | wikipedia | NULL | | dewiki | en | NULL | wikipedia | NULL | | diqwiki | en | NULL | wikipedia | NULL | | dsbwiki | en | NULL | wikipedia | NULL | | dvwiki | en | NULL | wikipedia | NULL | | dzwiki | en | NULL | wikipedia | NULL | | eewiki | en | NULL | wikipedia | NULL | | elwiki | en | NULL | wikipedia | NULL | | emlwiki | en | NULL | wikipedia | NULL | | enwiki | en | NULL | wikipedia | NULL | | eowiki | en | NULL | wikipedia | NULL | | eswiki | en | NULL | wikipedia | NULL | | etwiki | en | NULL | wikipedia | NULL | | euwiki | en | NULL | wikipedia | NULL | | extwiki | en | NULL | wikipedia | NULL | | fawiki | en | NULL | wikipedia | NULL | | ffwiki | en | NULL | wikipedia | NULL | | fiu_vrowiki | en | NULL | wikipedia | NULL | | fiwiki | en | NULL | wikipedia | NULL | | fjwiki | en | NULL | wikipedia | NULL | | fowiki | en | NULL | wikipedia | NULL | | frpwiki | en | NULL | wikipedia | NULL | | frrwiki | en | NULL | wikipedia | NULL | | frwiki | en | NULL | wikipedia | NULL | | furwiki | en | NULL | wikipedia | NULL | | fywiki | en | NULL | wikipedia | NULL | | gagwiki | en | NULL | wikipedia | NULL | | ganwiki | en | NULL | wikipedia | NULL | | gawiki | en | NULL | wikipedia | NULL | | gdwiki | en | NULL | wikipedia | NULL | | glkwiki | en | NULL | wikipedia | NULL | | glwiki | en | NULL | wikipedia | NULL | | gnwiki | en | NULL | wikipedia | NULL | | gomwiki | en | NULL | wikipedia | NULL | | gotwiki | en | NULL | wikipedia | NULL | | guwiki | en | NULL | wikipedia | NULL | | gvwiki | en | NULL | wikipedia | NULL | | hakwiki | en | NULL | wikipedia | NULL | | hawiki | en | NULL | wikipedia | NULL | | hawwiki | en | NULL | wikipedia | NULL | | hewiki | en | NULL | wikipedia | NULL | | hifwiki | en | NULL | wikipedia | NULL | | hiwiki | en | NULL | wikipedia | NULL | | howiki | en | NULL | wikipedia | NULL | | hrwiki | en | NULL | wikipedia | NULL | | hsbwiki | en | NULL | wikipedia | NULL | | htwiki | en | NULL | wikipedia | NULL | | huwiki | en | NULL | wikipedia | NULL | | hywiki | en | NULL | wikipedia | NULL | | hzwiki | en | NULL | wikipedia | NULL | | iawiki | en | NULL | wikipedia | NULL | | idwiki | en | NULL | wikipedia | NULL | | iewiki | en | NULL | wikipedia | NULL | | igwiki | en | NULL | wikipedia | NULL | | iiwiki | en | NULL | wikipedia | NULL | | ikwiki | en | NULL | wikipedia | NULL | | ilowiki | en | NULL | wikipedia | NULL | | iowiki | en | NULL | wikipedia | NULL | | iswiki | en | NULL | wikipedia | NULL | | itwiki | en | NULL | wikipedia | NULL | | iuwiki | en | NULL | wikipedia | NULL | | jawiki | en | NULL | wikipedia | NULL | | jbowiki | en | NULL | wikipedia | NULL | | jvwiki | en | NULL | wikipedia | NULL | | kaawiki | en | NULL | wikipedia | NULL | | kabwiki | en | NULL | wikipedia | NULL | | kawiki | en | NULL | wikipedia | NULL | | kbdwiki | en | NULL | wikipedia | NULL | | kgwiki | en | NULL | wikipedia | NULL | | kiwiki | en | NULL | wikipedia | NULL | | kjwiki | en | NULL | wikipedia | NULL | | kkwiki | en | NULL | wikipedia | NULL | | klwiki | en | NULL | wikipedia | NULL | | kmwiki | en | NULL | wikipedia | NULL | | knwiki | en | NULL | wikipedia | NULL | | koiwiki | en | NULL | wikipedia | NULL | | kowiki | en | NULL | wikipedia | NULL | | krcwiki | en | NULL | wikipedia | NULL | | krwiki | en | NULL | wikipedia | NULL | | kshwiki | en | NULL | wikipedia | NULL | | kswiki | en | NULL | wikipedia | NULL | | kuwiki | en | NULL | wikipedia | NULL | | kvwiki | en | NULL | wikipedia | NULL | | kwwiki | en | NULL | wikipedia | NULL | | kywiki | en | NULL | wikipedia | NULL | | ladwiki | en | NULL | wikipedia | NULL | | lawiki | en | NULL | wikipedia | NULL | | lbewiki | en | NULL | wikipedia | NULL | | lbwiki | en | NULL | wikipedia | NULL | | lezwiki | en | NULL | wikipedia | NULL | | lgwiki | en | NULL | wikipedia | NULL | | lijwiki | en | NULL | wikipedia | NULL | | liwiki | en | NULL | wikipedia | NULL | | lmowiki | en | NULL | wikipedia | NULL | | lnwiki | en | NULL | wikipedia | NULL | | lowiki | en | NULL | wikipedia | NULL | | lrcwiki | en | NULL | wikipedia | NULL | | ltgwiki | en | NULL | wikipedia | NULL | | ltwiki | en | NULL | wikipedia | NULL | | lvwiki | en | NULL | wikipedia | NULL | | maiwiki | en | NULL | wikipedia | NULL | | map_bmswiki | en | NULL | wikipedia | NULL | | mdfwiki | en | NULL | wikipedia | NULL | | mgwiki | en | NULL | wikipedia | NULL | | mhrwiki | en | NULL | wikipedia | NULL | | mhwiki | en | NULL | wikipedia | NULL | | minwiki | en | NULL | wikipedia | NULL | | miwiki | en | NULL | wikipedia | NULL | | mkwiki | en | NULL | wikipedia | NULL | | mlwiki | en | NULL | wikipedia | NULL | | mnwiki | en | NULL | wikipedia | NULL | | mowiki | en | NULL | wikipedia | NULL | | mrjwiki | en | NULL | wikipedia | NULL | | mrwiki | en | NULL | wikipedia | NULL | | mswiki | en | NULL | wikipedia | NULL | | mtwiki | en | NULL | wikipedia | NULL | | muswiki | en | NULL | wikipedia | NULL | | mwlwiki | en | NULL | wikipedia | NULL | | myvwiki | en | NULL | wikipedia | NULL | | mywiki | en | NULL | wikipedia | NULL | | mznwiki | en | NULL | wikipedia | NULL | | nahwiki | en | NULL | wikipedia | NULL | | napwiki | en | NULL | wikipedia | NULL | | nawiki | en | NULL | wikipedia | NULL | | ndswiki | en | NULL | wikipedia | NULL | | nds_nlwiki | en | NULL | wikipedia | NULL | | newiki | en | NULL | wikipedia | NULL | | newwiki | en | NULL | wikipedia | NULL | | ngwiki | en | NULL | wikipedia | NULL | | nlwiki | en | NULL | wikipedia | NULL | | nnwiki | en | NULL | wikipedia | NULL | | novwiki | en | NULL | wikipedia | NULL | | nowiki | en | NULL | wikipedia | NULL | | nrmwiki | en | NULL | wikipedia | NULL | | nsowiki | en | NULL | wikipedia | NULL | | nvwiki | en | NULL | wikipedia | NULL | | nywiki | en | NULL | wikipedia | NULL | | ocwiki | en | NULL | wikipedia | NULL | | omwiki | en | NULL | wikipedia | NULL | | orwiki | en | NULL | wikipedia | NULL | | oswiki | en | NULL | wikipedia | NULL | | pagwiki | en | NULL | wikipedia | NULL | | pamwiki | en | NULL | wikipedia | NULL | | papwiki | en | NULL | wikipedia | NULL | | pawiki | en | NULL | wikipedia | NULL | | pcdwiki | en | NULL | wikipedia | NULL | | pdcwiki | en | NULL | wikipedia | NULL | | pflwiki | en | NULL | wikipedia | NULL | | pihwiki | en | NULL | wikipedia | NULL | | piwiki | en | NULL | wikipedia | NULL | | plwiki | en | NULL | wikipedia | NULL | | pmswiki | en | NULL | wikipedia | NULL | | pnbwiki | en | NULL | wikipedia | NULL | | pntwiki | en | NULL | wikipedia | NULL | | pswiki | en | NULL | wikipedia | NULL | | ptwiki | en | NULL | wikipedia | NULL | | quwiki | en | NULL | wikipedia | NULL | | rmwiki | en | NULL | wikipedia | NULL | | rmywiki | en | NULL | wikipedia | NULL | | rnwiki | en | NULL | wikipedia | NULL | | roa_rupwiki | en | NULL | wikipedia | NULL | | roa_tarawiki | en | NULL | wikipedia | NULL | | rowiki | en | NULL | wikipedia | NULL | | ruewiki | en | NULL | wikipedia | NULL | | ruwiki | en | NULL | wikipedia | NULL | | rwwiki | en | NULL | wikipedia | NULL | | sahwiki | en | NULL | wikipedia | NULL | | sawiki | en | NULL | wikipedia | NULL | | scnwiki | en | NULL | wikipedia | NULL | | scowiki | en | NULL | wikipedia | NULL | | scwiki | en | NULL | wikipedia | NULL | | sdwiki | en | NULL | wikipedia | NULL | | sewiki | en | NULL | wikipedia | NULL | | sgwiki | en | NULL | wikipedia | NULL | | shwiki | en | NULL | wikipedia | NULL | | simplewiki | en | NULL | wikipedia | NULL | | siwiki | en | NULL | wikipedia | NULL | | skwiki | en | NULL | wikipedia | NULL | | slwiki | en | NULL | wikipedia | NULL | | smwiki | en | NULL | wikipedia | NULL | | snwiki | en | NULL | wikipedia | NULL | | sowiki | en | NULL | wikipedia | NULL | | sqwiki | en | NULL | wikipedia | NULL | | srnwiki | en | NULL | wikipedia | NULL | | srwiki | en | NULL | wikipedia | NULL | | sswiki | en | NULL | wikipedia | NULL | | stqwiki | en | NULL | wikipedia | NULL | | stwiki | en | NULL | wikipedia | NULL | | suwiki | en | NULL | wikipedia | NULL | | svwiki | en | NULL | wikipedia | NULL | | swwiki | en | NULL | wikipedia | NULL | | szlwiki | en | NULL | wikipedia | NULL | | tawiki | en | NULL | wikipedia | NULL | | tetwiki | en | NULL | wikipedia | NULL | | tewiki | en | NULL | wikipedia | NULL | | tgwiki | en | NULL | wikipedia | NULL | | thwiki | en | NULL | wikipedia | NULL | | tiwiki | en | NULL | wikipedia | NULL | | tkwiki | en | NULL | wikipedia | NULL | | tlwiki | en | NULL | wikipedia | NULL | | tnwiki | en | NULL | wikipedia | NULL | | towiki | en | NULL | wikipedia | NULL | | tpiwiki | en | NULL | wikipedia | NULL | | trwiki | en | NULL | wikipedia | NULL | | tswiki | en | NULL | wikipedia | NULL | | ttwiki | en | NULL | wikipedia | NULL | | tumwiki | en | NULL | wikipedia | NULL | | twwiki | en | NULL | wikipedia | NULL | | tyvwiki | en | NULL | wikipedia | NULL | | tywiki | en | NULL | wikipedia | NULL | | udmwiki | en | NULL | wikipedia | NULL | | ugwiki | en | NULL | wikipedia | NULL | | ukwiki | en | NULL | wikipedia | NULL | | urwiki | en | NULL | wikipedia | NULL | | uzwiki | en | NULL | wikipedia | NULL | | vecwiki | en | NULL | wikipedia | NULL | | vepwiki | en | NULL | wikipedia | NULL | | vewiki | en | NULL | wikipedia | NULL | | viwiki | en | NULL | wikipedia | NULL | | vlswiki | en | NULL | wikipedia | NULL | | vowiki | en | NULL | wikipedia | NULL | | warwiki | en | NULL | wikipedia | NULL | | wawiki | en | NULL | wikipedia | NULL | | wowiki | en | NULL | wikipedia | NULL | | wuuwiki | en | NULL | wikipedia | NULL | | xalwiki | en | NULL | wikipedia | NULL | | xhwiki | en | NULL | wikipedia | NULL | | xmfwiki | en | NULL | wikipedia | NULL | | yiwiki | en | NULL | wikipedia | NULL | | yowiki | en | NULL | wikipedia | NULL | | zawiki | en | NULL | wikipedia | NULL | | zeawiki | en | NULL | wikipedia | NULL | | zhwiki | en | NULL | wikipedia | NULL | | zh_classicalwiki | en | NULL | wikipedia | NULL | | zh_min_nanwiki | en | NULL | wikipedia | NULL | | zh_yuewiki | en | NULL | wikipedia | NULL | | zuwiki | en | NULL | wikipedia | NULL | +------------------+------+------+-----------+------+ 291 rows in set (0.01 sec)
Comment Actions
MariaDB [(none)]> SELECT dbname, lang, name, family, url FROM meta_p.wiki WHERE (url IS NULL OR name IS NULL) AND family != 'wikipedia'; +-------------+------+------+-------------+--------------------------+ | dbname | lang | name | family | url | +-------------+------+------+-------------+--------------------------+ | ukwikimedia | en | NULL | wikimedia | https://uk.wikimedia.org | | centralauth | en | NULL | centralauth | NULL | +-------------+------+------+-------------+--------------------------+ 2 rows in set (0.01 sec)
Comment Actions
The sitematrix API is also broken:
new mw.Api().get( { action: 'sitematrix', smsiteprop: 'dbname|url', smlangprop: 'site' } ) .done( function ( data ) { var sites = {}; $.each( data.sitematrix, function () { $.each( this.site || ( $.isArray( this ) ? this : [] ), function () { sites[this.dbname] = this.url; } ); } ); console.log( sites.enwiki ); } );
nullTools using those data, such as https://tools.wmflabs.org/dewkin/, do not work correctly.
Comment Actions
Ricordisamoa raised the priority of this task from "Unbreak Now!" to "Unbreak Before Now!".
Comment Actions
The sitematrix bug is tracked in T106963: SiteMatrix API returns unexpected null for 'wiki.url' field of Wikipedia project.
Comment Actions
Surely that level of priority is reserved for tasks in which the wikis are broken for most readers or something similarly catastrophic.
In general, if you think an issue is extremely urgent, you can join #wikimedia-operations on freenode and poke someone about it. Or you can try direct e-mail.
In this particular case, maybe awarding a "The World Burns" token would be sufficient to express your frustration?
Comment Actions
I didn't actually set any priority here.
In this particular case, maybe awarding a "The World Burns" token would be sufficient to express your frustration?
I'm sorry but I use "The World Burns" with a different meaning (as you can see in my Phabricator prophile).
Comment Actions
The World is not burning but we cannot effectively patrol lots of smaller wikis, so it's not burning but at least being filled with garbage ;)
Comment Actions
will there be any fix soon?
see: https://de.wikipedia.org/wiki/Benutzer:Flominator/Freiburg
Comment Actions
This was already fixed:
MariaDB [meta_p]> select * from wiki where url is null; +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------+ | dbname | lang | name | family | url | size | slice | is_closed | has_echo | has_flaggedrevs | has_visualeditor | has_wikidata | is_sensitive | +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------+ | centralauth | en | NULL | centralauth | NULL | 1 | s7.labsdb | 0 | 0 | 0 | 0 | 0 | 0 | +-------------+------+------+-------------+------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------+ 1 row in set (0.00 sec)
That's the only row which is supposed to be null.