Page MenuHomePhabricator

Drop Cassandra keyspaces for /page/references
Closed, ResolvedPublic

Description

The PCS /page/references endpoint will not be used and will be dropped shortly. This task is to drop the Cassandra keyspaces for the endpoint.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptWed, Mar 18, 7:22 PM

This has been deployed, so we can drop those key spaces!

This has been deployed, so we can drop those key spaces!

OK, let's dot all the "i"s, and cross the "t"s; To confirm:

Is this the correct list of keyspaces?

keyspaces
enwiki_T_references
others_T_references
wikipedia_T_references

These three do in fact appear to be completely inactive.

Reads/writes over 10 second sample
eevans@restbase1016:~$ diff <(nodetool-a tablestats -- "enwiki_T_references".data | grep -E "(Read|Write) Count: ") <(sleep 10; nodetool-a tablestats -- "enwiki_T_references".data | grep -E "(Read|Write) Count: ")
eevans@restbase1016:~$ diff <(nodetool-a tablestats -- "others_T_references".data | grep -E "(Read|Write) Count: ") <(sleep 10; nodetool-a tablestats -- "others_T_references".data | grep -E "(Read|Write) Count: ")
eevans@restbase1016:~$ diff <(nodetool-a tablestats -- "wikipedia_T_references".data | grep -E "(Read|Write) Count: ") <(sleep 10; nodetool-a tablestats -- "wikipedia_T_references".data | grep -E "(Read|Write) Count: ")
eevans@restbase1016:~$

If this all looks correct, I will apply the following:

drop_references.yaml
drop_enwiki_T_references:
  statement: |
    DROP KEYSPACE IF EXISTS "enwiki_T_references";

drop_others_T_references:
  statement: |
    DROP KEYSPACE IF EXISTS "others_T_references";

drop_wikipedia_T_references:
  statement: |
    DROP KEYSPACE IF EXISTS "wikipedia_T_references";
Eevans triaged this task as Medium priority.Wed, Mar 25, 9:33 PM

LGTM. Beta cluster has one as well

Mentioned in SAL (#wikimedia-operations) [2020-03-25T21:46:30Z] <urandom> dropping unused Cassandra keyspaces -- T248018

LGTM. Beta cluster has one as well

Oh yes, good catch; I dropped others_T_references from there as well

Ok, these keyspaces have been removed from production, dev, and deployment-prep. Out of an abundance of caution, I will leave this open until Friday, and close after cleaning up the snapshots.

Eevans closed this task as Resolved.Tue, Mar 31, 12:26 AM

Done.