[10:11:56] (03CR) 10Kosta Harlan: [C: 03+2] Add an image: update schema for editsummary_dialog [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737135 (https://phabricator.wikimedia.org/T294672) (owner: 10MewOphaswongse) [10:12:38] (03Merged) 10jenkins-bot: Add an image: update schema for editsummary_dialog [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737135 (https://phabricator.wikimedia.org/T294672) (owner: 10MewOphaswongse) [10:23:23] (03CR) 10Kosta Harlan: [C: 03+2] Add a link: add expand and collapse actions [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737114 (https://phabricator.wikimedia.org/T293147) (owner: 10MewOphaswongse) [10:24:07] (03Merged) 10jenkins-bot: Add a link: add expand and collapse actions [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737114 (https://phabricator.wikimedia.org/T293147) (owner: 10MewOphaswongse) [10:32:26] joal: o/ (just saw your ping from last week) [10:54:56] Hi dcausse - actually I solved my question alone :) [11:06:14] ok :) [11:09:11] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban: Snapshot and Reload cassandra2 pageview_per_article data table from all 12 instances - https://phabricator.wikimedia.org/T291472 (10BTullis) All compactions from the previous load have completed. Starting the reload of the 9th... [11:47:32] hi all, a question: if I would like to get the total pageview data for the top 25 Wikipedias as shown here for eswiki: https://stats.wikimedia.org/#/es.wikipedia.org/reading/total-page-views/normal|table|2019-10-01~2021-12-01|~total|monthly in an automated way (e.g. a Python script), how should I go about it? [11:51:56] CristianCantoro: Hello. I would start by looking at and trying out some queries available here: https://wikimedia.org/api/rest_v1/#/ [11:53:23] btullis: great, I will take a look, thanks [11:54:53] CristianCantoro: You're welcome. Feel free to come back with any more queries if you run into issues and we'll try to help. [11:56:11] btulis: I have spotted a very small bug in the https://stats.wikimedia.org/ website, namely the IRC link in the footer still links to freenode :-S [11:56:57] I would like to fix it myself, I have a developer account but never used gerrit and that part of the infrastructure [11:57:42] also, it seems that I had to add my SSH key to my gerrit account, it was added on the Wikitech OpenStack preferences but I was getting a permission denied error [11:57:46] now it works [11:58:24] CristianCantoro: Great, thanks for contributing 😃 [12:01:40] CristianCantoro: It sounds like you're well on your way to fixing it, but let us know if you get stuck again. You can create a Phabricator ticket and tag it with #analytics-wikistats if you like. We'll get the change deployed asap. [12:36:19] btullis: ok, I was able to install te dependencies (had to take a moment to figure out the version of node+npm) and I had a couple of hiccups with missing dependencies for `gulp`, but I have made the fix and I can see the fixed version locally. It is also passing all the tests :-) [12:36:25] (horray!) [12:37:56] btullis: what I see is that now `package.json`, `package-lock.json` and `src/components/BottomFooter.vue``(where I made the fix) are changed [12:38:39] CristianCantoro: Awesome. Great progress. [12:38:42] should I commit only the changes in `src/components/BottomFooter.vue` and ignore the changes in `package.json` ? [12:40:54] ah, I see for some reason it didn't like that I installed `gulp` globally and so I installed it locally (without `-g` and that's why it has changed the `package.json` [12:41:05] CristianCantoro: I think so, yes. It's likely that the changes to `package.json` and `package-lock.json` are only related to your dependency issue. [12:41:46] ok, then I will commit only `src/components/BottomFooter.vue` [12:42:34] CristianCantoro: https://en.wikipedia.org/wiki/Success_Kid#/media/File:SuccessKid.jpg [12:43:54] Thanks again. [13:20:03] (03PS1) 10CristianCantoro: Fix webchat link from Freenode to Libera [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 [13:20:05] (03CR) 10Welcome, new contributor!: "Thank you for making your first contribution to Wikimedia! :) To learn how to get your code changes reviewed faster and more likely to get" [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 (owner: 10CristianCantoro) [13:23:31] 🥳🥳🥳 [13:54:30] (03CR) 10Btullis: "Thanks very much for this contribution." [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 (owner: 10CristianCantoro) [13:57:41] hello! btullis yt? got a sec to be my backup for https://phabricator.wikimedia.org/T279440#7481773 ? [13:58:05] Certainly have. Batcave? [13:58:29] ya [13:58:33] 2 mins [14:33:24] (03CR) 10CristianCantoro: "I missed that, it would make total sense to change both. Can I do a new commit+squash or how can I do that?" [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 (owner: 10CristianCantoro) [14:36:16] (03CR) 10Milimetric: Add discussiontools_subscription query to sqoop (031 comment) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/736021 (https://phabricator.wikimedia.org/T290516) (owner: 10MNeisler) [14:54:18] (03CR) 10Joal: "discussion continuation :)" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/736021 (https://phabricator.wikimedia.org/T290516) (owner: 10MNeisler) [14:59:46] hm, lots of these kinds of disconnects where my username gets changed and then it can't automatically rejoin [15:00:05] yeah, it has happened to me as well milimetric :( [15:04:51] Hi, just to say that I haven't managed to do anything with the `monitor_refine_event_sanitized_analytics_delayed` alarms today. I see the patch that you created is still active mforns: https://gerrit.wikimedia.org/r/c/operations/puppet/+/737110 but I wasn't sure whether I was supposed to re-run the service, reset failed, or leave it for now. [15:05:31] btullis: I was just going to ping :) [15:05:42] I think we should merge Marcel's patch [15:06:16] it looks to me like the alerts we get every day are solved by that delay (unless the job takes longer than 2 hours, so maybe we can look at that first and adjust the delay [15:06:18] ) [15:06:31] heya btullis :] I think we can merge the patch and see if it works. We seem to agree that it should fix the problem. I'd say there's nothing wrong with the refine job, so no need to re-run [15:06:50] OK, I can merge and deploy now. Shall I reset-failed on the service as well? [15:07:16] btullis: is that a restart after failure? [15:07:23] if so, yes :] [15:10:32] RECOVERY - Check unit status of monitor_refine_event_sanitized_analytics_delayed on an-launcher1002 is OK: OK: Status of the systemd unit monitor_refine_event_sanitized_analytics_delayed https://wikitech.wikimedia.org/wiki/Analytics/Systems/Managing_systemd_timers [15:10:35] OK, merged, deployed, and I've done a `systemctl reset-failed monitor_refine_event_sanitized_analytics_delayed.service` [15:10:46] It just clears the icinga status --^ [15:11:08] Heading afk for a few hours now for childcare, but will be around again later. [15:28:04] thanks yall ^ [15:38:24] 10Analytics, 10Analytics-Wikistats: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10Kipala) [15:46:43] 10Analytics, 10Patch-For-Review: Data drifts between superset_production on an-coord1001 and db1108 - https://phabricator.wikimedia.org/T279440 (10Ottomata) Oh, somehow I had missed the fact that an-coord1002 IS ALSO OUT OF SYNC! And, it is even more out of sync than ever: an-coord1001: ` MariaDB [(none)]> S... [15:46:57] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Refactor analytics-meta MariaDB layout to multi instance with failover - https://phabricator.wikimedia.org/T284150 (10Ottomata) [15:47:21] 10Analytics, 10Patch-For-Review: Data drifts between superset_production on an-coord1001 and db1108 - https://phabricator.wikimedia.org/T279440 (10Ottomata) [15:54:26] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 (10Ottomata) [15:54:28] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 (10Ottomata) [15:56:33] 10Analytics, 10Patch-For-Review: Data drifts between superset_production on an-coord1001 and db1108 - https://phabricator.wikimedia.org/T279440 (10elukey) >>! In T279440#7489667, @Ottomata wrote: > Oh, somehow I had missed the fact that an-coord1002 IS ALSO OUT OF SYNC! And, it is even more out of sync than e... [15:57:55] I may be a few minutes late for standup [16:12:08] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban: Write document about "Fast Enough Superset" - https://phabricator.wikimedia.org/T294046 (10JAllemandou) Link to document https://docs.google.com/document/d/1bBDQO76y9jLm95veLjR5UswpBvEq9-nW-E9zO5AWULc [16:37:23] 10Analytics, 10Analytics-Wikistats: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10JAllemandou) 05Open→03Invalid Hi @Kipala, thanks for reporting :) The reason for your number of views to be different in 1) is because they include user, spider and automated traffic, whi... [16:39:06] 10Analytics, 10Patch-For-Review: Data drifts between superset_production on an-coord1001 and db1108 - https://phabricator.wikimedia.org/T279440 (10Ottomata) > if you want to merge all in analytics-meta keep an eye on db metrics afterwards (on bare metal it could not even be noticeable, but better safe than sor... [16:46:38] 10Analytics, 10Analytics-Wikistats: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10Kipala) Hi JAllemandou, I suspected something like this. Then it looks to me badly labelled. It should say on the page what you just told me ("include user, spider and automated traffic").... [16:47:45] 10Analytics, 10Analytics-Wikistats: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10JAllemandou) 05Invalid→03Open [16:47:57] 10Analytics, 10Analytics-Wikistats: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10Kipala) Hi JAllemandou, I suspected something like this. Then it looks to me badly labelled. It should say on the page what you just told me ("include user, spider and automated traffic"). B... [16:50:04] (03CR) 10Ottomata: "Hm, this is def safe from a backwards compatibility perspective, but services like EventGate expect the schema versions to be immutable, s" [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/736933 (https://phabricator.wikimedia.org/T294738) (owner: 10Jdlrobson) [16:57:06] (03PS1) 10DCausse: [WIP] rdf-streaming-updater: add a "reconcile" operation [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737429 (https://phabricator.wikimedia.org/T279541) [16:58:28] 10Analytics, 10Analytics-Wikistats, 10Data-Engineering: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10JAllemandou) [17:02:22] 10Analytics, 10Analytics-Wikistats, 10Data-Engineering, 10Data-Engineering-Kanban: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10odimitrijevic) a:03Milimetric [17:13:01] (03PS1) 10Milimetric: Correct pageview data description [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737430 (https://phabricator.wikimedia.org/T295298) [17:27:42] (03CR) 10Andrew Bogott: "Trying to clean up my gerrit todo list got me looking at this patch. We /are/ running 3.7 now arent' we?" [analytics/quarry/web] - 10https://gerrit.wikimedia.org/r/711134 (owner: 10David Caro) [17:43:13] (03CR) 10Joal: [C: 03+1] Correct pageview data description [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737430 (https://phabricator.wikimedia.org/T295298) (owner: 10Milimetric) [17:44:31] 10Analytics, 10Analytics-Wikistats, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10Milimetric) Thanks for pointing this out, @Kipala, I definitely agree with you the description was wrong. Would you m... [17:50:11] milimetric: ottomata: I can create user 'milimetric'; and grant permissions to that user on an-coord1002, is that a good idea? Then milimetric can just `mysql` [17:50:27] (03CR) 10Andrew Bogott: "On my Buster VM (python3.7) I don't get any warnings about allowlist when I run the tests." [analytics/quarry/web] - 10https://gerrit.wikimedia.org/r/711134 (owner: 10David Caro) [17:50:43] razzi: was just looking for an easier way, but yeah i think that will be it., you will probably have to do on an-coord1001 too [17:50:51] ok cool [17:50:51] add to the task what you did so we can eremember to undo it please [17:50:55] sure [17:50:59] https://phabricator.wikimedia.org/T284150 [17:51:04] thanks, making lunch... [17:52:36] razzi: that sounds ok, but is that tied to my user or just the username "milimetric"? So, basically, just making sure someone can't just do "mysql -umilimetric" [17:53:04] hm yeah milimetric that is an issue, I just tried it :P [17:53:15] and it let me in as you though it should not have [17:53:21] We can add a password I guess... [17:53:33] Let me delete that user while we debug this [17:53:33] razzi: if you make it accessable only via localhost [17:53:34] its ok [17:53:38] oh ok [17:53:44] razzi: you can make a my.cnf that only I have access to [17:53:46] also, maybe just make an 'admin' account [17:54:28] I don't know how to write a my.cnf [17:54:30] but I can look it up [17:54:39] that sounds like a good idea though, trusty unix file permissions [18:01:03] these things are usually in /etc/mysql somewhere, there's an example in puppet for the research user accessing all the prod replicas, which is how the analytics-mysql convenience thing works [18:01:14] (everyone has access to that cnf) [18:01:45] you can make a my.cnf that just has [client] settings in it [18:01:51] so I did this [18:02:01] cat my.cnf [18:02:01] [client] [18:02:01] user=admin [18:02:01] password=... [18:02:10] but it doesn't work when I do this: [18:02:25] ```razzi@an-coord1002:~$ mysql --defaults-file=my.cnf [18:02:26] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)``` [18:02:50] but this does work: ```razzi@an-coord1002:~$ mysql -uadmin -p``` [18:04:03] razzi try --defaults-extra-file [18:04:44] 10Analytics, 10Analytics-Wikistats, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Wikistats Bug differing view numbers - https://phabricator.wikimedia.org/T295298 (10Kipala) Looks good! Thanks. I would appreciate if it could be clarified for each pageview page, what is shown. I had... [18:04:46] ```ls -l /home/milimetric/my.cnf [18:04:46] -r-------- 1 milimetric root 66 Nov 8 18:03 /home/milimetric/my.cnf [18:04:50] ``` [18:05:07] lgtm [18:05:20] lmk if you can use it milimetric [18:05:21] thanks! I'll log in in a bit and poke around [18:07:07] !log run `create user 'admin'@'localhost' identified by ; grant all privileges on *.* to admin;` to allow milimetric to access mysql on an-coord1002 for T284150 [18:07:11] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [18:07:11] T284150: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 [18:08:07] I am about to do some routine maintenance on the wiki replica db servers, and it occurs to me that maybe someone in here would like to do it, or follow along, or generally know that it's happening. Any takers? [18:08:21] (Don't be shy, this will definitely be a blind-leading-blind situation since Brooke used to do most of this) [18:08:27] mysql --defaults-extra-file=my.cnf works for me btw [18:08:37] I'll follow along andrewbogott ! [18:10:44] (03CR) 10Jdlrobson: [C: 04-1] Add `init` as a valid enum for action field (031 comment) [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/736933 (https://phabricator.wikimedia.org/T294738) (owner: 10Jdlrobson) [18:42:04] (03PS1) 10Jenniferwang: Add skin_diff schema to sanitize allowlist Ticket:T287255 [analytics/refinery] - 10https://gerrit.wikimedia.org/r/737471 [18:46:39] (03CR) 10Jenniferwang: "Hi Megan, could you review the fields of skin_diff to be added to the allowlist?" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/737471 (owner: 10Jenniferwang) [18:59:50] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 (10Ottomata) FYI, I merged https://phabricator.wikimedia.org/T279440#7489667 into this task as stated... [19:00:11] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban, 10Patch-For-Review: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 (10Ottomata) [19:03:17] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban: Recreate analytics-meta replica on db1108 from master on an-coord1001 - https://phabricator.wikimedia.org/T295312 (10Ottomata) [19:10:11] 10Analytics, 10Analytics-Kanban, 10Data-Engineering, 10Data-Engineering-Kanban: Recreate analytics-meta replica on db1108 from master on an-coord1001 - https://phabricator.wikimedia.org/T295312 (10Ottomata) @Marostegui, I'm reading https://wikitech.wikimedia.org/wiki/Backup-mariadb, can/should we use that... [19:11:58] 10Analytics, 10Product-Analytics (Kanban): Add mediawiki_skin_diff to the allowlist - https://phabricator.wikimedia.org/T287255 (10jwang) [19:12:20] 10Analytics, 10Product-Analytics (Kanban): Add mediawiki_skin_diff to the allowlist - https://phabricator.wikimedia.org/T287255 (10jwang) [19:14:41] (03PS2) 10Jenniferwang: Add skin_diff schema to sanitize allowlist Bug: T287255 [analytics/refinery] - 10https://gerrit.wikimedia.org/r/737471 (https://phabricator.wikimedia.org/T287255) [19:15:34] (03PS3) 10Jenniferwang: Add skin_diff schema to sanitize allowlist [analytics/refinery] - 10https://gerrit.wikimedia.org/r/737471 (https://phabricator.wikimedia.org/T287255) [19:44:28] !log create admin user on an-coord1001 for T284150 [19:44:32] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [19:44:32] T284150: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 [19:45:05] mforns: reading https://phabricator.wikimedia.org/T294024 and trying to remember some things [19:45:08] so, the idea is: [19:45:22] aha [19:45:31] A. there will be some automated way for artifacts to make it to archiva [19:45:40] ideally in a special archiva repo [19:45:48] yes, each team should take care of that, yes special repo [19:45:49] then, we sync all packages from that repo to HDFS [19:45:54] makes sense [19:45:58] also! [19:46:00] PROBLEM - MariaDB Replica SQL: analytics-meta-replica on an-coord1002 is CRITICAL: CRITICAL slave_sql_state Slave_SQL_Running: No, Errno: 1396, Errmsg: Error Operation CREATE USER failed for admin@localhost on query. Default database: . [Query snipped] https://wikitech.wikimedia.org/wiki/MariaDB/troubleshooting%23Depooling_a_replica [19:46:07] then, our airflow stuff can depend on artifacts directly from HDFS always? [19:46:21] razzi: ^^^ [19:46:29] I think the best way would be to have the dependencies specified in a json/yaml file in each team's folder [19:46:47] it looks like the replica tried to replicate your create user statement [19:46:50] and it failed on the slave [19:47:03] i'm guessing because the user existed from your previous create user today? [19:49:30] razzi: i want to fix an-coord1002, yt? [19:49:41] woops [19:49:45] there are several ways to fix, but easiest will be to drop the user you created on an-coord1002 [19:49:48] and just restart the slave [19:49:52] i believe that will let it proceed. [19:49:55] I'm watching andrew bogott work on wikireplicas [19:50:06] ok razzi, may I proceed? [19:50:36] proceeding. [19:50:38] yeah go for it [19:51:32] !log an-coord1002: drop user 'admin'@'localhost'; start slave; to fix broken replication - T284150 [19:51:38] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [19:51:38] T284150: Refactor analytics-meta MariaDB layout to use an-db100[12] - https://phabricator.wikimedia.org/T284150 [19:51:45] looksk good so far, i think that fixed it razzi [19:51:56] cool cool [19:52:07] ottomata: actually, there's two approaches: 1) Pull *all* packages from archiva every N minutes, and 2) let the deployment process pull the specified dependencies just once [19:52:16] right [19:52:18] what do you think will be best? [19:52:21] RECOVERY - MariaDB Replica SQL: analytics-meta-replica on an-coord1002 is OK: OK slave_sql_state Slave_SQL_Running: Yes https://wikitech.wikimedia.org/wiki/MariaDB/troubleshooting%23Depooling_a_replica [19:52:41] the latter might be simpler? but will be slower on the first turn [19:52:42] run* [19:53:24] yes, is that a drawback? [19:53:30] probably not really [19:53:48] mforns: maybe there will be deps not in this special archiva repo though, right? [19:53:49] like, jars? [19:54:16] hmm, and we are talking about packaged conda envs, right? [19:54:20] not in archiva? ah! you mean in other repos [19:54:21] not individual deps? [19:54:38] no, for now, just packaged envs [19:54:47] hm ok [19:54:55] so, i guess we could somehow put the jars they need in the packaged env too? [19:55:16] hm interesting [19:55:33] a packed conda env is really just a tar.gz file [19:55:50] it does some special rewriting of PATHs on unpack, but that's just for python classloading [19:55:54] yes, I thought we'd have jars for java/scala and envs for python [19:56:29] i guess...the user will be making both e.g. requiremenrts.txt files, but also will need other types of artifacts [19:56:38] but, maybe they'll want to specify the conda env, not deps, for a job? [19:56:54] is it: the list of requirements is only for CI to build the packed conda env? [19:57:06] and then when running the job they haev to specify the conda env via archiva/hdfs? [19:57:36] yes that's what I imagined for python [19:57:36] or, it is more streamlined? like, users specify the requirements they need, and that will automatically result in a ready to use conda env that the executor knows how to get? [19:58:10] but now you made me think that this approach is not the same for java/scala [20:03:06] can I add a commit to a patch? [20:04:35] CristianCantoro: you can amend an existing commit as long as the change-id says the same, and then just push the amended commit to gerrit [20:04:58] https://www.mediawiki.org/wiki/Gerrit/Tutorial#Amending_a_change_(your_own_or_someone_else's) [20:06:08] 10Analytics-Radar, 10WMDE-GeoInfo-FocusArea: Review existing dashboards and metrics for maps - https://phabricator.wikimedia.org/T295315 (10awight) [20:08:36] majavah: ok, thanks [20:16:23] (03PS1) 10Kosta Harlan: LinkSuggestionInteraction: Add qualitygate_dialog [schemas/event/secondary] - 10https://gerrit.wikimedia.org/r/737489 (https://phabricator.wikimedia.org/T274325) [20:26:51] ottomata: just to make sure, I'm checking an-coord1001 vs. an-coord1002, right? [20:27:57] milimetric: sure, also db1108 is messed up too [20:28:04] an-coord1001 -> db1108 [20:29:14] hm, don't think I have access to that [20:29:40] razzi: can you get me that too? [20:29:47] sure [20:29:49] 1 sec [20:30:08] Well [20:30:20] be extra careful on that one, it's a db* not an an-coord* [20:30:35] :) [20:30:51] razzi: I don't think I can ssh to it, what's it used for? [20:31:00] is it accessible by the research user maybe? [20:31:03] db1108 is a Backup Analytics Multiinstance Databases (mariadb::misc::analytics::backup) [20:31:03] DB section analytics_meta (alias: mysql.analytics_meta) [20:31:03] DB section matomo (alias: mysql.matomo) [20:31:22] backups for an-coord and matomo [20:31:26] nothing that special [20:31:42] ah, ok, well, maybe I'll just look at the coords replicating to each other, start with that [20:32:06] cool. That one uses a different login scheme since it has "sections" [20:32:22] I log in with `sudo mysql -S /run/mysqld/mysqld.analytics_meta.sock` [20:32:31] or replace analytics_meta w matomo for example [20:32:54] so idk if the create user thing will work / is a good idea [21:30:35] 10Analytics, 10Data-Engineering, 10Event-Platform, 10Platform Engineering, 10tech-decision-forum: MediaWiki Events as Source of Truth - Decision Statement Overview - https://phabricator.wikimedia.org/T291120 (10WMDE-leszek) Hello, apologies for a late question (I have marked the "feedback" deadline for a... [23:10:14] 10Analytics, 10Data-Engineering, 10Event-Platform, 10Platform Engineering, 10tech-decision-forum: MediaWiki Events as Source of Truth - Decision Statement Overview - https://phabricator.wikimedia.org/T291120 (10awight) My understanding is that some of us got swept up into discussing the choice of a //sin... [23:19:17] (03PS2) 10CristianCantoro: Fix webchat link from Freenode to Libera [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 [23:24:45] (03CR) 10CristianCantoro: "I have fixed the link in the README and updated the patch." [analytics/wikistats2] - 10https://gerrit.wikimedia.org/r/737386 (owner: 10CristianCantoro)