Transaction Deadlock

[chronark]

Preliminary Checks

• I have reviewed the documentation: https://unkey.com/docs

• I have searched for existing issues: https://github.com/unkeyed/unkey/issues

• This issue is not a question, general help request, or anything other than a bug report directly related to Unkey. Please ask questions in our Discord community: https://unkey.com/discord.

Reproduction / Replay Link (Optional)

No response

Issue Summary

I just saw this failure in our CI tests

We need to check out why this happens and fix it

https://github.com/unkeyed/unkey/actions/runs/10475239709/job/29012452407

FAIL  src/routes/v1_identities_listIdentities.happy.test.ts > returns ratelimits
DatabaseError: target: unkey.-.primary: vttablet: rpc error: code = Aborted desc = Deadlock found when trying to get lock; try restarting transaction (errno 1213) (sqlstate 40001) (CallerID: ***): Sql: "insert into ratelimits(id, `name`, workspace_id, created_at, updated_at, key_id, identity_id, `limit`, duration) values (:vtg1 /* VARCHAR */, :vtg2 /* VARCHAR */, :vtg3 /* VARCHAR */, :vtg4 /* INT64 */, :vtg5 /* INT64 */, default, :vtg6 /* VARCHAR */, :vtg7 /* INT64 */, :vtg8 /* INT64 */)", BindVars: {REDACTED}

Steps to Reproduce

Not sure yet

Expected behavior

it does not throw up

Other information

No response

Screenshots

No response

Version info

- OS:
- Node:
- npm:

[linear]

ENG-1303 Transaction Deadlock