Page MenuHomePhabricator

Prepare and check storage layer for pcmwiki
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui added a subscriber: Marostegui.

Let us know when the wiki is created so we can sanitize it.

Zabe changed the edit policy from "Custom Policy" to "All Users".Jun 21 2022, 11:35 AM
Urbanecm added a subscriber: Urbanecm.

The database was just created.

Mentioned in SAL (#wikimedia-operations) [2022-08-17T14:18:07Z] <marostegui> Redact new wikis guwwiktionary pcmwiki bjnwiktionary T312214 T310879 T309056

Redacted on codfw.
Waiting for replication to catch up s5 to go for eqiad (there's a schema change running on the sanitarium master)

Sanitized on eqiad, but still waiting for clouddb1021 to catch up (18h behind)

All done, ready for views creation.

Mentioned in SAL (#wikimedia-operations) [2023-01-12T09:47:14Z] <btullis@cumin1001> Added views for new wiki: pcmwiki T310879

I believe that this is now complete.

tullis@tools-sgebastion-10:~$ sql pcmwiki "select * from page limit 2"
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       1 |              0 | Main_Pej        |                0 |           0 |   0.4287915033 | 20230105004350 | 20230105004837     |       17442 |       19 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-url |                0 |           1 | 0.078457951077 | 20220817111906 | 20220817111210     |           2 |      109 | wikitext           | NULL      |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+