Drop section-offsets keyspaces
Closed, ResolvedPublic

Description

Work has been done to remove the section.offsets table from RESTBase.

When it's deployed, we need to drop section-offsets keyspaces in labs, development, and production clusters

Labs:

"others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"
"others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"

Dev:

"others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"
"wikipedia_T_parsoid_stash_section2ACMDK1DRzacK9n"
"commons_T_parsoid_stash_section2ACMDK1DRzacK9nUB"
"enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"
"wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP"
"commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t"
"enwiki_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"
"others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"

Prod:

"others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"
"wikipedia_T_parsoid_stash_section2ACMDK1DRzacK9n"
"commons_T_parsoid_stash_section2ACMDK1DRzacK9nUB"
"enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"
"wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP"
"commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t"
"enwiki_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"
"others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"

We need to verify there's no read/write activity on them as well via nodetool.

Clarakosi created this task.Nov 2 2018, 6:32 PM
Pchelolo updated the task description. (Show Details)

The code has been deployed. This could be applied in production now.

Keyspace drops
drop_others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"

drop_wikipedia_T_parsoid_stash_section2ACMDK1DRzacK9n:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "wikipedia_T_parsoid_stash_section2ACMDK1DRzacK9n"

drop_commons_T_parsoid_stash_section2ACMDK1DRzacK9nUB:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "commons_T_parsoid_stash_section2ACMDK1DRzacK9nUB"

drop_enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"

drop_wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP"

drop_commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t"

drop_enwiki_T_parsoid_stash_section2ACMDK1DRzacK9nUB3:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "enwiki_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"

drop_others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3:
  comment: |
    https://phabricator.wikimedia.org/T208616
  statement: |
    DROP KEYSPACE IF EXISTS "others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3"
Eevans added a comment.EditedWed, Nov 14, 5:10 PM
eevans@restbase1007:~/cassandra-schema-nodejs$ for i in `cat t.txt`; do echo "$i"; diff -u <(nodetool-a tablestats $i | grep -A 2 "Read Count") <(sleep 10; nodetool-a tablestats $i | grep -A 2 "Read Count"); done
others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq
wikipedia_T_parsoid_stash_section2ACMDK1DRzacK9n
commons_T_parsoid_stash_section2ACMDK1DRzacK9nUB
enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq
wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP
commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t
enwiki_T_parsoid_stash_section2ACMDK1DRzacK9nUB3
others_T_parsoid_stash_section2ACMDK1DRzacK9nUB3
eevans@restbase1007:~/cassandra-schema-nodejs$
Eevans triaged this task as Normal priority.Thu, Nov 15, 8:01 PM

Mentioned in SAL (#wikimedia-operations) [2018-11-15T20:04:34Z] <urandom> dropping disused keyspaces -- T208616

Eevans closed this task as Resolved.Thu, Nov 15, 11:38 PM

Done.