Page MenuHomePhabricator

Update interwiki table on beta cluster
Closed, ResolvedPublic

Description

Wikis on the beta cluster are now at on the wmcloud domain

https://en.wikipedia.beta.wmcloud.org/wiki/Main_Page

The interwiki table still has wmflabs

http://en.wikipedia.beta.wmflabs.org

also is it supposed to be https? production uses https://en.wikipedia.org/wiki/$1

root@BETA[enwiki]> select * from interwiki where iw_prefix = 'en';
+-----------+----------------------------------------------+--------+-----------+----------+----------+
| iw_prefix | iw_url                                       | iw_api | iw_wikiid | iw_local | iw_trans |
+-----------+----------------------------------------------+--------+-----------+----------+----------+
| en        | http://en.wikipedia.beta.wmflabs.org/wiki/$1 |        |           |        1 |        0 |
+-----------+----------------------------------------------+--------+-----------+----------+----------+
NOTE: there also is the sites table that needs to be updated and reading_list_project (on wikishared)

Event Timeline

This blocks T400364 since the ReadingLists extension does.a reverse interwiki lookup to check if the project is valid and the reading list entry title is valid.

We also need to update the reading_list_project table

Note that we don't use that table...

https://noc.wikimedia.org/conf/highlight.php?file=interwiki-labs.php

'_wiki:en' => '1 https://en.wikipedia.beta.wmcloud.org/wiki/$1',

The interwiki table in production for the metawiki and enwiki databases is empty, so we probably should empty the beta cluster tables to remove this potential source of confusion.

reedy@deployment-deploy04:~$ foreachwiki sql.php /home/reedy/interwiki.sql
-----------------------------------------------------------------
aawiki
-----------------------------------------------------------------
aawiki:  stdClass Object
aawiki:  (
aawiki:      [count(*)] => 0
aawiki:  )
aawiki:  
-----------------------------------------------------------------
apiportalwiki
-----------------------------------------------------------------
apiportalwiki:  stdClass Object
apiportalwiki:  (
apiportalwiki:      [count(*)] => 0
apiportalwiki:  )
apiportalwiki:  
-----------------------------------------------------------------
arwiki
-----------------------------------------------------------------
arwiki:  stdClass Object
arwiki:  (
arwiki:      [count(*)] => 610
arwiki:  )
arwiki:  
-----------------------------------------------------------------
bnwiki
-----------------------------------------------------------------
bnwiki:  stdClass Object
bnwiki:  (
bnwiki:      [count(*)] => 0
bnwiki:  )
bnwiki:  
-----------------------------------------------------------------
cawiki
-----------------------------------------------------------------
cawiki:  stdClass Object
cawiki:  (
cawiki:      [count(*)] => 0
cawiki:  )
cawiki:  
-----------------------------------------------------------------
commonswiki
-----------------------------------------------------------------
commonswiki:  stdClass Object
commonswiki:  (
commonswiki:      [count(*)] => 610
commonswiki:  )
commonswiki:  
-----------------------------------------------------------------
crhwiki
-----------------------------------------------------------------
crhwiki:  stdClass Object
crhwiki:  (
crhwiki:      [count(*)] => 0
crhwiki:  )
crhwiki:  
-----------------------------------------------------------------
cswiki
-----------------------------------------------------------------
cswiki:  stdClass Object
cswiki:  (
cswiki:      [count(*)] => 0
cswiki:  )
cswiki:  
-----------------------------------------------------------------
dewiki
-----------------------------------------------------------------
dewiki:  stdClass Object
dewiki:  (
dewiki:      [count(*)] => 610
dewiki:  )
dewiki:  
-----------------------------------------------------------------
dewiktionary
-----------------------------------------------------------------
dewiktionary:  stdClass Object
dewiktionary:  (
dewiktionary:      [count(*)] => 0
dewiktionary:  )
dewiktionary:  
-----------------------------------------------------------------
enwiki
-----------------------------------------------------------------
enwiki:  stdClass Object
enwiki:  (
enwiki:      [count(*)] => 610
enwiki:  )
enwiki:  
-----------------------------------------------------------------
enwikibooks
-----------------------------------------------------------------
enwikibooks:  stdClass Object
enwikibooks:  (
enwikibooks:      [count(*)] => 609
enwikibooks:  )
enwikibooks:  
-----------------------------------------------------------------
enwikinews
-----------------------------------------------------------------
enwikinews:  stdClass Object
enwikinews:  (
enwikinews:      [count(*)] => 609
enwikinews:  )
enwikinews:  
-----------------------------------------------------------------
enwikiquote
-----------------------------------------------------------------
enwikiquote:  stdClass Object
enwikiquote:  (
enwikiquote:      [count(*)] => 609
enwikiquote:  )
enwikiquote:  
-----------------------------------------------------------------
enwikisource
-----------------------------------------------------------------
enwikisource:  stdClass Object
enwikisource:  (
enwikisource:      [count(*)] => 613
enwikisource:  )
enwikisource:  
-----------------------------------------------------------------
enwikiversity
-----------------------------------------------------------------
enwikiversity:  stdClass Object
enwikiversity:  (
enwikiversity:      [count(*)] => 609
enwikiversity:  )
enwikiversity:  
-----------------------------------------------------------------
enwikivoyage
-----------------------------------------------------------------
enwikivoyage:  stdClass Object
enwikivoyage:  (
enwikivoyage:      [count(*)] => 0
enwikivoyage:  )
enwikivoyage:  
-----------------------------------------------------------------
enwiktionary
-----------------------------------------------------------------
enwiktionary:  stdClass Object
enwiktionary:  (
enwiktionary:      [count(*)] => 609
enwiktionary:  )
enwiktionary:  
-----------------------------------------------------------------
eowiki
-----------------------------------------------------------------
eowiki:  stdClass Object
eowiki:  (
eowiki:      [count(*)] => 610
eowiki:  )
eowiki:  
-----------------------------------------------------------------
eswiki
-----------------------------------------------------------------
eswiki:  stdClass Object
eswiki:  (
eswiki:      [count(*)] => 0
eswiki:  )
eswiki:  
-----------------------------------------------------------------
eswikibooks
-----------------------------------------------------------------
eswikibooks:  stdClass Object
eswikibooks:  (
eswikibooks:      [count(*)] => 0
eswikibooks:  )
eswikibooks:  
-----------------------------------------------------------------
fawiki
-----------------------------------------------------------------
fawiki:  stdClass Object
fawiki:  (
fawiki:      [count(*)] => 0
fawiki:  )
fawiki:  
-----------------------------------------------------------------
foundationwiki
-----------------------------------------------------------------
foundationwiki:  stdClass Object
foundationwiki:  (
foundationwiki:      [count(*)] => 0
foundationwiki:  )
foundationwiki:  
-----------------------------------------------------------------
frwiki
-----------------------------------------------------------------
frwiki:  stdClass Object
frwiki:  (
frwiki:      [count(*)] => 49
frwiki:  )
frwiki:  
-----------------------------------------------------------------
frwiktionary
-----------------------------------------------------------------
frwiktionary:  stdClass Object
frwiktionary:  (
frwiktionary:      [count(*)] => 0
frwiktionary:  )
frwiktionary:  
-----------------------------------------------------------------
hewiki
-----------------------------------------------------------------
hewiki:  stdClass Object
hewiki:  (
hewiki:      [count(*)] => 610
hewiki:  )
hewiki:  
-----------------------------------------------------------------
hewiktionary
-----------------------------------------------------------------
hewiktionary:  stdClass Object
hewiktionary:  (
hewiktionary:      [count(*)] => 0
hewiktionary:  )
hewiktionary:  
-----------------------------------------------------------------
hiwiki
-----------------------------------------------------------------
hiwiki:  stdClass Object
hiwiki:  (
hiwiki:      [count(*)] => 0
hiwiki:  )
hiwiki:  
-----------------------------------------------------------------
incubatorwiki
-----------------------------------------------------------------
incubatorwiki:  stdClass Object
incubatorwiki:  (
incubatorwiki:      [count(*)] => 0
incubatorwiki:  )
incubatorwiki:  
-----------------------------------------------------------------
jawiki
-----------------------------------------------------------------
jawiki:  stdClass Object
jawiki:  (
jawiki:      [count(*)] => 0
jawiki:  )
jawiki:  
-----------------------------------------------------------------
kowiki
-----------------------------------------------------------------
kowiki:  stdClass Object
kowiki:  (
kowiki:      [count(*)] => 0
kowiki:  )
kowiki:  
-----------------------------------------------------------------
loginwiki
-----------------------------------------------------------------
loginwiki:  stdClass Object
loginwiki:  (
loginwiki:      [count(*)] => 0
loginwiki:  )
loginwiki:  
-----------------------------------------------------------------
metawiki
-----------------------------------------------------------------
metawiki:  stdClass Object
metawiki:  (
metawiki:      [count(*)] => 610
metawiki:  )
metawiki:  
-----------------------------------------------------------------
nlwiki
-----------------------------------------------------------------
nlwiki:  stdClass Object
nlwiki:  (
nlwiki:      [count(*)] => 0
nlwiki:  )
nlwiki:  
-----------------------------------------------------------------
plwikivoyage
-----------------------------------------------------------------
plwikivoyage:  stdClass Object
plwikivoyage:  (
plwikivoyage:      [count(*)] => 0
plwikivoyage:  )
plwikivoyage:  
-----------------------------------------------------------------
ruwiki
-----------------------------------------------------------------
ruwiki:  stdClass Object
ruwiki:  (
ruwiki:      [count(*)] => 0
ruwiki:  )
ruwiki:  
-----------------------------------------------------------------
simplewiki
-----------------------------------------------------------------
simplewiki:  stdClass Object
simplewiki:  (
simplewiki:      [count(*)] => 610
simplewiki:  )
simplewiki:  
-----------------------------------------------------------------
sqwiki
-----------------------------------------------------------------
sqwiki:  stdClass Object
sqwiki:  (
sqwiki:      [count(*)] => 610
sqwiki:  )
sqwiki:  
-----------------------------------------------------------------
srwiki
-----------------------------------------------------------------
srwiki:  stdClass Object
srwiki:  (
srwiki:      [count(*)] => 0
srwiki:  )
srwiki:  
-----------------------------------------------------------------
svwiki
-----------------------------------------------------------------
svwiki:  stdClass Object
svwiki:  (
svwiki:      [count(*)] => 0
svwiki:  )
svwiki:  
-----------------------------------------------------------------
test2wiki
-----------------------------------------------------------------
test2wiki:  stdClass Object
test2wiki:  (
test2wiki:      [count(*)] => 0
test2wiki:  )
test2wiki:  
-----------------------------------------------------------------
testwiki
-----------------------------------------------------------------
testwiki:  stdClass Object
testwiki:  (
testwiki:      [count(*)] => 610
testwiki:  )
testwiki:  
-----------------------------------------------------------------
ukwiki
-----------------------------------------------------------------
ukwiki:  stdClass Object
ukwiki:  (
ukwiki:      [count(*)] => 0
ukwiki:  )
ukwiki:  
-----------------------------------------------------------------
viwiki
-----------------------------------------------------------------
viwiki:  stdClass Object
viwiki:  (
viwiki:      [count(*)] => 0
viwiki:  )
viwiki:  
-----------------------------------------------------------------
votewiki
-----------------------------------------------------------------
votewiki:  stdClass Object
votewiki:  (
votewiki:      [count(*)] => 0
votewiki:  )
votewiki:  
-----------------------------------------------------------------
wikidatawiki
-----------------------------------------------------------------
wikidatawiki:  stdClass Object
wikidatawiki:  (
wikidatawiki:      [count(*)] => 0
wikidatawiki:  )
wikidatawiki:  
-----------------------------------------------------------------
zhwiki
-----------------------------------------------------------------
zhwiki:  stdClass Object
zhwiki:  (
zhwiki:      [count(*)] => 0
zhwiki:  )
zhwiki:  
-----------------------------------------------------------------
zhwikivoyage
-----------------------------------------------------------------
zhwikivoyage:  stdClass Object
zhwikivoyage:  (
zhwikivoyage:      [count(*)] => 0
zhwikivoyage:  )
zhwikivoyage:

Mentioned in SAL (#wikimedia-cloud) [2025-07-25T22:25:38Z] <Reedy> truncate all interwiki tables T400488

bd808 assigned this task to Reedy.
bd808 moved this task from To Triage to Backlog on the Beta-Cluster-Infrastructure board.

The "fix" implemented here was not what @aude asked for, but we were able to find and correct a configuration diff from production.