Page MenuHomePhabricator

Create new tables: cx_significant_edits and cx_section_translation
Closed, ResolvedPublicBUG REPORT

Description

Create new tables for SectionTranslation in ContentTranslation extension:

  • cx_section_translation (/srv/mediawiki-staging/php-1.38.0-wmf.26/extensions/ContentTranslation/sql/section-translations.sql)
  • cx_significant_edits (/srv/mediawiki-staging/php-1.38.0-wmf.26/extensions/ContentTranslation/sql/significant-edits.sql) and
  • testwiki (s3)
  • production (x1)

Event Timeline

KartikMistry renamed this task from Create cx_section_translation table to Create new tables: cx_significant_edits and cx_section_translation.Feb 23 2022, 1:11 PM
KartikMistry updated the task description. (Show Details)

Change 765556 had a related patch set uploaded (by Nik Gkountas; author: Nik Gkountas):

[mediawiki/extensions/ContentTranslation@master] SX entrypoints: Autogenerate sql file for cx_significant_edits table

https://gerrit.wikimedia.org/r/765556

Change 765556 merged by jenkins-bot:

[mediawiki/extensions/ContentTranslation@master] SX entrypoints: Autogenerate sql file for cx_significant_edits table

https://gerrit.wikimedia.org/r/765556

Marostegui moved this task from Triage to Refine on the DBA board.
Marostegui subscribed.

Do these need to go to x1 (wikishared)? I am asking cause the other cx table do live there (as well as on s3 where testwiki live).
Lastly, for those living in s3, are they ok if they get replicated to our public wiki replicas hosts or do they need to be private?

Do these need to go to x1 (wikishared)? I am asking cause the other cx table do live there (as well as on s3 where testwiki live).
Lastly, for those living in s3, are they ok if they get replicated to our public wiki replicas hosts or do they need to be private?

All production tables for ContentTranslation are on x1 (wikishared). Only testwiki ContentTranslation tables are on S3 (see: https://phabricator.wikimedia.org/T263417#6498244), so testwiki requires separate deployment for tables on S3.

Sounds good, if the tables are also public, then you should be good to go and you can deploy them anytime that works for you.

This should be schedule to deploy once all changes are in Production.

KartikMistry changed the task status from Open to In Progress.Mar 16 2022, 7:13 AM
KartikMistry claimed this task.

Mentioned in SAL (#wikimedia-operations) [2022-03-16T07:15:22Z] <urbanecm> Create testwiki.cx_significant_edits and testwiki.cx_section_translation at s3 (T302371; mwscript sql.php --wiki=testwiki /srv/mediawiki-staging/php-1.38.0-wmf.26/extensions/ContentTranslation/sql/{section-translations,significant-edits}.sql))

Mentioned in SAL (#wikimedia-operations) [2022-03-21T07:08:29Z] <urbanecm> Create wikishared.cx_significant_edits and wikishared.cx_section_translation at x1 (T302371; mwscript sql.php --wiki=aawiki --wikidb=wikishared --cluster=extension1 /srv/mediawiki-staging/php-1.38.0-wmf.26/extensions/ContentTranslation/sql/{section-translations,significant-edits}.sql))