[00:13:45] I feel this could be better written up somewhere else https://phabricator.wikimedia.org/T179922#3753537 [00:47:16] bd808: so, if i continue seeing this: oursql.ProgrammingError: (1049, "Unknown database 's52467__hashtags'", None) even after switching to c1 (and c3), what might be going on? [00:48:23] AFAIK user dbs haven't moved? [00:48:25] hmmm... the reporting tool sees that database -- https://tools.wmflabs.org/tool-db-usage/owner/s52467 [00:48:35] it would not be on c3 [00:48:44] but it should still be on c1 [00:50:53] I can confirm that `use s52467__hashtags;` works on c1.labsdb from an account that has global use permissions [00:54:13] yeah, and i can get at it using my defaults file with the mysql cli, so let's see, maybe some addresses are being cached somewhere [01:07:52] cool, all fixed, for now! I'll have to pencil in some time to rearchitect some things [01:36:53] What is labsdb1010? There's nothing useful on the wiki about it [01:38:05] Dispenser: today it is a hot spare for 09 and 11 [01:38:31] in the future it may be used to take some of the load for the web or analytics hosts [01:38:48] there was a bit about the architecture in the blog post we wrote [01:39:07] https://phabricator.wikimedia.org/phame/post/view/70/new_wiki_replica_servers_ready_for_use/ [01:39:49] the last paragraph in the "bigger, faster, more available" section [08:03:18] (03PS1) 10Hashar: Fix flake8 'do not use bare except' [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) [08:17:13] (03CR) 10jenkins-bot: Localisation updates from https://translatewiki.net. [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390954 (owner: 10L10n-bot) [09:08:22] (03Abandoned) 10Hashar: basic setup for the application [labs/tools/flow-oauth-demo] - 10https://gerrit.wikimedia.org/r/213590 (https://phabricator.wikimedia.org/T101217) (owner: 10Rjain) [09:14:03] (03Abandoned) 10Hashar: Code-style tweaks [labs/tools/wikicaptcha] - 10https://gerrit.wikimedia.org/r/197514 (owner: 10Ricordisamoa) [09:14:09] (03PS5) 10Lokal Profil: Make statistics table for unknown fields [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390169 [09:14:42] (03PS13) 10Lokal Profil: Restructure missing_commonscat_links [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/380060 (https://phabricator.wikimedia.org/T176528) [09:15:36] (03Abandoned) 10Hashar: Add README.md [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/305851 (owner: 10Jérémie Roquet) [09:15:49] (03Abandoned) 10Hashar: a [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361629 (owner: 10Minhtq15) [09:15:51] (03Abandoned) 10Hashar: fourth [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361628 (owner: 10Minhtq15) [09:15:54] (03Abandoned) 10Hashar: asd [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361626 (owner: 10Minhtq15) [09:15:56] (03Abandoned) 10Hashar: second [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361021 (owner: 10Minhtq15) [09:15:59] (03Abandoned) 10Hashar: first commit [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361020 (owner: 10Minhtq15) [09:16:02] (03Abandoned) 10Hashar: a [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/361022 (owner: 10Minhtq15) [09:16:10] (03Abandoned) 10Hashar: init readme [labs/tools/WikiConvFR-training-2016] - 10https://gerrit.wikimedia.org/r/305865 (owner: 10Xavier Combelle) [09:53:22] (03CR) 10Jean-Frédéric: [C: 032] [BUGFIX]Allow non-ascii template names [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390064 (https://phabricator.wikimedia.org/T180068) (owner: 10Lokal Profil) [09:53:57] (03CR) 10Jean-Frédéric: [C: 032] "Good catch that it was not updated!" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390064 (https://phabricator.wikimedia.org/T180068) (owner: 10Lokal Profil) [09:55:08] (03Merged) 10jenkins-bot: [BUGFIX]Allow non-ascii template names [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390064 (https://phabricator.wikimedia.org/T180068) (owner: 10Lokal Profil) [09:56:09] (03CR) 10jenkins-bot: [BUGFIX]Allow non-ascii template names [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390064 (https://phabricator.wikimedia.org/T180068) (owner: 10Lokal Profil) [09:58:28] (03PS1) 10Jean-Frédéric: [WIP] Fix unsafe operation on str that should use unicode [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 [09:59:46] (03CR) 10jerkins-bot: [V: 04-1] [WIP] Fix unsafe operation on str that should use unicode [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 (owner: 10Jean-Frédéric) [10:02:37] (03CR) 10Jean-Frédéric: "Not sure what to do with the `b` strings..." [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 (owner: 10Jean-Frédéric) [13:01:00] it seems like there are some bots running on the bastion again [13:01:19] https://www.irccloud.com/pastebin/uXsVs3PF/ [14:18:00] Hi. I want to know, into what table in DB being logged global bot assigns? When some user became a global bot, in what DB table it is written? It is not a 'logging' table on meta, this table is only for local meta bots [14:36:35] SELECT * FROM user_groups; ? [14:41:55] jynus, no, I want to know entire history of global bot assigns, not only current list [14:42:26] for local bots it is in the 'logging' table [14:42:55] shouldn't it be on the logging of meta, is somwhere? [14:43:39] maybe it is on centralauth [14:45:12] no, 'logging' table on meta contains only records about local meta bots and non-global bots for small wikis without crats [14:45:16] there is a global-bot SELECT DISTINCT gug_group FROM global_user_groups; [14:47:05] meta has no table 'global_user_groups', see https://quarry.wmflabs.org/query/23018 [14:47:12] centraluth [14:47:15] not metawiki [14:48:26] https://quarry.wmflabs.org/query/23026 [14:50:51] ok, but this is not a history [14:51:09] where is a logging table for global groups assigns? [14:53:21] mbh: meta `logging`, type = 'gblrights' [14:54:23] zhuyfei, thank you [14:54:34] np [14:55:24] select distinct log_title from logging where log_type="gblrights" and log_params like '%global-bot%'; on meta is what i looking for [15:35:25] (03CR) 10Jean-Frédéric: [C: 032] Stop categorization job during database update [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390142 (owner: 10Lokal Profil) [15:36:08] (03Merged) 10jenkins-bot: Stop categorization job during database update [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390142 (owner: 10Lokal Profil) [15:36:55] (03CR) 10jenkins-bot: Stop categorization job during database update [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390142 (owner: 10Lokal Profil) [16:00:58] (03CR) 10MarcoAurelio: "check experimental" [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) (owner: 10Hashar) [16:02:18] (03CR) 10MarcoAurelio: "check experimental" [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) (owner: 10Hashar) [16:02:58] (03CR) 10MarcoAurelio: "@hashar The bot doesn't listen to me. Can we 'check experimental' here? Thanks." [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) (owner: 10Hashar) [16:07:49] (03CR) 10Paladox: "check experimental" [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) (owner: 10Hashar) [17:03:55] !log reading-web-staging Joined project as admin user to help debug T180037 [17:03:57] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Reading-web-staging/SAL [17:03:57] T180037: [Spike] Can the new render service on Debian Stretch? - https://phabricator.wikimedia.org/T180037 [17:05:00] (03CR) 10Lokal Profil: "couldn't see b' strings in the Jenkins complaint.or did you see that somewhere else" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 (owner: 10Jean-Frédéric) [17:07:59] (03CR) 10Zoranzoki21: [C: 031] git.wikimedia.org -> phab [labs/tools/lists] - 10https://gerrit.wikimedia.org/r/390329 (https://phabricator.wikimedia.org/T139089) (owner: 10TerraCodes) [17:11:57] !log reading-web-staging Removed role::labs::mediawiki_vagrant from project global puppet config in horizon (T180037) [17:12:00] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Reading-web-staging/SAL [17:12:00] T180037: [Spike] Can the new render service on Debian Stretch? - https://phabricator.wikimedia.org/T180037 [17:16:47] (03CR) 10Jean-Frédéric: "> couldn't see b' strings in the Jenkins complaint.or did you see" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 (owner: 10Jean-Frédéric) [17:18:11] !log reading-web-staging Attempting to create chromium-render-stretch.reading-web-staging.eqiad.wmflabs instance (T180037) [17:18:13] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Reading-web-staging/SAL [17:18:13] T180037: [Spike] Can the new render service run on Debian Stretch? - https://phabricator.wikimedia.org/T180037 [17:31:12] (03CR) 10Lokal Profil: "> > couldn't see b' strings in the Jenkins complaint.or did you see" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/390969 (owner: 10Jean-Frédéric) [19:54:09] (03CR) 10Hashar: "There are no jobs defined in the experimental pipeline for that repository." [labs/tools/stewardbots] - 10https://gerrit.wikimedia.org/r/390951 (https://phabricator.wikimedia.org/T180283) (owner: 10Hashar) [23:41:10] (03PS1) 10Lokal Profil: [WIP] Fix bad idx entries [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/391139 (https://phabricator.wikimedia.org/T174503) [23:48:48] (03CR) 10Lokal Profil: "so looking at the results it seems as though (at least sometimes) the whole id's string is cut down in size (not just the municipality pa" [labs/tools/heritage] - 10https://gerrit.wikimedia.org/r/391139 (https://phabricator.wikimedia.org/T174503) (owner: 10Lokal Profil)