Thursday, 2017-06-15

openstackgerritMike Fedosin proposed openstack/mistral master: Add Glare action pack  https://review.openstack.org/47389800:34
*** zhurong has joined #openstack-mistral00:39
openstackgerritMike Fedosin proposed openstack/mistral master: Use recommended function to setup auth middleware in devstack  https://review.openstack.org/47379601:07
*** liujiong has joined #openstack-mistral01:59
liujiongHi, mistral team, I got trouble with mistral dabase, can you help me?03:00
liujiong2017-06-15 10:57:37.745 181972 INFO mistral.api.controllers.v2.workflow [-] Fetch workflows. marker=None, limit=None, sort_keys=[u'created_at'], sort_dirs=[u'asc'], fields=[], filters={}03:00
liujiong2017-06-15 10:57:37.786 181972 DEBUG oslo_db.sqlalchemy.engines [-] Parent process 181924 forked (181972) with an open database connection, which is being discarded and recreated. checkout03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool [-] Exception during reset or similar03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool Traceback (most recent call last):03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 636, in _finalize_fairy03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool     fairy._reset(pool)03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 776, in _reset03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool     pool._dialect.do_rollback(self)03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool   File "/usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2526, in do_rollback03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool     dbapi_connection.rollback()03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool OperationalError: (2006, 'MySQL server has gone away')03:00
liujiong2017-06-15 10:57:37.791 181972 ERROR sqlalchemy.pool.QueuePool03:00
*** catintheroof has joined #openstack-mistral03:15
*** fultonj has quit IRC03:28
*** fultonj has joined #openstack-mistral03:40
*** catintheroof has quit IRC03:47
*** fultonj has quit IRC04:04
*** fultonj has joined #openstack-mistral04:06
*** gkadam has joined #openstack-mistral04:21
*** zhurong has quit IRC04:28
*** zhurong has joined #openstack-mistral04:40
openstackgerritRenat Akhmerov proposed openstack/mistral master: Make sure that the field "state_info" trimmed as expected  https://review.openstack.org/47419504:40
*** ttpl has quit IRC04:41
rakhmerovliujiong: hi, please paste all logs and stack traces to paste.openstack.org04:45
rakhmerovcan you show your mistral config?04:45
*** ttpl has joined #openstack-mistral04:48
*** ttpl has quit IRC04:52
openstackgerritShubhendu Poothia proposed openstack/mistral master: Set access_policy for messaging's dispatcher  https://review.openstack.org/47445104:53
*** ttpl has joined #openstack-mistral04:54
*** jaosorior has quit IRC05:00
*** ttpl has quit IRC05:22
openstackgerritSharat Sharma proposed openstack/python-mistralclient master: Add pagination options for workflows and actions  https://review.openstack.org/45851505:41
*** sharatss has joined #openstack-mistral05:41
*** dtantsur|afk is now known as dtantsur05:49
openstackgerritSharat Sharma proposed openstack/python-mistralclient master: Add pagination options for workflows and actions  https://review.openstack.org/45851506:54
*** liujiong_lj has joined #openstack-mistral06:57
*** liujiong has quit IRC06:58
liujiong_ljrakhmerov: thank you! I figured it out - the logs I posted wasn't the root cause of the problem, I added new actions to mapping.json but forgot to populate database.06:59
rakhmerovok )06:59
liujiong_ljrakhmerov: but seems mistral will have database issue like posted when it's set with HA.07:00
rakhmerovwhy?07:01
liujiong_ljI havn't digged into that but got such problem when we deploy mistral with HA.07:02
liujiong_ljThe same issue also exists in Barbican project, it should depend on the way we use oslo.db07:03
*** jaosorior has joined #openstack-mistral07:12
*** amoralej|off is now known as amoralej07:15
*** liujiong_lj has quit IRC07:22
*** liujiong has joined #openstack-mistral07:22
openstackgerritSharat Sharma proposed openstack/python-mistralclient master: Add pagination options for workflows and actions  https://review.openstack.org/45851507:36
*** shardy has joined #openstack-mistral07:36
*** gkadam is now known as gkadam-brb07:48
*** jpich has joined #openstack-mistral08:11
*** shardy has quit IRC08:31
*** dtantsur is now known as dtantsur|lunch08:33
*** liujiong has quit IRC08:43
*** liujiong has joined #openstack-mistral08:43
openstackgerritRenat Akhmerov proposed openstack/mistral master: Make sure that the field "state_info" trimmed as expected  https://review.openstack.org/47419509:15
openstackgerritRenat Akhmerov proposed openstack/mistral master: Make sure that the field "state_info" trimmed as expected  https://review.openstack.org/47419509:28
*** sharatss has quit IRC09:36
*** d0ugal has quit IRC09:48
*** d0ugal has joined #openstack-mistral09:49
*** sharatss has joined #openstack-mistral09:54
*** dtantsur|lunch is now known as dtantsur09:56
openstackgerritMerged openstack/mistral master: Set access_policy for messaging's dispatcher  https://review.openstack.org/47445110:00
thervesharatss, Are you looking at https://review.openstack.org/#/c/455174/ failures?10:03
therveIt was broken by the recent changes you made10:03
sharatsshi therve, i was making those changes given in review10:03
thervesharatss, Well yeah review are wrong sometimes :)10:04
sharatsstherve, if u have got some time pls take a look at it10:04
thervetest failures are not :D10:04
therveYeah we can't rename api_key, it's a compatibility parameter10:04
therveThe kwargs.pop('session') is not doing the same thing as before10:05
sharatsstherve, yea.. i reverted the api_key though...10:05
thervesharatss, Not the tests10:05
sharatsstherve, i am deeply involved in the cricket match :P10:06
openstackgerritThomas Herve proposed openstack/python-mistralclient master: Use keystoneauth plugins and session instead of keystoneclient  https://review.openstack.org/45517410:06
therveGood for you :D10:06
sharatsstherve, you watching?10:06
*** liujiong has quit IRC10:06
therveHum no :)10:06
*** jkilpatr has quit IRC10:32
openstackgerritRenat Akhmerov proposed openstack/mistral master: Make sure that the field "state_info" trimmed as expected  https://review.openstack.org/47419510:45
*** jkilpatr has joined #openstack-mistral10:49
*** shardy has joined #openstack-mistral10:50
*** gkadam-brb is now known as gkadam11:00
*** amoralej is now known as amoralej|lunch11:02
rakhmerovsharatss, therve: yeah, that was rather a question :)11:09
rakhmerovI mean renaming api_key11:09
rakhmerovI didn't know for sure11:09
sharatssrakhmerov, i tried to rename but failed badly :D11:09
openstackgerritRenat Akhmerov proposed openstack/mistral master: Make sure that the field "state_info" trimmed as expected  https://review.openstack.org/47419511:29
*** chlong has joined #openstack-mistral11:32
*** amoralej|lunch is now known as amoralej12:17
*** zhurong has quit IRC12:26
*** zhurong has joined #openstack-mistral12:28
*** zhurong has quit IRC12:36
fultonjhttps://review.openstack.org/#/c/469644/12/workbooks/ceph-ansible.yaml@6412:36
fultonj^ does anyone have advice on the two issues pointed out above? ^12:37
fultonjd0ugal rbrady ?12:37
fultonjhas anyone built a datastructure using yaql in one mistral task and passed it to another mistral task as input ?12:40
fultonje.g http://paste.openstack.org/show/61269112:40
rakhmerovfultonj: not sure I understand your last question12:42
rakhmerovis there any specific problem with it?12:42
rakhmerovyou can make a datastructure and just use "publish" to pass it further to other tasks downstream12:42
rakhmerovand it will be accessible using $.my_datastructure12:42
fultonjrakhmerov: yes, publish has worked well for me for simpler variables. assuming it works well for a dict like (http://paste.openstack.org/show/612691) then I am thinking of setting it equal to a var12:44
*** sharatss has quit IRC12:45
fultonjinventory: <% $.var %>12:45
thervefultonj, I don't get why you don't reuse stuff publish in set_ip_lists12:45
rakhmerovyeah, it should work w/o problems12:45
fultonj^ i would then pass the above12:45
fultonjhowever, the action tripleo.ansbile-playbook isn't working nicely with it12:46
rakhmerovthere isn't a difference how primitive values and data structures are processed12:46
fultonjtherve: yes, i was planning to that originally12:46
fultonjultimately i think this is a formatting issue12:46
fultonjso do i solve it by modifying the action to deal with the json i get from the yaql OR should i be smarter about generating the datastructure?12:47
fultonjrakhmerov: ok, thanks for the confirmation12:47
fultonjthe action is here https://review.openstack.org/#/c/470021/13/tripleo_common/actions/ansible.py12:48
fultonjmy attempts to build the structure in yaql and pass it gets me errors like this12:49
fultonjhttp://paste.openstack.org/raw/612697/12:49
fultonjthe action expects yaml12:50
fultonji can have it convert json to yaml within the action and make json a new option12:50
fultonjor am i overlooking the power of yaql12:50
fultonj?12:50
fultonjwondering the direction i ought to go in12:50
thervefultonj, So what happens if you do eg hosts: <% mon_ips %>12:53
fultonjtherve: i tried that and it copmlained. i will reproduce right now and share the error.12:53
fultonj              hosts: <%$.mon_ips %>12:55
* fultonj running12:55
fultonj              hosts: <% $.mon_ips %>12:55
therveYeah sorry12:55
fultonjnp12:55
fultonji understand what you meant12:55
d0ugalFL1SK: looking.12:56
d0ugalfultonj: looking12:57
d0ugalFL1SK: sorry.12:57
fultonjhttp://paste.openstack.org/raw/612701/12:57
fultonjtherve: ^12:57
fultonjd0ugal: thanks12:57
fultonjtherve: i think it's not getting a good yaml list from "hosts: <% $.mon_ips %>"12:57
fultonjgood => one that parses correctly :)12:58
thervefultonj, Isn't that u'mons': {u'hosts': [u'192.168.24.8']} ?12:58
fultonjshould be12:58
* fultonj adds task to echo the var12:58
d0ugalso the issue is that it is converted into a string?12:58
therveI mean I wonder if the error isn't on another hosts12:59
therveLike when it's empty, I guess it wants [] not ''12:59
therveBut you didn't change all hosts, did you?12:59
fultonjtherve: just mons12:59
fultonj<% env().get('service_ips', {}).get('ceph_mon_ctlplane_node_ips', []) %>12:59
fultonj^ it6 should be getting [] if nothing, though I know there's an IP13:00
thervefultonj, But did you do it for mdss?13:01
fultonjtherve: mdss is empty, but at least ansible runs and things parse13:01
fultonjtherve: to focus on the concatenation problem i temporarily yank out others13:02
fultonjso i just have osd and mon13:02
fultonjhttp://paste.openstack.org/raw/612703/13:03
fultonjso...13:03
fultonj<% $.mon_ips %>13:03
fultonjis13:04
fultonj[13:04
fultonj  "192.168.24.8"13:04
fultonj]13:04
* fultonj does same to osds13:04
*** catintheroof has joined #openstack-mistral13:07
thervefultonj, So I don't know what format ansible wants for hosts in that structure13:08
fultonjhttps://docs.ansible.com/ansible/intro_inventory.html13:09
therveBut I'm sure we can come with it once we know :)13:09
fultonjtherve: exactly13:09
fultonji am thinking of adding a json option13:09
fultonj" Valid file extensions include ‘.yml’, ‘.yaml’, ‘.json"13:09
fultonjto the ansible action13:09
fultonjand building the whole thing w/ yaql http://paste.openstack.org/show/612691/13:10
fultonjbut didn't want to go down the road if someone thought i should just solve this 100% in the workflow13:10
fultonjas per line 20513:12
thervefultonj, So it would seem it wants "hosts":  {"192.168.24.8": ""}, no?13:12
fultonjhttps://review.openstack.org/#/c/470021/13/tripleo_common/actions/ansible.py13:12
fultonjpaste the structure and chose the right syntax13:12
fultonjs/syntax/suffix13:12
fultonjtherve: why would it want that?13:13
fultonjtherve: i think you're right13:13
thervefultonj, https://github.com/ansible/ansible/blob/devel/examples/hosts.yaml13:13
fultonjgiven https://review.openstack.org/#/c/471759/1/coe/kubernetes-master.yaml13:13
therveThat's what it looks like13:13
fultonjbut i don't undersatnd13:13
therveSo yeah : {} actually13:14
*** rbrady has quit IRC13:15
fultonjtherve: so use yaql to build something that looks like "hosts":  {"192.168.24.8": {}},13:15
*** rbrady has joined #openstack-mistral13:15
thervefultonj, Yeah13:15
fultonjok, i'll pursue that and no action modification and see how it goes13:16
fultonjthanks13:16
thervefultonj, $.mon_ips.toDict($, {})13:16
* d0ugal is following along13:16
*** rbrady has quit IRC13:17
* fultonj runs workbook with new yaql ^ 13:17
*** rbrady has joined #openstack-mistral13:17
fultonjtherve: wins!13:18
therve\o/13:18
fultonjhttp://paste.openstack.org/raw/612705/13:18
fultonjproblem 1 solved13:19
* fultonj moves to problem 2 (when there are no mds)13:19
therveI trust that it's the write output :)13:19
therves/write/right13:19
therveWell I think it should work too if it's empty13:19
*** dprince has joined #openstack-mistral13:20
*** catinthe_ has joined #openstack-mistral13:21
*** catintheroof has quit IRC13:24
*** catintheroof has joined #openstack-mistral13:25
*** catinthe_ has quit IRC13:25
*** catinthe_ has joined #openstack-mistral13:26
*** catinth__ has joined #openstack-mistral13:26
*** catintheroof has quit IRC13:26
fultonjtherve: close13:28
fultonjtherve: i think i need a diff yaql expression13:28
thervefultonj, What do you have?13:28
fultonjto manage the case where the list is empty13:28
fultonjerror=No method "toDict" for13:29
fultonjreceiver mds_ips matches supplied arguments, data={}],13:29
*** catintheroof has joined #openstack-mistral13:29
*** catinthe_ has quit IRC13:30
therveHum13:30
thervefultonj, Can you paste the template?13:30
fultonjtherve: yes13:30
fultonjhttp://paste.openstack.org/raw/612707/13:31
thervefultonj, You're missing $. no?13:32
fultonjtherve: yeah sorry about that13:32
* fultonj re-runs13:33
*** catinth__ has quit IRC13:33
therveThat's ok :)13:33
therveActually that makes think about a task, which is to unit test yaql in tht13:33
therveWonder how hard it would be13:33
fultonjtherve: wins again!13:34
fultonjhttp://paste.openstack.org/raw/612708/13:35
fultonjtherve: thanks you just solved my problems and got me unstuck13:35
thervefultonj, You're very welcome!13:35
fultonjwith less code, not more code too13:35
therveThanks for pioneering those interfaces! They are not super dry yet13:36
*** bobh has joined #openstack-mistral13:43
*** bobh has quit IRC13:46
*** bobh has joined #openstack-mistral13:49
*** zhurong has joined #openstack-mistral13:51
*** jistr is now known as jistr|mtg13:59
*** flaper87 has joined #openstack-mistral14:02
flaper87fultonj: did you see my patches?14:02
fultonjflaper87: yes (473587 + 473586)14:03
fultonjflaper87: i will try them out in my env and comment14:04
fultonjflaper87: and thank you14:04
flaper87fultonj: my pleasure! :)14:04
flaper87thank you for testing them14:04
*** zhurong has quit IRC14:22
openstackgerritMike Fedosin proposed openstack/mistral master: Use recommended function to setup auth middleware in devstack  https://review.openstack.org/47379614:51
*** jistr|mtg is now known as jistr14:59
*** dtantsur is now known as dtantsur|bbl15:02
*** gkadam has quit IRC15:04
*** jkilpatr_ has joined #openstack-mistral15:40
*** jkilpatr has quit IRC15:43
*** dtantsur|bbl is now known as dtantsur15:49
*** jpich has quit IRC16:06
*** rbrady is now known as rbrady-afk16:08
*** jkilpatr has joined #openstack-mistral16:36
*** jkilpatr_ has quit IRC16:37
*** dtantsur is now known as dtantsur|afk16:38
*** bobh has quit IRC16:45
*** jtomasek has quit IRC17:13
*** bobh has joined #openstack-mistral17:14
*** shardy has quit IRC17:47
*** amoralej is now known as amoralej|off18:16
*** catinthe_ has joined #openstack-mistral19:07
*** jaosorior is now known as jaosorior_away19:08
*** catintheroof has quit IRC19:11
*** catintheroof has joined #openstack-mistral19:22
*** catinthe_ has quit IRC19:25
*** dprince has quit IRC19:50
*** jkilpatr has quit IRC20:18
openstackgerritMerged openstack/mistral master: Increase the Environment variable column length  https://review.openstack.org/47381320:21
fultonjflaper87: i found two issues so far and i'm looking at a 3rd20:27
fultonjhttps://review.openstack.org/#/c/473586/2/tripleo_common/actions/ansible.py20:27
fultonj^ the two20:27
fultonjhttp://paste.openstack.org/raw/612749/20:32
*** jkilpatr has joined #openstack-mistral20:59
*** catinthe_ has joined #openstack-mistral21:06
*** catintheroof has quit IRC21:09
*** catinthe_ has quit IRC21:28
*** bobh has quit IRC22:05
*** jkilpatr has quit IRC22:24
openstackgerritOpenStack Proposal Bot proposed openstack/mistral master: Updated from global requirements  https://review.openstack.org/47465522:43
*** jkilpatr has joined #openstack-mistral23:43

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