[00:30:11] hi [00:30:27] are https://www.mediawiki.org/wiki/Extension:CentralNotice/Database_schema those tables included in replication? [00:30:34] where do I find them? [00:31:05] use metawiki_p; SHOW TABLES does not return those [02:56:35] 06Labs, 10DBA, 06Operations: disk failure on labsdb1002 - https://phabricator.wikimedia.org/T126946#2373304 (10zhuyifei1999) >>! In T126946#2371339, @Blahma wrote: > A confirmed work around is to remove categories from the concerned articles, save and add immediately revert, but I have been questioned by a p... [05:08:55] 06Labs, 10Labs-Infrastructure, 13Patch-For-Review: I/O on labmon1001 is very slow - https://phabricator.wikimedia.org/T127957#2373390 (10yuvipanda) So as an update the old labmon1001 died on the table, we have a newer machine (T136972) with a lot less RAM, same disks but better RAID config. However, that has... [05:09:28] 06Labs, 10Labs-Infrastructure, 13Patch-For-Review: I/O on labmon1001 is very slow - https://phabricator.wikimedia.org/T127957#2373395 (10yuvipanda) [05:09:30] 06Labs, 10Labs-Infrastructure, 06Operations, 10ops-eqiad: Reinstall labmon1001 with new disk configuration (and jessie) - https://phabricator.wikimedia.org/T136227#2373391 (10yuvipanda) 05Open>03declined The machine died on the table, never quite came back up from a restart. We did T136972 instead [05:10:01] 06Labs, 10Labs-Infrastructure, 13Patch-For-Review: I/O on labmon1001 is very slow - https://phabricator.wikimedia.org/T127957#2059611 (10yuvipanda) [06:05:45] 06Labs, 10labs-sprint-116, 10DBA, 13Patch-For-Review: Make watchlist table available on labs - https://phabricator.wikimedia.org/T59617#2373399 (10scfc) There is already the potential for a privilege vulnerability that would expose private user data: If someone hacks MediaWiki, they can execute arbitrary S... [12:53:07] 06Labs, 10labs-sprint-116, 10DBA, 13Patch-For-Review: Make watchlist table available on labs - https://phabricator.wikimedia.org/T59617#2373793 (10jcrespo) > There is already the potential for a privilege vulnerability that would expose private user data: If someone hacks MediaWiki, they can execute arbitr... [13:25:58] 06Labs, 10labs-sprint-116, 10DBA, 13Patch-For-Review: Make watchlist table available on labs - https://phabricator.wikimedia.org/T59617#2373812 (10jcrespo) There is a huge improvement for it being a real table rather than a view- it has usable indexes, so now you can do: ``` MariaDB labsdb1001 enwiki_p... [15:27:58] anyone to answer my question from earlier today? [15:29:39] Base: If it's not on show tables, then it's not. [15:30:32] Glaisher: the thing is that perhaps it's not metawiki_p where I should look for it, but I have no clue what else can it be [15:32:18] Base: CN's tables are on metawiki, afaik [15:32:51] 10Tool-Labs-tools-wikiloves: add Greece to WLE2016 tools - https://phabricator.wikimedia.org/T136936#2352813 (10Danilo) [[https://commons.wikimedia.org/w/index.php?diff=198406046|Done]] [15:33:55] 10Tool-Labs-tools-wikiloves: add Greece to WLE2016 tools - https://phabricator.wikimedia.org/T136936#2373921 (10Danilo) 05Open>03Resolved a:03Danilo [15:38:02] Base: I don't know what you asked. [15:38:30] the channel is logged [15:40:30] ... [16:59:57] 06Labs, 10Tool-Labs, 10Tool-Labs-tools-Database-Queries, 10MediaWiki-extensions-CentralNotice: CentralNotice tables should be available on labs - https://phabricator.wikimedia.org/T137641#2373958 (10Base) [17:35:55] 10Labs-Other-Projects, 06Discovery, 06Maps: Receiving warning emails about failed puppet runs - multiple instances - https://phabricator.wikimedia.org/T135942#2373986 (10dschwen) @notconfusing rebooting the instances took care of it. Sorry about the slow answer. I rebooted a single instance first and wanted... [17:41:53] 06Labs, 10DBA: CentralNotice tables should be available on labs - https://phabricator.wikimedia.org/T137641#2373987 (10valhallasw) [17:42:09] 06Labs, 10DBA: CentralNotice tables should be available on labs - https://phabricator.wikimedia.org/T137641#2373958 (10valhallasw) [17:42:12] 06Labs, 10Wikimedia-Labs-General, 10DBA, 06Operations, 07Tracking: Database replication services (tracking) - https://phabricator.wikimedia.org/T50930#2373988 (10valhallasw) [18:01:07] 06Labs, 10Labs-Infrastructure, 06Operations, 06Release-Engineering-Team, and 3 others: Firewall rules for labs support host to communicate with contint1001.eqiad.wmnet (new gallium) - https://phabricator.wikimedia.org/T137323#2374010 (10JanZerebecki) While T137323#2365101 is important. I don't understand T... [18:51:24] 10Labs-Other-Projects, 06Discovery, 06Maps: Receiving warning emails about failed puppet runs - multiple instances - https://phabricator.wikimedia.org/T135942#2374048 (10notconfusing) Yes, rebooting through the wikitech web interface took care of it for me too. [19:33:56] 06Labs, 10DBA: CentralNotice tables should be available on labs - https://phabricator.wikimedia.org/T137641#2373958 (10Steinsplitter) This looks like a duplicate of [[T135405]] [19:37:33] 06Labs, 10DBA: CentralNotice tables should be available on labs - https://phabricator.wikimedia.org/T137641#2374079 (10scfc) [19:37:35] 06Labs, 10DBA: Replicate CN related tables at labs - https://phabricator.wikimedia.org/T135405#2374081 (10scfc) [19:46:24] 06Labs, 10DBA: Replicate CentralNotice tables to Labs - https://phabricator.wikimedia.org/T135405#2374085 (10scfc) [20:00:15] 06Labs, 10Labs-Infrastructure, 06Operations, 06Release-Engineering-Team, and 3 others: Firewall rules for labs support host to communicate with contint1001.eqiad.wmnet (new gallium) - https://phabricator.wikimedia.org/T137323#2364905 (10BBlack) @JanZerebecki - most of our production hosts are in private in... [20:33:40] 06Labs, 10DBA: Replicate CentralNotice tables to Labs - https://phabricator.wikimedia.org/T135405#2374114 (10Base) The tables in the desc looks like indeed the most useful ones, but I would like all the extension's tables to be replicated. [20:41:25] 06Labs, 10Tool-Labs, 13Patch-For-Review: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed - https://phabricator.wikimedia.org/T121279#2374115 (10doctaxon) Why is it not possible to postpone the closing of HTTP POST loophole? At German Wikipedia MerlBot is a very important bot w... [20:53:11] 06Labs, 10Tool-Labs, 13Patch-For-Review: Figure out a way to keep MerlBot running when the HTTP POST loophole is closed - https://phabricator.wikimedia.org/T121279#2374119 (10BBlack) Because Merlbot is a relatively-special case, we've already discussed in some related email threads about leaving a loophole o... [22:29:03] Change on 12wikitech.wikimedia.org a page Nova Resource:Tools/Access Request/Lesgles was created, changed by Lesgles link https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Access_Request/Lesgles edit summary: Created page with "{{Tools Access Request |Justification=I'm an administrator on Latin Wikipedia, and I'm interested in setting up a bot to correct minor spelling mistakes and do various mainten..." [22:45:41] 10Quarry: Add a possibility to delete a draft - https://phabricator.wikimedia.org/T135908#2314983 (10Base) What I do — I just reuse the queries which better'd be deleted or which were just those empty ones. Once you've renamed and changed it nobody knows what it was before that. Perhaps some process for marking... [22:57:20] 10Quarry: Add a possibility to delete a draft - https://phabricator.wikimedia.org/T135908#2374162 (10Dvorapa) @Base The same as I do. That is a great idea to add a possibility to mark them for reuse.