Are there any cases where a 'deadlock detected (SQLSTATE 40P01)' error occurs?

[hyeyoung-leee]

Hi,

Can a deadlock error occur when simultaneously pushing multiple images to a project with storage quota?
unknown: ERROR: deadlock detected (SQLSTATE 40P01)

I have found the reason.
I want to limit the number of repositories per project, so I have added the code to the file.
/src/server/middleware/blob/put_manifest.go

This sometimes causes a deadlock between project_blob and quota_usage tables.
Can you help me fix this?

[MinerYang]

We do not support add repository limitations for projects, BTW, this is no relevant to either put_manifest or quota refresh.