Wednesday, 2019-03-20

*** jamesmcarthur has quit IRC00:01
*** jamesmcarthur has joined #storyboard00:07
*** diablo_rojo has quit IRC00:48
*** jamesmcarthur has quit IRC00:50
*** jamesmcarthur has joined #storyboard01:16
*** jamesmcarthur has quit IRC01:18
*** jamesmcarthur has joined #storyboard01:19
*** jamesmcarthur has quit IRC01:22
*** whoami-rajat has joined #storyboard01:30
*** jamesmcarthur has joined #storyboard01:33
*** jamesmcarthur has quit IRC02:22
*** jamesmcarthur has joined #storyboard02:26
*** jamesmcarthur has quit IRC03:56
*** udesale has joined #storyboard04:00
*** jamesmcarthur has joined #storyboard04:00
*** jamesmcarthur has quit IRC04:00
*** jamesmcarthur has joined #storyboard04:01
*** jamesmcarthur has quit IRC04:05
*** jamesmcarthur has joined #storyboard04:27
*** scherbatsky has quit IRC05:13
*** tosky has joined #storyboard07:29
*** jpich has joined #storyboard07:48
*** jtomasek has quit IRC08:49
SotKRou: in boards/worklists, "user" means "able to add, move, and remove cards", and "owner" means "able to add, move, and remove cards, and also able to edit titles, permissions, lane ordering, and filters"08:56
*** jtomasek has joined #storyboard09:09
*** dtantsur|afk is now known as dtantsur09:21
*** jtomasek has quit IRC11:14
Rou[Radwa Khattab (radwasm), Rou's Workspace] Okay, thanks11:21
Rou[Radwa Khattab (radwasm), Rou's Workspace] I need a bit of help in something11:21
*** jtomasek has joined #storyboard11:25
*** udesale has quit IRC11:28
*** udesale has joined #storyboard11:29
Rou[Radwa Khattab (radwasm), Rou's Workspace] First of all, I'm not saying this as cliche's or to increase my chances at being accepted in Outreachy program or whatsoever. But I'm speaking honestly, and I do have to say this. I still don't know what the final application is like.11:34
RouAnyway, I have been waiting for Outreachy projects' list since last of 2018, but when they are finally released, I had family issues and I wasted lots of time. And now in college, God, I barely find time and I am decreasing my GPA each day for the sake of trying to understand everything in Storyboard and contributing. But it is totally worth it to me, I have to get accepted, I don't even give myself a thought that I might not. Won't a11:34
Rou[Radwa Khattab (radwasm), Rou's Workspace] I have experience in lots of things, and always passionate to learn more, like really. But time.... now I noticed that the deadline for the final application in next Tuesday, and I still haven't contributed anything. So, please, please, could you help me out guiding me how to looks for bugs I can fix, and how to find them in the code? I have experience in Python actually and I can read the co11:35
RouSo, please, help me out? I wanna leave a mark in this project and contribute to it.11:35
*** jpich has quit IRC11:42
*** jpich has joined #storyboard11:42
*** jpich has quit IRC11:49
*** jpich has joined #storyboard11:49
Rou[Radwa Khattab (radwasm), Rou's Workspace] https://files.sameroom.io/L6lvFd53zbi2MaH_iTi2U01EvLh4pwpie8PmoDrYQR8/Screenshot+from+2019-03-20+14-08-00.png12:17
Rou[Radwa Khattab (radwasm), Rou's Workspace] So I was considering working on the things I noticed myself, but I need guidance to know where to look up in the code and how to submit them for review and merge. I think I should submit the bug first and assign it to myself? Or what?12:19
*** jpich has quit IRC12:19
*** jpich has joined #storyboard12:20
*** jpich has quit IRC12:35
*** jpich has joined #storyboard12:35
*** jpich has quit IRC12:39
SotKit'd probably be easier to help you work out where to look in the code if you create a story for it first an assign the tasks to yourself, yeah12:40
Rou[Radwa Khattab (radwasm), Rou's Workspace] And say I finished the task as in code, what shall I do then?12:41
SotKhttps://docs.openstack.org/infra/manual/developers.html#starting-work-on-a-new-project describes how to make and send patches12:46
Rou[Radwa Khattab (radwasm), Rou's Workspace] I will check it once I get home from college12:48
Rou[Radwa Khattab (radwasm), Rou's Workspace] what is the difference between storyboard and storyboard-webclient?12:57
Rou[Radwa Khattab (radwasm), Rou's Workspace] Is the webclient for the UI while the other for the API or what?12:57
SotKthat's right, storyboard is just the api, and storyboard-webclient is a standalone web app which communicates with it]13:00
Rou[Radwa Khattab (radwasm), Rou's Workspace] So any code regarding retrieval of data or database should be in storyboard?13:06
SotKyeah13:06
Rou[Radwa Khattab (radwasm), Rou's Workspace] And anything regarding UI as something in Bootstrap will be in the webclient13:07
SotKcorrect13:07
Rou[Radwa Khattab (radwasm), Rou's Workspace] okay, one last thing for now, do suggest how do I start going through the code to understand it better?13:07
Rou[Radwa Khattab (radwasm), Rou's Workspace] the api13:07
*** jpich has joined #storyboard13:09
*** mkarray has joined #storyboard13:26
SotKI tend to read through the bits I need, starting from whichever endpoint I'm thinking about in `storyboard/api/v1/` and looking at any functions that are imported from elsewhere13:34
SotKhttps://pecan.readthedocs.io/en/latest/rest.html#writing-restful-web-services-with-restcontroller is documentation about the library we use for creating the endpoints13:35
mkarrayI've been hearing complaints around the office here and there that storyboard has begun acting painfully slow, was there some merge that could have caused this?13:58
SotKI have a suspicion it was the move to have the db on the same machine as the api which has caused it13:58
mkarrayThat sounds like it would do it14:02
SotKfungi: how painful would it be to undo that (at least until our db is optimised a bit)?14:03
fungii don't think having the db on the same server has made it slower than when it was on a remote trove instance. aside from the latency involved in communicating with the remote db, the new server instance is larger than the size of the old server instance and old trove db instance combined14:10
fungianother thing which changed at the same time though was moving from running on ubuntu 14.04 to 16.0414:11
fungias well as reinstalling with the latest python dependencies available, since normally they only get upgraded if the minimum requirement increases14:11
fungilogged into the server right now i'm running top and seeing it mostly idle most of the time. what operations are acting slow? or is it intermittently slow for all operations?14:12
SotKthe slowness I've experienced has mostly been when navigating to or searching for stories14:12
SotKsimilar to the extreme slowness on storyboard-dev (where you click on a story and wait a non-trivial time before anything happens) but less extreme14:13
fungiit looks like we have a lot of cache memory pressure on the server, according to our cacti graphs14:14
fungito the point where we're pushing into almost 2gb of swap even though we're only actively using 2gb of the 8gb available memory for processes14:14
fungiso that likely explains a lot of it. now to see what's trying to cache so much, and whether we can tune it down or need a larger instance with more available memory14:15
fungihttp://cacti.openstack.org/cacti/graph.php?action=view&local_graph_id=66356&rra_id=all14:15
fungihttp://cacti.openstack.org/cacti/graph.php?action=view&local_graph_id=66358&rra_id=all14:16
fungiso at the moment the mysqld process us consuming 3476084k and apache2 has two processes consuming 2197064k and 2183068k14:17
fungicorresponding resident memory for those three processes is only 350712k, 155768k and 134504k respectively though14:18
fungii'm going to restart apache2 and mysqld and see what happens to memory consumption14:18
SotKthanks14:19
fungimysqld is now at 1241908k virt 238784k res, and the apache processes are at 1368452k/73148k and 1368452k/72608k14:21
fungiso they spiked back up amazingly quickly14:21
fungiand climbing. mysqld at 1.8g virt, apache processes both back to 2.1g virt14:24
fungithe apache error log is accumulating quite a few wsgi errors too14:25
*** jamesmcarthur has quit IRC14:25
fungiand warnings14:25
fungiWARNING oslo_db.sqlalchemy.utils [-] Unique keys not in sort_keys. The sorting order may be unstable.\x1b[00m14:25
*** jamesmcarthur has joined #storyboard14:25
fungiWARNING storyboard.notifications.publisher [-] Attempted to send payload with no destination resource.14:25
fungi/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/sqltypes.py:255: SAWarning: Unicode type received non-unicode bind param value 'QBQo4tSFw7N8uKlDdSdMdDbKJ...'.14:26
fungiinterestingly, the apache2/mysql restarts seem to have halved the used space on the rootfs as well: http://cacti.openstack.org/cacti/graph.php?action=view&local_graph_id=66359&rra_id=all14:28
SotKhm, interesting14:37
*** ivy has joined #storyboard14:47
*** dtantsur is now known as dtantsur|bbl14:51
fungianyway, it does seem like there must be some cache memory growth at work, but for the moment the memory pressure is relieved so i'm curious whether the observed performance issues have subsided as well14:51
fungiif not, then obviously this was a red herring, but if things are much faster for the moment then we may need to look closer at mysql and apache cache memory use14:52
SotKI'm still seeing similar response times to before the restart14:55
fungihrm15:50
openstackgerritAdam Coldrick proposed openstack-infra/storyboard master: Whitelist `rm` for docs target in tox.ini  https://review.openstack.org/64492016:15
openstackgerritAdam Coldrick proposed openstack-infra/storyboard master: WIP: Add docker-compose based dev setup instructions  https://review.openstack.org/64492116:15
openstackgerritAdam Coldrick proposed openstack-infra/storyboard master: WIP: rewrite/clarify non-docker dev env instructions  https://review.openstack.org/64492216:15
SotKthe docs part of that needs a bit more tidying and I ended up almost rewriting the old installation guide, but that's a start to getting the docker-compose stuff I've been using to simplify getting my development environments up and running in-repo16:18
*** dtantsur|bbl is now known as dtantsur16:22
*** altlogbot_1 has joined #storyboard16:41
*** altlogbot_1 has quit IRC16:41
*** jamesmcarthur has quit IRC16:52
*** jamesmcarthur has joined #storyboard16:53
*** udesale has quit IRC17:17
*** Smera has joined #storyboard17:19
*** altlogbot_3 has joined #storyboard17:27
*** altlogbot_3 has quit IRC17:28
*** altlogbot_3 has joined #storyboard17:31
*** jpich has quit IRC17:33
*** Smera has quit IRC17:43
*** Smera has joined #storyboard17:44
*** Smera has quit IRC17:52
*** Smera has joined #storyboard17:53
*** dtantsur is now known as dtantsur|afk17:53
mkarray Will there be a meeting today?17:58
SmeraHey! I have a follow-up question. How do I run the webclient on localhost? I googled, but was only able to come up with generic responses.18:04
*** mrhillsman has joined #storyboard18:09
mkarraySmera: Refer to this https://docs.openstack.org/infra/storyboard/install/development.html#installing-the-javascript-based-web-client18:11
*** irclogbot_3 has quit IRC18:21
*** irclogbot_2 has joined #storyboard18:25
clarkbfungi: diablo_rojo_phon SotK see mkarray's question about a meeting today18:25
diablo_rojo_phonclarkb: yeah was debating.18:26
diablo_rojo_phonI think it would be good to have one if you're around SotK18:27
*** irclogbot_2 has quit IRC18:27
*** irclogbot_3 has joined #storyboard18:30
fungii know mkarray had a topic to bring up about webclient handling of user objects in searches18:30
fungias far as having a bit of a design discussion18:30
fungii'm good with holding a meeting18:31
mkarrayI'm okay either way, my topic doesn't necessarily require a meeting though it probably suits being in one18:32
*** diablo_rojo has joined #storyboard18:33
diablo_rojoI will update the agenda then18:34
diablo_rojomkarray, was the changing query structure your topic?18:35
mkarrayyup, If were holding one I can go into more detail18:35
diablo_rojomkarray, cool. Don't need to add anything else to the agenda just was confirming thats what you wanted to talk about18:36
SotKYeah let's have one18:36
diablo_rojoSotK, the agenda is updated I think18:38
fungithanks diablo_rojo!18:42
*** altlogbot_3 has quit IRC19:00
SotKright then, meeting time19:01
*** altlogbot_0 has joined #storyboard19:03
*** altlogbot_0 has quit IRC19:06
*** Fatema_ has joined #storyboard19:07
*** altlogbot_1 has joined #storyboard19:08
*** Smera has quit IRC19:12
*** Smera has joined #storyboard19:13
*** Fatema_ has quit IRC19:14
*** irclogbot_3 has quit IRC19:16
*** irclogbot_1 has joined #storyboard19:18
*** Smera has quit IRC19:26
*** irclogbot_1 has quit IRC19:30
*** irclogbot_0 has joined #storyboard19:32
*** altlogbot_1 has quit IRC19:34
*** altlogbot_0 has joined #storyboard19:36
*** dhellmann has quit IRC19:57
fungiswap activity and disk i/o on the swap partition are definitely almost nonexistent since the mysql and apache2 restarts at ~14:20 utc19:58
*** dhellmann has joined #storyboard19:59
fungithe story view of a project-team page seems to populate fairly quickly for me20:00
fungiloading a random story seems to populate tasks and comments in a reasonable timeframe20:01
* SotK tries again now he's in a different place20:02
fungimostly curious to know which particular actions (besides the automatic worklist/board lanes we already knew to be slow) are performing questionably20:02
fungiif nothing else it gives me something to recreate the observed problems with if i'm trying different tuning options20:03
mkarrayI'll ask the people who mentioned complaints to me today when they are free fungi (and if the problem is persisting)20:03
SotKI'm seeing a delay of about 3 seconds from clicking on a link to a story in the story list to something actually happens (which is because the story is pre-loaded before the state is changed, its the request to get the story that is taking that time)20:04
SotKits long enough to feel like the click didn't work, which is a relatively new development20:04
fungigot it. i do wonder what's going on during those several seconds20:06
fungisome api query happening?20:07
SotKyeah, its a query to /v1/stories/:id20:13
SotKs/query/GET request/20:13
fungiokay, so in theory i can debug by hitting the api directly and timing the response20:21
*** irclogbot_0 has quit IRC20:45
*** irclogbot_2 has joined #storyboard20:48
*** altlogbot_0 has quit IRC20:53
*** altlogbot_1 has joined #storyboard20:56
*** ivy has quit IRC21:00
openstackgerritMalek Karray proposed openstack-infra/storyboard-webclient master: Flawed logic when checking for invalid query  https://review.openstack.org/64500821:09
*** mkarray has quit IRC21:24
*** whoami-rajat has quit IRC21:29
*** jamesmcarthur has quit IRC23:23
*** tosky has quit IRC23:31
*** jamesmcarthur has joined #storyboard23:32
*** jamesmcarthur has quit IRC23:38
*** jamesmcarthur has joined #storyboard23:38

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