Page MenuHomePhabricator

Prepare and check storage layer for trwikivoyage
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

LSobanski triaged this task as Medium priority.Jan 6 2021, 1:20 PM
LSobanski moved this task from Triage to Blocked on the DBA board.
LSobanski added a subscriber: LSobanski.

Thanks, let us know when the database is created, so we can sanitize it.

Mentioned in SAL (#wikimedia-operations) [2021-01-12T08:40:32Z] <marostegui> Sanitize bclwiktionary diqwiktionary niawiki niawiktionary diqwiktionary on db1124 db2094 db11154 T270280 T270276 T270414 T270410 T271261

Mentioned in SAL (#wikimedia-operations) [2021-01-12T08:40:32Z] <marostegui> Sanitize bclwiktionary diqwiktionary niawiki niawiktionary diqwiktionary on db1124 db2094 db11154 T270280 T270276 T270414 T270410 T271261

Ignore this, this database isn't created, just a mistake of copying the ticket numbers.

Urbanecm added a subscriber: Urbanecm.

Thanks, let us know when the database is created, so we can sanitize it.

The database was just created

Mentioned in SAL (#wikimedia-operations) [2021-01-19T14:19:32Z] <marostegui> Sanitize trwikivoyage on db2094:3315, db1124:3315, db1154:3315 T271261

This has been sanitized.
Tested with my user and everything works fine, ran check private data on clouddb1013 and 1020 which back clean.
Now waiting for labsdb* hosts to finish it (it will take a lot longer) before sending to WMCS for the views creation.

Marostegui moved this task from In progress to Done on the DBA board.
Marostegui added subscribers: Bstorm, aborrero, nskaggs.

This is ready for the views creation.

  • _p database created
  • grant added to labsdbuser role

Please cloud-services-team create the views on labsdb1009, 1010, 1011, clouddb1016:3315 and clouddb1020:3315

@Bstorm @nskaggs I have been pinged about the views for this - do you have some estimation on when they'll be created?

I'm surprised this is here! I thought I'd cleared all these out. Sorry.

I'll try to make sure it gets done this week.

MariaDB [trwikivoyage_p]> select * from page limit 2;
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title      | page_restrictions | page_is_redirect | page_is_new | page_random    | page_touched   | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
|       1 |              0 | Anasayfa        |                   |                0 |           0 |  0.01011649632 | 20210216205535 | 20210216211207     |        5720 |     1332 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-url |                   |                0 |           1 | 0.879980654111 | 20210119132732 | 20210119132732     |           2 |      108 | wikitext           | NULL      |
+---------+----------------+-----------------+-------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
2 rows in set (0.00 sec)

Done.