The restrictions tables were cleared out of RESTBase codebase, so they should be dropped from cassandra. Tables in prod/dev:
"enwiki_T_page__restrictions" "wikipedia_T_page__restrictions" "others_T_page__restrictions" "commons_T_page__restrictions"
Tables in beta cluster:
"others_T_page__restrictions"
Verified with nodetool that the tables are not used.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • Pchelolo | T194190 Infinite rerender loop in RESTBase | |||
| Restricted Task | |||||
| Resolved | • Pchelolo | T204752 Clean up restrictions tables in cassandra |
Confirmed; There are no reads/writes occurring on these keyspaces.
eevans@restbase1007:~$ for i in enwiki_T_page__restrictions wikipedia_T_page__restrictions others_T_page__restrictions commons_T_page__restrictions; do diff <(nodetool-a tablestats $i.data | egrep -E -A 4 "^Keyspace") <(sleep 10; nodetool-a tablestats $i.data | egrep -E -A 4 "^Keyspace"); done eevans@restbase1007:~$
The following will do it for the production cluster.
drop_enwiki_T_page__restrictions: comment: Obsolete. statement: | DROP KEYSPACE IF EXISTS "enwiki_T_page__restrictions" drop_wikipedia_T_page__restrictions: comment: Obsolete. statement: | DROP KEYSPACE IF EXISTS "wikipedia_T_page__restrictions" drop_others_T_page__restrictions: comment: Obsolete. statement: | DROP KEYSPACE IF EXISTS "others_T_page__restrictions" drop_commons_T_page__restrictions: comment: Obsolete. statement: | DROP KEYSPACE IF EXISTS "commons_T_page__restrictions"
Mentioned in SAL (#wikimedia-operations) [2018-10-03T12:54:39Z] <urandom> DROP unused RESTBase tables - T204752
Manually dropped others_T_page__restrictions in deployment-prep.
eevans@deployment-restbase01:~$ c-cqlsh default Connected to Test Cluster at 10.68.16.128:9042. [cqlsh 5.0.1 | Cassandra 3.11.2 | CQL spec 3.4.4 | Native protocol v4] Use HELP for help. cassandra@cqlsh> DROP KEYSPACE "others_T_page__restrictions"; cassandra@cqlsh>
hm... on restbase1007:
c-cqlsh a -e "describe keyspaces;" | grep restr "commons_T_page__restrictions"
And the dev cluster was forgotten.