Skip to content

Investigate database deadlock inserting ratelimits #4530

@chronark

Description

@chronark

Grafana alerted on a database error when inserting into the ratelimits table.

Error snippet:

database failed to insert ratelimits: Error 1213 (40001): target: unkey.-.primary: vttablet: Deadlock found when trying to get lock; try restarting transaction (errno 1213) (sqlstate 40001)

This happens on an INSERT ... ON DUPLICATE KEY UPDATE into ratelimits with multiple value tuples.

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions