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

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 18 2019, 6:30 AM
Marostegui triaged this task as Normal priority.Sep 18 2019, 6:30 AM
Marostegui moved this task from Triage to Next 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.

Marostegui moved this task from Next to In progress on the DBA board.Tue, Sep 24, 9:14 AM

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

Marostegui closed this task as Resolved.Tue, Sep 24, 9:15 AM

This table has been dropped.