Skip to content

Deadlocks inserting into host_certificate_sources #34116

@getvictor

Description

@getvictor

Fleet version:
4.74.0 (assuming released)


💥  Actual behavior

In loadtest startup, seeing ~20% failure rate on this SQL statement:

Image
Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

🛠️ To fix

Try to eliminate/reduce deadlocks.

Product designer: _________________________

🧑‍💻  Steps to reproduce

  1. Spin up Jorge's new loadtest with 20K+ hosts at once and watch for errors.

🕯️ More info (optional)

N/A

QA

Since this is an issue that only happens at loadtest startup and may not be impacting any customers, simply monitor loadtest startup for these errors.

Metadata

Metadata

Assignees

Labels

#g-security-complianceSecurity & Compliance product groupbugSomething isn't working as documented~released bugThis bug was found in a stable release.

Type

No type

Projects

Status

✔️Awaiting QA

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions