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

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

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.

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.