| *** mrhillsman has quit IRC | 00:51 | |
| *** whoami-rajat has joined #storyboard | 03:54 | |
| *** udesale has joined #storyboard | 04:01 | |
| *** gouthamr_ has joined #storyboard | 06:14 | |
| *** gouthamr has quit IRC | 06:15 | |
| *** irclogbot_3 has quit IRC | 06:18 | |
| *** irclogbot_0 has joined #storyboard | 06:20 | |
| *** jtomasek has joined #storyboard | 06:58 | |
| *** tosky has joined #storyboard | 07:14 | |
| *** jpich has joined #storyboard | 08:05 | |
| *** whoami-rajat has quit IRC | 08:48 | |
| *** jpich has quit IRC | 09:00 | |
| *** udesale has quit IRC | 09:02 | |
| *** udesale has joined #storyboard | 09:03 | |
| *** udesale has quit IRC | 09:04 | |
| *** jpich has joined #storyboard | 09:08 | |
| *** udesale has joined #storyboard | 09:08 | |
| *** udesale has quit IRC | 09:13 | |
| *** udesale has joined #storyboard | 09:14 | |
| *** udesale has quit IRC | 09:51 | |
| *** udesale has joined #storyboard | 09:52 | |
| *** jpich has quit IRC | 09:52 | |
| *** jpich has joined #storyboard | 09:52 | |
| *** udesale has quit IRC | 09:56 | |
| *** udesale has joined #storyboard | 09:57 | |
| *** jpich has quit IRC | 09:57 | |
| *** jpich has joined #storyboard | 09:58 | |
| *** udesale has quit IRC | 10:00 | |
| *** udesale has joined #storyboard | 10:00 | |
| *** Zara has quit IRC | 10:44 | |
| *** Zara has joined #storyboard | 11:05 | |
| *** udesale has quit IRC | 11:39 | |
| *** whoami-rajat has joined #storyboard | 12:14 | |
| *** zbr is now known as zbr|ruck | 12:53 | |
| *** udesale has joined #storyboard | 13:58 | |
| *** jamesmcarthur has joined #storyboard | 14:58 | |
| *** jpich has quit IRC | 15:12 | |
| *** jpich has joined #storyboard | 15:13 | |
| *** jamesmcarthur has quit IRC | 15:56 | |
| *** jpich has quit IRC | 16:29 | |
| *** diablo_rojo has joined #storyboard | 16:30 | |
| *** whoami-rajat has quit IRC | 16:44 | |
| *** whoami-rajat has joined #storyboard | 17:02 | |
| *** udesale has quit IRC | 17:07 | |
| *** tosky has quit IRC | 18:41 | |
| *** diablo_rojo has quit IRC | 19:12 | |
| *** diablo_rojo has joined #storyboard | 19:13 | |
| *** jtomasek has quit IRC | 19:22 | |
| *** whoami-rajat has quit IRC | 19:34 | |
| *** armstrong has joined #storyboard | 19:56 | |
| armstrong | Hello | 19:58 |
|---|---|---|
| fungi | hello armstrong! | 19:59 |
| armstrong | is there a way, to extract all project bugs from storyboard | 19:59 |
| armstrong | Using command line | 20:00 |
| armstrong | ? | 20:01 |
| fungi | armstrong: there is a storyboard python library, though i think it lacks a command-line wrapper: https://opendev.org/opendev/python-storyboardclient | 20:05 |
| fungi | ahh, yeah, its documentation confirms as much: https://docs.openstack.org/infra/python-storyboardclient/ | 20:06 |
| fungi | there are usage examples for it in the documentation though | 20:07 |
| fungi | or you could just query the storyboard rest api directly. that's documented at | 20:09 |
| fungi | https://docs.openstack.org/infra/storyboard/webapi/v1.html | 20:09 |
| fungi | this method can retrieve tasks by project_id or project_group_id (all projects in a specific project team) | 20:11 |
| fungi | https://docs.openstack.org/infra/storyboard/webapi/v1.html#get--v1-tasks-search | 20:11 |
| armstrong | Ok great! | 20:12 |
| armstrong | I appreciate @fungi | 20:12 |
| fungi | you need to be aware of storyboard's data model though... a task is associated with one project, but a story can contain multiple tasks for different projects | 20:12 |
| armstrong | Oh I see | 20:13 |
| fungi | oh, though this method claims to resolve that directly if you need: https://docs.openstack.org/infra/storyboard/webapi/v1.html#get--v1-stories-search | 20:13 |
| fungi | looks like you can use that to query for stories which have at least one task associated with a particular project or project group | 20:14 |
| fungi | so maybe that's sufficient | 20:15 |
| fungi | anyway, you can likely do the same with python-storyboardclient | 20:16 |
| fungi | you'll want to create an access token by going to https://storyboard.openstack.org/#!/profile/tokens and hitting the "issue token" button | 20:17 |
| fungi | (you can also get to that page from the user drop-down at the top-right of the webclient) | 20:18 |
| armstrong | I noticed the API requires a user token, how do I obtain this? | 20:19 |
| fungi | that's what i was just describing | 20:24 |
| fungi | it gets called a few things in different places... access token, authentication token, user token | 20:24 |
| fungi | all the same thing | 20:25 |
| armstrong | Ok | 20:27 |
| *** gouthamr_ is now known as gouthamr | 21:16 | |
| *** ianychoi_ has joined #storyboard | 21:19 | |
| *** ianychoi has quit IRC | 21:22 | |
| *** ianychoi_ has quit IRC | 21:30 | |
| *** ianychoi_ has joined #storyboard | 21:31 | |
| fungi | SotK: per discussion in #openstack-infra creation of a new story on storyboard.openstack.org with two or more initial tasks seems to result in "500: POST /api/v1/tasks: This session is in 'inactive' state, due to the SQL transaction being rolled back; no further SQL can be emitted within this transaction." | 22:06 |
| fungi | apparently creating with only one initial task and then adding more tasks later works | 22:06 |
| fungi | is this the same problem https://review.opendev.org/650614 was trying to address? | 22:07 |
| SotK | Sounds like a new problem, probably introduced by that patch | 22:10 |
| fungi | i wonder if retries don't actually work due to transaction rollback? | 22:11 |
| SotK | Yeah that could well be the case | 22:20 |
| SotK | We should probably just look at rewriting the problematic function I think | 22:20 |
| SotK | I keep meaning to write a script to fill my test instance with a load of stories so I can reproduce it | 22:20 |
| fungi | SotK: one of the outreachy intern candidates mentioned having used http://filldb.info/ to populate a local sb deployment with a configurable amount of appropriate data | 22:23 |
| fungi | you just dump in the db schema and set a few tuning parameters | 22:24 |
| SotK | Oh that looks promising | 22:24 |
| fungi | they claimed it "just worked" for them | 22:25 |
| SotK | Thanks, I'll experiment with it when I get the time | 22:25 |
| fungi | SotK: this is the pecan/sqla traceback from the InvalidRequestError: http://paste.openstack.org/show/753329/ | 22:49 |
| fungi | it definitely passed right through the function 650614 decorated for retries | 22:51 |
| fungi | so seems like a pretty safe bet | 22:51 |
| fungi | same user is also failing to be able to create a worklist, and this is the corresponding traceback in the apache error log: http://paste.openstack.org/show/753330/ | 23:06 |
| *** ianw_pto is now known as ianw | 23:08 | |
| fungi | looks like that may be fallout from the team ownership work? | 23:08 |
| fungi | corresponding line there is "event_team_owners = [{id: teams_api.team_get(id).name} | 23:08 |
| fungi | er | 23:08 |
| fungi | corresponding line there is "event_team_owners = [{id: teams_api.team_get(id).name} for id in owners]" | 23:08 |
| fungi | so the teams_api.team_get(id) is apparently returning None and we're failing to check for that before trying to access its name | 23:09 |
| openstackgerrit | Jeremy Stanley proposed opendev/storyboard master: Guard for nonexistent team in worklist creation https://review.opendev.org/667248 | 23:21 |
| fungi | SotK: ^ that's my best guess | 23:21 |
| *** cloudnull has joined #storyboard | 23:26 | |
| fungi | cloudnull here is the one who found our two latest exceptions | 23:27 |
| cloudnull | o/ | 23:27 |
| diablo_rojo | cloudnull, hola | 23:27 |
| * diablo_rojo was reading scrollback in infra | 23:27 | |
| fungi | for the orm error where it looks like we're retrying in an inactive session because the initial try had its transaction rolled back, i expect we just need to reopen one of the several stories we had about that | 23:29 |
| fungi | well, about the multiple task creation deadlock which led to adding that retry decorator anyway | 23:29 |
| diablo_rojo | fungi, you want to reopen it/make another? | 23:33 |
| fungi | i don't want to make yet another story about that problem in case we end up reverting the fix | 23:35 |
| diablo_rojo | Thats fair | 23:35 |
| fungi | probably best we reopen the one whose task was linked from that retry decorator change | 23:36 |
| diablo_rojo | Maybe I'll just add mention to the meeting agenda for tomorrow | 23:36 |
| diablo_rojo | err wednesday | 23:36 |
| SotK | Looks like we're using the wrong variable in those team-related dictionary comprehensions | 23:36 |
| SotK | Should be team_owners and team_users for the team ones | 23:37 |
| SotK | I don't know how I didn't catch that | 23:37 |
| SotK | I guess my test instance must've had conveniently overlapping IDs every time I tried | 23:38 |
| diablo_rojo | It's alright. Stuff happens. | 23:38 |
| fungi | i've set the task for https://storyboard.openstack.org/#!/story/2000983 back to todo and included the new traceback from the resulting inactive session | 23:40 |
| fungi | SotK: should i just change the variable in 667248? | 23:41 |
| fungi | (and drop the conditionals) | 23:41 |
| SotK | Yeah :) | 23:42 |
| SotK | Thanks for patching! | 23:42 |
| * SotK goes to sleep | 23:43 | |
| openstackgerrit | Jeremy Stanley proposed opendev/storyboard master: Correct team iterator lists in worklist creation https://review.opendev.org/667248 | 23:44 |
| fungi | there we go ^ | 23:44 |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!