Thursday, 2021-12-02

opendevreviewMridula Joshi proposed openstack/glance-specs master: Expose store specific information  https://review.opendev.org/c/openstack/glance-specs/+/81739105:50
crohmannHello everyone. I have an OpenStack Ussuri with Glance image import via web-download method "not working". The image itself (so the shell object with just the metadata yet) is created and also the corresponding task. The task state is switching to "processing", but then nothing happens. No obvious errors / warnings in the log file.08:36
crohmannWhere should I look next for why the download to the staging space does not start?08:41
opendevreviewRajat Dhasmana proposed openstack/glance-specs master: Expose store specific information  https://review.opendev.org/c/openstack/glance-specs/+/81739110:21
simondodsleyMy devstack has recently started to fail when uploading the cirros image... What would be causing this error: https://www.irccloud.com/pastebin/rW1KmIsS/13:40
abhishekkrosmaita, jokke_, dansmith, croelandt, pdeore glance weekly meeting in 15 minutes at #openstack-meeting13:47
abhishekksimondodsley, which devstack version you are using, is it latest ?13:52
simondodsleymaster 13:53
abhishekklooking at error, it looks like it is not setting default limits in keystone for glance13:53
abhishekkcan you try by setting this 'GLANCE_ENABLE_QUOTAS' False in local.conf ?13:54
simondodsleyYes - I can try that13:55
abhishekkcool, let me know what happens13:56
*** whoami-rajat__ is now known as whoami-rajat14:00
crohmannrosmaita: simondodsley: May bug you with a glance question real quick? I am trying to use the web-download import method - so actually the api_image_import task via the web-download. I am able to create tasks just fine, but they only reach the processing state - with literally no indication on what happens. I just need a pointer on where to dig deeper? How can I debug the task execution further?14:29
rosmaitacrohmann: maybe join the glance meeting, happening right now in #openstack-meeting14:30
crohmannThere is no video, just IRC, right? rosmaita ?14:36
rosmaitayes, irc only14:37
crohmanncan I just dump a question in there? Don't want to mess up the conversation flow.14:37
rosmaitacrohmann: you have excellent timing, open discussion just starting!14:40
simondodsleyabhishekk: sadly that didn't resolve it. Same error.14:47
abhishekkstrange14:47
akekane__last 8 minutes14:53
akekane__simondodsley, I need to try it locally14:53
simondodsleyI want to try it again... let me get back to you14:54
akekane__ack14:54
fricklersimondodsley: I saw that issue while testing https://review.opendev.org/c/openstack/devstack/+/817074 , are you sure you are using latest master?14:55
simondodsleyI may have added the paramer for disabling the glance  quotas in the wrong zuul file... checking14:56
akekane__simondodsley, I think this patch mentioned by frickler will also solve your issue14:57
*** akekane__ is now known as abhishekk14:58
simondodsleyabhishekk: yes - running in a CI and it always pulls master14:59
abhishekkack14:59
* akekane_ going for dinner15:12
simondodsleyabhishekk: frickler: setting `GLANCE_ENABLE_QUOTAS = False` fixes this - thanks for the pointers.15:42
crohmanndansmith: I did check on our installation again and much say we are running the dedicated eventlet app port 9292, eventlet.wsgi.server. And then with apache being the reverse proxy in front. So I am wondering if this the the same issue or if web-download should work with this deployment?16:07
dansmithcrohmann: if you're running glance-api as an eventlet standalone, it should work fine, even if apache is in front16:07
dansmithare you saying you didn't realize that you were already doing that, or are you saying you're going to try that arrangement?16:08
crohmannI did not realize that Glance was actually NOT mod_wsgi, but other components are.16:08
crohmannThat's what go me confused.16:08
crohmannso I am now wondering if there was anything else you can think of, that we should look at that could cause our web-download to not start.16:10
crohmannI mean the task is picked up by the tasks executor, it's just not starting a download / creating a file or throwing any errors.16:10
dansmithah okay, so.. first off, you definitely do not want to just be creating the task, you want to be doing import16:10
dansmithcan you show me what import call you're making?16:11
crohmannI did use that shorthand as well.16:11
dansmithand then logs showing the relevant timeframe16:11
crohmann"glance image-create-via-import --name crohmann-via-import --import-method web-download  --uri https://cloud.debian.org/images/cloud/OpenStack/current-10/debian-10-openstack-amd64.raw --container-format bare --disk-format raw"16:12
dansmithokay, I'm not as familiar with using the create-via-import instead of create and then import, but yeah let me see logs16:12
dansmithI assume that ^ should work just like create..import16:13
crohmannah, what would be your approach / command then?16:13
crohmannThat image-create-via-import apparently is EXPERIMENTAL anyways.16:13
dansmithcreate and then import, but again, that's just because it's how I do things to test stepwise16:13
dansmithcan you pastebin the logs?16:14
crohmannI was trying to emulate the steps tools like https://github.com/osism/openstack-image-manager do.16:14
crohmannYeah - I am just now doing a clean run to have some readable logs.16:16
crohmannI would use your commands though, just to be save. Where do you set the URI in your approach? Is that an option for the create or import command?16:16
*** tosky_ is now known as tosky16:17
dansmithfor import16:17
dansmiththe create is just creating a record, with no data, the import is the thing that "fills" it, so it takes the uri16:17
dansmithbut really, I wouldn't expect this is a problem with the client if you see the task getting picked up, so .. logs would be the best way to make progress here :)16:17
*** priteau is now known as Guest738816:38
*** priteau_ is now known as priteau16:38
crohmannsorry dansmith ... there you go: https://pastebin.com/yDnn3bdz16:43
dansmithcrohmann: okay that's showing a POST of the task,16:46
dansmithwhich is not how it should be working16:46
dansmithso perhaps the client *is* doing something different for that create-and-import thing16:47
dansmithcrohmann: can you try create and then import to see if it behaves differently?16:47
crohmannI just did, but then I am hitting an error with SQLAlchemy due to us using PostgreSQL with the handling of boolean vs. 0/1 :-(16:52
crohmann"oslo_db.exception.DBError: (psycopg2.errors.UndefinedFunction) operator does not exist: boolean <> integer"16:52
crohmannPostgreSQL does not like this: "UPDATE image_properties SET updated_at=%(updated_at)s, deleted=%(deleted)s, value=%(value)s WHERE image_properties.name = %(name_1)s AND image_properties.image_id = %(image_id_1)s AND image_properties.deleted != %(deleted_1)s]"16:53
dansmithwell,16:54
dansmiththat probably means it is indeed doing the right thing now, but yeah... that's a problem16:55
dansmithI'm surprised the SA dialect stuff doesn't handle that for us16:56
dansmithbut as you probably no, there's very little if any testing on pg these days16:56
dansmithno? know.16:56
crohmannYeah. We ran into PostgreSQL issues before and I know we have to switch.16:56
crohmanntoo bad there is no more sunsetting on PostgreSQL support than this: https://governance.openstack.org/tc/resolutions/20170613-postgresql-status.html16:58
dansmithwell, there was some pushback, so it's one of those things where if we say "no" then there's pushback, but if we let it atrophy there isn't16:59
dansmithwhich sucks, but.. you know :/16:59
crohmannI shall be setting up another DB on this DEV machine to at least be able to reproduce or dig further into the web-download issue. May I contact you again tomorrow or Monday when I got around to it?16:59
dansmithcrohmann: can you show me the full log before you hit that failure just to see if it looks like it's getting further?17:00
crohmannsure - 1 minute17:00
dansmithcrohmann: you are welcome to ping me tomorrow or next week. however, you should know I'll be on PTO for the rest of the year after friday :P17:00
dansmithcrohmann: abhishekk is a more than ample substitute for me, and he will be around I think17:01
dansmithcrohmann: he even rides a cool motorcycle17:01
crohmanndansmith: reload the pastebin, updated the log17:02
dansmithError, this is a private paste or is pending moderation. If this paste belongs to you, please login to Pastebin to view it. 17:03
dansmithnot sure you can update a pastebin, it's a new url right?17:03
crohmannargh "Pastebin’s SMART filters have detected potentially offensive or questionable content in your paste.17:05
crohmannThe content you are trying to publish has been deemed potentially offensive or questionable by our filters, because of this you’re receiving this warning.17:05
dansmithhah17:05
dansmithmaybe they're punishing you for running postgres? :P17:06
dansmithpaste.openstack.org17:06
dansmithslower and less good, but probably also less smart17:06
crohmannoh man ... that throws a proxy error 500 :-(17:12
dansmithlol17:13
dansmithhttps://paste.debian.net/17:13
crohmannhttps://paste.debian.net/hidden/c72d74d7/17:16
crohmanndansmith: Thanks for your patience ;-)17:16
dansmithcrohmann: okay it didn't even get to the internal task bit17:17
dansmithbut that's just because of where we hit the db issue, 17:17
dansmiththis one is clearly in the import path, which is what you want17:17
dansmithso you can file a bug if you want with the PG problem, that log tells us where it is17:18
dansmithand I could maybe hack up the patch quickly if you wanted to try to apply it locally17:18
crohmannI just switched to Sqlite for this one box. Let me see if that work. As for the PostgreSQL issue - I gladly raise a bug, if you are interested in fixing this.17:19
dansmithhttps://termbin.com/1j1f17:20
crohmanndansmith: You won't believe it ... with SQlite it appears to just work. Nothing changed but the database.17:24
dansmithI would believe it :)17:24
dansmithso "works" meaning the import and the web-download, etc?17:25
dansmithif you will file a bug for the pg thing and include that full trace in the bug, I will push the patch against it17:25
crohmannI sure will do so - thanks again.17:26
dansmithand also, if you're willing to file a bug against create-and-import not working (assuming it still doesn't, which I assume is true) that would also be great17:26
dansmithcrohmann: shoot me the bug numbers/links here when you do, if you don't mind17:26
crohmannWell I was trying to use https://github.com/osism/openstack-image-manager initally.17:26
crohmannSo I believe their approach at https://github.com/osism/openstack-image-manager/blob/1b952c783acb648f28299e6ccc0b7b9af77085b1/src/manage.py#L54 is not working?17:27
dansmithI expect not, and even if it does, it skips some other machinery we have around making it threadsafe, etc17:27
dansmithI have to jump on a call, bbl17:27
crohmannallright, it's late here anyways. I shall drop your the bug id17:28
crohmannThanks a 100017:28
dansmithcool, thanks17:28
crohmanndansmith: Here you go with the bug id: https://bugs.launchpad.net/glance/+bug/195306318:09
opendevreviewDan Smith proposed openstack/glance master: Fix set_property_atomic() boolean type casting  https://review.opendev.org/c/openstack/glance/+/82024718:57
dansmithcrohmann: thanks ^18:57
rosmaitadansmith: that's a blast from the past: https://review.opendev.org/c/openstack/glance/+/54410519:29
dansmithrosmaita: hah19:35

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