=== ilasc changed the topic of #launchpad to: Help contact: ilasc (06:00-15:00 UTC Mon-Fri) | Launchpad is an open source project: https://dev.launchpad.net/ | This channel is logged: http://irclogs.ubuntu.com/ | User Guide: https://help.launchpad.net/ | Support and spam reporting: https://answers.launchpad.net/launchpad
=== pieq_ is now known as pieq
=== cristiangsp changed the topic of #launchpad to: Help contact: cristiangsp (08:00-17:00 UTC Mon-Fri) | Launchpad is an open source project: https://dev.launchpad.net/ | This channel is logged: http://irclogs.ubuntu.com/ | User Guide: https://help.launchpad.net/ | Support and spam reporting: https://answers.launchpad.net/launchpad
[09:01] <marcustomlinson> hey guys, any idea why this minimal program: https://paste.ubuntu.com/p/kCxNCvHxhy/ would result in this exception: https://paste.ubuntu.com/p/vZNBP5PySf/ (this was working fine last week, but seemed to break over the weekend)
[09:02] <marcustomlinson> the troublesome line appears to be "if user in cla_members:"
[09:53] <marcustomlinson> cristiangsp: sorry I was meant to ping you about ^
[10:04] <cristiangsp> after doings some checks and also checking the oops it seems that the  "if user in cla_members:" is executing a query that ends up timing out
[10:09] <marcustomlinson> yeah something broke between last week and this
[10:13] <marcustomlinson> "for user in cla_members:" results in the same error
[10:15] <cristiangsp> yeah, I assume that the iterator tries to fetch all the users in the collection and that generates query that end ups timing out
[10:19] <cristiangsp> let me check with the team to see if there is any alternative path for this or there is something that changed recently
[10:21] <marcustomlinson> cristiangsp: thanks!
[11:59] <cristiangsp> <marcustomlinson> after checking with the team we do not see a specific reason why the query performed by the script should take that long. We will need further investigation, could you file a bug for it at Launchpad? Thanks!
[11:59] <marcustomlinson> cristiangsp: ok will do
[12:02] <cristiangsp> thanks!
[12:15] <cjwatson> But also the way in which you're doing that query is inherently inefficient at the moment and we'll probably want to work out some kind of recommendation for changing your code.  Not sure exactly what yet.
[23:08] <saiarcot895> Hi, in https://launchpad.net/~saiarcot895/+archive/ubuntu/flightgear-edge/+packages, the disk usage is readding 8.2 GB (above the quota of 8 GB), but I currently don't have enough in that PPA to have it be taking up that much space. I've deleted a large data package last week and it says "Removed from disk on 2021-03-26", but the download links are still there, implying it's not fully gone
[23:09] <saiarcot895> How long would it take for those files to get deleted?