Page MenuHomePhabricator

Remove old (a.k.a NG) Parsoid tables
Closed, ResolvedPublic0 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 triaged this task as Normal priority.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 21 2019, 12:24 PM

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?

mobrovac claimed this task.

Beta keyspaces have been dropped. Prod to follow next week.

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

mobrovac closed this task as Resolved.

The corresponding keyspaces have been dropped. Resolving.