Monday, 2017-05-08

*** iceyao has joined #ara00:49
*** iceyao has quit IRC00:53
*** cuongnv has joined #ara01:01
*** iceyao has joined #ara01:10
*** iceyao has quit IRC01:15
*** iceyao has joined #ara01:23
openstackgerritDavid Moreau Simard proposed openstack/ara master: Do not merge: Test openstack-ansible gate job  https://review.openstack.org/43609803:25
*** iceyao has quit IRC04:10
*** iceyao has joined #ara04:35
*** iceyao has quit IRC04:40
*** iceyao has joined #ara04:49
*** iceyao has quit IRC04:59
*** iceyao has joined #ara05:16
*** iceyao has quit IRC05:20
*** iceyao has joined #ara05:33
*** iceyao has quit IRC05:38
*** iceyao has joined #ara06:17
*** cuongnv has quit IRC06:19
*** vcn[m] has quit IRC06:19
*** cuongnv has joined #ara06:19
*** vcn[m] has joined #ara06:24
*** iceyao has quit IRC07:46
*** iceyao has joined #ara07:52
*** cuongnv has quit IRC08:16
*** drab has quit IRC08:37
*** drab has joined #ara08:50
*** iceyao has quit IRC09:39
*** iceyao has joined #ara09:40
*** iceyao has quit IRC09:55
*** iceyao has joined #ara10:22
*** iceyao has quit IRC10:26
*** iceyao has joined #ara10:52
dmsimardARA 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
dmsimardlarsks: ^ there's some good words for you in there :)13:21
larsksdmsimard: thanks! I saw that in my rss feed but haven't had the chance to read it yet...13:22
larsksBut hey, congrats on a year! :)13:22
*** karimb has joined #ara13:31
*** tbielawa has joined #ara13:54
*** reet_ has joined #ara14:36
reet_hi14:37
reet_after migrating to 0.13 I get following error when I am trying to open page '2' of the reports14: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.1214:38
dmsimardreet_: are you running on wsgi ?14:39
reet_dmsimard:  via basic:  ara-manage runserver -h 0.0.0.0 -p 808014:40
dmsimardreet_: okay, if you do "ara playbook list", do you see the playbooks you'd expect ?14:41
reet_dmsimard: let me check14:41
reet_dmsimard: no, the same error $ ara playbook list No row was found for one()14:41
dmsimardreet_: 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 afterwards14:43
dmsimardreet_: 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 --user14:47
dmsimardreet_: hmm, so you were running off of a trunk installation ?14:48
dmsimardI'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 too14:49
dmsimardreet_: 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 requirement14: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. Understood14:51
dmsimardah, yeah, --upgrade upgrades everything14:51
dmsimardthere's an argument you can pass to pip to only upgrade the one package you're asking for14:51
dmsimardI forget what it is14:51
reet_dmsimard: no problem I know what you mean sorry for confusion14: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
dmsimardreet_: 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
dmsimardreet_: thanks :)14:54
dmsimardreet_: 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
dmsimardreet_: so I'll go and get the database from that build and upgrade, see what happens14:56
reet_dmsimard: cool14:58
dmsimardreet_: 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.515:05
dmsimardthat should be fine15:05
reet_dmsimard: https://pastebin.com/1gbVavab15:08
dmsimardreet_: 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
dmsimardreet_: 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 problem15: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/issue1073015:19
dmsimardreet_: the svg images not showing is usually related to a mime type issue15:20
reet_dmsimard: right15:21
dmsimardreet_: 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
dmsimardreet_: you can add verbosity for sql queries with export ARA_SQL_DEBUG=true15:22
*** vcn[m] has quit IRC15:43
reet_dmsimard: not sure it this helps for debug https://pastebin.com/DnPNEpiZ15:44
*** vcn[m] has joined #ara15:48
*** iceyao has quit IRC16:41
*** iceyao has joined #ara16:49
*** iceyao has quit IRC16:51
dmsimardreet_: sort of16:54
dmsimardreet_: 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-L19516:56
dmsimardreet_: 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 saved16:57
dmsimardreet_: I'll try and send a patch, maybe you can try it and let me know if that fixes it for you16:57
reet_dmsimard: all right17:00
*** iceyao has joined #ara17: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 thou17:18
openstackgerritDavid Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved  https://review.openstack.org/46337617:28
openstackgerritDavid Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved  https://review.openstack.org/46337617:38
dmsimardreet_: I think that last patch should do it, I also added a unit test.17:38
dmsimardreet_: you can patch locally with https://review.openstack.org/gitweb?p=openstack/ara.git;a=patch;h=d666941fe6e69716e870ad56e8f4e9e689f6503717:38
openstackgerritDavid Moreau Simard proposed openstack/ara master: Return a generated file object if the playbook file was not saved  https://review.openstack.org/46337617:44
dmsimarddon't mind this last patchset, just pep8 fixes17:44
*** tbielawa is now known as tbielawa|vroooOO17:45
*** iceyao has quit IRC17:59
*** iceyao has joined #ara18:21
*** iceyao has quit IRC18:25
reet_dmsimard: still some kind of DB issue https://pastebin.com/wgy59VUE18:25
dmsimardreet_: hmm, that's super puzzling18:38
reet_dmsimard: need to run now will try tomorrow. for now will use fresh database. Have a good day!18:39
dmsimardreet_: okay, let me know if you happen to find what was the problem18: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 reproducible18:41
*** iceyao has joined #ara18:43
*** iceyao has quit IRC18:47
*** iceyao has joined #ara19:17
*** iceyao has quit IRC19:22
*** iceyao has joined #ara20:01
*** drab has left #ara20:01
*** iceyao has quit IRC20:05
*** reet_ has quit IRC20:25
*** iamnotarobot has joined #ara20:36
*** karimb has quit IRC21:02
*** karimb has joined #ara21:03
*** iceyao has joined #ara22:07
*** iceyao has quit IRC22:12
*** themurph has quit IRC22:15
*** themurph has joined #ara22:17
*** iamnotarobot has quit IRC22:24
*** themurph has quit IRC22:25
*** iceyao has joined #ara22:49
*** iceyao has quit IRC22:53
*** themurph has joined #ara23:01
*** iceyao has joined #ara23:30
*** iceyao has quit IRC23:34

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!