Page MenuHomePhabricator

Enable access to Wikipedia Tulu (tcywiki) on labs replicas
Closed, ResolvedPublic

Description

This is a subtask of T140898: Create Wikipedia Tulu, but not a blocker.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

I have first to apply the filters on production side.

jcrespo moved this task from Triage to Done on the DBA board.
jcrespo added subscribers: yuvipanda, Krenair, chasemp.
$ for host in labsdb1001.eqiad.wmnet labsdb1003.eqiad.wmnet; do mysql -h $host -e "SELECT count(*) FROM tcywiki.user WHERE user_password <> ''"; done
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
$ for host in labsdb1001.eqiad.wmnet labsdb1003.eqiad.wmnet; do mysql -h $host -e "SELECT count(*) FROM tcywiki.recentchanges WHERE rc_ip <> ''"; done
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
$ for host in labsdb1001.eqiad.wmnet labsdb1003.eqiad.wmnet; do mysql -h $host -e "SELECT count(*) FROM tcywiki.revision WHERE rev_text_id <> 0"; done
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+

Production side of things is done. Now it comes the part that is not yet clear; where we have some scripts that may not be fully finished.

I will add @chasemp @yuvipanda and @Krenair to ask for the status of that and how to proceed.

krenair@tools-bastion-03:~$ sql tcywiki
ERROR 1049 (42000): Unknown database 'tcywiki_p'

Needs a maintain-replicas run

Note that this can be done by any member of the 'ops' group in puppet, it does not need to wait for my maintain-replicas rewrite. See T138450

chasemp claimed this task.

_p view variant should be good to go