Page MenuHomePhabricator

Drop WikiGrok tables from production
Closed, ResolvedPublic

Description

This extension has been undeployed and archived. Two years later, any data in its tables has lost any meaningfulness.

So far, I've found it on enwiki, testwiki and wikidata:

[enwiki]> show tables like 'wikigrok%';
+------------------------------+
| Tables_in_enwiki (wikigrok%) |
+------------------------------+
| wikigrok_claims              |
| wikigrok_questions           |
| wikigrok_responses           |
+------------------------------+
3 rows in set (0.00 sec)

[wikidatawiki]> show tables like 'wikigrok%';
+------------------------------------+
| Tables_in_wikidatawiki (wikigrok%) |
+------------------------------------+
| wikigrok_claims                    |
| wikigrok_responses                 |
+------------------------------------+

[testwiki]> show tables like 'wikigrok%';
+--------------------------------+
| Tables_in_testwiki (wikigrok%) |
+--------------------------------+
| wikigrok_questions             |
+--------------------------------+

Data size:

[enwiki]> select count(*) from wikigrok_questions;
+----------+
| count(*) |
+----------+
|   334918 |
+----------+

[wikidatawiki]> select count(*) from wikigrok_claims union select count(*) from wikigrok_responses;
+----------+
| count(*) |
+----------+
|     3333 |
|     2672 |
+----------+

[testwiki]> select count(*) from wikigrok_questions;
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.24 sec)

Event Timeline

Mentioned in SAL (#wikimedia-operations) [2017-08-02T10:18:17Z] <marostegui> Rename wikigrok tables on enwiki on db1089 - T172020

Marostegui moved this task from Backlog to In progress on the DBA board.
Marostegui subscribed.

This tables exists on:

s1: enwiki
s3: test2wiki, testwiki, testwikidatawiki (mostly empty tables)
s5: wikidatawiki

I have backup'ed them on:

root@dbstore1001:/srv/tmp/T172020# pwd
/srv/tmp/T172020
root@dbstore1001:/srv/tmp/T172020# ls -lh
total 87M
-rw-r--r-- 1 root root  86M Aug  2 10:03 s1.sql
-rw-r--r-- 1 root root 1.6K Aug  2 10:13 s3.tar.gz
-rw-r--r-- 1 root root 613K Aug  2 10:15 s5.sql

I have also renamed those tables on db1089 and will leave them renamed for a few days to make sure nothing breaks.

root@PRODUCTION s1 slave[enwiki]> show tables like 'T172%';
+----------------------------+
| Tables_in_enwiki (T172%)   |
+----------------------------+
| T172020_wikigrok_claims    |
| T172020_wikigrok_questions |
| T172020_wikigrok_responses |
+----------------------------+
3 rows in set (0.00 sec)

To revert this change just connect to db1089 and run:

set session sql_log_bin=0;
rename table T172020_wikigrok_claims to wikigrok_claims;
rename table T172020_wikigrok_questions to wikigrok_questions;
rename table T172020_wikigrok_responses to wikigrok_responses;

Mentioned in SAL (#wikimedia-operations) [2017-08-16T08:37:24Z] <marostegui> Drop wikigrok tables from s1, s3 and s5 - T172020

Dropped from the places it existed