Page MenuHomePhabricator

Prepare and check storage layer for bjnwiktionary
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Marostegui triaged this task as Medium priority.Jul 6 2022, 1:15 PM
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".Jul 8 2022, 4:41 PM
Urbanecm subscribed.

The database was just created.

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.

T312214#8164447 sounds like the outstanding step is to setup the views for the Toolforge replicas. Is that correct?

T312214#8164447 sounds like the outstanding step is to setup the views for the Toolforge replicas. Is that correct?

Yes

Hi, can we get this done? It's been blocking T318506 for months now

Sincere apologies. This slipped between the cracks. I will prioritize it now.

I believe that this is now working. Apologies once again for the delay @Bennylin .

btullis@tools-sgebastion-10:~$ sql bjnwiktionary
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 720619355
Server version: 10.4.22-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [bjnwiktionary_p]> 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 | Laman_Tatambaian |                0 |           0 | 0.873903978848 | 20230108095816 | 20230108095601     |        7632 |    17435 | wikitext           | NULL      |
|       2 |              8 | Sitesupport-url  |                0 |           1 | 0.649533464439 | 20220817120425 | 20220817120425     |           2 |      110 | wikitext           | NULL      |
+---------+----------------+------------------+------------------+-------------+----------------+----------------+--------------------+-------------+----------+--------------------+-----------+
2 rows in set (0.002 sec)

MariaDB [bjnwiktionary_p]>

Please do let me know if it doesn't work as you expect and I will investigate.

Mentioned in SAL (#wikimedia-operations) [2023-01-12T16:08:51Z] <btullis@cumin1001> Added views for new wiki: bjnwiktionary T312214

I believe that this is now working. Apologies once again for the delay @Bennylin .
...
Please do let me know if it doesn't work as you expect and I will investigate.

Much appreciated! Thanks!