Page MenuHomePhabricator

Drop frwiki.archive_save table
Closed, ResolvedPublic

Description

I just found that on frwiki (s6) we have the following table:

root@db1061:/srv/sqldata/frwiki# ls -lh archive_save.*
-rw-rw---- 1 mysql mysql 9.0K Oct  7  2013 archive_save.frm
-rw-rw---- 1 mysql mysql 1.9G Nov  4  2013 archive_save.ibd
root@db2117.codfw.wmnet[frwiki]> select min(ar_timestamp),max(ar_timestamp) from archive_save limit 1;
+-------------------+-------------------+
| min(ar_timestamp) | max(ar_timestamp) |
+-------------------+-------------------+
| 20010608121056    | 20131104020448    |
+-------------------+-------------------+
1 row in set (2.60 sec)

I assume this is just a test, and can probably be deleted without any problems. It has not been written since 2013 and only exists on frwiki

Event Timeline

Marostegui moved this task from Triage to Pending comment on the DBA board.

Taken a temporary backup of this just in case:

root@cumin1001:/home/marostegui/T233187# ls -lh archive_save.sql
-rw-r--r-- 1 root root 945M Sep 23 14:46 archive_save.sql

Will drop this table tomorrow.

Mentioned in SAL (#wikimedia-operations) [2019-09-24T09:14:52Z] <marostegui> Drop table archive_save on frwiki T233187

This table has been dropped.