Bstorm added a comment.
In T248592#6003342 <https://phabricator.wikimedia.org/T248592#6003342>, @Addshore wrote: > wb_terms in the cloud replicas for wikidatawiki_p is a view though? Or did I get that wrong? > If it is a view then we just remove that view and create a new table in wikidatawiki_p called wb_terms that is empty? > If it is not a view then we must do some more things. We don't have any real tables in the *_p databases, and we should keep it that way because I think it very unwise to complicate the wikireplicas more than they already are. Only views are in those DBs, and they point at tables in the corresponding "non_p" databases. That's the whole basis of the design at the moment. I also do not wish to create things that exist outside the scripted system re: the views. Theoretically, many tasks around the views should be do-able by the WMCS on-call without a lot of fuss. The wikidatawiki_p database should just have views in it that roughly match the description in the puppet-controlled yaml file. Otherwise, it'll get broken by a script run one way or another. > In T248592#6002790 <https://phabricator.wikimedia.org/T248592#6002790>, @Bstorm wrote: > >> I would prefer the table rename be done, then the views can be adjusted so that wb_terms and wb_terms_no_longer_updated both are in the "fullviews" key in the yaml. That will make it clear there is no filtering or other whatnot going on. >> In the patch I put up both wb_terms and wb_terms_no_longer_updated will point to wb_terms until the rename and empty table. > > If this is the desired approach then we can coordinate this on Monday (or chat tomorrow Friday) :) Sure! TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: JAllemandou, Bstorm, Marostegui, WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez, darthmon_wmde, Nandana, sietec, Lahi, Gq86, GoranSMilovanovic, Chicocvenancio, Allthingsgo, QZanden, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331, Jay8g, bd808, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs