Friday, 2022-04-08

*** ysandeep|out is now known as ysandeep00:14
*** rlandy is now known as rlandy|out00:28
opendevreviewIan Wienand proposed openstack/project-config master: grafana: update afs for centos 9 wheel volumes  https://review.opendev.org/c/openstack/project-config/+/83707601:54
opendevreviewMerged openstack/project-config master: grafana: update afs for centos 9 wheel volumes  https://review.opendev.org/c/openstack/project-config/+/83707602:57
*** chandankumar is now known as chkumar|ruck05:34
*** jpena|off is now known as jpena07:02
*** ysandeep is now known as ysandeep|lunch07:55
*** ysandeep|lunch is now known as ysandeep08:56
*** ysandeep is now known as ysandeep|afk09:58
*** ysandeep|afk is now known as ysandeep10:16
*** bhagyashris_ is now known as bhagyashris10:19
*** rlandy|out is now known as rlandy|rover10:21
*** dasm|off is now known as dasm11:16
*** dviroel|afk is now known as dviroel11:28
*** ysandeep is now known as ysandeep|afk12:06
*** ysandeep|afk is now known as ysandeep14:05
fzzf[m]fungi: clarkb Hi, source-repositories  how to use local image to build diskimage.like these https://opendev.org/openstack/project-config/src/branch/master/nodepool/elements/cache-devstack/source-repository-images .I want download cirrors, and use these.14:59
clarkbfzzf[m]: if yo uadd that cache-devstack element it will do it for you15:01
clarkbor you can add your own element with your own list of images like that15:01
fzzf[m]clarkb: I have add cache-devstack element, but I found every time build diskimage downloads cirrors from the network... (full message at https://matrix.org/_matrix/media/r0/download/matrix.org/HrTrDjfIEyfEHLUYkgtQKOav)15:04
fungifzzf[m]: it should only download it if the file is not already in the dib cache on the nodepool builder15:04
fungidid it ever successfully download and cache the file?15:05
fungior are you removing/not persisting that cache?15:05
clarkbya there is nothing we can do about you not being able to download their images. YOu'll hvae to debug that on your side15:07
clarkbits possible they don't download for us but we juts added rocky images that build properly15:07
fzzf[m]fungi: how to check cache status.15:07
clarkbI just successfully downloaded the first image in the list15:07
fungiyeah, i tested downloading them at home when the question of whether the builder is behind a proxy came up15:09
fzzf[m]I can download images. but there was a failure during the build process15:10
clarkbfzzf[m]: the failure is downloading those images in the build process (at least that was what you linked previously and just indicated above)15:10
fzzf[m]clarkb: If I build successfully, nodepool will save the cache locally, right?15:11
clarkbyes15:12
fzzf[m]clarkb: okay, there are some other problems I will fix, then try to build. thanks :)15:13
elodilleshi infra team, i have a task in my release managements tasks list for this week: 'Coordinate with the Infrastructure team to swap out the previous cycle signing key and establish the new one for the starting cycle.'15:25
elodilleso:)15:25
elodillesso if you could help with this ^^^, that would be awesome :)15:25
clarkbI thought that happened but I'm trying to check now15:27
clarkbour docs don't seem to indicate where in our zuul configs we se tit15:27
clarkbI'm wrong it last rotated in october15:29
clarkbopenstack/project-config/zuul.d/secrets.yaml15:29
clarkbI guess the change I remember was on the openstack/governance side updating key fingerprints and now we need to update hte actual key15:30
fungiclarkb: elodilles: the key blob needs to be exported, encoded and pushed, yes. it's on my to do list15:31
fungiand yeah, what was done earlier was publishing the upcoming public key to the releases repo/site15:32
elodillesclarkb: fungi: ack, thanks for dealing with it o/15:35
fungionce the change to update the secret merges, then i'll push a separate change to update the use date ranges for the keys on the releases site15:36
*** ysandeep is now known as ysandeep|out15:55
*** ysandeep|out is now known as ysandeep|PTO15:55
*** dviroel is now known as dviroel|lunch15:59
*** jpena is now known as jpena|off16:05
*** dviroel|lunch is now known as dviroel|mtg16:55
*** dviroel|mtg is now known as dviroel17:19
dansmithclarkb: still around?18:06
clarkbdansmith: ya18:06
dansmithclarkb: so, let's say at the end of a tempest run I have generated a nice json dict of some stats (db queries, memory usage, etc)18:06
dansmithis there something we could plug into the log pipeline to digest that in some way, either just to compare that job to the average of recent runs?18:07
clarkbI think you could have elasticsearch ingest it and then from there you could use their tooling to graph it over time etc18:08
dansmithlike, I wonder if we were to dump it into graphite on successful gate runs or something and use that to calculate an average (per job name) that we could compare against for a given proposed patch18:08
clarkbgetting it into graphite is harder because of the way we firewall things off18:08
clarkbbut it might be doable. I'd have to think about that18:08
clarkbgrafana can graph data in ES though so maybe thats the easiest thing18:08
dansmithdoes elasticsearch tooling have graphing stuff?18:08
dansmithah okay18:08
clarkbis have grafana talk to the ES as a secondary backend18:08
fungikeep in mind that the elasticsearch/opensearch retention is short, so graphing it *there* probably wouldn't make sense if you want a longer trend18:09
dansmithfungi: I'm more thinking "is this run's number higher than the average (of this job) for the past 7 days?18:09
dansmith(substantially higher of course) 18:09
fungifor the past 7 days would almost certainly fit18:09
fungiif you want trending over months, you'd need to extract it to another location18:10
dansmithplotting over the course of a cycle or more would be something else for sure18:10
dansmithyeah18:10
clarkbya I think starting there is straightforward then if we want to go longer we can think harder about getting the data in graphite18:10
clarkband hopfeully you just change out the data source in the existing graphs and that is easy18:11
clarkbbasically generating the data and making graphs for it can be constants then swap out backends if necessary18:11
dansmithbut I guess this is something to talk to dpawlik about yeah?18:12
clarkbya and or the opensearch folks they had talked about being interestd in specific use caess like this (at least to hear how we are trying to use it)18:12
clarkbI'm pretty sure that elasticsearch can store data like this out of the box though so should be good to go18:13
dansmithclarkb: https://termbin.com/suwq18:21
clarkbdansmith: https://www.elastic.co/blog/found-crash-elasticsearch#mapping-explosion indicates how to write your json to make es happier but that looks great otherwise18:27
clarkbthen I think you ask dpawlik to ingest it as a json document (not logs) and you can then query/search it18:28
dansmithI'd expect it needs to be flat for something like es or graphite, I was mostly trying to make it readable for humans as a first go and then I can translate18:28
dansmithbut yeah18:28
dansmithokay cool18:28
*** dviroel is now known as dviroel|brb18:28
clarkbdansmith: you might also want to capture privsep memory use as last I looked it was quite high18:30
clarkband ist a bit more hidden18:30
dansmithI assume it's mixed inside one of those values currently18:31
clarkboh as a child process. That may be18:31
clarkbdpawlik: for the ingstion of that I think you want ot do it into a different index that will make querying and pruning simpler18:32
clarkband actually that may enable much longer retention time for the data since it should be fairly small18:32
dansmithwell, I see it running for neutron on my devstack machine, but not sure it's under either of the systemd service trees, which seems weird18:32
dansmithI guess it double-forked to get out of that18:33
dansmithso yeah18:33
clarkbso ya my suggestion is json reformated to make ES happy, ingested as json doc to a dedicated index or set of indexes. Then when grafana queries it can query that specific index prefix insted. And if sizes are small as expected can keep more days of data around18:34
* dansmith nods18:37
*** dviroel|brb is now known as dviroel18:41
dansmithyeah, 82MB for just neutron's privsep helper... seems like a lot18:49
*** akahat|rover is now known as akahat18:56
dansmithclarkb: https://termbin.com/xger18:57
dansmithstill pretty readable if that's flat enough18:57
fungiyeah, i think dpawlik said he expected to be around again next week, so probably good to sync up then on options19:02
dansmithI hope turning on the perf schema query logging won't slow things down too much19:05
opendevreviewJeremy Stanley proposed openstack/project-config master: Replace old Yoga cycle signing key with Zed  https://review.opendev.org/c/openstack/project-config/+/83717419:21
fungielodilles: once that ^ lands, we'll want to do a release-test tag to make sure things aren't somehow broken19:21
fungiand then i'll update the dates on the releases.o.o index page19:21
elodillesfungi: ack, noted20:00
clarkbdansmith: I doubt it will slow things down ES is really good at handlings docs like this aiui. Its the log use case it struggles with20:42
*** dviroel is now known as dviroel|out20:42
clarkbit still deals with random text like that better than a lot of options but it is really good at json doc storage aiui20:43
clarkband ya I think that json looks like what it wants20:55
dansmithclarkb: I meant the mysql flags I'm having to turn on to get the per-db numbers21:06
dansmithbut it looks like maybe it's okay based on the last run.. we'll see21:06
clarkboh sorry.  I expect simple counters aren't too bad. The analysis stuff is probably much more costly. But maybe also a good thing to run separately (specifically query analyzer against common queries)21:08
dansmithright, but I don't see anywhere I can get db query stats without full query logging21:08
dansmithbut I haven't dug very deep.. once I get this to actually run I'll survey more21:08
*** dasm is now known as dasm|off22:44
opendevreviewClark Boylan proposed openstack/openstack-zuul-jobs master: Add build-wheel-cache jobs for CentOS Stream 9  https://review.opendev.org/c/openstack/openstack-zuul-jobs/+/83682923:44
clarkbI don't think ^ will work but it helps capture what I learned and where I ended up23:44
fungidansmith: probably goes without saying, but please make sure we don't collect mysql query logs from the jobs (there was an incident some years back with slowlog collection in devstack runs bloating logging massively)23:59

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!