[01:56:42] 06Labs: Revert: request increased quota (floating ip) for "cvn" labs project - https://phabricator.wikimedia.org/T150209#2807686 (10Krinkle) @chasemp This is now done. I've released one of the floating IPs. We're back to 2 now. [01:56:51] 06Labs, 07Tracking: Existing Labs project quota increase requests (Tracking) - https://phabricator.wikimedia.org/T140904#2807688 (10Krinkle) [01:56:53] 06Labs: Revert: request increased quota (floating ip) for "cvn" labs project - https://phabricator.wikimedia.org/T150209#2807687 (10Krinkle) 05stalled>03Open [01:59:34] PROBLEM - Puppet run on tools-webgrid-lighttpd-1208 is CRITICAL: CRITICAL: 66.67% of data above the critical threshold [0.0] [02:08:32] 10Tool-Labs-tools-Other, 06Community-Tech, 07Easy: Edit Count tool on labs shows text in wrong language - https://phabricator.wikimedia.org/T111512#2807705 (10kaldari) 05Open>03Resolved a:03kaldari Looks like this was fixed by Ori. [02:34:35] RECOVERY - Puppet run on tools-webgrid-lighttpd-1208 is OK: OK: Less than 1.00% above the threshold [0.0] [04:41:15] PROBLEM - Puppet staleness on tools-mail-01 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [43200.0] [04:59:33] PROBLEM - Puppet staleness on tools-proxy-01 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [43200.0] [06:59:49] 10Quarry, 10Tool-Labs-tools-tsreports: Quarry-TSreports feature parity - https://phabricator.wikimedia.org/T78549#2807839 (10intracer) [07:26:45] 10Quarry: Allow to translate Quarry UI - https://phabricator.wikimedia.org/T151104#2807850 (10intracer) [07:38:30] 10Quarry: Excel does not recognize Quarry CSV output as UTF-8 - https://phabricator.wikimedia.org/T76126#790571 (10zhuyifei1999) >>! In T76126#800937, @valhallasw wrote: > One option might be to add .xlsx output, which probably supports non-MBCS encodings. +1 [08:16:56] 10Quarry, 07I18n: Allow to translate Quarry UI - https://phabricator.wikimedia.org/T151104#2807868 (10matej_suchanek) [10:09:47] 10Quarry: Quarry exports integers as floats to wikitable - https://phabricator.wikimedia.org/T151106#2807913 (10intracer) [11:13:51] 10Quarry: Quarry truncates values - https://phabricator.wikimedia.org/T151108#2807947 (10intracer) [11:46:19] 10Quarry: Quarry truncates values - https://phabricator.wikimedia.org/T151108#2807983 (10intracer) 05Open>03Invalid All ok, just need to add ``` SET SESSION group_concat_max_len = 10000; ``` [13:26:57] I'm having KeyboardInterrupt errors with time.sleep [13:27:11] that shouldn't happen, right? [13:30:22] are you inputting Ctrl+C while it's running time.sleep ? [13:37:03] no [13:41:49] I jstart it, then don't do anything. I then check the .err file, and http://pastebin.com/jxEqsF1D occurs [14:01:19] ideas? [14:55:15] how can I find the sql db where my tools store things? [14:59:30] mafk, `sql local` [14:59:45] it's empty [14:59:48] hm [15:00:06] MariaDB ([none]) [15:00:09] 10Quarry: Add an option to export result in Wikilist - https://phabricator.wikimedia.org/T137268#2363098 (10XXN) Should there be 2 options for each type of list: bulleted and numbered? **----** As an alternative users always can output resultset in the following format: ``` SELECT CONCAT('* ',page_title) AS pa... [15:00:30] so our tools are suposed to store info somewhere... where "somewhere" it's unknown [15:00:31] mafk, which tool? [15:00:37] Krenair: stewardbots [15:00:49] can you do some computer magic? [15:01:59] krenair@tools-bastion-03:~$ sudo grep user /data/project/stewardbots/replica.my.cnf [15:01:59] user='s51541' [15:02:13] then `sql local` and `show databases like 's51541\_%';` [15:02:26] reveals DBs s51541_stewardbot and s51541_sulwatcher [15:02:52] so you want to `sql local` then either `use s51541_stewardbot` or `use s51541_sulwatcher` [15:03:57] yep, those tables are used for the two of our bots [15:04:04] those are databases [15:04:12] I'll try to log to them [15:04:16] yep, dbs, sorry [15:04:29] one contains 5 tables and one contains 3 tables [15:07:13] okay so I'm in the _stewardbot db [15:08:51] show tables; [15:08:54] got it [15:11:14] I should probably delete the contents from logging@sulwatcher, it's very large [15:11:23] with very outdated stuff [15:33:36] DELETE * FROM table_name; :P [15:40:24] 10Tool-Labs-tools-stewardbots: Delete old data and or stop logging to stewardbots' SULWatcher SQL DB - https://phabricator.wikimedia.org/T151113#2808090 (10MarcoAurelio) [15:41:14] 10Tool-Labs-tools-stewardbots: Delete old data and/or stop logging to stewardbots' SULWatcher SQL DB - https://phabricator.wikimedia.org/T151113#2808102 (10MarcoAurelio) p:05Triage>03Normal [15:49:05] 10Quarry: Huge resultsets may cause issues (Quarry) - https://phabricator.wikimedia.org/T151114#2808108 (10XXN) [16:12:05] (03PS1) 10MarcoAurelio: Link fix [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/322427 [16:12:33] (03CR) 10jenkins-bot: [V: 04-1] Link fix [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/322427 (owner: 10MarcoAurelio) [16:15:28] (03CR) 10MarcoAurelio: [C: 032 V: 032] Link fix [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/322427 (owner: 10MarcoAurelio) [16:17:29] (03CR) 10MarcoAurelio: "Ignored tox check due to HTML changes only and being failing on a file not modifiyed here." [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/322427 (owner: 10MarcoAurelio) [16:19:56] 10Quarry: Huge resultsets may cause issues - https://phabricator.wikimedia.org/T151114#2808153 (10Reedy) [16:29:54] 10Quarry: Huge resultsets may cause issues - https://phabricator.wikimedia.org/T151114#2808161 (10XXN) [18:22:31] 10Tool-Labs-tools-Xtools, 07I18n: xTools not translating some strings - https://phabricator.wikimedia.org/T150931#2808303 (10MusikAnimal) 05Open>03Resolved a:03MusikAnimal I cleared the i18n cache in Redis and that seemed to do it. Most likely unrelated, there's issues with the Top Pages tool now: http:/... [18:35:47] (03PS1) 10Ricordisamoa: Fix for cachetools v2.0.0 [labs/tools/ptable] - 10https://gerrit.wikimedia.org/r/322429 [18:41:26] I have a bot that has quite a few DB requests. Is there a way to remove that limit? [18:42:21] what limit? [18:42:22] DatGuy is there not a way to merge the requests together? [18:43:08] Isec [18:46:35] http://imgur.com/a/qgEN6 I can only assume its regarding to the Labs database since I have the bot flag on enwiki [18:55:44] thats a 503 errror not a db [18:58:08] I know, but API shouldn't trigger that [18:58:31] If something goes wrong... [18:59:47] DatGuy maybe its an connection rate throttle to enwiki or something i dont know (even though since its an labs ip shouldnt wmf sites ignore anything connecting wise from labs) [19:05:15] "even though since its an labs ip shouldnt wmf sites ignore anything connecting wise from labs" - why should they ignore traffic from labs? [19:06:08] (03CR) 10Ricordisamoa: [C: 032] Fix for cachetools v2.0.0 [labs/tools/ptable] - 10https://gerrit.wikimedia.org/r/322429 (owner: 10Ricordisamoa) [19:06:27] (03Merged) 10jenkins-bot: Fix for cachetools v2.0.0 [labs/tools/ptable] - 10https://gerrit.wikimedia.org/r/322429 (owner: 10Ricordisamoa) [19:06:28] tom29739 i meant throttling [19:13:56] Is there a way to override this? [19:14:46] A throttle wouldn't give a 503 [19:14:47] DatGuy try reducing the edit rate? [19:15:00] the edit rate itself isn't that high [19:15:07] (if you mean writing to the API) [19:39:43] Does the following work? */15 * * * * jsub -N clearlog -once /data/project/datbot/biglog.sh [19:40:07] it should DatGuy [19:40:13] it will email you with any errors if any [19:40:33] and that's in crontab -e [19:40:39] correct [19:53:16] 06Labs, 10Labs-Infrastructure, 07Beta-Cluster-reproducible, 07Puppet: New instance have broken puppet configuration when using puppetmaster standalone - https://phabricator.wikimedia.org/T148929#2808344 (10hashar) p:05Triage>03High [19:53:27] 06Labs, 10Labs-Infrastructure, 10Continuous-Integration-Infrastructure, 07Beta-Cluster-reproducible, 07Puppet: New instance have broken puppet configuration when using puppetmaster standalone - https://phabricator.wikimedia.org/T148929#2736876 (10hashar) [19:54:16] 06Labs, 10Labs-Infrastructure, 10Continuous-Integration-Infrastructure, 07Beta-Cluster-reproducible, 07Puppet: New instance have broken puppet configuration when using puppetmaster standalone - https://phabricator.wikimedia.org/T148929#2736876 (10hashar) @mobrovac here is the task related to the instance... [19:54:25] 06Labs, 10Labs-Infrastructure, 10Continuous-Integration-Infrastructure, 07Beta-Cluster-reproducible, 07Puppet: New instance have broken puppet configuration when using puppetmaster standalone - https://phabricator.wikimedia.org/T148929#2808351 (10hashar) [20:01:24] 06Labs, 10Labs-Infrastructure, 10Continuous-Integration-Infrastructure, 07Beta-Cluster-reproducible, 07Puppet: New instance have broken puppet configuration when using puppetmaster standalone - https://phabricator.wikimedia.org/T148929#2808357 (10hashar) Note that once one has deleted `/var/lib/puppet/ss... [20:22:02] PROBLEM - Puppet run on tools-services-02 is CRITICAL: CRITICAL: 100.00% of data above the critical threshold [0.0] [20:55:28] bd808? have you had time to look at the change yet (sorry i am just really curious today) [22:13:06] (03CR) 10Paladox: "recheck" [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:14:50] (03PS3) 10Zppix: about.php addition [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/320859 [22:15:32] (03CR) 10Zppix: [C: 032] "Merging still WIP but I want to avoid having merge conflicts with this file." [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/320859 (owner: 10Zppix) [22:15:40] (03Merged) 10jenkins-bot: about.php addition [labs/tools/ZppixBot] - 10https://gerrit.wikimedia.org/r/320859 (owner: 10Zppix) [22:16:12] (03CR) 10Zppix: [C: 032] Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:18:41] (03CR) 10Paladox: [C: 032] "I'm going to re do c+2 since it froze." [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:19:01] (03Abandoned) 10Paladox: Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:19:04] (03Restored) 10Paladox: Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:19:08] (03CR) 10Paladox: Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:19:11] (03CR) 10Paladox: [C: 032] Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:19:45] (03Merged) 10jenkins-bot: Replacing swig with swig-templates [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/320294 (owner: 10Paladox) [22:28:10] (03PS1) 10Paladox: Fix swig calling colors instead of color [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/322487 [22:28:19] (03CR) 10Paladox: [C: 032] Fix swig calling colors instead of color [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/322487 (owner: 10Paladox) [22:28:50] (03Merged) 10jenkins-bot: Fix swig calling colors instead of color [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/322487 (owner: 10Paladox) [22:31:23] (03CR) 10Zppix: "Approved self-merge due to failures preventing the bot from working properly" [labs/tools/grrrit] - 10https://gerrit.wikimedia.org/r/322487 (owner: 10Paladox)