Skip to content

High DB load when conditional access is turned on #35333

@rfairburn

Description

@rfairburn

Fleet version: v4.75.1

Web browser and operating system:


💥  Actual behavior

High DB Load when conditional access is turned on due to an error message like the following:

{"err":"failed to load the integration: getting microsoft_compliance_partner_integrations: context canceled","host_id":<id>,"level":"error","msg":"load conditional access configured and enabled, skipping ingestion","ts":"2025-11-07T01:20:35.312403145Z"}

https://github.com/fleetdm/fleet/blob/main/server/service/osquery.go#L2410-L2451 looks to call ds.Team() which gets the count as part of what it does in teamDB().

Here is what the db usage showed that lead to looking at teamDB():

Image

🛠️ To fix

🧑‍💻  Steps to reproduce

  1. TODO
  2. TODO

🕯️ More info (optional)

N/A

Metadata

Metadata

Assignees

Labels

#g-orchestrationOrchestration product group:releaseReady to write code. Scheduled in a release. See "Making changes" in handbook.bugSomething isn't working as documentedcustomer-numa~released bugThis bug was found in a stable release.

Type

No type

Projects

Status

Done

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions