Yes, a communication would be great (including, on this thread). As it stands right now, the linktargets table is incomplete on the wikis I checked. For instance, this fawiki query <https://superset.wmcloud.org/superset/sqllab/?savedQueryId=71> returns 388 results but the equivalent query <https://superset.wmcloud.org/superset/sqllab/?savedQueryId=72> using linktargets only returns 4 results. My bots are using quite a few queries that rely on pl_title or pl_namespace. I'd rather spend time update the queries only after the linktargets table is fully updated, so I can compare the results of old and new queries as a validation step.
On Fri, Jan 19, 2024 at 4:08 PM Xabriel Collazo Mojica < xcoll...@wikimedia.org> wrote: > Amir, > > To summarize: the only wiki that will soon get the old columns dropped is > commonswiki and the rest of the wikis will keep the old columns until the > migration to the new columns is complete on all wikis, at which time there > will be a communication. > > Is this correct? > > Thanks, > -- > Xabriel J. Collazo Mojica (he/him, pronunciation > <https://commons.wikimedia.org/wiki/File:Xabriel_Collazo_Mojica_-_pronunciation.ogg> > ) > Sr Software Engineer > Wikimedia Foundation > > On Wed, Jan 17, 2024 at 9:57 PM Ben Kurtovic <wikipedia.ear...@gmail.com> > wrote: > >> Thanks for the clear explanation, this gives more context for the urgency. >> >> > On Jan 17, 2024, at 3:04 PM, Amir Sarabadani <asarabad...@wikimedia.org> >> wrote: >> > What about only dropping it from Commons to reduce the risk of outage >> and leave the rest until the all are finished (or all except Wikidata)? >> You'd have to write something for the new schema regardless. >> >> If we insist on dropping now, I do think treating Commons as special and >> waiting until all are finished before dropping the rest would be better. >> It’s a small difference but potentially makes the logic simpler to >> implement. >> >> Ben / Earwig >> _______________________________________________ >> Cloud mailing list -- cloud@lists.wikimedia.org >> List information: >> https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ >> > > _______________________________________________ > Cloud mailing list -- cloud@lists.wikimedia.org > List information: > https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ >
_______________________________________________ Cloud mailing list -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/