Thursday, 2022-04-07

brinzhang_bauzas:about tenant_id topic, imo, there is nothing need to discuss, I have been doing it since wallaby, it's clear what we should do00:34
brinzhang_and the time it's later for me, sorry I will absent.00:36
*** bhagyashris_ is now known as bhagyashris05:52
*** amoralej|off is now known as amoralej07:21
bauzasbrinzhang_: no worries, we already discussed about your series and I think it's prioritized07:56
brinzhang_bauzas:ack, thx08:35
opendevreviewWenping Song proposed openstack/nova-specs master: qUsage of new trait of OWNER_NOVA  https://review.opendev.org/c/openstack/nova-specs/+/83658309:07
opendevreviewBalazs Gibizer proposed openstack/nova stable/yoga: Fix eventlet.tpool import  https://review.opendev.org/c/openstack/nova/+/83678810:19
opendevreviewBalazs Gibizer proposed openstack/nova stable/ussuri: Reproduce bug 1944759  https://review.opendev.org/c/openstack/nova/+/83673311:34
opendevreviewBalazs Gibizer proposed openstack/nova stable/ussuri: Store old_flavor already on source host during resize  https://review.opendev.org/c/openstack/nova/+/83673411:53
*** amoralej is now known as amoralej|lunch12:11
Ugglahello12:34
sean-k-mooneyo/12:34
Ugglasean-k-mooney, I need help.12:35
UgglaI try to test my code with devstack. I have an issue with the migration of DB. It seems that nove-manage db sync did the correctly on cell0 but not cell1.12:36
sean-k-mooneyyou have to run it twice12:36
Ugglahum no12:36
UgglaI don't think so12:37
sean-k-mooneyyou have to run the sycn for each db 12:37
sean-k-mooneycell0 is kind of special12:37
sean-k-mooneybut in general you run the sync per cell12:37
sean-k-mooneydevstack should already do this12:37
sean-k-mooneyhow exactly did it fail12:37
Ugglait seems it doesn't fail. But cell1 has not the share_mapping table and the version within alambic_version table has not evolved.12:39
UgglaI may miss something but ....12:39
sean-k-mooneywhere did you create it12:40
sean-k-mooneydo you have the link to your patch12:40
Ugglasure12:40
Ugglahttps://review.opendev.org/c/openstack/nova/+/83119312:40
sean-k-mooneyok you modified the main db model12:41
sean-k-mooneythat should be correct12:41
sean-k-mooneyi just wanted to make sur eyou did not put it in the api db by mistake12:41
UgglaAll tests unit + func looks fine with tox.12:41
UgglaI mean a functional test using the api + db is working fine. 12:42
UgglaBut on devstack the migration seemed to not fan out to all cell. 12:42
UgglaIt happens only on cell012:42
Ugglasean-k-mooney, we can share a gmeet session, if you would like to see it.12:43
sean-k-mooneythe dbs are set up here12:43
sean-k-mooneyhttps://github.com/openstack/devstack/blob/master/lib/nova#L818-L871=12:43
Ugglaoh ok I get it .12:44
UgglaIf necessary, the --config-file argument can be used to point to the correct nova.conf file for the given cell.12:45
sean-k-mooneyyes12:45
sean-k-mooneyhttps://github.com/openstack/devstack/blob/master/lib/nova#L843=12:46
sean-k-mooneyis where the db sync shoudl happen for cell 112:46
sean-k-mooneyusing the cell1 conductor config12:46
UgglaI did not understand the doc correctly12:46
sean-k-mooneyso we are doing  $NOVA_BIN_DIR/nova-manage --config-file $conffile db sync --local_cell12:47
sean-k-mooney--local_cell disables faning out ot other celsl as part of the sync12:47
chateaulavbauzas: great PTG so far! I am otherwise held up today, but i will be there tomorrow just fyi12:47
sean-k-mooneyack12:48
sean-k-mooneyUggla: have you tried runnign that manually12:48
Ugglayep it is a bit ambiguous IMHO. 12:48
UgglaI'm gonna try.12:48
sean-k-mooneynova-manage --config-file /etc/nova/nova-conductor-1.conf db sync --local_cell12:49
sean-k-mooneyi think that woudl be the right path but its something like that12:49
sean-k-mooneyah its /etc/nova/nova_cell1.conf12:49
Ugglanova-manage --config-file /etc/nova/nova_cell1.conf db sync  correct ?12:51
sean-k-mooneyyes12:51
sean-k-mooneythat is what devstack ran12:51
UgglaERROR: Could not access cell0.12:51
sean-k-mooneyodd...12:51
sean-k-mooneylet me try that myself12:51
bauzaschateaulav: no worries12:52
Ugglasean-k-mooney, I got this: https://paste.openstack.org/show/bw9C4K0JEaD2eH2kM3TF/12:53
sean-k-mooneyUggla: you are missing --local_cell12:53
sean-k-mooneythat disablise it trying to connect to cell012:53
sean-k-mooneywhen syncign cell 112:53
sean-k-mooneystack@controller:/home/vagrant$ nova-manage --config-file /etc/nova/nova_cell1.conf db sync --local_cell12:54
sean-k-mooneythat should work12:54
Ugglasean-k-mooney, sounds good ! I'm gonna check12:54
bauzascorrect ^12:54
Ugglait is ok regarding the tables \o/12:55
sean-k-mooneyso how did you configure devstack to use your patch12:56
Ugglabut I'm unclear if this is specific onlyfor devstack  ?12:56
sean-k-mooneyno you have to do this for all installers12:56
sean-k-mooneynova-manage can try and discover all the cells via the api db technially but that assuem either you store the password in the db which we discurage or you use the same password on all db instances12:57
bauzashttps://github.com/openstack/devstack/blob/master/lib/nova#L81812:57
bauzasand https://github.com/openstack/devstack/blob/master/lib/nova#L84712:57
sean-k-mooneyin generall its simpler to have one config file per cell and run the comand once per cell12:58
Ugglafor devstack I use my patch by configuring a git remote on my repo and "pulling" it12:58
bauzascontext : https://docs.openstack.org/nova/latest/admin/cells.html#configuring-a-new-deployment12:58
sean-k-mooneyUggla: ok so you set NOVA_REPO and NOVA_BRANCH before you stacked12:58
sean-k-mooneyand you did not already have /opt/stack/nova right12:58
sean-k-mooneybefore you ran stack.sh12:58
Ugglanot sorry, I had a already installed devstack and replace the code with mine + restart12:59
sean-k-mooneyoh ok12:59
sean-k-mooneyso doing sudo systemctl restart devstack@n-*12:59
Ugglayep12:59
sean-k-mooneyworks only for python changes12:59
sean-k-mooneyif you chagne the db you have to manually sync again12:59
Ugglaack13:00
sean-k-mooney99% of the time we are not touching the db so we dont usually call that out13:00
Ugglado we agree that the doc for db migration is this one: https://docs.openstack.org/nova/latest/admin/upgrades.html13:00
sean-k-mooneyyes it is13:01
sean-k-mooney"""Using the newly installed nova code, run the DB sync. First run nova-manage api_db sync, then nova-manage db sync. nova-manage db sync should be run for all cell databases, including cell0. If necessary, the --config-file argument can be used to point to the correct nova.conf file for the given cell."""13:01
Ugglaany objection if I propose a minor update to make it clearer ?13:01
sean-k-mooneyim not sure what is not clear but sure we can review it13:02
sean-k-mooneyits always ok to propose updates to docs ectra13:02
sean-k-mooneywe will just review it as normal13:02
sean-k-mooneyyou could add an example i guess13:02
Ugglasean-k-mooney, that's clearly what I was looking. And I was confuse by the fact that it was not clear for me is all cells will be updated or not.13:02
UgglaAnd more confuse by that:   --local_cell  Only sync db in the local cell: do not attempt to fan-out to all cells 13:03
sean-k-mooneywell it says ""nova-manage db sync should be run for all cell databases""13:03
sean-k-mooneythat imperitive directing you to run it for each cell13:04
*** amoralej|lunch is now known as amoralej13:04
sean-k-mooneyUggla: feel free to add a note with examples or other changes if you think it would help make it cleaner13:05
UgglaI agree, but I had the doubt if it was automatic or normal.13:05
sean-k-mooneyUggla: https://github.com/openstack/nova/blob/master/nova/cmd/manage.py#L193-L195=13:07
Ugglasean-k-mooney, clearly I understood it incorrectly. But I think this is mainly due to: "Only sync db in the local cell: do not attempt to fan-out to all cells" --> so without this option I thought it will configure all cells13:08
sean-k-mooneynot quite13:08
sean-k-mooneywithout it it will do cell0 and the curernt cell13:09
sean-k-mooneyeach nova.conf will only have one cell db configured13:09
sean-k-mooneywe do not have the code required to loop over all the cells in the api db and update them automatically13:09
sean-k-mooneyso without --local_cell it does cell0 and the local cell13:09
sean-k-mooneywith it it only does the local cell13:10
sean-k-mooneycell1 in this case13:10
sean-k-mooneycell0 is speical its not a real cell13:10
sean-k-mooneyit used for instance that could not be schduled to a host13:10
UgglaI'm not clear. What is local cell ?13:10
sean-k-mooneyand a few other internal usecases13:10
sean-k-mooneyit the one that is reference in the nova.conf13:11
sean-k-mooneyin the [database]/connection value13:11
sean-k-mooneyso 13:12
sean-k-mooney[database]13:12
sean-k-mooneyconnection = mysql+pymysql://root:password@127.0.0.1/nova_cell1?charset=utf813:12
sean-k-mooneyby default devstack generates /etc/nova/nova.conf with that pointign at cell013:13
Ugglaok back to my previous question, do you have cases where nova.conf does not contain cell0 ? 13:13
Ugglaor is it only devstack specific ?13:13
sean-k-mooneyno you do13:13
sean-k-mooneythe conductor config dont point to cell013:13
sean-k-mooneythey point to there cell db13:13
sean-k-mooneywhcih will be cell1 or in osp we call it just nova13:14
Ugglaok it clear now. thx.13:17
Uggla\o/ my code is working. At least the index part... ;)13:22
Ugglaand the creation part. Seems I manage to discuss with manila ! 13:35
spatelsean-k-mooney i have opened this bug for my issue - https://bugs.launchpad.net/nova/+bug/196805413:53
sean-k-mooneythat does not seem like a nova issue13:54
sean-k-mooneythe error is with conencting to the rabbitmq right13:54
bauzasreminder : nova sessions start in 4 mins13:56
bauzasnova sessions start now14:02
sean-k-mooneyjoining14:02
bauzashttps://www.openstack.org/ptg/rooms/newton14:02
sean-k-mooneyspatel: that looks like you are having internal network issue with connectivty between your comptues and the contoler14:02
spatelThis is all running behind single switch so its hard to say network issue. all other nodes are happy 14:03
spatelas soon as i restart my nova-compute everything came back 14:04
spatellook like some thread crashed and never recover until manually restart14:04
sean-k-mooneyit could be related to dns14:04
spatelOut of 20 compute 2 nodes encounter with this issue.. 14:04
sean-k-mooneyhttps://github.com/openstack/nova/commit/fe1ebe69f358cbed62434da3f1537a94390324bb14:05
spatelI have everything using IP address 14:06
spateli have found similar bug but not sure its related to my issue or not - https://bugs.launchpad.net/oslo.messaging/+bug/193493714:06
sean-k-mooneyspatel: the error are not coming from nova so i woudl think its unlikely this is a nova bug it proably an oslo one if its not related to your infra14:07
spateli don't think its related to infra for sure14:07
spateli may post same bug to oslo 14:08
sean-k-mooneyyou can just add them to the bug14:08
sean-k-mooneyyou dont need to create a second one14:08
*** artom__ is now known as artom14:12
spatelsean-k-mooney how do i add them in existing bug?14:24
spatelaffected project?14:24
sean-k-mooneyyes14:26
spateldone, thanks14:26
opendevreviewStephen Finucane proposed openstack/placement master: db: Replace implicit conversion of SELECT into FROM  https://review.opendev.org/c/openstack/placement/+/80091014:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Replace 'as_scalar()' with 'scalar_subquery()'  https://review.opendev.org/c/openstack/placement/+/80110014:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Update 'select()' calls  https://review.opendev.org/c/openstack/placement/+/80110314:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Remove use of non-integer/slice indices  https://review.opendev.org/c/openstack/placement/+/80110414:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Replace deprecated 'FromClause.select().whereclause' parameter  https://review.opendev.org/c/openstack/placement/+/80110514:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Use explicit transactions  https://review.opendev.org/c/openstack/placement/+/80110614:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Remove unnecessary use of '_mapping'  https://review.opendev.org/c/openstack/placement/+/80110714:41
opendevreviewStephen Finucane proposed openstack/placement master: tests: Restore - don't reset - warning filters  https://review.opendev.org/c/openstack/placement/+/82811914:41
opendevreviewStephen Finucane proposed openstack/placement master: db: Use Row, not LegacyRow  https://review.opendev.org/c/openstack/placement/+/82830514:41
opendevreviewStephen Finucane proposed openstack/placement master: tox: Enable SQLAlchemy 2.0 warnings  https://review.opendev.org/c/openstack/placement/+/80110814:41
stephenfingibi: Fixed that placement issue. Can you relook at https://review.opendev.org/c/openstack/placement/+/801103 and https://review.opendev.org/c/openstack/placement/+/800910 when you get a chance (maybe after CI runs if you want)14:52
gibistephenfin: added to my review list14:53
stephenfinsean-k-mooney: melwitt: bauzas: I'll need one of you folks to be the other +2/+W when you've time ^14:53
stephenfinContext is this SQLA 2.0 stuff came up in the TC call earlier and I thought these had merged already :)14:53
bauzasstephenfin: ack, will look14:54
stephenfinta14:54
sean-k-mooneyah ws going to ask14:55
sean-k-mooneyok its sqla14:55
sean-k-mooneyya no worries14:55
bauzasas I wrote on https://ptg.opendev.org/ptg.html, next discussion will be at 4pmUTC15:12
bauzasstephenfin: you got my review-prio flag on your placement SQLA db series15:22
stephenfinbauzas: thanks15:31
sean-k-mooneywe proably should have proceeded witht he nova adgenda and then asked them to ping us in highsight15:37
gibinext time we will be smarter :)15:40
gibimaybe we need to punt the rest of the nova topic to friday?15:42
sean-k-mooneywe coudl i guess15:44
sean-k-mooneyi kind of wanted to finish today if we did not have other topics15:44
sean-k-mooneyso that we could sync with neutron or cinder tomorrow15:45
sean-k-mooneyor tc15:45
sean-k-mooneywithout worring about conflicts15:45
gibiyeah15:47
gibilet see how fast the tc session goes15:47
opendevreviewBalazs Gibizer proposed openstack/nova stable/train: Reproduce bug 1944759  https://review.opendev.org/c/openstack/nova/+/83699315:55
opendevreviewBalazs Gibizer proposed openstack/nova stable/train: Store old_flavor already on source host during resize  https://review.opendev.org/c/openstack/nova/+/83699415:55
bauzasfolks, what should we do ?16:00
gibiI think this tc discussion is useful16:02
bauzasartom_: melwitt: gibi: sean-k-mooney: Uggla: elodilles: could we have our arbiterd session by 1630UTC ?16:02
gibibauzas: works for me16:02
bauzasI tend to agree with sean-k-mooney, ideally we should free ourselves tomorrow as soon as we can16:02
* Uggla ok16:02
melwittsure16:02
artom_So in 30 minutes?16:02
bauzasthanks folks, updating then the ptgbot16:02
bauzasyeah16:03
artom_Sure16:03
elodillesbauzas: ack, don't wait for me. (especially, since i haven't added much to the topics + there won't be any stable or release specific topic o:))16:06
bauzaselodilles: ack, you're free to end up early, I bless you :p16:07
elodilles:)16:07
bauzassean-k-mooney: just sayin', I'll leave the TC room16:28
bauzasand open the nova room16:28
sean-k-mooneyack ok ill swap now16:31
bauzasgibi: ack, no worries, see you tomorrow morning17:02
bauzasas a reminder, we have a cyborg x-p at 8amUTC17:02
gibiack17:03
bauzasgibi: we'll just wrap the nova sessions tomorrow I think 17:03
gibiI will join to the Cyborg session17:03
bauzasjust after the neutron topic17:03
bauzasgibi: thanks !17:03
*** amoralej is now known as amoralej|off17:08
sean-k-mooneybauzas: i likely will be asleep for the cyborg session. if i am awake ill try and attend but ill read back after most likely.17:35
sean-k-mooneythe main topic is just thw owner_ traits17:35
sean-k-mooneyright17:35
sean-k-mooneyor general topic of how to model some rps are not owned by nova17:36
sean-k-mooneyi think we had agreed to add owned_by on all our RPs last cycle but it then never happened17:36
sean-k-mooneywe discussed this in relation to generic mdevs17:37
sean-k-mooneyhttps://review.opendev.org/c/openstack/nova-specs/+/836583/3/specs/zed/approved/owner-nova-trait-usage.rst17:44
*** dasm|off is now known as dasm18:42
*** dasm is now known as dasm|off22:44

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