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 subscribed.

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 subscribed.

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      |
+---------+----------------+-----------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+