Wednesday, 2022-10-12

opendevreviewJulia Kreger proposed openstack/ironic-inspector master: WIP SQLAlchemy 2.0 prep  https://review.opendev.org/c/openstack/ironic-inspector/+/86073100:34
vanougood morning ironic02:20
opendevreviewOpenStack Proposal Bot proposed openstack/ironic-inspector master: Imported Translations from Zanata  https://review.opendev.org/c/openstack/ironic-inspector/+/86102303:16
opendevreviewOpenStack Proposal Bot proposed openstack/ironic master: Imported Translations from Zanata  https://review.opendev.org/c/openstack/ironic/+/86102703:25
arne_wiebalckGood morning, Ironic!06:34
jm1dtantsur: good morning :) maybe you could have another look at this patch please? 👀 https://review.opendev.org/c/openstack/bifrost/+/859430/07:26
rpittaugood morning ironic! o/07:40
opendevreviewRiccardo Pittau proposed openstack/metalsmith stable/zed: Allow to use Ansible OpenStack Col. 1.x.x with openstacksdk >=0.99.0  https://review.opendev.org/c/openstack/metalsmith/+/86105008:14
rpittauany core with good heart having a minute to dedicate to fix metalsmith CI in zed reviewing this ^ would be greatly appreciated :)08:25
dtantsurjm1: just back from PTO, will put on my queue09:13
jm1dtantsur: thank you :) btw you dont want to know which dirty hacks we put into metalsmith while you were afk :D09:15
dtantsurouch ouch09:15
dtantsurwhat will win: my curiosity or my desire to keep sanity?09:15
* rpittau hides09:15
jm1dtantsur: in case curiosity wins, just follow rpittau's link above ;)09:16
jm1dtantsur: btw we can remove this hack once we backport some of the baremetal patches to aoc's stable branch09:17
jm1dtantsur: but thats work in progress09:17
opendevreviewMerged openstack/ironic-inspector master: Imported Translations from Zanata  https://review.opendev.org/c/openstack/ironic-inspector/+/86102310:38
opendevreviewMerged openstack/ironic master: Imported Translations from Zanata  https://review.opendev.org/c/openstack/ironic/+/86102710:44
opendevreviewEbbex proposed openstack/bifrost master: Enable epel repository for more than CentOS  https://review.opendev.org/c/openstack/bifrost/+/86108212:43
TheJuliadtantsur: any opinion if we rm -f ironic_inspector/tests/functional.py ?13:43
dtantsur:D13:43
dtantsurTheJulia: chances are non-zero, it exercises things that are not covered by tempest13:43
dtantsurwhy?13:43
TheJuliait is being *exceptionally* problematic with sqlalchemy 2.0 and turning essentially requires autocommit to work13:43
TheJulias/turning//13:44
TheJuliaeven pointing it at mysql, is... abysmal with sqlalchemy 2.0 :(13:44
dtantsurthis is pretty weird, I think it only needs to rebuild the database13:45
TheJuliahow many human-hours is it worth to try and keep it, do you think?13:45
dtantsurI'm a bit worried about the situation itself, rather than the specific tests13:46
TheJulia(I wouldn't be asking if I hadn't already lost two days to it)13:46
dtantsurit feels like we're ready to sacrifice anything just to be able to use SQLAlchemy 213:46
TheJuliatwo days of banging my head13:46
dtantsurMy question in response: at which point do we start to push back to upgrading to it?13:46
TheJuliadunno, tempest/integration seem to work just fine... although I broke some of the unit tests on my wip patch and I'm having to fix those now since I kept trying to get functional tests working13:48
dtantsurif we remove functional tests, we'll also completely lose coverage for ironic-inspector-client13:49
dtantsurboth may be fine since ironic-inspector barely sees any changes any more13:49
TheJuliathe functional tests don't use ironic-inspector-client at all13:50
dtantsurTheJulia: there is a version in irnoic-inspector-client that does13:50
TheJuliapart of the reason I'm curious how much you'd desire to keep it13:50
TheJulia... what?13:50
dtantsurhttps://opendev.org/openstack/python-ironic-inspector-client/src/branch/master/ironic_inspector_client/tests/functional.py13:51
dtantsurit's derived from the inspector's functional tests13:51
TheJuliaoh jeeze13:51
dtantsuryes, it's ugly, and yes, I'm to blame :)13:51
TheJuliaIs it too early to add liquor to coffee?13:51
dtantsurI'm not going to shed a single tear if these are gone13:51
dtantsurI guess my biggest frustration is that we probably don't understand our own DB layer well enough13:52
TheJuliaWell, that makes me feel a little better13:52
dtantsur(you don't understand well enough, everyone else doesn't understand at all :D)13:52
TheJulia(more like... we didn't understand it before hand, and now we're in sqlalchemy locking dungeon)13:53
dtantsuryeah, I don't claim we've ever understood it :)13:53
TheJulia((and sqlite is monologing on how we will meet our doom....))13:54
* TheJulia is sure a superhero is there someplace13:54
dtantsurI do hope we don't break sqlite support completely in the end :)13:54
TheJulia... we likely need to have a scenario job in place someplace, because it is not about our support as much as it is autocommit going away13:55
TheJuliainspector's state machine appears to tickle things sufficently that it is easy to deadlock13:56
JayFdtantsur: We cannot skip on the SQLA2.0 upgrade. Not unless we want to be stuck on old software indefinately. Not upgrading sqlalchemy is a hole that is extremely difficult to get out of, I've worked on multiple projects that tried to freeze it and in the end it was horrible.14:29
dtantsurIt's less about staying on 1.0 forever, more about: if the migration is taking so much effort, it's alarming14:30
JayFIt's a pretty aggressive API change by SQLA, honestly14:32
JayFand I suspect that is to *force us to understand the DB layer we never understood* to prevent hidden bugs14:32
ebbexdtantsur: https://review.opendev.org/c/openstack/bifrost/+/741964/26/playbooks/roles/bifrost-ironic-install/defaults/required_defaults_Debian_family.yml Do you remember why apache2-utils is installed?14:45
ebbexI'm trying to do some mapping/cleanup of the required_defaults, (ref. https://review.opendev.org/c/openstack/bifrost/+/855805/1//COMMIT_MSG#15) and I don't really see the reason why many of these are listed here. like py3-{dev,pip,setuptools} are all handled earlier on, py3-{iniparse,pymysql} feels like they should be a venv install, not a system package, much like passlib in lower-constraints.15:00
dtantsurebbex: apache2-utils.. probably for htpasswd?15:00
ebbexI don't see the need for htpasswd though? The ansible htpass module which we use requires passlib.15:02
dtantsurhmm15:02
ebbexif I'm not using dib, the list of required_packages i actually need on deb/alma/suse is [ipmitool, ipxe, isolinux, mariadb-server, dnsmasq and iptables].15:05
ebbexmaybe selinux/policycoreutils on alma, but those can probably be in the venv aswell.15:08
TheJuliaJayF: oh, it absolutely is designed to push people to better patterns and to try and understand what is happening under the hood.15:10
rpittaubye everyone, have a great evening! o/16:09
TheJuliaJayF: w/r/t allocations table, your testing revealed that the update migrated the table?!16:26
JayFTheJulia: yes16:26
JayFwhich should be a noop if it's utf8 -> utf8mb316:26
TheJuliajust the character encoding? or character encoding and engine?16:26
TheJuliayah16:26
JayFI did not test engine; I already have experienced that behavior (it won't migrate engine)16:26
TheJuliayeah, that is what I was thinking16:26
TheJuliagoing to add a patch to check the engine and warn upon it, since some mariadb builds out in the wild don't even support myiasm16:27
JayFIf it's possible, we should detect + loudly warn if encoding will be migrated from anything but utf8, same for engine16:27
* TheJulia looks at her local db16:27
JayFand make sure upgrade notes indicate that this migration exists, because I wonder if it's *really* noop for very large DBs16:27
TheJuliaJayF: writing an explicit upgrade check to do so16:27
JayFeven updating the metadata if there is a large amount of rows may not be free (?)... I'm just not sure16:28
JayFand I don't want someone to get surprised16:28
opendevreviewMerged openstack/ironic-inspector stable/wallaby: CI: Zuul no longer respects queue  https://review.opendev.org/c/openstack/ironic-inspector/+/86016316:34
opendevreviewMerged openstack/ironic bugfix/19.0: Stable only: Correct release note, packaging not required  https://review.opendev.org/c/openstack/ironic/+/86074016:34
opendevreviewMerged openstack/ironic bugfix/18.1: Stable only: Correct release note, packaging not required  https://review.opendev.org/c/openstack/ironic/+/86074216:34
opendevreviewMerged openstack/ironic stable/xena: Stable only: Correct release note, packaging not required  https://review.opendev.org/c/openstack/ironic/+/86074116:34
opendevreviewMerged openstack/ironic stable/yoga: Stable only: Correct release note, packaging not required  https://review.opendev.org/c/openstack/ironic/+/86073816:34
opendevreviewMerged openstack/ironic-python-agent-builder stable/wallaby: dhcp-all-interfaces: let NetworkManager doit.  https://review.opendev.org/c/openstack/ironic-python-agent-builder/+/86043317:23
JayFGoing to post some things here that are passing tests, and fix CI, and just need landing:17:38
JayFhttps://review.opendev.org/c/openstack/ironic-inspector/+/86016417:38
JayFhttps://review.opendev.org/c/openstack/ironic-inspector/+/86016517:38
JayFTheJulia: I think some of those rel note updates got merged w/o the acutal code it was describing; e.g. https://review.opendev.org/c/openstack/ironic/+/86014217:40
TheJuliaJayF: if you sign17:40
TheJuliaerr17:40
TheJuliasigh17:40
JayFit's not a big deal; I'm trying to get those landed all today so I can revamp the release pr17:41
JayFI just noticed it17:41
TheJuliahttps://review.opendev.org/c/openstack/ironic/+/860144 <-- wut17:43
opendevreviewJay Faulkner proposed openstack/ironic stable/wallaby: Stable only: Factor out addition of packaging lib  https://review.opendev.org/c/openstack/ironic/+/86014417:44
TheJuliathe depends-on...17:44
JayFwhat depends-on <.< >.> 17:44
JayFlol17:44
TheJulialol17:44
JayFit was depending on the ironic CI fixes17:44
JayFbut that got landed17:44
JayFand I probably screwed up the syntax17:44
JayFstill developing my skills for dealing with over 9000 PRs lol17:44
TheJuliahttps://review.opendev.org/c/openstack/ironic/+/860144/3/requirements.txt17:45
TheJuliaoh, nvmd17:45
JayFyeah, it shows two lines changed b/c I didn't have a newline at the end17:45
JayFwhich is not ideal but also doesn't matter17:45
TheJuliayup17:46
JayFthanks for approving all those, now just hoping CI will work on 'em lol17:46
JayFhttps://review.opendev.org/c/openstack/ironic-inspector/+/860170 any ideas on how to get CI on this one happy? I thought the pins I put in tox.ini would be enough but I'm clearly missing something17:49
TheJuliaeww17:50
JayFhey, milestone: my open patches list fits on my entire monitor again lol17:52
TheJulia\o.17:53
TheJuliaerr, \o/17:53
JayFOh hey, I should say this here: tomorrow I'm going to start a new thing; Office Hours. Basically live streaming my "normal work" for a couple of hours on youtube, while being around if anyone wants to ask questions or do interactive reviews, whatever. See https://twitter.com/jayofdoom/status/1580246189974654977 for more info17:54
TheJuliawell, the most recent failure is definitely more along the lines of tests are not happy17:55
JayFThe conflict is caused by:17:58
JayF    The user requested automaton>=1.9.017:58
JayF    The user requested (constraint) automaton===3.0.117:58
JayFis what I'm seeing for all those tests17:58
JayFwhich to me implies some kind of bad requirement being pulled in17:58
JayFhmm17:58
JayFOH17:58
JayFHmm. 17:59
JayF>       - openstack-lower-constraints-master-branch-jobs 17:59
JayFlooks suspicious17:59
JayFI feel like we need to actually pin openstack/requirements somewhere in the zuul jobs yaml?17:59
TheJulial-c jobs are no more, but it shouldn't be contaminating that one, unless it is the lc job on that17:59
JayFbecause it looks like that unit test is using requirements.txt from devstack (not from the default location in tox.ini)18:00
JayFwhich is why my tox.ini change didn't help18:00
TheJuliathe fact https://zuul.opendev.org/t/openstack/build/cb901a402b9d4ae4865386263c2f5ca3 is not the case on all jobs is suspect18:03
JayF[3432] /home/zuul/src/opendev.org/openstack/ironic-inspector$ /home/zuul/src/opendev.org/openstack/ironic-inspector/.tox/py36/bin/python -m pip install -c/home/zuul/src/opendev.org/openstack/requirements/upper-constraints.txt -r/home/zuul/src/opendev.org/openstack/ironic-inspector/requirements.txt -r/home/zuul/src/opendev.org/openstack/ironic-inspector/test-requirements.txt18:04
JayFnote the URL to upper-constraints being passed18:04
JayFunless we somhow limit the requirements version going in there somewhere else18:04
JayFit's using u-c from master and requirements from bugfix/whateverit is18:04
TheJuliabut yeah, definitely using master reqs18:04
TheJuliaalso the job is using older ubuntu18:05
TheJuliawhich means the mirror of wheels does not have a prebuilt 3.0.1 wheel18:05
TheJuliaweird...18:05
TheJuliathere is a way to override it, I'm jut not sure18:05
JayFI'm going to try to now18:05
TheJuliarpittau: ^^^ I seem to remember you've run into something like this before, if we haven't solved it by tomorrow, help would be appreciated18:06
JayFI mean, I'm going to punt on the inspector ones if we have anyone who might have real-knowledge about tackling this18:08
JayFbecause I suspect there are still lower-hanging-fruit on the changes I have up, and I want to merge in the ones that are close18:08
JayFbefore trying to figure out the hard cases 18:08
JayFhttps://review.opendev.org/c/openstack/ironic/+/860851 and https://review.opendev.org/c/openstack/ironic/+/860852 are a couple of good changes, I don't wanna land with single +2, this is Julia's changes coming out of the last meeting to reduce testing on t/u/v18:20
opendevreviewMerged openstack/ironic-inspector stable/victoria: CI: Various fixes  https://review.opendev.org/c/openstack/ironic-inspector/+/86016418:45
opendevreviewMerged openstack/ironic-inspector stable/ussuri: CI: Zuul no longer respects queue  https://review.opendev.org/c/openstack/ironic-inspector/+/86016518:45
opendevreviewMerged openstack/ironic bugfix/18.1: Stable only: Factor out addition of packaging lib  https://review.opendev.org/c/openstack/ironic/+/86014318:45
opendevreviewJulia Kreger proposed openstack/ironic master: Add upgrade check warning for allocations db  https://review.opendev.org/c/openstack/ironic/+/86110720:11
opendevreviewVerification of a change to openstack/ironic stable/xena failed: Stable only: Factor out addition of packaging lib  https://review.opendev.org/c/openstack/ironic/+/86014220:38
opendevreviewJulia Kreger proposed openstack/ironic master: Fix allocations default table type  https://review.opendev.org/c/openstack/ironic/+/86019820:58
opendevreviewJulia Kreger proposed openstack/ironic master: Phase 1 - SQLAlchemy 2.0 Compatability  https://review.opendev.org/c/openstack/ironic/+/85633620:59
opendevreviewJulia Kreger proposed openstack/ironic master: Phase 2 - SQLAlchemy 2.0 Compatability  https://review.opendev.org/c/openstack/ironic/+/85751620:59
opendevreviewJulia Kreger proposed openstack/ironic master: Phase 3 - SQLAlchemy 2.0 Compatability  https://review.opendev.org/c/openstack/ironic/+/85793220:59
TheJuliaokay, mostly just restacking those^ with the exception of the first20:59
JayFah, someone needs to kick ironicbaremetal.org to be aware of the zed release21:01
JayFI should probably do that today if nobody else is gonna21:01
TheJuliak21:01
* JayF getting some proofs printed of these -> https://home.jvf.cc/~jay/Ironic_mascot_with_qr.svg as die cut stickers (qr code goes to ironicbaremetal.org)21:02
TheJuliaI'm likely going to head out soon after uploading current change states to gerrit21:02
JayFif anyone wants to get on the list to get some, just reach out to me21:02
JayFI'm getting a bunch printed after validating the QR code works on a proof, courtesy of G-Research Open Source Software team21:02
JayFI'll take a look at those patches and re-review them, it'll be exciting to get those landed \o/ thank you for the db work21:04
TheJuliaI needed to do soemthing that was not look at inspector today :)21:07
opendevreviewMerged openstack/ironic stable/wallaby: Stable only: Factor out addition of packaging lib  https://review.opendev.org/c/openstack/ironic/+/86014421:52
opendevreviewVerification of a change to openstack/ironic stable/xena failed: Stable only: Factor out addition of packaging lib  https://review.opendev.org/c/openstack/ironic/+/86014222:01
JayFironic-standalone job has been failing on a large number of patches recently23:01
JayFjust saying that out loud here if someone wants to look into it; there are some examples in the SQLA line ^^ up there, or really any random patch23:01
JayFotherwise I'll add to my list and see if I can get there tomorrow23:02
opendevreviewMerged openstack/metalsmith stable/zed: Allow to use Ansible OpenStack Col. 1.x.x with openstacksdk >=0.99.0  https://review.opendev.org/c/openstack/metalsmith/+/86105023:20

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