*** iceyao has joined #ara | 00:49 | |
*** iceyao has quit IRC | 00:53 | |
*** cuongnv has joined #ara | 01:01 | |
*** iceyao has joined #ara | 01:10 | |
*** iceyao has quit IRC | 01:15 | |
*** iceyao has joined #ara | 01:23 | |
openstackgerrit | David Moreau Simard proposed openstack/ara master: Do not merge: Test openstack-ansible gate job https://review.openstack.org/436098 | 03:25 |
---|---|---|
*** iceyao has quit IRC | 04:10 | |
*** iceyao has joined #ara | 04:35 | |
*** iceyao has quit IRC | 04:40 | |
*** iceyao has joined #ara | 04:49 | |
*** iceyao has quit IRC | 04:59 | |
*** iceyao has joined #ara | 05:16 | |
*** iceyao has quit IRC | 05:20 | |
*** iceyao has joined #ara | 05:33 | |
*** iceyao has quit IRC | 05:38 | |
*** iceyao has joined #ara | 06:17 | |
*** cuongnv has quit IRC | 06:19 | |
*** vcn[m] has quit IRC | 06:19 | |
*** cuongnv has joined #ara | 06:19 | |
*** vcn[m] has joined #ara | 06:24 | |
*** iceyao has quit IRC | 07:46 | |
*** iceyao has joined #ara | 07:52 | |
*** cuongnv has quit IRC | 08:16 | |
*** drab has quit IRC | 08:37 | |
*** drab has joined #ara | 08:50 | |
*** iceyao has quit IRC | 09:39 | |
*** iceyao has joined #ara | 09:40 | |
*** iceyao has quit IRC | 09:55 | |
*** iceyao has joined #ara | 10:22 | |
*** iceyao has quit IRC | 10:26 | |
*** iceyao has joined #ara | 10:52 | |
dmsimard | ARA is officially one year old today and I posted something to retrospect and look back at the last year: https://dmsimard.com/2017/05/08/ara-is-one-year-old-a-look-back-at-the-past-year/ | 13:21 |
dmsimard | larsks: ^ there's some good words for you in there :) | 13:21 |
larsks | dmsimard: thanks! I saw that in my rss feed but haven't had the chance to read it yet... | 13:22 |
larsks | But hey, congrats on a year! :) | 13:22 |
*** karimb has joined #ara | 13:31 | |
*** tbielawa has joined #ara | 13:54 | |
*** reet_ has joined #ara | 14:36 | |
reet_ | hi | 14:37 |
reet_ | after migrating to 0.13 I get following error when I am trying to open page '2' of the reports | 14:37 |
reet_ | raise orm_exc.NoResultFound("No row was found for one()") NoResultFound: No row was found for one() | 14:37 |
reet_ | database was updated from 0.12 | 14:38 |
dmsimard | reet_: are you running on wsgi ? | 14:39 |
reet_ | dmsimard: via basic: ara-manage runserver -h 0.0.0.0 -p 8080 | 14:40 |
dmsimard | reet_: okay, if you do "ara playbook list", do you see the playbooks you'd expect ? | 14:41 |
reet_ | dmsimard: let me check | 14:41 |
reet_ | dmsimard: no, the same error $ ara playbook list No row was found for one() | 14:41 |
dmsimard | reet_: hm, is the database path set ? | 14:42 |
reet_ | dmsimard: should be, when I go to the /about I get proper numbers: playbooks run XXX, tasks run YYY. Upgrade I did just via pip without touching configurations afterwards | 14:43 |
dmsimard | reet_: that's odd... I can try to reproduce the issue on my end. You're using sqlite ? What exact version did you upgrade from ? | 14:44 |
reet_ | dmsimard: it was ara-0.12.6.dev5. I was installing it via: pip install --user | 14:47 |
dmsimard | reet_: hmm, so you were running off of a trunk installation ? | 14:48 |
dmsimard | I'll try. | 14:48 |
reet_ | dmsimard: when I wanted to install ara 0.13 I noticed that ara now downloads ansible 2.3 as prerequisite. So I decided to create separate virtualenv to avoid any problems with ansible 2.3 (I did not test it yet). after creating seprate virtualenv I installed 0.13 yes it is sqlite. Default settings in general. Website opens I can go to /about page and see proper numbers. I see first page of reports too | 14:49 |
dmsimard | reet_: just note that ara doesn't require ansible 2.3, it requires ansible >= 2.1 so it just picks up the latest version of ansible if you do not already meet that requirement | 14:49 |
reet_ | dmsimard: yes, for previous ara it was trunk ara-0.12.6.dev5 (I will tell you in a moment why trunk and not regular 0.12) | 14:49 |
reet_ | dmsimard: hmm I had 2.2.1.0 ah ok I guess my mistake was to do pip install --upgrade so it started upgrading dependencies too. Understood | 14:51 |
dmsimard | ah, yeah, --upgrade upgrades everything | 14:51 |
dmsimard | there's an argument you can pass to pip to only upgrade the one package you're asking for | 14:51 |
dmsimard | I forget what it is | 14:51 |
reet_ | dmsimard: no problem I know what you mean sorry for confusion | 14:51 |
reet_ | dmsimard: any thoughts where should I look further? Looks like ara not happy with my DB? I understand 0.13 performs small DB upgrade? | 14:52 |
dmsimard | reet_: yeah, there is a sql migration but it should not break anything -- at least from the tests that we've done. I'll try and see if I can reproduce the problem and let you know. | 14:53 |
reet_ | dmsimard: ok! thanks. I will dig a little too. Great UI you did! | 14:54 |
dmsimard | reet_: thanks :) | 14:54 |
dmsimard | reet_: okay, I found the commit for 0.12.6, it was this one: https://review.openstack.org/#/c/459084/ (see build here: http://logs.openstack.org/84/459084/2/check/gate-ara-integration-latest-centos-7/f257868/logs/build/ ) | 14:56 |
dmsimard | reet_: so I'll go and get the database from that build and upgrade, see what happens | 14:56 |
reet_ | dmsimard: cool | 14:58 |
dmsimard | reet_: hm, works on my end. Can you pastebin me something ? I want to see what the schema looks like and what the alembic version is.. "sqlite3 <sqlite file>" and then ".schema" and "select * from alembic_version" | 15:00 |
reet_ | dmsimard: preparing pastebin. BTW I am on Python 2.7.5 | 15:05 |
dmsimard | that should be fine | 15:05 |
reet_ | dmsimard: https://pastebin.com/1gbVavab | 15:08 |
dmsimard | reet_: hm, that looks good to me -- the schema is up to date with the latest migration and the alembic version is good too. | 15:10 |
dmsimard | reet_: did you back up the database before upgrading ? can you run the migration again off a copy of the back up ? | 15:11 |
reet_ | dmsimard: as this is more prototyping phase I did not make a backup of the DB unfortunately. | 15:12 |
reet_ | dmsimard: this is interesting. reports/list/3.html and reports/list/4.html works fine. Just 2.html has a problem | 15:15 |
reet_ | dmsimard: maybe I can enable somehow a little more debugging to see the query? | 15:16 |
reet_ | dmsimard: the reason I tried trunk I wanted to check if I will have the same problem related to the not visible svg images on the ara web page. Reason is not ara but my too old python version which is coming with RHEL7 http://bugs.python.org/issue10730 | 15:19 |
dmsimard | reet_: the svg images not showing is usually related to a mime type issue | 15:20 |
reet_ | dmsimard: right | 15:21 |
dmsimard | reet_: it tends to happen in containers because they are very stripped down, the known solution is to make sure /etc/mime.types exists (it's provided by the mailcap package) | 15:21 |
dmsimard | reet_: you can add verbosity for sql queries with export ARA_SQL_DEBUG=true | 15:22 |
*** vcn[m] has quit IRC | 15:43 | |
reet_ | dmsimard: not sure it this helps for debug https://pastebin.com/DnPNEpiZ | 15:44 |
*** vcn[m] has joined #ara | 15:48 | |
*** iceyao has quit IRC | 16:41 | |
*** iceyao has joined #ara | 16:49 | |
*** iceyao has quit IRC | 16:51 | |
dmsimard | reet_: sort of | 16:54 |
dmsimard | reet_: the playbook.file object is actually a property that we build, it's a helper to access the playbook file easily https://github.com/openstack/ara/blob/master/ara/models.py#L191-L195 | 16:56 |
dmsimard | reet_: In the unlikely event that a playbook is recorded by interrupted *very* early, it's possible that a playbook could have an entry and not a file because it was interrupted before the file was saved | 16:57 |
dmsimard | reet_: I'll try and send a patch, maybe you can try it and let me know if that fixes it for you | 16:57 |
reet_ | dmsimard: all right | 17:00 |
*** iceyao has joined #ara | 17:18 | |
reet_ | dmsimard: I did one more thing: I installed ara 0.13 in the non virtualenvironment with 'pip install ara==0.13 --user' and now I get following error: 'site-packages/jinja2/environment.py", line 408, in getattr return getattr(obj, attribute) UndefinedError: 'macros' is undefined' | 17:18 |
reet_ | dmsimard: looks like I messed up something. With the empty database it starts thou | 17:18 |
openstackgerrit | David Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved https://review.openstack.org/463376 | 17:28 |
openstackgerrit | David Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved https://review.openstack.org/463376 | 17:38 |
dmsimard | reet_: I think that last patch should do it, I also added a unit test. | 17:38 |
dmsimard | reet_: you can patch locally with https://review.openstack.org/gitweb?p=openstack/ara.git;a=patch;h=d666941fe6e69716e870ad56e8f4e9e689f65037 | 17:38 |
openstackgerrit | David Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved https://review.openstack.org/463376 | 17:44 |
dmsimard | don't mind this last patchset, just pep8 fixes | 17:44 |
*** tbielawa is now known as tbielawa|vroooOO | 17:45 | |
*** iceyao has quit IRC | 17:59 | |
*** iceyao has joined #ara | 18:21 | |
*** iceyao has quit IRC | 18:25 | |
reet_ | dmsimard: still some kind of DB issue https://pastebin.com/wgy59VUE | 18:25 |
dmsimard | reet_: hmm, that's super puzzling | 18:38 |
reet_ | dmsimard: need to run now will try tomorrow. for now will use fresh database. Have a good day! | 18:39 |
dmsimard | reet_: okay, let me know if you happen to find what was the problem | 18:39 |
reet_ | dmsimard: sure will let you know. I will try to fill up the database on 0.12 and do the upgrade to 0.13 once again. Maybe effect will be reproducible | 18:41 |
*** iceyao has joined #ara | 18:43 | |
*** iceyao has quit IRC | 18:47 | |
*** iceyao has joined #ara | 19:17 | |
*** iceyao has quit IRC | 19:22 | |
*** iceyao has joined #ara | 20:01 | |
*** drab has left #ara | 20:01 | |
*** iceyao has quit IRC | 20:05 | |
*** reet_ has quit IRC | 20:25 | |
*** iamnotarobot has joined #ara | 20:36 | |
*** karimb has quit IRC | 21:02 | |
*** karimb has joined #ara | 21:03 | |
*** iceyao has joined #ara | 22:07 | |
*** iceyao has quit IRC | 22:12 | |
*** themurph has quit IRC | 22:15 | |
*** themurph has joined #ara | 22:17 | |
*** iamnotarobot has quit IRC | 22:24 | |
*** themurph has quit IRC | 22:25 | |
*** iceyao has joined #ara | 22:49 | |
*** iceyao has quit IRC | 22:53 | |
*** themurph has joined #ara | 23:01 | |
*** iceyao has joined #ara | 23:30 | |
*** iceyao has quit IRC | 23:34 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!