Run FlowUpdateRevContentModelFromOccupyPages.php in production
Closed, ResolvedPublic

Description

This is from https://gerrit.wikimedia.org/r/#/c/230370/ and can be run on all wikis tomorrow (or later), after 1.26wmf19 or later is on all WMF wikis.

Beta:

mattflaschen@deployment-bastion:~$ foreachwiki extensions/Flow/maintenance/FlowUpdateRevContentModelFromOccupyPages.php
-----------------------------------------------------------------
aawiki
-----------------------------------------------------------------
aawiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
arwiki
-----------------------------------------------------------------
arwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
cawiki
-----------------------------------------------------------------
cawiki:  WARNING: Skipped "Viquipèdia_Discussió:Flow" because it does not exist
cawiki:  WARNING: Skipped "Viquipèdia_Discussió:Flow/proves" because it does not exist
cawiki:  WARNING: Skipped "Viquipèdia:La_taverna/Tecnicismes" because it does not exist
cawiki:  WARNING: Skipped "Viquipèdia_Discussió:La_taverna/Tecnicismes" because it does not exist
cawiki:  Completed batch.
cawiki:  
cawiki:  Set content model for 0 pages; skipped 4 pages.
-----------------------------------------------------------------
commonswiki
-----------------------------------------------------------------
commonswiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
deploymentwiki
-----------------------------------------------------------------
deploymentwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
dewiki
-----------------------------------------------------------------
dewiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
en_rtlwiki
-----------------------------------------------------------------
en_rtlwiki:  WARNING: Skipped "Talk:Flow" because it does not exist
en_rtlwiki:  Completed batch.
en_rtlwiki:  
en_rtlwiki:  Set content model for 0 pages; skipped 1 pages.
-----------------------------------------------------------------
enwiki
-----------------------------------------------------------------
enwiki:  Set content model for "Talk:Flow_QA"
enwiki:  Set content model for "Talk:Flow"
enwiki:  Completed batch.
enwiki:  
enwiki:  Set content model for 2 pages; skipped 0 pages.
-----------------------------------------------------------------
enwikibooks
-----------------------------------------------------------------
enwikibooks:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
enwikinews
-----------------------------------------------------------------
enwikinews:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
enwikiquote
-----------------------------------------------------------------
enwikiquote:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
enwikisource
-----------------------------------------------------------------
enwikisource:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
enwikiversity
-----------------------------------------------------------------
enwikiversity:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
enwiktionary
-----------------------------------------------------------------
enwiktionary:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
eowiki
-----------------------------------------------------------------
eowiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
eswiki
-----------------------------------------------------------------
eswiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
fawiki
-----------------------------------------------------------------
fawiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
hewiki
-----------------------------------------------------------------
hewiki:  Set content model for "שיחת_ויקיפדיה:זרימה"
hewiki:  Completed batch.
hewiki:  
hewiki:  Set content model for 1 pages; skipped 0 pages.
-----------------------------------------------------------------
hiwiki
-----------------------------------------------------------------
hiwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
jawiki
-----------------------------------------------------------------
jawiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
kowiki
-----------------------------------------------------------------
kowiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
loginwiki
-----------------------------------------------------------------
loginwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
metawiki
-----------------------------------------------------------------
metawiki:  WARNING: Skipped "Talk:Flow/Developer_test_page" because it does not exist
metawiki:  Completed batch.
metawiki:  
metawiki:  Set content model for 0 pages; skipped 1 pages.
-----------------------------------------------------------------
ruwiki
-----------------------------------------------------------------
ruwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
simplewiki
-----------------------------------------------------------------
simplewiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
sqwiki
-----------------------------------------------------------------
sqwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
testwiki
-----------------------------------------------------------------
testwiki:  WARNING: Skipped "Talk:Flow_QA" because it does not exist
testwiki:  WARNING: Skipped "Talk:Sandbox" because it does not exist
testwiki:  WARNING: Skipped "Wikipedia:Co-op/Mentorship_match" because it does not exist
testwiki:  WARNING: Skipped "Wikipedia_talk:Co-op/Person4" because it does not exist
testwiki:  WARNING: Skipped "Wikipedia_talk:Co-op/Mentor4" because it does not exist
testwiki:  Completed batch.
testwiki:  
testwiki:  Set content model for 0 pages; skipped 5 pages.
-----------------------------------------------------------------
ukwiki
-----------------------------------------------------------------
ukwiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
wikidatawiki
-----------------------------------------------------------------
wikidatawiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
zerowiki
-----------------------------------------------------------------
zerowiki:  Set content model for 0 pages; skipped 0 pages.
-----------------------------------------------------------------
zhwiki
-----------------------------------------------------------------
zhwiki:  Set content model for 0 pages; skipped 0 pages.

I spot-checked the database afterwards and it looked good.

Mattflaschen-WMF added a comment.EditedAug 20 2015, 9:30 PM

Run in production.

There are five pages that didn't exist:

The cawiki one is Flow anyway because of the namespace.

cawiki: WARNING: Skipped "Viquipèdia_Discussió:La_taverna/Tecnicismes" because it does not exist
mediawikiwiki: WARNING: Skipped "Talk:Cite-from-id" because it does not exist

And some from testwiki:

testwiki:  WARNING: Skipped "Wikipedia:Co-op/Mentorship_match" because it does not exist
testwiki:  WARNING: Skipped "Wikipedia_talk:Co-op/Person4" because it does not exist
testwiki: WARNING: Skipped "Wikipedia_talk:Co-op/Mentor4" because it does not exist

P1912

Catrope set Security to None.

Not sure if it's relevant:

There is no results - http://quarry.wmflabs.org/query/4877

use enwiki_p;
SELECT page_id, page_namespace, page_title, page_content_model, rev_content_model FROM page JOIN revision ON rev_page = page_latest WHERE page_namespace = 1 AND page_title IN ('Flow', 'Flow_QA');

Resultset (0 rows)

rev_page = page_id gives only wikitext http://quarry.wmflabs.org/query/4879

SELECT page_id, page_namespace, page_title, page_content_model, rev_content_model FROM page JOIN revision ON rev_page = page_id WHERE page_namespace = 1 AND page_title IN ('Flow', 'Flow_QA');

Resultset (5 rows) Download data
Search:

page_idpage_namespacepage_titlepage_content_modelrev_content_model
71307841Flowwikitext
71307841Flowwikitext
71307841Flowwikitext
71307841Flowwikitext
71307841Flowwikitext

Not sure if it's relevant:

There is no results - http://quarry.wmflabs.org/query/4877

Could you cross-check it against https://gerrit.wikimedia.org/r/#/c/228271/2/wmf-config/InitialiseSettings.php (pages listed on left side)?

Neither Talk:Flow nor Talk:Flow_QA are Flow (and the second does not exist) on production English Wikipedia, because those pages are reserved for discussion of the actual articles Flow and Flow QA (and we don't have any Wikipedia article talk pages Flow in production) (Flow QA also does not exist on English Wikipedia production).

There are/were Flow occupied pages (they're still there, but technically they no longer use 'occupation') on English Wikipedia production, though, such as https://en.wikipedia.org/wiki/Wikipedia_talk:WikiProject_Hampshire . See my first link.

DannyH closed this task as Resolved.Aug 26 2015, 5:33 PM
DannyH added a subscriber: DannyH.