CINXE.COM

<!DOCTYPE html><html><head><meta charset="UTF-8" /><title>⚓ T224440 Migrate GUC to actor database table</title><meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=yes" /><link rel="mask-icon" color="#3D4B67" href="https://phab.wmfusercontent.org/res/phabricator/db699fe1/rsrc/favicons/mask-icon.svg" /><link rel="apple-touch-icon" sizes="76x76" href="https://phab.wmfusercontent.org/file/data/wai6mh2gkrssonesklmm/PHID-FILE-jiixbumihmhuzz2paeut/favicon" /><link rel="apple-touch-icon" sizes="120x120" href="https://phab.wmfusercontent.org/file/data/a3izriz5azyzso4bnueg/PHID-FILE-ps6cpmki336a7zc3oqjn/favicon" /><link rel="apple-touch-icon" sizes="152x152" href="https://phab.wmfusercontent.org/file/data/o2jxp55a4p46ytynsfng/PHID-FILE-rug6ohtqrwvnunh5kj4x/favicon" /><link rel="icon" id="favicon" href="https://phab.wmfusercontent.org/file/data/ylbeoktf43zmd3loe435/PHID-FILE-ahr5qqrmgg3kjvzhpv4k/favicon" /><meta name="referrer" content="no-referrer" /><link rel="stylesheet" type="text/css" href="https://phab.wmfusercontent.org/res/defaultX/phabricator/45b62efe/core.pkg.css" /><link rel="stylesheet" type="text/css" href="https://phab.wmfusercontent.org/res/defaultX/phabricator/35995d6d/maniphest.pkg.css" /><link rel="stylesheet" type="text/css" href="https://phab.wmfusercontent.org/res/defaultX/phabricator/666e25ad/rsrc/css/phui/phui-badge.css" /><script type="text/javascript" src="https://phab.wmfusercontent.org/res/defaultX/phabricator/98e6504a/rsrc/externals/javelin/core/init.js"></script></head><body class="device-desktop platform-windows phui-theme-blue"><div class="main-page-frame" id="main-page-frame"><div id="phabricator-standard-page" class="phabricator-standard-page"><div class="phabricator-main-menu phabricator-main-menu-background" id="UQ0_74"><a class=" phabricator-core-user-menu phabricator-core-user-mobile-menu" href="#" role="button" data-sigil="phui-dropdown-menu" data-meta="0_255"><span class="aural-only">Page Menu</span><span class="visual-only phui-icon-view phui-font-fa fa-bars" data-meta="0_256" aria-hidden="true"></span><span class="caret"></span></a><a class="phabricator-main-menu-search-button phabricator-expand-application-menu" data-sigil="jx-toggle-class" data-meta="0_254"><span class="phabricator-menu-button-icon phui-icon-view phui-font-fa fa-search" id="UQ0_129"></span></a><a class="phabricator-main-menu-brand" href="/"><span class="aural-only">Home</span><span class="phabricator-main-menu-project-logo" style="background-size: 40px 40px; background-position: 0 0; background-image: url(https://phab.wmfusercontent.org/file/data/ki2yptiznxwthixxdwas/PHID-FILE-be4byvg2akyovi3g33wq/logo)"></span><span class="phabricator-wordmark">Phabricator</span></a><ul class="phui-list-view phabricator-search-menu"><li class="phui-list-item-view phui-list-item-type-link phabricator-main-menu-search"><div class="" data-sigil=""><form action="/search/" method="POST"><input type="hidden" name="__csrf__" value="B@ocpniiki4fbddba8add0de83" /><input type="hidden" name="__form__" value="1" /><div class="phabricator-main-menu-search-container"><input type="text" name="query" id="UQ0_130" autocomplete="off" accesskey="F" autocorrect="off" autocapitalize="off" spellcheck="false" /><button id="UQ0_132" class="phui-icon-view phui-font-fa fa-search"><span class="aural-only">Search</span></button><button class="button dropdown has-icon phui-button-default phabricator-main-menu-search-dropdown" id="UQ0_133" data-sigil="global-search-dropdown" data-meta="0_257"><span class="aural-only">Configure Global Search</span><span class="visual-only phui-icon-view phui-font-fa fa-globe" data-sigil="global-search-dropdown-icon" data-meta="0_258" aria-hidden="true"></span><span class="caret"></span></button><input type="hidden" name="search:scope" value="all" data-sigil="global-search-dropdown-input" /><input type="hidden" id="UQ0_134" name="search:application" value="PhabricatorManiphestApplication" data-sigil="global-search-dropdown-app" /><input type="hidden" name="search:primary" value="true" /><div id="UQ0_131" class="phabricator-main-menu-search-target"></div></div></form></div></li></ul><a class=" phabricator-core-login-button" href="https://phabricator.wikimedia.org/auth/start/?next=%2FT224440" role="button"><div class="phui-button-text">Log In</div></a></div><div id="phabricator-standard-page-body" class="phabricator-standard-page-body"><div class="phui-crumbs-view phui-crumbs-border"><div class="phui-crumbs-actions"><a href="/maniphest/task/edit/nocreate/" class="phui-crumbs-action" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-plus-square" data-meta="0_259" aria-hidden="true"></span><span class="phui-crumbs-action-name">Create Task</span></a></div><a href="/maniphest/" class="phui-crumb-view phui-crumb-has-icon"><span class="visual-only phui-icon-view phui-font-fa fa-anchor" data-meta="0_260" aria-hidden="true"></span><span class="phui-crumb-name"> Maniphest</span> </a><span class="visual-only phui-icon-view phui-font-fa fa-angle-right phui-crumb-divider phui-crumb-view" data-meta="0_261" aria-hidden="true"></span><span class="phui-crumb-view phabricator-last-crumb"><span class="phui-crumb-name"> T224440</span> </span></div><div class="phui-two-column-view phui-side-column-right "><div class="phui-two-column-container"><div class="phui-two-column-header"><div class="phui-header-shell phui-header-tall "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header"><span class="visual-only phui-icon-view phui-font-fa fa-check-square-o red phui-header-icon" data-meta="0_250" aria-hidden="true"></span>Migrate GUC to actor database table</span><div class="phui-header-subheader"><span class="phui-tag-view phui-tag-type-shade phui-tag-indigo phui-tag-shade phui-tag-icon-view "><span class="phui-tag-core "><span class="visual-only phui-icon-view phui-font-fa fa-check-square-o" data-meta="0_253" aria-hidden="true"></span>Closed, Resolved</span></span><span class="policy-header-callout"><span class="visual-only phui-icon-view phui-font-fa fa-globe bluegrey" data-meta="0_252" aria-hidden="true"></span><a class="policy-link" href="/policy/explain/PHID-TASK-p5s46hkyr6uopn4kov5u/view/" data-sigil="workflow">Public</a></span></div></div><div class="phui-header-col3"><div class="phui-header-action-links"><a class="button button-grey has-icon has-text phui-button-default phui-mobile-menu msl phui-header-action-link" href="#" role="button" data-sigil="phui-dropdown-menu" data-meta="0_248"><span class="visual-only phui-icon-view phui-font-fa fa-bars" data-meta="0_249" aria-hidden="true"></span><div class="phui-button-text">Actions</div></a></div></div></div></h1></div></div><div class="phui-two-column-content"><div class="phui-two-column-row grouped"><div class="phui-side-column"><div class=""><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-two-column-properties"><ul class="phabricator-action-list-view " id="UQ0_0"><li id="UQ0_45" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/maniphest/task/edit/224440/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-pencil grey phabricator-action-view-icon" data-meta="0_219" aria-hidden="true"></span>Edit Task</a></li><li id="UQ0_52" class="phabricator-action-view phabricator-action-view-submenu phabricator-action-view-href action-has-icon" style="" data-sigil="phui-submenu" data-meta="0_221"><a href="#" class="phabricator-action-view-item" data-sigil="keep-open"><span class="visual-only phui-icon-view phui-font-fa fa-anchor phabricator-action-view-icon" data-meta="0_220" aria-hidden="true"></span>Edit Related Tasks...<span class="caret-right" id="UQ0_46"></span></a></li><li id="UQ0_47" class="phabricator-action-view phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/maniphest/task/subtask/224440/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-level-down phabricator-action-view-icon" data-meta="0_222" aria-hidden="true"></span>Create Subtask</a></li><li id="UQ0_48" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-parent/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-chevron-circle-up grey phabricator-action-view-icon" data-meta="0_223" aria-hidden="true"></span>Edit Parent Tasks</a></li><li id="UQ0_49" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-subtask/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-chevron-circle-down grey phabricator-action-view-icon" data-meta="0_224" aria-hidden="true"></span>Edit Subtasks</a></li><li id="UQ0_50" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.merge-in/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-compress grey phabricator-action-view-icon" data-meta="0_225" aria-hidden="true"></span>Merge Duplicates In</a></li><li id="UQ0_51" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.close-as-duplicate/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-times grey phabricator-action-view-icon" data-meta="0_226" aria-hidden="true"></span>Close As Duplicate</a></li><li id="UQ0_61" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-submenu phabricator-action-view-href action-has-icon" style="" data-sigil="phui-submenu" data-meta="0_228"><a href="#" class="phabricator-action-view-item" data-sigil="keep-open"><span class="visual-only phui-icon-view phui-font-fa fa-link grey phabricator-action-view-icon" data-meta="0_227" aria-hidden="true"></span>Edit Related Objects...<span class="caret-right" id="UQ0_58"></span></a></li><li id="UQ0_59" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-commit/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-code grey phabricator-action-view-icon" data-meta="0_229" aria-hidden="true"></span>Edit Commits</a></li><li id="UQ0_60" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style="display: none; margin-left: 16px;"><a href="/search/rel/task.has-mock/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-camera-retro grey phabricator-action-view-icon" data-meta="0_230" aria-hidden="true"></span>Edit Mocks</a></li><li id="UQ0_65" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><form action="/subscriptions/add/PHID-TASK-p5s46hkyr6uopn4kov5u/" method="POST" data-sigil="workflow"><input type="hidden" name="__csrf__" value="B@ocpniiki4fbddba8add0de83" /><input type="hidden" name="__form__" value="1" /><button class="phabricator-action-view-item"><span class="visual-only phui-icon-view phui-font-fa fa-plus-circle grey phabricator-action-view-icon" data-meta="0_231" aria-hidden="true"></span>Subscribe</button></form></li><li id="UQ0_67" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/subscriptions/mute/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-volume-up grey phabricator-action-view-icon" data-meta="0_232" aria-hidden="true"></span>Mute Notifications</a></li><li id="UQ0_69" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/wmf/escalate-task/224440/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-eye-slash grey phabricator-action-view-icon" data-meta="0_233" aria-hidden="true"></span>Protect as security issue</a></li><li id="UQ0_71" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/token/give/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-trophy grey phabricator-action-view-icon" data-meta="0_234" aria-hidden="true"></span>Award Token</a></li><li id="UQ0_73" class="phabricator-action-view phabricator-action-view-disabled phabricator-action-view-href action-has-icon" style=""><a href="/flag/edit/PHID-TASK-p5s46hkyr6uopn4kov5u/" class="phabricator-action-view-item" data-sigil="workflow"><span class="visual-only phui-icon-view phui-font-fa fa-flag grey phabricator-action-view-icon" data-meta="0_235" aria-hidden="true"></span>Flag For Later</a></li></ul><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Assigned To</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ojwbfntu5tqpwhaoiqhk/PHID-FILE-lqnvzvmxt6cyf37tlcpx/profile)" href="/p/MusikAnimal/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/MusikAnimal/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_236">MusikAnimal</a></td></tr></tbody></table></div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Authored By</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-with-content"><td rowspan="2" class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" href="/p/Krinkle/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_237">Krinkle</a></td></tr><tr><td class="phui-curtain-object-ref-view-epoch-cell"><span class="screen-only">May 27 2019, 6:09 PM</span><span class="print-only" aria-hidden="true">2019-05-27 18:09:43 (UTC+0)</span></td></tr></tbody></table></div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Tags</div><div class="phui-curtain-panel-body"><ul class="phabricator-handle-tag-list "><li class="phabricator-handle-tag-list-item"><a href="/tag/tool-global-user-contributions/" class="phui-tag-view phui-tag-type-shade phui-tag-blue phui-tag-shade phui-tag-icon-view " data-sigil="hovercard" data-meta="0_239"><span class="phui-tag-core "><span class="visual-only phui-icon-view phui-font-fa fa-briefcase" data-meta="0_238" aria-hidden="true"></span>Tool-Global-user-contributions</span></a> <a href="/project/board/766/" class="maniphest-board-link">(Confirmed Problem)</a></li></ul></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Referenced Files</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-list-view-empty">None</div></div></div></div><div class="phui-curtain-panel "><div class="phui-curtain-panel-header">Subscribers</div><div class="phui-curtain-panel-body"><div class="phui-curtain-object-ref-list-view "><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/2k47tvkka236nmpz22pc/PHID-FILE-h42cqpdrg4yr7egelavj/profile)" href="/p/Aklapper/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Aklapper/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_240">Aklapper</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/umdix2irqa7pv7fxkwvx/PHID-FILE-7ejbs3mgx7c3zvejqpix/alphanumeric_aleo-white_C.png-_648d72-0%2C0%2C0%2C0.png)" href="/p/Count_Count/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Count_Count/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_241">Count_Count</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/247abt7phqlbitgglyxa/PHID-FILE-tx36db6dprvfuxu72bcj/alphanumeric_aleo-white_D.png-_ec9da1-0%2C0%2C0%2C0.png)" href="/p/Daimona/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Daimona/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_242">Daimona</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/v6locq3etwigatuxsjjf/PHID-FILE-xllcxsdw3rhajdrusbbe/alphanumeric_lato-white_I.png-_5e904e-255%2C255%2C255%2C0.7.png)" href="/p/Ixocactus/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Ixocactus/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_243">Ixocactus</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" href="/p/Krinkle/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_244">Krinkle</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ojwbfntu5tqpwhaoiqhk/PHID-FILE-lqnvzvmxt6cyf37tlcpx/profile)" href="/p/MusikAnimal/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/MusikAnimal/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_245">MusikAnimal</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/2gffy5bww6ck2ynuxnpz/PHID-FILE-jyvkjrrdy7c4mbtu7gb3/profile)" href="/p/RhinosF1/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/RhinosF1/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_246">RhinosF1</a></td></tr></tbody></table></div><div class="phui-curtain-object-ref-view "><table><tbody><tr class="phui-curtain-object-ref-view-without-content"><td class="phui-curtain-object-ref-view-image-cell"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q3sgugeppvp7kt3yjufa/PHID-FILE-b63ck2rcmg45jgoh7srs/profile)" href="/p/Tks4Fish/" class="visual-only" aria-hidden="true"></a></td><td class="phui-curtain-object-ref-view-title-cell"><a href="/p/Tks4Fish/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_247">Tks4Fish</a></td></tr></tbody></table></div></div></div></div></div></div></div><div class="phui-main-column"><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-box-blue-property "><div class="phui-header-shell "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header">Description</span></div><div class="phui-header-col3"></div></div></h1></div><div class="phui-property-list-section"><div class="phui-property-list-text-content"><div class="phabricator-remarkup"><div class="phabricator-remarkup"><p>Per <a href="/T223406" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_0"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T223406: Remove reference to fields replaced by the actor table from WMCS views</span></span></a>.</p> <p>Need to come up with a strategy for how to best handle this.</p> <p>In particular, in a way that remains reasonably performant because the tool still hasn't recovered from the previous migration / <a href="/T195515" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_1"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T195515: GUC query performance regressed 100x from <3s to 80-300s</span></span></a>.</p></div></div></div></div></div><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-box-blue-property "><div class="phui-header-shell "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header">Details</span></div><div class="phui-header-col3"></div></div></h1></div><div class="phui-property-list-section"><div class="phui-property-list-text-content"><div class="aphront-table-wrap"><table class="aphront-table-view"><tr><th class="right"></th><th class="wide object-link">Subject</th><th class="left">Repo</th><th class="left aphront-table-view-nodevice">Branch</th><th class="n aphront-table-view-nodevice">Lines +/-</th></tr><tr><td class="right"><span class="visual-only phui-icon-view phui-font-fa fa-code-fork black" data-sigil="has-tooltip" data-meta="0_2" aria-hidden="true"></span></td><td class="wide object-link"><a href="https://gerrit.wikimedia.org/r/c/518347">Use the optimised actor_recentchanges/actor_revision everywhere</a></td><td class="left"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc" target="_blank">labs/tools/guc</a></td><td class="left aphront-table-view-nodevice"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc/+/master" target="_blank">master</a></td><td class="n aphront-table-view-nodevice"><span style="color:green;" title="3 Line(s) added">+3</span><span style="color:red;" title="3 Line(s) removed"> -3</span></td></tr><tr class="alt"><td class="right"><span class="visual-only phui-icon-view phui-font-fa fa-code-fork black" data-sigil="has-tooltip" data-meta="0_3" aria-hidden="true"></span></td><td class="wide object-link"><a href="https://gerrit.wikimedia.org/r/c/518337">Fix revision query after actor migration (user_id = actor_user, not actor_name)</a></td><td class="left"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc" target="_blank">labs/tools/guc</a></td><td class="left aphront-table-view-nodevice"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc/+/master" target="_blank">master</a></td><td class="n aphront-table-view-nodevice"><span style="color:green;" title="2 Line(s) added">+2</span><span style="color:red;" title="2 Line(s) removed"> -2</span></td></tr><tr><td class="right"><span class="visual-only phui-icon-view phui-font-fa fa-code-fork black" data-sigil="has-tooltip" data-meta="0_4" aria-hidden="true"></span></td><td class="wide object-link"><a href="https://gerrit.wikimedia.org/r/c/517576">Adopt actor tables and use dedicated comment table views</a></td><td class="left"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc" target="_blank">labs/tools/guc</a></td><td class="left aphront-table-view-nodevice"><a href="https://gerrit.wikimedia.org/r/plugins/gitiles/labs/tools/guc/+/master" target="_blank">master</a></td><td class="n aphront-table-view-nodevice"><span style="color:green;" title="31 Line(s) added">+31</span><span style="color:red;" title="27 Line(s) removed"> -27</span></td></tr></table></div><a href="https://gerrit.wikimedia.org/r/#/q/bug:T224440">Customize query in gerrit</a></div></div></div><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-box-blue-property "><div class="phui-header-shell "><h1 class="phui-header-view"><div class="phui-header-row"><div class="phui-header-col2"><span class="phui-header-header">Related Objects</span></div><div class="phui-header-col3"></div></div></h1></div><div class=" " data-sigil="phui-tab-group-view" data-meta="0_13"><ul class="phui-list-view phui-list-navbar phui-list-navbar-horizontal "><li class="phui-list-item-view phui-list-item-type-link phui-list-item-selected " data-sigil="phui-tab-view" data-meta="0_14"><a href="#" class="phui-list-item-href" data-sigil=""><span class="phui-list-item-name">Mentions</span></a></li></ul><div id="UQ0_2"><div class=""><div class="phui-property-list-section"><div class="phui-property-list-container grouped"><div class="phui-property-list-properties-wrap "><dl class="phui-property-list-properties"><dt class="phui-property-list-key">Mentioned In </dt><dd class="phui-property-list-value"><span class=""><a href="/T226287" class="phui-handle" data-sigil="hovercard" data-meta="0_5">T226287: GUC: Add display of edit counts (again)</a><br /><a href="/T224930" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_6">T224930: No contributions shown for any user in Global user contribution tool</a></span> </dd><dt class="phui-property-list-key">Mentioned Here </dt><dd class="phui-property-list-value"><span class=""><a href="/T224930" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_7">T224930: No contributions shown for any user in Global user contribution tool</a><br /><a href="/T215445" class="phui-handle" data-sigil="hovercard" data-meta="0_8">T215445: comment and actor view challenges for Cloud Services</a><br /><a href="/T215466" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_9">T215466: Remove revision_comment_temp and revision_actor_temp</a><br /><a href="/T221339" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_10">T221339: Missing index on revision_userindex.rev_actor</a><br /><a href="/T195515" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_11">T195515: GUC query performance regressed 100x from <3s to 80-300s</a><br /><a href="/T223406" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_12">T223406: Remove reference to fields replaced by the actor table from WMCS views</a></span> </dd></dl></div></div></div></div></div></div></div><div class="phui-timeline-view" id="UQ0_3"><h3 class="aural-only">Event Timeline</h3><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_75"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5215309" id="5215309" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-pencil phui-timeline-icon" data-meta="0_74" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_15">Krinkle</a> created this task.<span class="phui-timeline-extra"><a href="#5215309" data-sigil="has-tooltip" data-meta="0_73"><span class="screen-only">May 27 2019, 6:09 PM</span><span class="print-only" aria-hidden="true">2019-05-27 18:09:43 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_78"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><div class="phui-timeline-wedge" style="display: none;"></div><div class="phui-timeline-group"><a name="5215322" id="5215322" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_77" aria-hidden="true"></span></span><span class="phui-handle" data-sigil="hovercard" data-meta="0_26"><span class="visual-only phui-icon-view phui-font-fa fa-lock lightgreytext" data-meta="0_27" aria-hidden="true"></span>Restricted Application</span> added a subscriber: <a href="/p/Aklapper/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_28">Aklapper</a>. <span class="phui-timeline-extra-information"> · <a href="/herald/transcript/3134764/">View Herald Transcript</a></span><span class="phui-timeline-extra"><a href="#5215322" data-sigil="has-tooltip" data-meta="0_76"><span class="screen-only">May 27 2019, 6:09 PM</span><span class="print-only" aria-hidden="true">2019-05-27 18:09:43 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell phui-timeline-green" data-sigil="transaction anchor-container" data-meta="0_81"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5215323" id="5215323" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill fill-has-color phui-timeline-icon-fill-green"><span class="visual-only phui-icon-view phui-font-fa fa-arrow-right phui-timeline-icon" data-meta="0_80" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_29">Krinkle</a> triaged this task as <span class="phui-timeline-value">High</span> priority.<span class="phui-timeline-extra"><a href="#5215323" data-sigil="has-tooltip" data-meta="0_79"><span class="screen-only">May 27 2019, 6:09 PM</span><span class="print-only" aria-hidden="true">2019-05-27 18:09:52 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_92"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-badges"><ul class="phui-badge-flex-view grouped flex-view-collapsed "><li class="phui-badge-flex-item"><a class="phui-badge-mini phui-badge-mini-orange " href="/badges/view/8/" data-sigil="has-tooltip" data-meta="0_90"><span class="visual-only phui-icon-view phui-font-fa fa-life-ring" data-meta="0_91" aria-hidden="true"></span></a></li></ul></div><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5215344" id="5215344" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_89" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_30">Krinkle</a> added a subscriber: <a href="/p/Anomie/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_31">Anomie</a>.<span class="phui-timeline-extra"><a href="#5215344" data-sigil="has-tooltip" data-meta="0_88"><span class="screen-only">May 27 2019, 6:31 PM</span><span class="print-only" aria-hidden="true">2019-05-27 18:31:58 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_86"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_87" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_32"><div class="phabricator-remarkup"><p>The way GUC currently works when processing a query:</p> <ol class="remarkup-list"> <li class="remarkup-list-item">Create connection to <tt class="remarkup-monospaced">s1.web.db.svc.eqiad.wmflabs</tt>.</li> <li class="remarkup-list-item">Get list of all wikis.</li> <li class="remarkup-list-item">For each db section (<tt class="remarkup-monospaced">{section}.web.db.svc.eqiad.wmflabs</tt>) (<em>GUC does dns resolve on the hostname, and re-uses db connections from other sections if share the same IP. Right now this means we will only ever establish one connection to the replicas as they're all cnames right now</em>):<ol class="remarkup-list"> <li class="remarkup-list-item">Find wikis that have matching revisions.</li> </ol></li> <li class="remarkup-list-item">Query centralauth_p for local usernames.</li> <li class="remarkup-list-item">For each wiki with non-zero matching revisions, two queries:<ol class="remarkup-list"> <li class="remarkup-list-item">Query user data.</li> <li class="remarkup-list-item">Query up to 20 descending contributions from the specified source (last 1h of recent changes, any recent changes, any revision).</li> </ol></li> </ol> <p>Example:</p> <div class="remarkup-code-block" data-code-lang="sql" data-sigil="remarkup-code-block"><div class="remarkup-code-header">Debug log</div><pre class="remarkup-code"><span></span><span class="c1">--- 2) Get list of all wikis</span> <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">meta_p</span><span class="o">`</span><span class="p">.</span><span class="o">`</span><span class="n">wiki</span><span class="o">`</span> <span class="k">WHERE</span> <span class="n">is_closed</span> <span class="o">=</span> <span class="mi">0</span> <span class="k">LIMIT</span> <span class="mi">1500</span><span class="p">;</span> <span class="c1">-- 3A) Quering wikis on `s3.labsdb` for matching revisions</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'abwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">abwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">UNION</span> <span class="k">ALL</span> <span class="err">…</span> <span class="err">…</span> <span class="err">…</span> <span class="k">UNION</span> <span class="k">ALL</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'zuwiktionary'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">zuwiktionary_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="c1">--- ⤷ +31.04s</span> <span class="c1">--- 3A) Quering wikis on `s7.labsdb` for matching revisions</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'arwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">arwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">UNION</span> <span class="k">ALL</span> <span class="err">…</span> <span class="err">…</span> <span class="err">…</span> <span class="k">UNION</span> <span class="k">ALL</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'viwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">viwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="c1">--- ⤷ +0.32s</span> <span class="c1">--- 3A) Quering wikis on `s1.labsdb` for matching revisions</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'enwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">enwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="c1">--- 3A) Quering wikis on `s8.labsdb` for matching revisions</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'wikidatawiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">wikidatawiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="err">…</span> <span class="err">…</span> <span class="err">…</span> <span class="c1">--- 5A) Query user data for commons.wikimedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="k">user</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">LIMIT</span> <span class="mi">10</span><span class="p">;</span> <span class="c1">--- 5B) Query contributions on commons.wikimedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">comment_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_minor_edit</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_len</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_parent_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_user_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_title</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_namespace</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_latest</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span> <span class="k">AS</span> <span class="o">`</span><span class="n">guc_is_cur</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">revision_userindex</span><span class="o">`</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="n">page</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_page</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">page_id</span><span class="o">`</span> <span class="k">LEFT</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="k">comment</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_comment_id</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">comment_id</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">rev_deleted</span><span class="o">`</span> <span class="o">=</span> <span class="mi">0</span> <span class="k">AND</span> <span class="o">`</span><span class="n">rev_user</span><span class="o">`</span> <span class="o">=</span> <span class="s1">'607047'</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">20</span><span class="p">;</span> <span class="c1">--- 5A) Query user data for en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="k">user</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">LIMIT</span> <span class="mi">10</span><span class="p">;</span> <span class="c1">--- 5B) Query contributions on en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">comment_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_minor_edit</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_len</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_parent_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_user_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_title</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_namespace</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_latest</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span> <span class="k">AS</span> <span class="o">`</span><span class="n">guc_is_cur</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">revision_userindex</span><span class="o">`</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="n">page</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_page</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">page_id</span><span class="o">`</span> <span class="k">LEFT</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="k">comment</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_comment_id</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">comment_id</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">rev_deleted</span><span class="o">`</span> <span class="o">=</span> <span class="mi">0</span> <span class="k">AND</span> <span class="o">`</span><span class="n">rev_user</span><span class="o">`</span> <span class="o">=</span> <span class="s1">'9014223'</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">20</span><span class="p">;</span> <span class="err">…</span> <span class="err">…</span> <span class="err">…</span> <span class="c1">--- Close remaining connection for s1.web.db.svc.eqiad.wmflabs</span> <span class="c1">--- Connections opened: 1</span> <span class="c1">--- Highest connection count: 1</span></pre></div> <p>Total backend time: 273.81s.</p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_103"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/ms665yc73j6nadjitytk/PHID-FILE-mocohumlrcbe2lcuplml/profile)" class="visual-only phui-timeline-image" href="/p/Anomie/" aria-hidden="true"></a><div class="phui-timeline-badges"><ul class="phui-badge-flex-view grouped flex-view-collapsed "><li class="phui-badge-flex-item"><a class="phui-badge-mini phui-badge-mini-orange " href="/badges/view/5/" data-sigil="has-tooltip" data-meta="0_101"><span class="visual-only phui-icon-view phui-font-fa fa-rocket" data-meta="0_102" aria-hidden="true"></span></a></li></ul></div><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5224202" id="5224202" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_100" aria-hidden="true"></span></span><a href="/p/Anomie/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_33">Anomie</a> added a comment.<span class="phui-timeline-extra"><a href="#5224202" data-sigil="has-tooltip" data-meta="0_99"><span class="screen-only">May 30 2019, 4:29 PM</span><span class="print-only" aria-hidden="true">2019-05-30 16:29:11 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_97"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_98" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_34"><div class="phabricator-remarkup"><blockquote class="remarkup-reply-block"> <div class="remarkup-reply-head">In <a href="/T224440#5215344" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_17"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T224440#5215344</span></span></a>, <a href="/p/Krinkle/" class="phui-tag-view phui-tag-type-person " data-sigil="hovercard" data-meta="0_22"><span class="phui-tag-core phui-tag-color-person">@Krinkle</span></a> wrote:</div> <div class="remarkup-reply-body"><div class="remarkup-code-block" data-code-lang="sql" data-sigil="remarkup-code-block"><div class="remarkup-code-header">Debug log</div><pre class="remarkup-code"><span></span><span class="c1">--- 3A) Quering wikis on `s1.labsdb` for matching revisions</span> <span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'abwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">abwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">WHERE</span> <span class="n">rev_user_text</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">UNION</span> <span class="k">ALL</span></pre></div></div> </blockquote> <p>This query would change to look something like</p> <div class="remarkup-code-block" data-code-lang="sql" data-sigil="remarkup-code-block"><pre class="remarkup-code"><span></span><span class="k">SELECT</span> <span class="k">COUNT</span><span class="p">(</span><span class="n">rev_id</span><span class="p">)</span> <span class="k">AS</span> <span class="n">counter</span><span class="p">,</span> <span class="s1">'enwiki'</span> <span class="k">AS</span> <span class="n">dbname</span> <span class="k">FROM</span> <span class="n">enwiki_p</span><span class="p">.</span><span class="n">actor</span> <span class="k">JOIN</span> <span class="n">enwiki_p</span><span class="p">.</span><span class="n">revision_userindex</span> <span class="k">ON</span> <span class="p">(</span><span class="n">rev_actor</span> <span class="o">=</span> <span class="n">actor_id</span><span class="p">)</span> <span class="k">WHERE</span> <span class="n">actor_name</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span></pre></div> <p>In a quick test using User:AnomieBOT on enwiki (counter = 3757214), your old query took 8 min 48.61 sec on one of the replicas while this new one took 9 min 6.83 sec on a different replica. The new query should improve to roughly match the old once <a href="/T215466" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_18"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T215466</span></span></a> happens, although that's at least a few months out.</p> <p>However, you might wind up with the same sort of too many tables in the s3 join that you had in <a href="/T195515" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_19"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T195515</span></span></a>, since the <tt class="remarkup-monospaced">actor</tt> view has to join against many others for permissions checking just as the <tt class="remarkup-monospaced">comment</tt> view does. If that does turn out to be the case, you might wind up having to look up the actor IDs first, individually. Or you could push for progress on <a href="/T215445" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_20"><span class="phui-tag-core phui-tag-color-object">T215445</span></a> to eliminate all those subqueries.</p> <blockquote><div class="remarkup-code-block" data-code-lang="sql" data-sigil="remarkup-code-block"><pre class="remarkup-code"><span></span><span class="c1">--- 5A) Query user data for en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">user_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="k">user</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">user_name</span><span class="o">`</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">LIMIT</span> <span class="mi">10</span><span class="p">;</span> <span class="c1">--- 5B) Query contributions on en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">comment_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_minor_edit</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_len</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_parent_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_user_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_title</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_namespace</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_latest</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span> <span class="k">AS</span> <span class="o">`</span><span class="n">guc_is_cur</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">revision_userindex</span><span class="o">`</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="n">page</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_page</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">page_id</span><span class="o">`</span> <span class="k">LEFT</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="k">comment</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_comment_id</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">comment_id</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">rev_deleted</span><span class="o">`</span> <span class="o">=</span> <span class="mi">0</span> <span class="k">AND</span> <span class="o">`</span><span class="n">rev_user</span><span class="o">`</span> <span class="o">=</span> <span class="s1">'9014223'</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">20</span><span class="p">;</span></pre></div></blockquote> <p>These should change like</p> <div class="remarkup-code-block" data-code-lang="sql" data-sigil="remarkup-code-block"><pre class="remarkup-code"><span></span><span class="c1">--- 5A) Query user data for en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">actor_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">actor_name</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">actor</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">actor_name</span><span class="o">`</span> <span class="o">=</span> <span class="p">:</span><span class="k">user</span> <span class="k">LIMIT</span> <span class="mi">10</span><span class="p">;</span> <span class="c1">--- 5B) Query contributions on en.wikipedia.org</span> <span class="k">SELECT</span> <span class="o">`</span><span class="n">comment_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_minor_edit</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_len</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_parent_id</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">rev_user_text</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_title</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_namespace</span><span class="o">`</span><span class="p">,</span> <span class="o">`</span><span class="n">page_latest</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">rev_id</span><span class="o">`</span> <span class="k">AS</span> <span class="o">`</span><span class="n">guc_is_cur</span><span class="o">`</span> <span class="k">FROM</span> <span class="o">`</span><span class="n">revision_userindex</span><span class="o">`</span> <span class="k">INNER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="n">page</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_page</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">page_id</span><span class="o">`</span> <span class="k">LEFT</span> <span class="k">OUTER</span> <span class="k">JOIN</span> <span class="o">`</span><span class="k">comment</span><span class="o">`</span> <span class="k">ON</span> <span class="o">`</span><span class="n">rev_comment_id</span><span class="o">`</span> <span class="o">=</span> <span class="o">`</span><span class="n">comment_id</span><span class="o">`</span> <span class="k">WHERE</span> <span class="o">`</span><span class="n">rev_deleted</span><span class="o">`</span> <span class="o">=</span> <span class="mi">0</span> <span class="k">AND</span> <span class="o">`</span><span class="n">rev_actor</span><span class="o">`</span> <span class="o">=</span> <span class="s1">'281698'</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="o">`</span><span class="n">rev_timestamp</span><span class="o">`</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">0</span><span class="p">,</span> <span class="mi">20</span><span class="p">;</span></pre></div> <p>I guess that you might currently have a different 5B if <tt class="remarkup-monospaced">:user</tt> is an IP, checking against <tt class="remarkup-monospaced">rev_user_text</tt> instead of <tt class="remarkup-monospaced">rev_user</tt>. There would be no difference using actors, these queries work for both registered users and IPs.</p> <p>Note that work on <a href="/T221339" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_21"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T221339</span></span></a> has made your old 5B start being really slow, to allow queries like the new 5B to be fast.</p> <p>BTW, why the "LIMIT 10" on the 5A query? Both <tt class="remarkup-monospaced">user.user_name</tt> and <tt class="remarkup-monospaced">actor.actor_name</tt> are unique, so it should always return either 0 or 1 row.</p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_106"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/247abt7phqlbitgglyxa/PHID-FILE-tx36db6dprvfuxu72bcj/alphanumeric_aleo-white_D.png-_ec9da1-0%2C0%2C0%2C0.png)" class="visual-only phui-timeline-image" href="/p/Daimona/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5225923" id="5225923" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_105" aria-hidden="true"></span></span><a href="/p/Daimona/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_35">Daimona</a> subscribed.<span class="phui-timeline-extra"><a href="#5225923" data-sigil="has-tooltip" data-meta="0_104"><span class="screen-only">May 31 2019, 12:11 PM</span><span class="print-only" aria-hidden="true">2019-05-31 12:11:17 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_109"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/247abt7phqlbitgglyxa/PHID-FILE-tx36db6dprvfuxu72bcj/alphanumeric_aleo-white_D.png-_ec9da1-0%2C0%2C0%2C0.png)" class="visual-only phui-timeline-image" href="/p/Daimona/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5231611" id="5231611" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_108" aria-hidden="true"></span></span><a href="/p/Daimona/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_36">Daimona</a> mentioned this in <a href="/T224930" class="phui-handle handle-status-closed" data-sigil="hovercard" data-meta="0_37">T224930: No contributions shown for any user in Global user contribution tool</a>.<span class="phui-timeline-extra"><a href="#5231611" data-sigil="has-tooltip" data-meta="0_107"><span class="screen-only">Jun 3 2019, 7:31 PM</span><span class="print-only" aria-hidden="true">2019-06-03 19:31:31 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_120"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-badges"><ul class="phui-badge-flex-view grouped flex-view-collapsed "><li class="phui-badge-flex-item"><a class="phui-badge-mini phui-badge-mini-orange " href="/badges/view/8/" data-sigil="has-tooltip" data-meta="0_118"><span class="visual-only phui-icon-view phui-font-fa fa-life-ring" data-meta="0_119" aria-hidden="true"></span></a></li></ul></div><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5236328" id="5236328" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_117" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_38">Krinkle</a> added a comment.<span class="phui-timeline-extra"><a href="#5236328" data-sigil="has-tooltip" data-meta="0_116"><span class="screen-only">Jun 5 2019, 10:34 AM</span><span class="print-only" aria-hidden="true">2019-06-05 10:34:44 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_114"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_115" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_39"><div class="phabricator-remarkup"><blockquote><p>BTW, why the "LIMIT 10" on the 5A query</p></blockquote> <p>This is because of prefix support. In the non-prefix case, it is indeed redundant. (<a href="https://github.com/wikimedia/labs-tools-guc/blob/85da713d0cc51f01e5b7832255ac16295873526b/src/Contribs.php#L66-L76" class="remarkup-link" target="_blank" rel="noreferrer">source code</a>)</p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_123"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q3sgugeppvp7kt3yjufa/PHID-FILE-b63ck2rcmg45jgoh7srs/profile)" class="visual-only phui-timeline-image" href="/p/Tks4Fish/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5242246" id="5242246" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_122" aria-hidden="true"></span></span><a href="/p/Tks4Fish/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_40">Tks4Fish</a> subscribed.<span class="phui-timeline-extra"><a href="#5242246" data-sigil="has-tooltip" data-meta="0_121"><span class="screen-only">Jun 7 2019, 1:59 AM</span><span class="print-only" aria-hidden="true">2019-06-07 01:59:27 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_126"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/2gffy5bww6ck2ynuxnpz/PHID-FILE-jyvkjrrdy7c4mbtu7gb3/profile)" class="visual-only phui-timeline-image" href="/p/RhinosF1/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5243774" id="5243774" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_125" aria-hidden="true"></span></span><a href="/p/RhinosF1/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_41">RhinosF1</a> subscribed.<span class="phui-timeline-extra"><a href="#5243774" data-sigil="has-tooltip" data-meta="0_124"><span class="screen-only">Jun 7 2019, 8:03 PM</span><span class="print-only" aria-hidden="true">2019-06-07 20:03:49 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_129"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/umdix2irqa7pv7fxkwvx/PHID-FILE-7ejbs3mgx7c3zvejqpix/alphanumeric_aleo-white_C.png-_648d72-0%2C0%2C0%2C0.png)" class="visual-only phui-timeline-image" href="/p/Count_Count/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5244408" id="5244408" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_128" aria-hidden="true"></span></span><a href="/p/Count_Count/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_42">Count_Count</a> subscribed.<span class="phui-timeline-extra"><a href="#5244408" data-sigil="has-tooltip" data-meta="0_127"><span class="screen-only">Jun 8 2019, 7:50 AM</span><span class="print-only" aria-hidden="true">2019-06-08 07:50:16 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_132"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/v6locq3etwigatuxsjjf/PHID-FILE-xllcxsdw3rhajdrusbbe/alphanumeric_lato-white_I.png-_5e904e-255%2C255%2C255%2C0.7.png)" class="visual-only phui-timeline-image" href="/p/Ixocactus/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5252019" id="5252019" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_131" aria-hidden="true"></span></span><a href="/p/Ixocactus/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_43">Ixocactus</a> subscribed.<span class="phui-timeline-extra"><a href="#5252019" data-sigil="has-tooltip" data-meta="0_130"><span class="screen-only">Jun 12 2019, 2:17 AM</span><span class="print-only" aria-hidden="true">2019-06-12 02:17:25 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_141"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5264157" id="5264157" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_140" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_44">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5264157" data-sigil="has-tooltip" data-meta="0_139"><span class="screen-only">Jun 18 2019, 1:22 AM</span><span class="print-only" aria-hidden="true">2019-06-18 01:22:18 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_137"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_138" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_45"><div class="phabricator-remarkup"><p>Change 517576 had a related patch set uploaded (by MusikAnimal; owner: MusikAnimal):<br /> [labs/tools/guc@master] [Experimental] Implement actor migration</p> <p><a href="https://gerrit.wikimedia.org/r/517576" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/517576</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_144"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5264158" id="5264158" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_143" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_46">gerritbot</a> added a project: <a href="/tag/patch-for-review/" class="phui-handle" data-sigil="hovercard" data-meta="0_47">Patch-For-Review</a>.<span class="phui-timeline-extra"><a href="#5264158" data-sigil="has-tooltip" data-meta="0_142"><span class="screen-only">Jun 18 2019, 1:22 AM</span><span class="print-only" aria-hidden="true">2019-06-18 01:22:19 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_147"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5274747" id="5274747" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_146" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_48">Krinkle</a> mentioned this in <a href="/T226287" class="phui-handle" data-sigil="hovercard" data-meta="0_49">T226287: GUC: Add display of edit counts (again)</a>.<span class="phui-timeline-extra"><a href="#5274747" data-sigil="has-tooltip" data-meta="0_145"><span class="screen-only">Jun 21 2019, 10:01 PM</span><span class="print-only" aria-hidden="true">2019-06-21 22:01:13 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_156"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275167" id="5275167" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_155" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_50">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5275167" data-sigil="has-tooltip" data-meta="0_154"><span class="screen-only">Jun 21 2019, 11:02 PM</span><span class="print-only" aria-hidden="true">2019-06-21 23:02:57 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_152"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_153" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_51"><div class="phabricator-remarkup"><p>Change 517576 <strong>merged</strong> by jenkins-bot:<br /> [labs/tools/guc@master] Adopt actor tables and use dedicated comment table views</p> <p><a href="https://gerrit.wikimedia.org/r/517576" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/517576</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell phui-timeline-green" data-sigil="transaction anchor-container" data-meta="0_169"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-badges"><ul class="phui-badge-flex-view grouped flex-view-collapsed "><li class="phui-badge-flex-item"><a class="phui-badge-mini phui-badge-mini-orange " href="/badges/view/8/" data-sigil="has-tooltip" data-meta="0_167"><span class="visual-only phui-icon-view phui-font-fa fa-life-ring" data-meta="0_168" aria-hidden="true"></span></a></li></ul></div><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275172" id="5275172" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill fill-has-color phui-timeline-icon-fill-green"><span class="visual-only phui-icon-view phui-font-fa fa-check-square-o phui-timeline-icon" data-meta="0_164" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_52">Krinkle</a> closed this task as <span class="phui-timeline-value">Resolved</span>.<span class="phui-timeline-extra"><a href="#5275172" data-sigil="has-tooltip" data-meta="0_163"><span class="screen-only">Jun 21 2019, 11:05 PM</span><span class="print-only" aria-hidden="true">2019-06-21 23:05:38 (UTC+0)</span></a></span></div><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill fill-has-color phui-timeline-icon-fill-green"><span class="visual-only phui-icon-view phui-font-fa fa-user phui-timeline-icon" data-meta="0_165" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_53">Krinkle</a> assigned this task to <a href="/p/MusikAnimal/" class="phui-handle phui-link-person">MusikAnimal</a>.</div><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-plus phui-timeline-icon" data-meta="0_166" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_54">Krinkle</a> added a subscriber: <a href="/p/MusikAnimal/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_55">MusikAnimal</a>.</div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_161"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_162" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_56"><div class="phabricator-remarkup"><blockquote class="remarkup-reply-block"> <div class="remarkup-reply-head">In <a href="/T224930#5275169" class="phui-tag-view phui-tag-type-object " data-sigil="hovercard" data-meta="0_23"><span class="phui-tag-core-closed"><span class="phui-tag-core phui-tag-color-object">T224930#5275169</span></span></a>, <a href="/p/Krinkle/" class="phui-tag-view phui-tag-type-person " data-sigil="hovercard" data-meta="0_25"><span class="phui-tag-core phui-tag-color-person">@Krinkle</span></a> wrote:</div> <div class="remarkup-reply-body"><p>I'm gonna land the patch now, although it <strong>only works for recent changes</strong> right now. Not for "All contributions".</p> <p>I've fixed the query for "All contributions" (which just means the 20 latest edits including those not in the last 30 days from recent changes) using the same pattern as <a href="/p/MusikAnimal/" class="phui-tag-view phui-tag-type-person " data-sigil="hovercard" data-meta="0_24"><span class="phui-tag-core phui-tag-color-person">@MusikAnimal</span></a> showed. But it now fails for a different reason: The query is now so slow for the <tt class="remarkup-monospaced">revision_userindex</tt> view that it times out on the <tt class="remarkup-monospaced">s3</tt> small wikis. And then the query for enwiki/commons/wikidata after that is trying to query the now broken connection object, and get skipped. I'll fix that in a separate change, but closing this for now.</p></div> </blockquote> </div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_178"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275347" id="5275347" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_177" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_57">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5275347" data-sigil="has-tooltip" data-meta="0_176"><span class="screen-only">Jun 21 2019, 11:36 PM</span><span class="print-only" aria-hidden="true">2019-06-21 23:36:07 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_174"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_175" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_58"><div class="phabricator-remarkup"><p>Change 518337 had a related patch set uploaded (by Krinkle; owner: Krinkle):<br /> [labs/tools/guc@master] Fix revision query after actor migration (user_id = actor_user, not actor_name)</p> <p><a href="https://gerrit.wikimedia.org/r/518337" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/518337</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_187"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275371" id="5275371" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_186" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_59">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5275371" data-sigil="has-tooltip" data-meta="0_185"><span class="screen-only">Jun 21 2019, 11:43 PM</span><span class="print-only" aria-hidden="true">2019-06-21 23:43:23 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_183"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_184" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_60"><div class="phabricator-remarkup"><p>Change 518337 <strong>merged</strong> by jenkins-bot:<br /> [labs/tools/guc@master] Fix revision query after actor migration (user_id = actor_user, not actor_name)</p> <p><a href="https://gerrit.wikimedia.org/r/518337" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/518337</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_190"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5275412" id="5275412" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_189" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_61">Krinkle</a> removed a project: <a href="/tag/patch-for-review/" class="phui-handle" data-sigil="hovercard" data-meta="0_62">Patch-For-Review</a>.<span class="phui-timeline-extra"><a href="#5275412" data-sigil="has-tooltip" data-meta="0_188"><span class="screen-only">Jun 22 2019, 12:23 AM</span><span class="print-only" aria-hidden="true">2019-06-22 00:23:53 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_199"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275461" id="5275461" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_198" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_63">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5275461" data-sigil="has-tooltip" data-meta="0_197"><span class="screen-only">Jun 22 2019, 1:21 AM</span><span class="print-only" aria-hidden="true">2019-06-22 01:21:06 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_195"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_196" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_64"><div class="phabricator-remarkup"><p>Change 518347 had a related patch set uploaded (by Krinkle; owner: Krinkle):<br /> [labs/tools/guc@master] Use the optimised actor_recentchanges/actor_revision everywhere</p> <p><a href="https://gerrit.wikimedia.org/r/518347" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/518347</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_202"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5275462" id="5275462" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_201" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_65">gerritbot</a> added a project: <a href="/tag/patch-for-review/" class="phui-handle" data-sigil="hovercard" data-meta="0_66">Patch-For-Review</a>.<span class="phui-timeline-extra"><a href="#5275462" data-sigil="has-tooltip" data-meta="0_200"><span class="screen-only">Jun 22 2019, 1:21 AM</span><span class="print-only" aria-hidden="true">2019-06-22 01:21:07 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_211"><div class="phui-timeline-event-view phui-timeline-major-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/6vn6slgby7ia62ouikut/PHID-FILE-ay56qvafgaxajuctgtw3/profile)" class="visual-only phui-timeline-image" href="/p/gerritbot/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><div class="phui-timeline-inner-content"><a name="5275905" id="5275905" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon phui-timeline-title-with-menu"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-comment phui-timeline-icon" data-meta="0_210" aria-hidden="true"></span></span><a href="/p/gerritbot/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_67">gerritbot</a> added a comment.<span class="phui-timeline-extra"><a href="#5275905" data-sigil="has-tooltip" data-meta="0_209"><span class="screen-only">Jun 22 2019, 2:06 PM</span><span class="print-only" aria-hidden="true">2019-06-22 14:06:41 (UTC+0)</span></a></span></div><a href="#" class="phui-timeline-menu" aria-haspopup="true" aria-expanded="false" data-sigil="phui-dropdown-menu" data-meta="0_207"><span class="aural-only">Comment Actions</span><span class="visual-only phui-icon-view phui-font-fa fa-caret-down" data-meta="0_208" aria-hidden="true"></span></a><div class="phui-timeline-core-content"><span class="transaction-comment" data-sigil="transaction-comment" data-meta="0_68"><div class="phabricator-remarkup"><p>Change 518347 <strong>merged</strong> by jenkins-bot:<br /> [labs/tools/guc@master] Use the optimised actor_recentchanges/actor_revision everywhere</p> <p><a href="https://gerrit.wikimedia.org/r/518347" class="remarkup-link" target="_blank" rel="noreferrer">https://gerrit.wikimedia.org/r/518347</a></p></div></span></div></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_214"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/q4xtskw4ul5dvrupkmqs/PHID-FILE-ezxrezgeehrb4vjobxgz/profile)" class="visual-only phui-timeline-image" href="/p/Krinkle/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="5275910" id="5275910" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-link phui-timeline-icon" data-meta="0_213" aria-hidden="true"></span></span><a href="/p/Krinkle/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_69">Krinkle</a> removed a project: <a href="/tag/patch-for-review/" class="phui-handle" data-sigil="hovercard" data-meta="0_70">Patch-For-Review</a>.<span class="phui-timeline-extra"><a href="#5275910" data-sigil="has-tooltip" data-meta="0_212"><span class="screen-only">Jun 22 2019, 2:14 PM</span><span class="print-only" aria-hidden="true">2019-06-22 14:14:42 (UTC+0)</span></a></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div><div class="phui-timeline-shell" data-sigil="transaction anchor-container" data-meta="0_218"><div class="phui-timeline-event-view phui-timeline-minor-event"><div class="phui-timeline-content"><a style="background-image: url(https://phab.wmfusercontent.org/file/data/2k47tvkka236nmpz22pc/PHID-FILE-h42cqpdrg4yr7egelavj/profile)" class="visual-only phui-timeline-image" href="/p/Aklapper/" aria-hidden="true"></a><div class="phui-timeline-wedge" style=""></div><div class="phui-timeline-group"><a name="6554019" id="6554019" class="phabricator-anchor-view"></a><div class="phui-timeline-title phui-timeline-title-with-icon"><span class="phui-timeline-icon-fill"><span class="visual-only phui-icon-view phui-font-fa fa-user-times phui-timeline-icon" data-meta="0_217" aria-hidden="true"></span></span><a href="/p/Aklapper/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_71">Aklapper</a> removed a subscriber: <a href="/p/Anomie/" class="phui-handle phui-link-person" data-sigil="hovercard" data-meta="0_72">Anomie</a>.<span class="phui-timeline-extra"><a href="#6554019" data-sigil="has-tooltip" data-meta="0_215"><span class="screen-only">Oct 16 2020, 5:40 PM</span><span class="print-only" aria-hidden="true">2020-10-16 17:40:29 (UTC+0)</span></a><span class="visual-only" aria-hidden="true"> · </span><span class="visual-only phui-icon-view phui-font-fa fa-bell-slash white phui-icon-emblem phui-icon-emblem-red" data-sigil="has-tooltip" data-meta="0_216" aria-hidden="true"></span></span></div></div></div></div></div><div class="phui-timeline-event-view phui-timeline-spacer"></div></div><div class="phui-box phui-box-border phui-object-box mlt mll mlr phui-object-box-flush "><a class="login-to-comment button" href="/login/?next=">Log In to Comment</a></div></div></div></div><div class="phui-two-column-content phui-two-column-footer"></div></div></div><div class="phabricator-standard-page-footer grouped"><span>Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct.</span> · <a href="https://wikimediafoundation.org/">Wikimedia Foundation</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Non-wiki_privacy_policy">Privacy Policy</a> · <a href="https://www.mediawiki.org/wiki/Special:MyLanguage/Code_of_Conduct">Code of Conduct</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use/Phabricator">Terms of Use</a> · <a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:General_disclaimer">Disclaimer</a> · <a href="https://creativecommons.org/licenses/by-sa/4.0/">CC-BY-SA</a> · <a href="https://www.gnu.org/licenses/old-licenses/gpl-2.0.html">GPL</a> · <a href="https://www.mediawiki.org/wiki/Phabricator/Credits">Credits</a></div></div></div></div><script type="text/javascript" src="https://phab.wmfusercontent.org/res/defaultX/phabricator/2eeda9e0/core.pkg.js"></script><data data-javelin-init-kind="merge" data-javelin-init-data="{"block":0,"data":[{"hovercardSpec":{"objectPHID":"PHID-TASK-kz4ojmzo3lhkjtotaa62"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ujvssye2lrupejj5iaoe"}},{"tip":"Merged","size":240},{"tip":"Merged","size":240},{"tip":"Merged","size":240},{"hovercardSpec":{"objectPHID":"PHID-TASK-cgobro6qzdc3px6catqc"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ly6jn5krzdpxrh3td245"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ly6jn5krzdpxrh3td245"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-5w2xk2qxnllmscjg2krf"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-63ckzl7u4o2n6l4xxwsr"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-nckpecjjx2ivv5uak4ki"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ujvssye2lrupejj5iaoe"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-kz4ojmzo3lhkjtotaa62"}},{"tabMap":{"mentions":"UQ0_2"}},{"tabKey":"mentions"},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-p5s46hkyr6uopn4kov5u"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-p5s46hkyr6uopn4kov5u"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-63ckzl7u4o2n6l4xxwsr"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ujvssye2lrupejj5iaoe"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-5w2xk2qxnllmscjg2krf"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-nckpecjjx2ivv5uak4ki"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz","contextPHID":"PHID-TASK-p5s46hkyr6uopn4kov5u"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ly6jn5krzdpxrh3td245"}},{"hovercardSpec":{"objectPHID":"PHID-USER-jcbfmubdgevrfmxvfrfj","contextPHID":"PHID-TASK-p5s46hkyr6uopn4kov5u"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz","contextPHID":"PHID-TASK-p5s46hkyr6uopn4kov5u"}},{"hovercardSpec":{"objectPHID":"PHID-APPS-PhabricatorHeraldApplication"}},[],{"hovercardSpec":{"objectPHID":"PHID-USER-hgn5uw2jafgjgfvxibhh"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-uqcn2l4ng4murmyfnvyp"}},{"phid":"PHID-XACT-TASK-354x3ylwkk46oly"},{"hovercardSpec":{"objectPHID":"PHID-USER-uqcn2l4ng4murmyfnvyp"}},{"phid":"PHID-XACT-TASK-i7zqbhg2k2rbkcm"},{"hovercardSpec":{"objectPHID":"PHID-USER-hvywcttgalazbjxfl3tq"}},{"hovercardSpec":{"objectPHID":"PHID-USER-hvywcttgalazbjxfl3tq"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-ly6jn5krzdpxrh3td245"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"phid":"PHID-XACT-TASK-6uife7xv2zpmjxf"},{"hovercardSpec":{"objectPHID":"PHID-USER-jrvxhqpljw3wtjwvjdox"}},{"hovercardSpec":{"objectPHID":"PHID-USER-2wquu5nwbdqcuzo5qiuf"}},{"hovercardSpec":{"objectPHID":"PHID-USER-vp57xgpgzrrzkg7l4a3n"}},{"hovercardSpec":{"objectPHID":"PHID-USER-r5tlaialmseofebx5arl"}},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-mojl6uj2g7l7joc"},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"hovercardSpec":{"objectPHID":"PHID-PROJ-onnxucoedheq3jevknyr"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-TASK-cgobro6qzdc3px6catqc"}},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-mjxadnev5aausml"},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-jcbfmubdgevrfmxvfrfj"}},{"phid":"PHID-XACT-TASK-n3lauix6kfpc6wl"},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-iqhocj3agkdxoip"},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-e6noxhcqts7dfjl"},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-PROJ-onnxucoedheq3jevknyr"}},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-jbgx42gojfjbgxt"},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"hovercardSpec":{"objectPHID":"PHID-PROJ-onnxucoedheq3jevknyr"}},{"hovercardSpec":{"objectPHID":"PHID-USER-idceizaw6elwiwm5xshb"}},{"phid":"PHID-XACT-TASK-4msj3snsdtrhfa3"},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-PROJ-onnxucoedheq3jevknyr"}},{"hovercardSpec":{"objectPHID":"PHID-USER-hgn5uw2jafgjgfvxibhh"}},{"hovercardSpec":{"objectPHID":"PHID-USER-uqcn2l4ng4murmyfnvyp"}},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-g64vnngiaqmfsvf","anchor":"5215309"},{"tip":"Via Herald"},[],{"phid":"PHID-XACT-TASK-vknrlepp5ku7g42","anchor":"5215322"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-5wthqdci4lydxdt","anchor":"5215323"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-354x3ylwkk46oly\/","ref":"T224440#5215344"},[],{"anchor":"5215344"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_5\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_82\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_83\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_7\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-354x3ylwkk46oly\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_84\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_85\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Web"},[],{"tip":"Continuous Integrator","align":"E","size":300},[],{"phid":"PHID-XACT-TASK-ygemu6dnh2lkuxx","anchor":"5215344"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-i7zqbhg2k2rbkcm\/","ref":"T224440#5224202"},[],{"anchor":"5224202"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_9\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_93\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_94\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_11\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-i7zqbhg2k2rbkcm\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_95\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_96\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Web"},[],{"tip":"Backport Deployer","align":"E","size":300},[],{"phid":"PHID-XACT-TASK-i7zqbhg2k2rbkcm","anchor":"5224202"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-zsvsmum3k25dxju","anchor":"5225923"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-2vy4i7mkbidc24s","anchor":"5231611"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-6uife7xv2zpmjxf\/","ref":"T224440#5236328"},[],{"anchor":"5236328"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_13\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_110\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_111\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_15\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-6uife7xv2zpmjxf\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_112\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_113\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Web"},[],{"tip":"Continuous Integrator","align":"E","size":300},[],{"phid":"PHID-XACT-TASK-6uife7xv2zpmjxf","anchor":"5236328"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-lvibjwmftb77vbf","anchor":"5242246"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-6o77yhuiwak4f7n","anchor":"5243774"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-gufgaezor47l5br","anchor":"5244408"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-wxdwpl22pnvhc7d","anchor":"5252019"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-mojl6uj2g7l7joc\/","ref":"T224440#5264157"},[],{"anchor":"5264157"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_17\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_133\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_134\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_19\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-mojl6uj2g7l7joc\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_135\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_136\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-mojl6uj2g7l7joc","anchor":"5264157"},{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-x3b4i3r7brz3ale","anchor":"5264158"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-yacjixcryjlajyv","anchor":"5274747"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-mjxadnev5aausml\/","ref":"T224440#5275167"},[],{"anchor":"5275167"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_21\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_148\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_149\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_23\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-mjxadnev5aausml\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_150\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_151\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-mjxadnev5aausml","anchor":"5275167"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-n3lauix6kfpc6wl\/","ref":"T224440#5275172"},[],{"anchor":"5275172"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_25\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_157\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_158\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_27\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-n3lauix6kfpc6wl\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_159\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_160\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Web"},[],[],[],{"tip":"Continuous Integrator","align":"E","size":300},[],{"phid":"PHID-XACT-TASK-iq6ib5yms7hntrr","anchor":"5275172"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-iqhocj3agkdxoip\/","ref":"T224440#5275347"},[],{"anchor":"5275347"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_29\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_170\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_171\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_31\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-iqhocj3agkdxoip\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_172\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_173\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-iqhocj3agkdxoip","anchor":"5275347"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-e6noxhcqts7dfjl\/","ref":"T224440#5275371"},[],{"anchor":"5275371"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_33\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_179\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_180\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_35\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-e6noxhcqts7dfjl\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_181\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_182\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-e6noxhcqts7dfjl","anchor":"5275371"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-7q53viwt4g6t4t5","anchor":"5275412"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-jbgx42gojfjbgxt\/","ref":"T224440#5275461"},[],{"anchor":"5275461"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_37\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_191\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_192\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_39\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-jbgx42gojfjbgxt\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_193\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_194\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-jbgx42gojfjbgxt","anchor":"5275461"},{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-kzpykwvc6jg5j4i","anchor":"5275462"},{"targetID":"UQ0_1","uri":"\/transactions\/quote\/PHID-XACT-TASK-4msj3snsdtrhfa3\/","ref":"T224440#5275905"},[],{"anchor":"5275905"},[],{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_41\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"#\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-quote\" data-meta=\"0_203\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-quote-left phabricator-action-view-icon\" data-meta=\"0_204\" aria-hidden=\"true\"\u003e\u003c\/span\u003eQuote Comment\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_43\" class=\"phabricator-action-view phabricator-action-view-href action-has-icon\" style=\"\"\u003e\u003ca href=\"\/transactions\/raw\/PHID-XACT-TASK-4msj3snsdtrhfa3\/\" class=\"phabricator-action-view-item\" data-sigil=\"transaction-raw\" data-meta=\"0_205\"\u003e\u003cspan class=\"visual-only phui-icon-view phui-font-fa fa-code phabricator-action-view-icon\" data-meta=\"0_206\" aria-hidden=\"true\"\u003e\u003c\/span\u003eView Raw Remarkup\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"tip":"Via Conduit"},[],{"phid":"PHID-XACT-TASK-4msj3snsdtrhfa3","anchor":"5275905"},{"tip":"Via Web"},[],{"phid":"PHID-XACT-TASK-b7itubpqtqez7hd","anchor":"5275910"},{"tip":"Via Bulk Update"},{"tip":"Silent Edit"},[],{"phid":"PHID-XACT-TASK-6s4uwu5lsynedun","anchor":"6554019"},[],[],{"itemIDs":["UQ0_47","UQ0_48","UQ0_49","UQ0_50","UQ0_51"],"caretID":"UQ0_46"},[],[],[],[],[],[],{"itemIDs":["UQ0_59","UQ0_60"],"caretID":"UQ0_58"},[],[],[],[],[],[],[],{"hovercardSpec":{"objectPHID":"PHID-USER-jcbfmubdgevrfmxvfrfj"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},[],{"hovercardSpec":{"objectPHID":"PHID-PROJ-msxjhndgg4jj2v53laa5"}},{"hovercardSpec":{"objectPHID":"PHID-USER-hgn5uw2jafgjgfvxibhh"}},{"hovercardSpec":{"objectPHID":"PHID-USER-vp57xgpgzrrzkg7l4a3n"}},{"hovercardSpec":{"objectPHID":"PHID-USER-hvywcttgalazbjxfl3tq"}},{"hovercardSpec":{"objectPHID":"PHID-USER-r5tlaialmseofebx5arl"}},{"hovercardSpec":{"objectPHID":"PHID-USER-sai77mtxmpqnm6pycyvz"}},{"hovercardSpec":{"objectPHID":"PHID-USER-jcbfmubdgevrfmxvfrfj"}},{"hovercardSpec":{"objectPHID":"PHID-USER-2wquu5nwbdqcuzo5qiuf"}},{"hovercardSpec":{"objectPHID":"PHID-USER-jrvxhqpljw3wtjwvjdox"}},{"menuID":"UQ0_0"},[],[],[],[],[],{"map":{"UQ0_74":"phabricator-search-menu-expanded","UQ0_129":"menu-icon-selected"}},{"items":"\u003cul class=\"phabricator-action-list-view \"\u003e\u003cli id=\"UQ0_76\" class=\"phabricator-action-view phabricator-action-view-type-label\" style=\"\"\u003e\u003cspan class=\"phabricator-action-view-item\"\u003eQueries\u003c\/span\u003e\u003c\/li\u003e\u003cli id=\"UQ0_78\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/7QeK_wflJk_7\/\" class=\"phabricator-action-view-item\"\u003eNewest Open Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_80\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/all\/\" class=\"phabricator-action-view-item\"\u003eAll Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_82\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/open\/\" class=\"phabricator-action-view-item\"\u003eOpen Tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_84\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/oqCBTAiQBgwa\/\" class=\"phabricator-action-view-item\"\u003eAuthored (oldest open)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_86\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/SH5VKrDBlEU3\/\" class=\"phabricator-action-view-item\"\u003eClosed by me\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_88\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/gd6mG.hk3..e\/\" class=\"phabricator-action-view-item\"\u003eOpen + Subscribed\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_90\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/9T8LzvTiy5gR\/\" class=\"phabricator-action-view-item\"\u003eOpen or Resolved tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_92\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/AtbLhf4ZUBGj\/\" class=\"phabricator-action-view-item\"\u003eUnbreak Now! (Newest first)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_94\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/NIBnes9aVyDQ\/\" class=\"phabricator-action-view-item\"\u003eUnbreak Now! (Oldest first)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_96\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/WKC5LNTfaXCf\/\" class=\"phabricator-action-view-item\"\u003eWikimedia-Incident - To Triage column\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_98\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/GTbIUdDaMLqV\/\" class=\"phabricator-action-view-item\"\u003eMediaWiki Train Deployments\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_100\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/KpRagEN3fCBC\/\" class=\"phabricator-action-view-item\"\u003e#RelEng To Triage - Oldest first\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_102\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/mkOQwHTmvsGv\/\" class=\"phabricator-action-view-item\"\u003e#RelEng - Latest Project-Admins tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_104\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/CnG3iW9ba4Sm\/\" class=\"phabricator-action-view-item\"\u003e#RelEng - Latest WMF-NDA tasks\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_106\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/dXiDCQ1lr2TH\/\" class=\"phabricator-action-view-item\"\u003ePrivacy Engineering (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_108\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/8bHBE5y3nW0T\/\" class=\"phabricator-action-view-item\"\u003eSecurity (Needs Triage)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_110\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/aWhl5RAqasgr\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_112\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/AV_XTZmS8sSZ\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Back Order) But Assigned\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_114\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/hPw5AfNlfd5X\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (In Progress) By Assigned\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_116\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/ylGCqhVtsW5D\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (Watching) No Update 30 Days\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_118\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/ZfhewVYD.6v2\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team (In Progress) But Closed or Stalled\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_120\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/gb3pNSWyyZm1\/\" class=\"phabricator-action-view-item\"\u003eSecurity Team Assigned But No Updates 30 days\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_122\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/1G5egePmdpkZ\/\" class=\"phabricator-action-view-item\"\u003eSecurity Readiness Reviews (Incoming)\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_124\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/skCqxOTyF9gX\/\" class=\"phabricator-action-view-item\"\u003eWMCS extended backlog\u003c\/a\u003e\u003c\/li\u003e\u003cli id=\"UQ0_126\" class=\"phabricator-action-view phabricator-action-view-type-label\" style=\"\"\u003e\u003cspan class=\"phabricator-action-view-item\"\u003eSearch\u003c\/span\u003e\u003c\/li\u003e\u003cli id=\"UQ0_128\" class=\"phabricator-action-view phabricator-action-view-href phabricator-action-view-type-link\" style=\"\"\u003e\u003ca href=\"\/maniphest\/query\/advanced\/\" class=\"phabricator-action-view-item\"\u003eAdvanced Search\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e"},[],{"items":[{"name":"Search"},{"icon":"fa-globe","name":"All Documents","value":"all"},{"icon":"fa-anchor","name":"Current Application","value":"application"},{"name":"Saved Queries"},{"icon":"fa-certificate","name":"Open Documents","value":"open"},{"icon":"fa-certificate","name":"Authored Documents","value":"MaJUpIp4XQjD"},{"icon":"fa-certificate","name":"Subscribed Documents","value":"icqHFhjyxmbF"},{"icon":"fa-certificate","name":"Owned Documents","value":"xCgkkySoe4z7"},{"icon":"fa-certificate","name":"Open Tasks","value":"open-tasks"},{"name":"More Options"},{"icon":"fa-search-plus","name":"Advanced Search","href":"\/search\/query\/advanced\/"},{"icon":"fa-book","name":"User Guide: Search","href":"https:\/\/we.phorge.it\/diviner\/find\/?name=Search%20User%20Guide&type=article&jump=1"}],"icon":"fa-globe","value":"all"},[],[],[],[]]}"></data><data data-javelin-init-kind="behaviors" data-javelin-init-data="{"refresh-csrf":[{"tokenName":"__csrf__","header":"X-Phabricator-Csrf","viaHeader":"X-Phabricator-Via","current":"B@ocpniiki4fbddba8add0de83"}],"history-install":[]}"></data><data data-javelin-init-kind="behaviors" data-javelin-init-data="{"phabricator-tooltips":[],"phui-hovercards":[],"phui-tab-group":[],"phabricator-transaction-list":[],"phabricator-show-older-transactions":[{"timelineID":"UQ0_3","viewData":[]}],"phabricator-watch-anchor":[],"phui-dropdown-menu":[],"phui-submenu":[],"workflow":[],"lightbox-attachments":[],"aphront-form-disable-on-submit":[],"toggle-class":[],"phabricator-gesture":[],"device":[],"high-security-warning":[{"show":false,"uri":"\/auth\/session\/downgrade\/","message":"Your session is in high security mode. When you finish using it, click here to leave."}],"phabricator-keyboard-shortcuts":[{"helpURI":"\/help\/keyboardshortcut\/","searchID":"UQ0_130","pht":{"\/":"Give keyboard focus to the search box.","?":"Show keyboard shortcut help for the current page."}}],"phabricator-search-typeahead":[{"id":"UQ0_131","input":"UQ0_130","button":"UQ0_132","selectorID":"UQ0_133","applicationID":"UQ0_134","defaultApplicationIcon":"fa-dot-circle-o","appScope":"application","src":"\/typeahead\/class\/PhabricatorSearchDatasource\/","limit":10,"placeholder":"Search","scopeUpdateURI":"\/settings\/adjust\/?key=search-scope"}],"quicksand-blacklist":[{"patterns":["\/phame\/live\/.*","\/conpherence\/.*","\/Z\\d+","\/file\/(data|download)\/.*","\/phortune\/.*","\/auth\/.*"]}]}"></data></body></html>