Page MenuHomePhabricator

Prepare and check storage layer for aswikiquote
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Ladsgroup changed the task status from Open to Stalled.Oct 21 2022, 3:19 PM
Ladsgroup moved this task from Triage to Blocked on the DBA board.

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

no storage it's in 100 edit system

Ladsgroup edited subscribers, added: Marostegui, Aklapper; removed: Mhab_Zdan1.
Urbanecm subscribed.

The database has been created. This should now be ready.

Zabe changed the edit policy from "Custom Policy" to "All Users".Jan 4 2023, 2:15 PM
Marostegui triaged this task as Medium priority.
Marostegui added a subscriber: BTullis.

Sanitized. Database _p and user grants created.
Ready for views creation.

Mentioned in SAL (#wikimedia-operations) [2023-01-12T17:08:38Z] <btullis@cumin1001> Added views for new wiki: aswikiquote T321294

I believe that this is now complete.

btullis@tools-sgebastion-10:~$ sql aswikiquote "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 | বেটুপাত               |                0 |           0 | 0.790142468368 | 20230108101627 | 20230108101757     |        7145 |       66 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-url       |                0 |           1 | 0.351912867518 | 20230104122443 | 20230104122443     |           2 |      107 | wikitext           | NULL      |
+---------+----------------+-----------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+