https://github.com/osquery/osquery logo
Title
r

Ryan

06/15/2020, 3:33 PM
Hi everyone! I have a question about labels in Fleet I hope someone can help? We have custom metadata that helps identify our hosts for the team using them, the environment they belong to and so on, the result is we have maybe 150 labels, all along the lines of 
SELECT 1 FROM custom_metadata WHERE team = "Team name"
 for each team name in use. This was working fine, but today we noticed that the labels were failing to load in the Fleet sidebar. The request to 
/api/v1/kolide/labels
 times out. The equivalent request
fleetctl get labels
was working, but taking several seconds. Are we creating too many labels here perhaps? Is there a better way to accomplish this instead?
If I try to reproduce it via curl:
time curl -H "Authorization: Bearer <redacted>>" https://<fqdn>:8080/api/v1/kolide/labels > test.json
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:--  0:00:40 --:--:--     0
curl: (92) HTTP/2 stream 1 was not closed cleanly: INTERNAL_ERROR (err 2)
real    0m40.024s
Via fleetctl works, but takes a couple of seconds:
time fleetctl get labels
<output of all labels - 178 results>
real    0m2.370s
Update: this seems to be working properly today 🤔 Not sure what’s going on 😄
z

zwass

06/16/2020, 3:36 PM
That is... quite strange. There are some major changes to Fleet upcoming that will effect all the performance, so let's (1) keep an eye on this and (2) see whether those changes resolve any issues that persist.
r

Ryan

06/16/2020, 3:46 PM
Sounds good! is there a roadmap I can look at for what’s coming?
z

zwass

06/16/2020, 3:52 PM
There's no formal roadmap. Fleet development mostly depends on what I can get funding for, things that catch my attention, or high priority bugs.
r

Ryan

06/16/2020, 4:44 PM
Ok cool, well I’m happy to help any way I can.