Monday, 2016-08-08

*** rrecio_ has joined #openstack-mistral00:04
*** toddjohn has joined #openstack-mistral00:15
*** rrecio_ has quit IRC00:16
*** toddjohn has quit IRC00:20
*** toddjohn has joined #openstack-mistral01:47
*** toddjohn has quit IRC01:51
*** toddjohn has joined #openstack-mistral02:48
rakhmerovhparekh, kong, ddeja, akuznetsova: guys, please review https://review.openstack.org/#/c/352075, it's pretty urgent because it blocks client development02:48
*** toddjohn has quit IRC02:52
*** FL1SK has quit IRC03:03
*** chlong has quit IRC03:25
*** toddjohn has joined #openstack-mistral03:50
*** toddjohn has quit IRC03:54
openstackgerritRenat Akhmerov proposed openstack/mistral: Fix GET /executions/<id> to init 'output' attribute explicitly  https://review.openstack.org/35220704:05
*** jaosorior has joined #openstack-mistral04:14
rakhmerovand https://review.openstack.org/#/c/352207/ too04:16
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: adapt 'join' tasks to work w/o locks  https://review.openstack.org/35172704:16
rakhmerovhparekh: hi, can you please also look at https://review.openstack.org/#/c/352207/04:17
rakhmerovdevstack tests are failing because of that too04:17
hparekhrakhmerov, sure04:17
rakhmerovthanks, it's super simple04:17
openstackgerritMerged openstack/mistral: fix for get action executions fails with "has no property 'type"  https://review.openstack.org/35207504:27
*** Ravikiran_K has joined #openstack-mistral04:29
hparekhrakhmerov, Do we need database transaction ? I think it is ok if we don't use database transaction04:31
rakhmerovhparekh: no-no, we do need it04:31
rakhmerovbecause this field is loaded lazily04:31
rakhmerovboth operations must happen within the same SQLAlchemy sessions04:32
rakhmerovI also just filed another bug that's related to this: https://bugs.launchpad.net/mistral/+bug/161081704:32
openstackLaunchpad bug 1610817 in Mistral "GET /action_executions should not include 'output' field" [High,New] - Assigned to Michal Gershenzon (michal-gershenzon)04:32
rakhmerovand it has a similar problem04:32
hparekhrakhmerov, Oh ok. Then I think we need same in  mistral/api/controllers/v2/action_execution.py04:33
rakhmerovyeah04:33
rakhmerovthat bug has info about it :)04:33
rakhmerovhparekh: so, we always need to use transactions of we have any kind of lazy loading, whether it's a collection or a deferred field04:34
rakhmerovin practice though it works but not always04:34
rakhmerovI don't know why04:34
rakhmerovI observe both behaviors04:34
rakhmerovbut in theory it must never work if we load a collection or deferred field in a separate transaction, seems like we have another bug somewhere that we are not aware of yet04:35
rakhmerovbecause sometimes it actually works04:35
hparekhrakhmerov, hmmm.. Thanks04:36
rakhmerovyou're still in doubts?04:37
rakhmerov:)04:37
hparekhrakhmerov, No doubts, I understand your point. :)04:37
rakhmerovok04:37
rakhmerovyeah, I just don't know yet why it works sometimes04:37
rakhmerovas if a transaction (and hence SQLAlchemy session) was ended after "with db_api.transaction():" block04:38
rakhmerovhave no idea how it is possible04:38
*** tonytan4ever has quit IRC04:39
*** toddjohn has joined #openstack-mistral04:50
hparekhddeja, kong , akuznetsova  If you have free time please review https://review.openstack.org/#/c/346814/04:51
konghparekh: ok04:52
* kong is looking04:52
hparekhthanks04:54
*** toddjohn has quit IRC04:55
konghparekh: left my comment after a quick review04:57
*** FL1SK has joined #openstack-mistral05:03
*** janki has joined #openstack-mistral05:06
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: adapt 'join' tasks to work w/o locks  https://review.openstack.org/35172705:10
openstackgerritMerged openstack/mistral: Fix GET /executions/<id> to init 'output' attribute explicitly  https://review.openstack.org/35220705:10
*** chlong has joined #openstack-mistral05:59
hparekhkong, rakhmerov,  Please look at https://bugs.launchpad.net/mistral/+bug/1609335 and https://blueprints.launchpad.net/mistral/+spec/mistral-retry-continue-on06:21
openstackLaunchpad bug 1609335 in Mistral "Retry get executed even if action is success" [Undecided,New] - Assigned to Lucky samadhiya (lucky-samadhiya)06:21
hparekhWe may need some discussion regarding this06:21
hparekhthis feature is little bit confusing06:22
*** toddjohn has joined #openstack-mistral06:52
*** toddjohn has quit IRC06:56
rakhmerovyes, ok07:14
*** sshnaidm has joined #openstack-mistral07:15
sshnaidmhi, I'd appreciate your attention to bug (in case it's missed) https://bugs.launchpad.net/mistral/+bug/1610269 (db missing the 'unique_key' column for delayed_calls_v2 table) which is affecting TripleO periodic jobs now, thanks07:18
openstackLaunchpad bug 1610269 in Mistral "db missing the 'unique_key' column for delayed_calls_v2 table" [Undecided,New]07:18
*** FL1SK has quit IRC07:21
*** jpich has joined #openstack-mistral07:36
*** nmakhotkin has joined #openstack-mistral08:02
*** jtomasek has quit IRC08:07
*** jistr|mtg is now known as jistr08:50
*** toddjohn has joined #openstack-mistral08:53
*** toddjohn has quit IRC08:58
rakhmerovsshnaidm: I already told jaosorior that it's currently a work-in-progress thing and DB migration is now missing for this column09:11
rakhmerovshould be made today09:11
rakhmerovso please be careful when updating from master09:11
sshnaidmrakhmerov, thanks09:12
*** FL1SK has joined #openstack-mistral09:19
d0ugalrakhmerov: Is there anything I can do to help with it?10:08
rakhmerovd0ugal: thanks, it's actually already in progress10:09
d0ugalokay, cool :)10:09
d0ugalThanks!10:10
d0ugalrakhmerov: Which patch is it?10:11
rakhmerovno patch yet, but there will be soon10:11
d0ugalk10:11
rakhmerovMichal is working on it10:12
rakhmerovI mean mgershen10:12
d0ugalokay, cool10:12
rakhmerovyep10:12
d0ugalI'll look out for it :)10:12
*** sshnaidm has quit IRC10:20
*** sshnaidm has joined #openstack-mistral10:40
*** sshnaidm is now known as sshnaidm|afk10:40
*** Ravikiran_K has quit IRC10:40
openstackgerritMerged openstack/mistral: Fix past migration scripts discrepancies  https://review.openstack.org/35209110:43
*** toddjohn has joined #openstack-mistral10:54
*** toddjohn has quit IRC10:59
openstackgerritOpenStack Proposal Bot proposed openstack/mistral: Updated from global requirements  https://review.openstack.org/35234911:03
openstackgerritprince_katiyar proposed openstack/python-mistralclient: Add error message when OS_USERNAME or OS_PASSWORD not provided  https://review.openstack.org/34814211:13
*** jaosorior has quit IRC11:27
*** sshnaidm|afk is now known as sshnaidm11:28
*** jaosorior has joined #openstack-mistral11:28
*** toddjohn has joined #openstack-mistral11:48
openstackgerritMichal Gershenzon proposed openstack/mistral: Add unique keys for non locking model  https://review.openstack.org/35237611:57
mgershend0ugal: here it is ^11:59
mgershensorry for keeping you waiting11:59
*** dprince has joined #openstack-mistral12:00
d0ugalmgershen: no problem, thanks - I'll take a look!12:03
*** toddjohn has quit IRC12:06
*** toddjohn has joined #openstack-mistral12:07
*** toddjohn has quit IRC12:11
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: adapt 'join' tasks to work w/o locks  https://review.openstack.org/35172712:19
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: make 'with-items' work w/o locks  https://review.openstack.org/35238612:19
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: make 'with-items' work w/o locks  https://review.openstack.org/35238612:25
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: adapt 'join' tasks to work w/o locks  https://review.openstack.org/35172712:25
openstackgerritMerged openstack/mistral: Updated from global requirements  https://review.openstack.org/35234912:27
rakhmerovddeja: hi Dawid, I addressed your comments in https://review.openstack.org/#/c/351727/12:27
ddejahi rakhmerov12:36
ddejalooking12:36
rakhmerovok )12:36
rakhmerovyou can also ask me here if needed12:37
rakhmerovthe changes are not trivial12:37
ddejaabout the key = 'th_c_t_s_a-%s' % task_ex.id12:37
rakhmerovyes12:37
rakhmerovit's purely internal data12:37
rakhmerovit will never be exposed to users12:38
ddejaI'm OK with reducing space in the DB12:38
rakhmerovok12:38
ddejaand I understand it is in only visible from the codebase or database12:38
ddejacan you just add comment for this?12:38
rakhmerovyeah, it just should be enough for debugging12:38
*** Ravikiran_K has joined #openstack-mistral12:38
rakhmerovI can, yes12:38
rakhmerovok in a separate patch? ;)12:39
ddejasure12:39
rakhmerovok12:39
rakhmerovI'll make a note12:39
ddejasomeone just might go there after a year and spend some time wondering 'what kind of language is this' ;)12:39
rakhmerov:)))12:39
ddejaoh, and since we are talking12:40
ddejaI have some questions about the insert_or_ignore method12:40
rakhmerovyes12:40
rakhmerovgo ahead12:41
ddejaI don't like that it hack a little the sql alchemy12:41
ddejaand depends on the dialect value12:41
ddejaisn't there any better way of achiving this?12:42
ddejaI mean, some internal mechanism of SQLAlchemy12:42
rakhmerovI didn't find such a way yet12:42
rakhmerovunfortunately12:42
rakhmerovI don't like this hack too but I spent several days trying to find a better solution12:42
rakhmerovnothing12:43
ddejaOK then12:43
rakhmerovthe key problem here is that we need this kind of conflict check at DB level12:43
rakhmerovit must be atomic12:43
rakhmerovwe could make it based on just ignoring exceptions but this approach doesn't work with Postgres12:44
rakhmerovbecause in Postgres if you get ANY sql query error it switches TX to "rollback-only" mode12:44
rakhmerovso it's a different behavior across databases12:44
rakhmerovand there are some nuances two12:45
ddejaoh, I see12:45
rakhmerovyeah, it's all painful12:45
rakhmerovddeja: as far as supporting different DBs, we're lucky that we can do it even for two DB dialects :)12:46
rakhmeroveven Postgres and Mysql work completely differently in many cases12:46
ddejayup12:46
rakhmerove.g. transactional support12:46
rakhmerovin fact, Mysql doesn't really support real 'repeatable read' :)12:47
rakhmerovwhich we tried to use in the past12:47
rakhmerovif they were supported normally, I wouldn't have to do this kind of hacks12:47
* ddeja just give +2 for the patch12:47
rakhmerov:)))12:47
rakhmerovthanks12:47
ddejano problem12:48
rakhmerovanyway, let me know if you want to know more, I spent last several weeks learning about this kind of tiny details in DB behavior12:48
rakhmerovI can tell12:48
rakhmerovddeja: but the good news is that Mistral now works ~100 times faster12:49
rakhmerovmay be even more than 100 times12:49
ddejawow12:49
rakhmerovyes12:49
ddejathat's good12:49
rakhmerovwithout locks12:49
rakhmerovI test these changes w/o locks locally with multiple Mistral instances12:50
rakhmerovit works like a rocket12:50
rakhmerovso my plan is to make all needed changes and then remove locks completely12:50
ddeja'It's not a rocket science... well, it is kind of' :)12:50
rakhmerovyeah, it's kind of :))12:50
ddejarakhmerov: great!12:51
ddejarakhmerov: Do we have a meeting today? There is no mail on opensktack-dev...12:54
rakhmerov:)12:54
rakhmerovyes, we do12:54
rakhmerovI'll send an email now12:54
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: make 'with-items' work w/o locks  https://review.openstack.org/35238612:57
*** toddjohn has joined #openstack-mistral12:57
nmakhotkinhi guys13:04
nmakhotkinhi rakhmerov!13:04
rakhmerovhi )13:05
nmakhotkingreat news! If it is indeed that Mistral now works about 100 times faster it is amazing13:06
nmakhotkinI really want to review these patches13:06
rakhmerovyeah, I believe I'm very close to finish these changes13:07
nmakhotkinI'll do it asap13:07
nmakhotkintomorrow, I think :)13:07
*** nmakhotkin has quit IRC13:08
rakhmerovok13:08
*** tonytan4ever has joined #openstack-mistral13:12
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: make 'with-items' work w/o locks  https://review.openstack.org/35238613:26
*** bobh has joined #openstack-mistral13:38
*** bobh has quit IRC13:44
*** bobh has joined #openstack-mistral13:45
openstackgerritMerged openstack/mistral: Add unique keys for non locking model  https://review.openstack.org/35237613:55
openstackgerritRyan Brady proposed openstack/mistral-lib: [WIP] Porting Security Related Code to Mistral-Lib  https://review.openstack.org/35243514:00
*** rrecio has joined #openstack-mistral14:08
*** rrecio_ has joined #openstack-mistral14:09
*** rrecio has quit IRC14:12
*** janki has quit IRC14:14
*** rrecio_ has quit IRC14:35
*** rrecio has joined #openstack-mistral14:45
*** jaosorior has quit IRC14:56
*** mgershen has quit IRC15:08
*** dprince has quit IRC15:14
*** toddjohn has quit IRC15:16
*** toddjohn has joined #openstack-mistral15:20
openstackgerritDawid Deja proposed openstack/mistral: Make mistral work with amqp and zmq backends  https://review.openstack.org/35248015:23
*** toddjohn has quit IRC15:25
*** brian_price has joined #openstack-mistral15:32
*** toddjohn has joined #openstack-mistral15:35
*** rbrady-afk is now known as rbrady15:38
*** Ravikiran_K has quit IRC15:45
*** sshnaidm has quit IRC16:01
*** Ravikiran_K has joined #openstack-mistral16:11
*** sshnaidm has joined #openstack-mistral16:13
*** toddjohn has quit IRC16:26
*** catintheroof has joined #openstack-mistral16:28
*** toddjohn has joined #openstack-mistral16:29
*** toddjohn_ has joined #openstack-mistral16:31
*** toddjoh__ has joined #openstack-mistral16:32
*** tonytan4ever has quit IRC16:34
*** toddjohn has quit IRC16:34
*** tonytan4ever has joined #openstack-mistral16:34
*** toddjohn_ has quit IRC16:35
*** toddjoh__ has quit IRC16:36
*** tonytan_brb has joined #openstack-mistral16:37
*** tonytan4ever has quit IRC16:38
openstackgerritRenat Akhmerov proposed openstack/mistral: Towards non-locking model: make 'with-items' work w/o locks  https://review.openstack.org/35238616:40
*** jpich has quit IRC16:51
*** bobh has quit IRC17:34
*** dprince has joined #openstack-mistral18:08
*** toddjohn has joined #openstack-mistral18:28
*** toddjohn has quit IRC18:33
*** bobh has joined #openstack-mistral18:34
*** toddjohn has joined #openstack-mistral18:38
*** bobh has quit IRC18:39
*** Ephur has quit IRC18:40
*** bobh has joined #openstack-mistral18:42
*** dulek_ has joined #openstack-mistral18:50
*** dulek has quit IRC18:50
*** dulek_ is now known as dulek18:50
*** Ravikiran_K has quit IRC18:51
*** dprince has quit IRC18:54
openstackgerritRyan Brady proposed openstack/mistral-lib: [WIP] Porting Security Related Code to Mistral-Lib  https://review.openstack.org/35243518:58
*** bobh has quit IRC19:03
*** Ephur has joined #openstack-mistral19:22
*** jistr has quit IRC19:44
*** bobh has joined #openstack-mistral19:45
*** jistr has joined #openstack-mistral19:48
*** jistr has quit IRC19:53
*** jistr has joined #openstack-mistral19:56
*** dprince has joined #openstack-mistral20:11
*** tonytan_brb has quit IRC20:16
*** dprince has quit IRC20:33
*** dprince has joined #openstack-mistral20:35
*** dprince has quit IRC21:02
*** tonytan4ever has joined #openstack-mistral21:17
*** tonytan4ever has quit IRC21:22
*** bobh has quit IRC21:23
*** bobh has joined #openstack-mistral21:33
*** tonytan4ever has joined #openstack-mistral21:35
*** catintheroof has quit IRC21:43
*** bobh has quit IRC22:10
*** chlong has quit IRC22:35
*** sshnaidm is now known as sshnaidm|afk22:38
*** vishwanathj has quit IRC23:20
*** toddjohn has quit IRC23:25
*** rrecio has quit IRC23:50

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