[Wikidata-bugs] [Maniphest] T271382: Request creation of annotation VPS project

2021-01-14 Thread Bstorm
Bstorm closed this task as "Resolved". Bstorm added a comment. Project is created with default quotas. You should have access via Horizon <https://horizon.wikimedia.org> now. TASK DETAIL https://phabricator.wikimedia.org/T271382 EMAIL PREFERENCES https://phabricat

[Wikidata-bugs] [Maniphest] T271382: Request creation of annotation VPS project

2021-01-13 Thread Bstorm
Bstorm added a project: cloud-services-team (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T271382 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, DVrandecic, gengh, dcaro, Devnull, maher, GrounderUK, GeminiAgaloos

[Wikidata-bugs] [Maniphest] T271382: Request creation of annotation VPS project

2021-01-13 Thread Bstorm
Bstorm claimed this task. Bstorm moved this task from Inbox to Approved on the Cloud-VPS (Project-requests) board. Bstorm added a comment. Approved in weekly meeting TASK DETAIL https://phabricator.wikimedia.org/T271382 WORKBOARD https://phabricator.wikimedia.org/project/board/2875

[Wikidata-bugs] [Maniphest] T257405: wdreconcile.toolforge.org acting as though HTTP 502 Gateway errors are cached

2020-09-30 Thread Bstorm
Bstorm added a comment. In T257405#6505154 <https://phabricator.wikimedia.org/T257405#6505154>, @Pintoch wrote: > Yesterday the `https://wdreconcile.toolforge.org/` service returned 504 errors for all URLs (after a waiting time - they did not appear "cached"

[Wikidata-bugs] [Maniphest] T262550: Toolforge returns HTTP 502 error

2020-09-10 Thread Bstorm
Bstorm closed this task as "Resolved". Bstorm claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T262550 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, tfmorris, aborrero, RhinosF1, Bugreporter, Pintoch

[Wikidata-bugs] [Maniphest] T262550: Toolforge returns HTTP 502 error

2020-09-10 Thread Bstorm
Bstorm added a subtask: T262562: Fix the mis-named k8s service in tools project. TASK DETAIL https://phabricator.wikimedia.org/T262550 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, tfmorris, aborrero, RhinosF1, Bugreporter

[Wikidata-bugs] [Maniphest] T262550: Toolforge returns HTTP 502 error

2020-09-10 Thread Bstorm
Bstorm added a project: cloud-services-team (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T262550 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, tfmorris, aborrero, RhinosF1, Bugreporter, Pintoch, Aklapper

[Wikidata-bugs] [Maniphest] T262550: Toolforge returns HTTP 502 error

2020-09-10 Thread Bstorm
Bstorm added a comment. This was due to an outage caused by an issue with DNS cleanup and naming of the service. https://gerrit.wikimedia.org/r/c/operations/puppet/+/626399 should prevent it in the future and just to be sure, we have T262562: Fix the mis-named k8s service in tools project

[Wikidata-bugs] [Maniphest] T258709: Add nfs mount point to labstore for wdqs servers (wikibase dumps access)

2020-08-11 Thread Bstorm
Bstorm added a project: cloud-services-team (Kanban). Bstorm updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T258709 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Aklapper, Bstorm, ArielGlenn, dcausse, nskaggs

[Wikidata-bugs] [Maniphest] [Commented On] T208416: Check whether wikidata-dev project requires NFS or not

2020-05-05 Thread Bstorm
Bstorm added a comment. If the NFS isn't needed, then it'll become a task for WMCS to coordinate removing NFS from the project. Since it uses /home, that just requires a little communication and care. TASK DETAIL https://phabricator.wikimedia.org/T208416 EMAIL PREFERENCES https

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-04-06 Thread Bstorm
Bstorm added a comment. Ok, that look right? https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/586384 TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore, Bstorm Cc

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
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

[Wikidata-bugs] [Maniphest] [Edited] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui, WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez, darthmon_wmde, Nandana, sietec

[Wikidata-bugs] [Maniphest] [Unassigned] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm removed Bstorm as the assignee of this task. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, Marostegui, WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez, darthmon_wmde

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. Done with today's part. Openstack upgrades seem to have affected some bots, or I'd put it in SAL. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. labsdb1011 is fighting with me. Lots of wikidata queries going on there. I'll start killin'  TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui

[Wikidata-bugs] [Maniphest] [Edited] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui, WMDE-leszek, Aklapper, Addshore, Alter-paule, Beast1978, Un1tY, Phamhi, Hook696, Daryl

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. Look good now @Addshore and @Marostegui ? TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui, WMDE-leszek, Aklapper, Addshore, Alter-paule, Beast1978

[Wikidata-bugs] [Maniphest] [Triaged] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm triaged this task as "Medium" priority. Bstorm updated the task description. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui, WMDE-leszek, Aklapper, Addsh

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. Proposing a change to the description to match that TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Marostegui, WMDE-leszek, Aklapper, Addshore, Alter

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. Generally, anything that is "select *" is under the fullviews structure in our config as long as the table name is the same. I think that's healthy. That yaml file is hard enough to understand as is. TASK DETAIL https://phabricator.wikimedia.org/T248

[Wikidata-bugs] [Maniphest] [Commented On] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm added a comment. 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 patc

[Wikidata-bugs] [Maniphest] [Claimed] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm claimed this task. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez, darthmon_wmde, Nandana, sietec, Bstorm, Lahi, Gq86

[Wikidata-bugs] [Maniphest] [Updated] T248592: Move wb_terms data in cloud replicas to wb_terms_no_longer_updated

2020-03-26 Thread Bstorm
Bstorm edited projects, added cloud-services-team (Kanban); removed Cloud-Services. TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez

[Wikidata-bugs] [Maniphest] [Triaged] T189747: Toolforge node for constraint reports updating bot

2020-02-11 Thread Bstorm
Bstorm triaged this task as "Low" priority. TASK DETAIL https://phabricator.wikimedia.org/T189747 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Lea_Lacroix_WMDE, Jklamo, Mike_Peel, Ayack, Edgars2007, Lucas_Werkmeister_W

[Wikidata-bugs] [Maniphest] [Updated] T222349: Do not rate limit dumps from internal network

2019-12-06 Thread Bstorm
Bstorm added projects: Data-Services, cloud-services-team (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T222349 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: EBernhardson, Bstorm, ArielGlenn, Gehel, Aklapper, Phamhi, Hook696

[Wikidata-bugs] [Maniphest] [Commented On] T222349: Do not rate limit dumps from internal network

2019-12-06 Thread Bstorm
Bstorm added a comment. Ok, it took a bit of doing, but here's what I found: The limits that are in place are based on having a server that was on 10G Ethernet but with less RAM, etc. Interesting thing is that notes in tasks and git state that the problem was that while the pipe was fast

[Wikidata-bugs] [Maniphest] [Commented On] T222349: Do not rate limit dumps from internal network

2019-12-06 Thread Bstorm
Bstorm added a comment. It looks like the limit was last raised 5 years ago. I'll double check a couple things, but I suspect that's old stuff we can raise. TASK DETAIL https://phabricator.wikimedia.org/T222349 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel

[Wikidata-bugs] [Maniphest] [Commented On] T178722: Remove puppet class role::labs::lvm::mnt

2019-11-27 Thread Bstorm
Bstorm added a comment. It looks like only one instance still uses this: osmit-uno.osmit.eqiad.wmflabs in the osmit project. TASK DETAIL https://phabricator.wikimedia.org/T178722 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm

[Wikidata-bugs] [Maniphest] [Updated] T173777: ListeriaBot logs in 28000 times a day

2019-10-23 Thread Bstorm
Bstorm removed a project: cloud-services-team (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T173777 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Magnus, Aklapper, Cyberpower678, MaxSem, darthmon_wmde, DannyS712, Nandana

[Wikidata-bugs] [Maniphest] [Updated] T230247: Increase VCPU quota for wikidata-query project

2019-08-13 Thread Bstorm
Bstorm added a project: cloud-services-team (Kanban). TASK DETAIL https://phabricator.wikimedia.org/T230247 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, bd808, Aklapper, Smalyshev, darthmon_wmde, DannyS712, Nandana, JKSTNK

[Wikidata-bugs] [Maniphest] [Commented On] T230247: Increase VCPU quota for wikidata-query project

2019-08-13 Thread Bstorm
Bstorm added a comment. +1 approved TASK DETAIL https://phabricator.wikimedia.org/T230247 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Bstorm, bd808, Aklapper, Smalyshev, darthmon_wmde, DannyS712, Nandana, JKSTNK, Fheredia, AndyTan

[Wikidata-bugs] [Maniphest] [Unblock] T224403: Update Labs replication and views to include new schema tables

2019-06-19 Thread Bstorm
Bstorm closed subtask T225038: Add new schema tables as public views in labs as Resolved. TASK DETAIL https://phabricator.wikimedia.org/T224403 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Bstorm Cc: Andrew, Bstorm, Addshore, Ladsgroup

[Wikidata-bugs] [Maniphest] [Edited] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2019-02-04 Thread Bstorm
Bstorm updated the task description. (Show Details) CHANGES TO TASK DESCRIPTION...NOTE: this ticket originally asked for compatibility to be maintained by adding joins to the views for the page and revision table. This idea has been dropped due to performance issumodified due to performance issues

[Wikidata-bugs] [Maniphest] [Unblock] T206636: Provide a way to have test servers on real hardware, isolated from production for Wikidata Query Service

2018-10-16 Thread Bstorm
Bstorm closed subtask T207184: dumps mounts don't show up on eqiad1-r VMs as "Resolved". TASK DETAILhttps://phabricator.wikimedia.org/T206636EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Addshore, Andrew, Aklapper, Smalyshev, Gehe

[Wikidata-bugs] [Maniphest] [Closed] T207184: dumps mounts don't show up on eqiad1-r VMs

2018-10-16 Thread Bstorm
Bstorm closed this task as "Resolved". TASK DETAILhttps://phabricator.wikimedia.org/T207184EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: gerritbot, Gehel, Smalyshev, Aklapper, Addshore, Andrew, CucyNoiD, Nandana, NebulousIris, thifran

[Wikidata-bugs] [Maniphest] [Commented On] T207184: dumps mounts don't show up on eqiad1-r VMs

2018-10-16 Thread Bstorm
Bstorm added a comment. Re-exported after some manual puppet runs. If it's good on the clients, I'll close it.TASK DETAILhttps://phabricator.wikimedia.org/T207184EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: gerritbot, Gehel, Smalyshev, Aklapper

[Wikidata-bugs] [Maniphest] [Commented On] T207184: dumps mounts don't show up on eqiad1-r VMs

2018-10-16 Thread Bstorm
Bstorm added a comment. Scratch is universally exported. Maps has specific IPs listed. Dumps appears to be controlled via a hiera value. What's the correct IP range for this @Andrew ?TASK DETAILhttps://phabricator.wikimedia.org/T207184EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. Ok, scwiki now has the compatibility whatnot moved to separate tables. If that doesn't break a lot of tools for some reason by tomorrow, I probably should just go ahead and put up patches to depool servers to do the whole batch instead of waiting. Some tools are really

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. @jcrespo, looks great! I think that, since the work is already done anyway, with the slow development possible on some tools, having some compatibility views available should be helpful. I'm eager to remove some of the compatibility joins from the replicas (which is part

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. (we should test on deploy on a smaller db first). Any suggestions? scwiki perhaps? If it isn't breaking yet, then I could merge now, deploy to that db, and actually do a general rebuild of the views during the reboot depools.TASK DETAILhttps://phabricator.wikimedia.org

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. That sounds like a reasonable edit for the docs.TASK DETAILhttps://phabricator.wikimedia.org/T174047EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Stashbot, jcrespo, gerritbot, Bstorm, Tgr, bd808, Anomie, Aklapper, daniel

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. For that matter, will anything break if I deploy that now? Like is the compatibility joins in the current tables actually needed at this point?TASK DETAILhttps://phabricator.wikimedia.org/T174047EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-09-11 Thread Bstorm
Bstorm added a comment. @jcrespo I am prepared to push the patch I put up with the "_compat" tables to provide an easy fix for people with not-so-maintained but still important tools. I'm not sure I should NULL the fields on this ticket just yet? However, if we haven't communicated t

[Wikidata-bugs] [Maniphest] [Closed] T167154: Delete wikidata-ldf project on wmflabs

2018-08-02 Thread Bstorm
Bstorm closed this task as "Resolved".Bstorm added a comment. Deleted one server, two zones and the project.TASK DETAILhttps://phabricator.wikimedia.org/T167154EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Andrew, CristianCantoro

[Wikidata-bugs] [Maniphest] [Commented On] T167154: Delete wikidata-ldf project on wmflabs

2018-08-01 Thread Bstorm
Bstorm added a comment. Thanks!TASK DETAILhttps://phabricator.wikimedia.org/T167154EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Andrew, CristianCantoro, Aklapper, AndyTan, sietec, Zylc, Bstorm, 1978Gage2001, Lahi, aborrero, Gq86, Bsandipan

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Hide deprecated/unused fields on toolforge replica [MCR]

2018-07-24 Thread Bstorm
Bstorm added a comment. The patch I suggested above should be safe to apply right away, allowing maintainers to move to the _compat views, if they want to (maybe that could feature in the early stages of the communication plan), and when the columns need to be hidden, they can be hidden

[Wikidata-bugs] [Maniphest] [Commented On] T194239: Request creation of mcr-dev VPS project

2018-05-24 Thread Bstorm
Bstorm added a comment. That should be set now.TASK DETAILhttps://phabricator.wikimedia.org/T194239EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Bstorm, bd808, Tgr, daniel, aude, Addshore, Aklapper, Zylc, 1978Gage2001, Lahi, aborrero, PDrouin-WMF

[Wikidata-bugs] [Maniphest] [Commented On] T194239: Request creation of mcr-dev VPS project

2018-05-24 Thread Bstorm
Bstorm added a comment. Sure.TASK DETAILhttps://phabricator.wikimedia.org/T194239EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Bstorm, bd808, Tgr, daniel, aude, Addshore, Aklapper, Zylc, 1978Gage2001, Lahi, aborrero, PDrouin-WMF, Gq86

[Wikidata-bugs] [Maniphest] [Unblock] T192306: Create MCR test wiki on WM Cloud

2018-05-24 Thread Bstorm
Bstorm closed subtask T194239: Request creation of mcr-dev VPS project as "Resolved". TASK DETAILhttps://phabricator.wikimedia.org/T192306EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Tgr, BstormCc: aude, Tgr, bd808, CCicalese_WMF, Abit, Addshore

[Wikidata-bugs] [Maniphest] [Closed] T194239: Request creation of mcr-dev VPS project

2018-05-24 Thread Bstorm
Bstorm closed this task as "Resolved".Bstorm claimed this task. TASK DETAILhttps://phabricator.wikimedia.org/T194239EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Bstorm, bd808, Tgr, daniel, aude, Addshore, Aklapper, Zylc, 1978Gage

[Wikidata-bugs] [Maniphest] [Commented On] T194239: Request creation of mcr-dev VPS project

2018-05-24 Thread Bstorm
Bstorm added a comment. Project is created.TASK DETAILhttps://phabricator.wikimedia.org/T194239EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Bstorm, bd808, Tgr, daniel, aude, Addshore, Aklapper, Zylc, 1978Gage2001, Lahi, aborrero, PDrouin-WMF

[Wikidata-bugs] [Maniphest] [Commented On] T194239: Request creation of mcr-dev VPS project

2018-05-24 Thread Bstorm
Bstorm added a comment. Sorry, I'll take care of this today.TASK DETAILhttps://phabricator.wikimedia.org/T194239EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Bstorm, bd808, Tgr, daniel, aude, Addshore, Aklapper, Zylc, 1978Gage2001, Lahi, aborrero

[Wikidata-bugs] [Maniphest] [Unblock] T174045: DB schema migration for MCR

2018-05-09 Thread Bstorm
Bstorm closed subtask T184446: Configure Toolforge replica views and dumps for the new MCR tables as "Resolved". TASK DETAILhttps://phabricator.wikimedia.org/T174045EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: BstormCc: Jdforrester-WMF, MZMcBride

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Provide backwards compatibility views for toolforge replica [MCR]

2018-05-08 Thread Bstorm
Bstorm added a comment. This should be good to go until we are actually dropping columns. At that point, the views should change to not look at the old columns at all to construct the fake columns.TASK DETAILhttps://phabricator.wikimedia.org/T174047EMAIL PREFERENCEShttps

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Provide backwards compatibility views for toolforge replica [MCR]

2018-05-03 Thread Bstorm
Bstorm added a comment. So one last thing on this (with the exception of changes needed just before columns are removed). When I run some of the resulting queries from that patch, I noticed that the slots table does a full table scan. This one in particular (understanding that wiki is my local

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Provide backwards compatibility views for toolforge replica [MCR]

2018-04-20 Thread Bstorm
Bstorm added a comment. I'm messing around with these and making sure I understand right. I've been assuming this sort of thing is going to be a left join so that we get old stuff and new stuff. Should this be an inner join (actually filtering rows out, which is a bit more severe)? I mean

[Wikidata-bugs] [Maniphest] [Commented On] T174047: Provide backwards compatibility views for toolforge replica [MCR]

2018-04-19 Thread Bstorm
Bstorm added a comment. So we need to filter on role_name = 'main'? I want to make sure I understand that piece while I throw the views together for this.TASK DETAILhttps://phabricator.wikimedia.org/T174047EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences