[02:39:53] 10Quarry: Quary API - https://phabricator.wikimedia.org/T178751#3701668 (10Green_Cardamom) [02:51:14] 10Quarry: Quarry API - https://phabricator.wikimedia.org/T178751#3701680 (10zhuyifei1999) [03:04:23] 10Quarry: Quarry API - https://phabricator.wikimedia.org/T178751#3701668 (10zhuyifei1999) If you are developing a tool or bot, you can run it on Wikimedia Cloud VPS or Toolforge and connect to the wiki replicas directly. Please see https://wikitech.wikimedia.org/wiki/Portal:Data_Services#Wiki_Replicas. I would n... [03:28:27] 10Quarry: Quarry API - https://phabricator.wikimedia.org/T178751#3701668 (10Base) It is also possible to run a bot a normal way (from personal computer or your own server) and ssh tunnel to Toolforge to run a database query (I believe it is easy to google how to do it for popular languages, I did not have troubl... [03:35:53] 10Quarry: Quarry API - https://phabricator.wikimedia.org/T178751#3701692 (10Green_Cardamom) As background I've written a unix command-line tool called Wikiget for accessing certain Wikimedia API functions to generate lists of article titles https://github.com/greencardamom/Wikiget I'd like to be able to offer... [05:11:09] 10Quarry: Quarry API - https://phabricator.wikimedia.org/T178751#3701702 (10zhuyifei1999) >>! In T178751#3701692, @Green_Cardamom wrote: > I'd like to be able to offer a new switch so users can send SQL queries from the command-line with Wikiget via Quarry API At the current state, I don't think this is within t... [06:28:32] (03PS172) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [06:39:07] (03CR) 10Ricordisamoa: [C: 04-2] "PS172 moves creation of POST data object from DragHelper to EditManager" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [06:42:47] (03PS173) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [06:51:52] (03CR) 10Ricordisamoa: [C: 04-2] "PS173 removes the outerIIFEBody option from the ESLint indent rule" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [07:07:48] (03PS174) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [07:13:23] (03CR) 10Ricordisamoa: [C: 04-2] "PS174 changes some vars into lets and consts" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [07:15:01] (03PS175) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [07:22:07] (03CR) 10Ricordisamoa: [C: 04-2] "PS175 moves some let declarations" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [07:24:26] (03PS176) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [07:28:47] (03CR) 10Ricordisamoa: [C: 04-2] "PS176 removes a useless variable" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [07:38:23] (03PS177) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [08:07:44] 10Data-Services, 10DBA, 10Security-Team: gblrename log_type missing on replicas - https://phabricator.wikimedia.org/T178752#3701720 (10Steinsplitter) [08:07:57] 10Data-Services, 10DBA, 10Security-Team: gblrename log_type missing on replicas - https://phabricator.wikimedia.org/T178752#3701734 (10Steinsplitter) [08:17:06] (03CR) 10Ricordisamoa: [C: 04-2] "PS177 replaces some functions with arrow functions" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [08:23:21] (03PS178) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [08:28:06] (03CR) 10Ricordisamoa: [C: 04-2] "PS178 changes demo.js into a module" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [08:29:35] (03PS179) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [08:33:17] (03CR) 10Ricordisamoa: [C: 04-2] "PS179 enables the ESLint wrap-iife rule" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [08:39:16] (03PS180) 10Ricordisamoa: Initial commit [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 [08:45:58] (03CR) 10Ricordisamoa: [C: 04-2] "PS180 changes some vars into lets and consts" [labs/tools/wikidata-slicer] - 10https://gerrit.wikimedia.org/r/241296 (owner: 10Ricordisamoa) [12:04:11] 10Quarry: Provide an API so external tools can run SQL queries via Quarry - https://phabricator.wikimedia.org/T178751#3701816 (10Aklapper) [13:43:44] 10Cloud-Services, 10Outreachy (Round-15): Proposal: Improvements for the Toolforge 'webservice' command - https://phabricator.wikimedia.org/T177603#3702064 (10Sowjanyavemuri) [15:11:28] 10Cloud-Services, 10Toolforge, 10DBA: Multiple concurrent long running queries from s51434 overloading labsdb1003 - https://phabricator.wikimedia.org/T133705#3702145 (10jcrespo) 05Resolved>03Open @Magnus these queries are unlikely to finish, ever (running for 2 days) CC @Marostegui. This time on labsdb1... [15:11:55] 10Cloud-Services, 10DBA: Multiple concurrent long running queries from s51434 overloading labsdb1003/labsdb1009 - https://phabricator.wikimedia.org/T133705#3702148 (10jcrespo) [15:51:15] 10Cloud-Services, 10Outreachy (Round-15): Proposal: Improvements for the Toolforge 'webservice' command - https://phabricator.wikimedia.org/T177603#3702183 (10Andrew) @Sowjanyavemuri, the Outreachy coordinators that I've spoken to are firm that your schedule does not qualify you for an internship for this cycl... [16:32:15] 10Cloud-Services, 10DBA: Multiple concurrent long running queries from s51434 overloading labsdb1003/labsdb1009 - https://phabricator.wikimedia.org/T133705#3702228 (10Magnus) OK, these are my old workaround for the removal of a wikidata DB table. (I did day the removal of the table will cause problems, but doe... [18:46:53] Hello all, my replica.my.cnf in /home/urbanecm is owned by unnamed group (GID is 13367). All my other files are owned by the wikidev group. Was there some re-numbering? [18:54:01] Urbanecm: not as far as I know. Your uid is 13367, so that's at least somewhat consistent, but I think the group should have been `wikidev` (or something like that), not a user group [18:56:15] Hm, in my case it's Uid: ( 1092/valhallasw) Gid: ( 550/ UNKNOWN) -- while wikidev is gid 500. Odd. [18:56:46] for tools, uid and gid are equal: Access: (0400/-r--------) Uid: (51328/tools.gerrit-reviewer-bot) Gid: (51328/ tools.gerrit-reviewer-bot) [18:57:46] mine are good [18:57:54] Access: (0400/-r--------) Uid: ( 3306/zhuyifei1999) Gid: ( 500/ wikidev) [18:59:40] I see a bunch of different patterns for world-readable home dirs. Some are 500, some are 550, some are the same as the uid [18:59:56] https://github.com/wikimedia/puppet/blob/dc84809ec7d3a595df5b6b59a4163db2e9493401/modules/role/files/labs/db/maintain-dbusers.py#L124 huh [19:00:53] zhuyifei1999_: that is true for tool users, but not for regular users [19:01:21] not that it really matters, the access os 0o400 anyway [19:03:06] maybe different versions of that maintain-dbusers set different gids? [19:03:22] it was in perl, once upon a time [19:05:19] there are even many homedirs owned my 550 [19:12:55] quite possible [19:45:06] (03PS1) 10Krinkle: Add LICENSE [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385853 [19:46:57] (03CR) 10Krinkle: [C: 032] Add LICENSE [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385853 (owner: 10Krinkle) [19:47:22] (03Merged) 10jenkins-bot: Add LICENSE [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385853 (owner: 10Krinkle) [20:54:03] 10Quarry: Provide an API so external tools can run SQL queries via Quarry - https://phabricator.wikimedia.org/T178751#3702386 (10Green_Cardamom) Ok I'll close this it doesn't sound like it will work but thanks for the explanations and good to have explored the idea anyway. [20:54:17] 10Quarry: Provide an API so external tools can run SQL queries via Quarry - https://phabricator.wikimedia.org/T178751#3702387 (10Green_Cardamom) 05Open>03declined [21:21:17] !log rcm Oxygen: stopping runners, restarting the server, starting runners then again [21:21:19] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Rcm/SAL [21:56:25] (03PS1) 10Krinkle: Output: Fix unclosed
    element from ChronologyOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385925 [21:56:27] (03PS1) 10Krinkle: frontend: Disable the submit button when loading, instead of hiding [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385926 [21:56:29] (03PS1) 10Krinkle: Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 [21:56:49] (03CR) 10jerkins-bot: [V: 04-1] Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 (owner: 10Krinkle) [22:00:00] (03PS1) 10Krinkle: [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 [22:00:28] (03CR) 10jerkins-bot: [V: 04-1] [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 (owner: 10Krinkle) [22:02:54] (03PS2) 10Krinkle: Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 [22:02:56] (03PS2) 10Krinkle: [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 [22:03:17] (03CR) 10jerkins-bot: [V: 04-1] [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 (owner: 10Krinkle) [22:04:28] (03PS3) 10Krinkle: Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 [22:04:30] (03PS3) 10Krinkle: [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 [22:04:51] (03CR) 10jerkins-bot: [V: 04-1] [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 (owner: 10Krinkle) [22:15:43] (03CR) 10Krinkle: [C: 032] Output: Fix unclosed
      element from ChronologyOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385925 (owner: 10Krinkle) [22:15:47] (03CR) 10Krinkle: [C: 032] frontend: Disable the submit button when loading, instead of hiding [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385926 (owner: 10Krinkle) [22:15:50] (03CR) 10Krinkle: [C: 032] Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 (owner: 10Krinkle) [22:15:53] (03Abandoned) 10Krinkle: [WIP] Add demo page for testing styles and layout [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385928 (owner: 10Krinkle) [22:16:09] (03Merged) 10jenkins-bot: Output: Fix unclosed
        element from ChronologyOutput [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385925 (owner: 10Krinkle) [22:16:13] (03Merged) 10jenkins-bot: frontend: Disable the submit button when loading, instead of hiding [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385926 (owner: 10Krinkle) [22:16:15] (03Merged) 10jenkins-bot: Modernise layout and remove (broken) Tool Labs logo [labs/tools/guc] - 10https://gerrit.wikimedia.org/r/385927 (owner: 10Krinkle)