Transaction in use error when creating role

[Flo4604]

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 randomly got this error when creating a role

{"error":{"code":"INTERNAL_SERVER_ERROR","docs":"https://unkey.dev/docs/api-reference/errors/code/INTERNAL_SERVER_ERROR","message":"target: unkey.-.primary: vttablet: rpc error: code = Aborted desc = transaction 1727848515790095014: in use: for query (CallerID: kzr01kdt6cz27x485f8p)","requestId":"req_2xEK1qBBAYjecN8sMJr7fHbKuajZ"}

Steps to Reproduce

1. Try to create a role via API Example code of what I did when creating the role:

roles := []string{"admin", "account"}
for _, role := range roles {
    _, err := s.unkey.Permissions.CreateRole(ctx, operations.CreateRoleRequestBody{
    	Name: role,
    })
    
    if err != nil {
    	log.Printf("Error creating role %s", err)
    }
}

Expected behavior

To not get an error

Other information

No response

Screenshots

No response

Version info

-

[linear]

ENG-1370 Transaction in use error when creating role

[chronark]

This is flaky, right?
Not consistently reproducible?

[chronark]

/award 150 points

[oss-gg]

Awarding Flo4604: 150 points 🕹️ Well done! Check out your new contribution on oss.gg/Flo4604

[RajuGangitla]

/assign

[oss-gg]

Assigned to @RajuGangitla! Please open a draft PR linking this issue within 48h ⚠️ If we can't detect a PR from you linking this issue in 48h, you'll be unassigned automatically 🕹️ Excited to have you ship this 🚀

[Flo4604]

This is flaky, right? Not consistently reproducible?

yup, its randomly happening, ill try to find something how its 100% repro

[chronark]

That'd be great, we can award more points if you can reliably reproduce it, or at least get us closer to the root cause

[KekmaTime]

/assign

[oss-gg]

Assigned to @KekmaTime! Please open a draft PR linking this issue within 48h ⚠️ If we can't detect a PR from you linking this issue in 48h, you'll be unassigned automatically 🕹️ Excited to have you ship this 🚀

[oss-gg]

@RajuGangitla, Just a little reminder: Please open a draft PR linking this issue within 12 hours. If we can't detect a PR in 12h, you will be unassigned automatically.

[Flo4604]

/assign

[oss-gg]

This issue is already assigned to another person. Please find more issues here.

[Flo4604]

/assign

[oss-gg]

Assigned to @Flo4604! Please open a draft PR linking this issue within 48h ⚠️ If we can't detect a PR from you linking this issue in 48h, you'll be unassigned automatically 🕹️ Excited to have you ship this 🚀

[oss-gg]

@KekmaTime, Just a little reminder: Please open a draft PR linking this issue within 12 hours. If we can't detect a PR in 12h, you will be unassigned automatically.

[oss-gg]

@RajuGangitla, Just a little reminder: Please open a draft PR linking this issue within 12 hours. If we can't detect a PR in 12h, you will be unassigned automatically.

[oss-gg]

@KekmaTime, Just a little reminder: Please open a draft PR linking this issue within 12 hours. If we can't detect a PR in 12h, you will be unassigned automatically.

[HimanshuGarg5480]

/assign

[oss-gg]

This issue is already assigned to another person. Please find more issues here.

[Flo4604]

/assign

there is already a pr open for this