Page MenuHomePhabricator

Remove old (a.k.a NG) Parsoid tables
Closed, ResolvedPublic0 Estimated Story Points

Description

We will soon be ready to stop using the old Parsoid tables. Concretely, once we stop relying on them as a fallback, we can drop the old, unused tables.

Beta

"others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04"
"others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"
"others_T_parsoid__ng_html"
"others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0"
"others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ"
"others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5"
"others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1"

Dev Cluster && Prod

"commons_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04"
"commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy"
"commons_T_parsoid__ng_html"
"commons_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0"
"commons_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLO"
"commons_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH"
"commons_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv"
"enwiki_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04"
"enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"
"enwiki_T_parsoid__ng_html"
"enwiki_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0"
"enwiki_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ"
"enwiki_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5"
"enwiki_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1"
"others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04"
"others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"
"others_T_parsoid__ng_html"
"others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0"
"others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ"
"others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5"
"others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1"
"wikipedia_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP"
"wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD"
"wikipedia_T_parsoid__ng_html"
"wikipedia_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWS"
"wikipedia_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJs"
"wikipedia_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PP"
"wikipedia_T_parsoid_stash_wikitextf0PBY8UXqY8Uui"

Event Timeline

mobrovac created this task.

Here are the statements to be executed.

beta.yaml
others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04:
  statement: DROP KEYSPACE "others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04";
others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8:
  statement: DROP KEYSPACE "others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8";
others_T_parsoid__ng_html:
  statement: DROP KEYSPACE "others_T_parsoid__ng_html";
others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0:
  statement: DROP KEYSPACE "others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0";
others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ:
  statement: DROP KEYSPACE "others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ";
others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5:
  statement: DROP KEYSPACE "others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5";
others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1:
  statement: DROP KEYSPACE "others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1";
prod.yaml
commons_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04:
  statement: DROP KEYSPACE "commons_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04";
commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy:
  statement: DROP KEYSPACE "commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy";
commons_T_parsoid__ng_html:
  statement: DROP KEYSPACE "commons_T_parsoid__ng_html";
commons_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0:
  statement: DROP KEYSPACE "commons_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0";
commons_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLO:
  statement: DROP KEYSPACE "commons_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLO";
commons_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH:
  statement: DROP KEYSPACE "commons_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH";
commons_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv:
  statement: DROP KEYSPACE "commons_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv";

enwiki_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04:
  statement: DROP KEYSPACE "enwiki_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04";
enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8:
  statement: DROP KEYSPACE "enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8";
enwiki_T_parsoid__ng_html:
  statement: DROP KEYSPACE "enwiki_T_parsoid__ng_html";
enwiki_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0:
  statement: DROP KEYSPACE "enwiki_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0";
enwiki_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ:
  statement: DROP KEYSPACE "enwiki_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ";
enwiki_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5:
  statement: DROP KEYSPACE "enwiki_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5";
enwiki_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1:
  statement: DROP KEYSPACE "enwiki_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1";

others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04:
  statement: DROP KEYSPACE "others_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP04";
others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8:
  statement: DROP KEYSPACE "others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8";
others_T_parsoid__ng_html:
  statement: DROP KEYSPACE "others_T_parsoid__ng_html";
others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0:
  statement: DROP KEYSPACE "others_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWSp0";
others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ:
  statement: DROP KEYSPACE "others_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJsLOQ";
others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5:
  statement: DROP KEYSPACE "others_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PPlH5";
others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1:
  statement: DROP KEYSPACE "others_T_parsoid_stash_wikitextf0PBY8UXqY8UuiDv1";

wikipedia_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP:
  statement: DROP KEYSPACE "wikipedia_T_parsoid__ng_4iO7iu2BPZmvx5_7kxNNNqVP";
wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD:
  statement: DROP KEYSPACE "wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD";
wikipedia_T_parsoid__ng_html:
  statement: DROP KEYSPACE "wikipedia_T_parsoid__ng_html";
wikipedia_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWS:
  statement: DROP KEYSPACE "wikipedia_T_parsoid__ngwEOh2HlqL6lr8QbNVKv1eSoWS";
wikipedia_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJs:
  statement: DROP KEYSPACE "wikipedia_T_parsoid_stash_dataWH8IDUS9SGI6LPpsJs";
wikipedia_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PP:
  statement: DROP KEYSPACE "wikipedia_T_parsoid_stash_htmlmXxc_uDhgnFQAdM8PP";
wikipedia_T_parsoid_stash_wikitextf0PBY8UXqY8Uui:
  statement: DROP KEYSPACE "wikipedia_T_parsoid_stash_wikitextf0PBY8UXqY8Uui";

LGTM, but let's not execute it until next week?

Mentioned in SAL (#wikimedia-operations) [2019-05-30T08:10:41Z] <mobrovac> drop old Parsoid tables from cassandra -- T223998

The corresponding keyspaces have been dropped. Resolving.