Maniphest T197789

Schema upgrades to add headers field
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• Pchelolo
	Jun 20 2018, 12:23 PM

Description

The following schema alternations should be done in production to support PR #1007

ALTER TABLE "others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"."data" ADD "headers" text;
ALTER TABLE "others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"."data" ADD "headers" text;
ALTER TABLE "others_T_parsoid__ng_html"."data" ADD "headers" text;
ALTER TABLE "others_T_mobile__ng_remaining"."data" ADD "headers" text;
ALTER TABLE "others_T_mobile__ng_lead"."data" ADD "headers" text;
ALTER TABLE "commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy"."data" ADD "headers" text;
ALTER TABLE "commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t"."data" ADD "headers" text;
ALTER TABLE "commons_T_parsoid__ng_html"."data" ADD "headers" text;
ALTER TABLE "commons_T_mobile__ng_remaining"."data" ADD "headers" text;
ALTER TABLE "commons_T_mobile__ng_lead"."data" ADD "headers" text;
ALTER TABLE "wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD"."data" ADD "headers" text;
ALTER TABLE "wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP"."data" ADD "headers" text;
ALTER TABLE "wikipedia_T_parsoid__ng_html"."data" ADD "headers" text;
ALTER TABLE "wikipedia_T_mobile__ng_remaining"."data" ADD "headers" text;
ALTER TABLE "wikipedia_T_mobile__ng_lead"."data" ADD "headers" text;
ALTER TABLE "enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"."data" ADD "headers" text;
ALTER TABLE "enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"."data" ADD "headers" text;
ALTER TABLE "enwiki_T_parsoid__ng_html"."data" ADD "headers" text;
ALTER TABLE "enwiki_T_mobile__ng_remaining"."data" ADD "headers" text;
ALTER TABLE "enwiki_T_mobile__ng_lead"."data" ADD "headers" text;

The following alternations should be done in beta:

ALTER TABLE "others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"."data" ADD "headers" text;
ALTER TABLE "others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"."data" ADD "headers" text;
ALTER TABLE "others_T_parsoid__ng_html"."data" ADD "headers" text;
ALTER TABLE "others_T_mobile__ng_remaining"."data" ADD "headers" text;
ALTER TABLE "others_T_mobile__ng_lead"."data" ADD "headers" text;

Related Objects
Search...

Status	Assigned	Task
Stalled	None	T324931 Clean up open RESTBase related tickets
In Progress	None	T262315 <CORE TECHNOLOGY> API Migration & RESTBase Sunset
Resolved	DAlangi_WMF	T324678 Migrate proton (chromium-render) away from restbase
Open	None	T167603 Any Chinese Wiki's projects about "Download as PDF" can not auto change to Simplified Chinese or Traditional Chinese
Resolved	ovasileva	T147553 [EPIC] Page previews broken on many projects
Open	ovasileva	T244262 [Epic] Enable page previews and reference previews as a beta feature on all projects
Open	None	T111231 Page previews for Wikidata
Invalid	None	T148854 Use RESTBase for zhwiki
Resolved	• Pchelolo	T188164 Popups don‘t support language variant conversion and {{lang}} template
Resolved	• mobrovac	T190689 FY17/18 Q4 Program 7 Services Goal: Language variants support
Resolved	• mobrovac	T197789 Schema upgrades to add headers field

Event Timeline

• Pchelolo triaged this task as High priority.Jun 20 2018, 12:23 PM

• Pchelolo created this task.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 20 2018, 12:23 PM

• Pchelolo updated the task description. (Show Details)Jun 20 2018, 12:26 PM

• Pchelolo updated the task description. (Show Details)Jun 25 2018, 11:19 AM

Mentioned in SAL (#wikimedia-operations) [2018-06-25T12:04:33Z] <mobrovac> Restbase: Add the "headers" field to Cassandra schemae in production for T197789

• mobrovac updated the task description. (Show Details)Jun 25 2018, 1:10 PM

The changes have been applied to all of our environments (beta, dev, prod) and all of the instances agree on the schemae, so resolving.

For posterity, this is the YAML used to apply the commands in dev and prod:

others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8:
  statement: ALTER TABLE "others_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"."data" ADD "headers" text;
others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq:
  statement: ALTER TABLE "others_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"."data" ADD "headers" text;
others_T_parsoid__ng_html:
  statement: ALTER TABLE "others_T_parsoid__ng_html"."data" ADD "headers" text;
others_T_mobile__ng_remaining:
  statement: ALTER TABLE "others_T_mobile__ng_remaining"."data" ADD "headers" text;
others_T_mobile__ng_lead:
  statement: ALTER TABLE "others_T_mobile__ng_lead"."data" ADD "headers" text;
commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy:
  statement: ALTER TABLE "commons_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy"."data" ADD "headers" text;
commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t:
  statement: ALTER TABLE "commons_T_parsoid__ng_section9wYKz1EvijuZtgPVP5t"."data" ADD "headers" text;
commons_T_parsoid__ng_html:
  statement: ALTER TABLE "commons_T_parsoid__ng_html"."data" ADD "headers" text;
commons_T_mobile__ng_remaining:
  statement: ALTER TABLE "commons_T_mobile__ng_remaining"."data" ADD "headers" text;
commons_T_mobile__ng_lead:
  statement: ALTER TABLE "commons_T_mobile__ng_lead"."data" ADD "headers" text;
wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD:
  statement: ALTER TABLE "wikipedia_T_parsoid__ng_data2pfX88WDfxDffCFHoTUD"."data" ADD "headers" text;
wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP:
  statement: ALTER TABLE "wikipedia_T_parsoid__ng_section9wYKz1EvijuZtgPVP"."data" ADD "headers" text;
wikipedia_T_parsoid__ng_html:
  statement: ALTER TABLE "wikipedia_T_parsoid__ng_html"."data" ADD "headers" text;
wikipedia_T_mobile__ng_remaining:
  statement: ALTER TABLE "wikipedia_T_mobile__ng_remaining"."data" ADD "headers" text;
wikipedia_T_mobile__ng_lead:
  statement: ALTER TABLE "wikipedia_T_mobile__ng_lead"."data" ADD "headers" text;
enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8:
  statement: ALTER TABLE "enwiki_T_parsoid__ng_data2pfX88WDfxDffCFHoTUDoy8"."data" ADD "headers" text;
enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq:
  statement: ALTER TABLE "enwiki_T_parsoid__ng_section9wYKz1EvijuZtgPVP5tq"."data" ADD "headers" text;
enwiki_T_parsoid__ng_html:
  statement: ALTER TABLE "enwiki_T_parsoid__ng_html"."data" ADD "headers" text;
enwiki_T_mobile__ng_remaining:
  statement: ALTER TABLE "enwiki_T_mobile__ng_remaining"."data" ADD "headers" text;
enwiki_T_mobile__ng_lead:
  statement: ALTER TABLE "enwiki_T_mobile__ng_lead"."data" ADD "headers" text;

• Vvjjkkii renamed this task from Schema upgrades to add headers field to 6kaaaaaaaa.Jul 1 2018, 1:02 AM

• Vvjjkkii reopened this task as Open.

• Vvjjkkii removed • mobrovac as the assignee of this task.

• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).

• Vvjjkkii updated the task description. (Show Details)

• Vvjjkkii removed a subscriber: Aklapper.

• mobrovac renamed this task from 6kaaaaaaaa to Schema upgrades to add headers field.Jul 1 2018, 10:21 AM

• mobrovac closed this task as Resolved.

• mobrovac claimed this task.

• mobrovac removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.

• mobrovac updated the task description. (Show Details)

• mobrovac unsubscribed.

Schema upgrades to add headers fieldClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Schema upgrades to add headers field
Closed, ResolvedPublic
Actions

Related Objects
Search...