Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[🐛 Bug]: Deadlocks around alertfields #3159

Open
talboren opened this issue Jan 27, 2025 · 0 comments
Open

[🐛 Bug]: Deadlocks around alertfields #3159

talboren opened this issue Jan 27, 2025 · 0 comments
Labels
Bug Something isn't working

Comments

@talboren
Copy link
Member

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction')
[SQL: INSERT INTO alertfield (id, tenant_id, field_name, provider_id, provider_type) VALUES (%(id)s, %(tenant_id_m0)s, %(field_name_m0)s, %(provider_id_m0)s, %(provider_type_m0)s), (%(id_m1)s, %(tenant_id_m1)s, %(field_name_m1)s, %(provider_id_m1)s, %(provider_type_m1)s), (%(id_m2)s, %(tenant_id_m2)s, %(field_name_m2)s, %(provider_id_m2)s, %(provider_type_m2)s), (%(id_m3)s, %(tenant_id_m3)s, %(field_name_m3)s, %(provider_id_m3)s, %(provider_type_m3)s), (%(id_m4)s, %(tenant_id_m4)s, %(field_name_m4)s, %(provider_id_m4)s, %(provider_type_m4)s), (%(id_m5)s, %(tenant_id_m5)s, %(field_name_m5)s, %(provider_id_m5)s, %(provider_type_m5)s), (%(id_m6)s, %(tenant_id_m6)s, %(field_name_m6)s, %(provider_id_m6)s, %(provider_type_m6)s), (%(id_m7)s, %(tenant_id_m7)s, %(field_name_m7)s, %(provider_id_m7)s, %(provider_type_m7)s), (%(id_m8)s, %(tenant_id_m8)s, %(field_name_m8)s, %(provider_id_m8)s, %(provider_type_m8)s), (%(id_m9)s, %(tenant_id_m9)s, %(field_name_m9)s, %(provider_id_m9)s, %(provider_type_m9)s), (%(id_m10)s, %(tenant_id_m10)s, %(field_name_m10)s, %(provider_id_m10)s, %(provider_type_m10)s), (%(id_m11)s, %(tenant_id_m11)s, %(field_name_m11)s, %(provider_id_m11)s, %(provider_type_m11)s), (%(id_m12)s, %(tenant_id_m12)s, %(field_name_m12)s, %(provider_id_m12)s, %(provider_type_m12)s), (%(id_m13)s, %(tenant_id_m13)s, %(field_name_m13)s, %(provider_id_m13)s, %(provider_type_m13)s), (%(id_m14)s, %(tenant_id_m14)s, %(field_name_m14)s, %(provider_id_m14)s, %(provider_type_m14)s), (%(id_m15)s, %(tenant_id_m15)s, %(field_name_m15)s, %(provider_id_m15)s, %(provider_type_m15)s), (%(id_m16)s, %(tenant_id_m16)s, %(field_name_m16)s, %(provider_id_m16)s, %(provider_type_m16)s), (%(id_m17)s, %(tenant_id_m17)s, %(field_name_m17)s, %(provider_id_m17)s, %(provider_type_m17)s), (%(id_m18)s, %(tenant_id_m18)s, %(field_name_m18)s, %(provider_id_m18)s, %(provider_type_m18)s), (%(id_m19)s, %(tenant_id_m19)s, %(field_name_m19)s, %(provider_id_m19)s, %(provider_type_m19)s), (%(id_m20)s, %(tenant_id_m20)s, %(field_name_m20)s, %(provider_id_m20)s, %(provider_type_m20)s), (%(id_m21)s, %(tenant_id_m21)s, %(field_name_m21)s, %(provider_id_m21)s, %(provider_type_m21)s), (%(id_m22)s, %(tenant_id_m22)s, %(field_name_m22)s, %(provider_id_m22)s, %(provider_type_m22)s), (%(id_m23)s, %(tenant_id_m23)s, %(field_name_m23)s, %(provider_id_m23)s, %(provider_type_m23)s), (%(id_m24)s, %(tenant_id_m24)s, %(field_name_m24)s, %(provider_id_m24)s, %(provider_type_m24)s), (%(id_m25)s, %(tenant_id_m25)s, %(field_name_m25)s, %(provider_id_m25)s, %(provider_type_m25)s), (%(id_m26)s, %(tenant_id_m26)s, %(field_name_m26)s, %(provider_id_m26)s, %(provider_type_m26)s), (%(id_m27)s, %(tenant_id_m27)s, %(field_name_m27)s, %(provider_id_m27)s, %(provider_type_m27)s), (%(id_m28)s, %(tenant_id_m28)s, %(field_name_m28)s, %(provider_id_m28)s, %(provider_type_m28)s), (%(id_m29)s, %(tenant_id_m29)s, %(field_name_m29)s, %(provider_id_m29)s, %(provider_type_m29)s), (%(id_m30)s, %(tenant_id_m30)s, %(field_name_m30)s, %(provider_id_m30)s, %(provider_type_m30)s), (%(id_m31)s, %(tenant_id_m31)s, %(field_name_m31)s, %(provider_id_m31)s, %(provider_type_m31)s), (%(id_m32)s, %(tenant_id_m32)s, %(field_name_m32)s, %(provider_id_m32)s, %(provider_type_m32)s), (%(id_m33)s, %(tenant_id_m33)s, %(field_name_m33)s, %(provider_id_m33)s, %(provider_type_m33)s), (%(id_m34)s, %(tenant_id_m34)s, %(field_name_m34)s, %(provider_id_m34)s, %(provider_type_m34)s), (%(id_m35)s, %(tenant_id_m35)s, %(field_name_m35)s, %(provider_id_m35)s, %(provider_type_m35)s), (%(id_m36)s, %(tenant_id_m36)s, %(field_name_m36)s, %(provider_id_m36)s, %(provider_type_m36)s), (%(id_m37)s, %(tenant_id_m37)s, %(field_name_m37)s, %(provider_id_m37)s, %(provider_type_m37)s), (%(id_m38)s, %(tenant_id_m38)s, %(field_name_m38)s, %(provider_id_m38)s, %(provider_type_m38)s), (%(id_m39)s, %(tenant_id_m39)s, %(field_name_m39)s, %(provider_id_m39)s, %(provider_type_m39)s), (%(id_m40)s, %(tenant_id_m40)s, %(field_name_m40)s, %(provider_id_m40)s, %(provider_type_m40)s), (%(id_m41)s, %(tenant_id_m41)s, %(field_name_m41)s, %(provider_id_m41)s, %(provider_type_m41)s), (%(id_m42)s, %(tenant_id_m42)s, %(field_name_m42)s, %(provider_id_m42)s, %(provider_type_m42)s), (%(id_m43)s, %(tenant_id_m43)s, %(field_name_m43)s, %(provider_id_m43)s, %(provider_type_m43)s), (%(id_m44)s, %(tenant_id_m44)s, %(field_name_m44)s, %(provider_id_m44)s, %(provider_type_m44)s), (%(id_m45)s, %(tenant_id_m45)s, %(field_name_m45)s, %(provider_id_m45)s, %(provider_type_m45)s), (%(id_m46)s, %(tenant_id_m46)s, %(field_name_m46)s, %(provider_id_m46)s, %(provider_type_m46)s), (%(id_m47)s, %(tenant_id_m47)s, %(field_name_m47)s, %(provider_id_m47)s, %(provider_type_m47)s), (%(id_m48)s, %(tenant_id_m48)s, %(field_name_m48)s, %(provider_id_m48)s, %(provider_type_m48)s), (%(id_m49)s, %(tenant_id_m49)s, %(field_name_m49)s, %(provider_id_m49)s, %(provider_type_m49)s), (%(id_m50)s, %(tenant_id_m50)s, %(field_name_m50)s, %(provider_id_m50)s, %(provider_type_m50)s), (%(id_m51)s, %(tenant_id_m51)s, %(field_name_m51)s, %(provider_id_m51)s, %(provider_type_m51)s), (%(id_m52)s, %(tenant_id_m52)s, %(field_name_m52)s, %(provider_id_m52)s, %(provider_type_m52)s), (%(id_m53)s, %(tenant_id_m53)s, %(field_name_m53)s, %(provider_id_m53)s, %(provider_type_m53)s), (%(id_m54)s, %(tenant_id_m54)s, %(field_name_m54)s, %(provider_id_m54)s, %(provider_type_m54)s), (%(id_m55)s, %(tenant_id_m55)s, %(field_name_m55)s, %(provider_id_m55)s, %(provider_type_m55)s), (%(id_m56)s, %(tenant_id_m56)s, %(field_name_m56)s, %(provider_id_m56)s, %(provider_type_m56)s), (%(id_m57)s, %(tenant_id_m57)s, %(field_name_m57)s, %(provider_id_m57)s, %(provider_type_m57)s), (%(id_m58)s, %(tenant_id_m58)s, %(field_name_m58)s, %(provider_id_m58)s, %(provider_type_m58)s), (%(id_m59)s, %(tenant_id_m59)s, %(field_name_m59)s, %(provider_id_m59)s, %(provider_type_m59)s), (%(id_m60)s, %(tenant_id_m60)s, %(field_name_m60)s, %(provider_id_m60)s, %(provider_type_m60)s), (%(id_m61)s, %(tenant_id_m61)s, %(field_name_m61)s, %(provider_id_m61)s, %(provider_type_m61)s), (%(id_m62)s, %(tenant_id_m62)s, %(field_name_m62)s, %(provider_id_m62)s, %(provider_type_m62)s), (%(id_m63)s, %(te...truncated 4502 additional bytes fired for Cloud Run Revision with {configuration_name=keep-api, location=us-central1, project_id=keephq-sandbox, revision_name=keep-api-01167-trc, service_name=keep-api}.```
@dosubot dosubot bot added the Bug Something isn't working label Jan 27, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant