deadlock detected DETAIL: Process 53 waits for ShareLock on transaction

[tomkolp]

Describe the issue

Since version 5.10-0e03b03f41 , there is a problem with slow writing of strings. I get a lot of errors with the errors below. The errors should still be sent to sentry, so they can be analyzed.

deadlock detected
DETAIL:  Process 53 waits for ShareLock on transaction 9436782; blocked by process 48.
Process 48 waits for ShareLock on transaction 9436777; blocked by process 53.
HINT:  See server log for query details.
CONTEXT:  while locking tuple (88,104) in relation "trans_translation"

I already tried

• I've read and searched the documentation.
• I've searched for similar filed issues in this repository.

Steps to reproduce the behavior

Save translate.

Expected behavior

No response

Screenshots

No response

Exception traceback

How do you run Weblate?

Docker container

Weblate versions

Wersja Weblate 5.10-dev — 4490b12889d398c0989882dd14020c7bf0e6ca12

Weblate deploy checks

Additional context

No response

[nijel]

Do you know at which version was the last one before these errors appeared? I'm not aware of any recent change which could have caused that. Furthermore, when do you get these errors?

I've just realized that you were using the old Sentry server which we discarded a few months ago, so unfortunately we don't have these errors recorded…

[nijel]

#13632 should improve the situation if you observe this on uploading.

[tomkolp]

I have uploaded the patch, after several hours of testing I have not received any errors via email.

Unfortunately, translation approvals are still very slow.

Can I get a new sentry address to send logs? If that is not possible, I will switch to my free sentry account and try to analyze it myself.
Edit:
However, the errors returned:
deadlock detected
DETAIL: Process 149 waits for ShareLock on transaction 9586553; blocked by process 599.
Process 599 waits for ShareLock on transaction 9586546; blocked by process 149.
HINT: See server log for query details.
CONTEXT: while locking tuple (63295,47) in relation "trans_unit"

[tomkolp]

https://eso-spolszczenie.sentry.io/share/issue/1af14cf66308447a8288977b008e4388/

[nijel]

The Sentry invitation didn't work:

Can you please try resending it to [email protected]?

[tomkolp]

The Sentry invitation didn't work:

Can you please try resending it to [email protected]?

I sent it

[tomkolp]

The last patch fixed the slow string saving issue.

Were you able to log into sentry? If so, I'll leave access for future bug analyses.

[nijel]

It again failed with the same error message. But looking inside Sentry, I got access to the project, so it did work in the end. I will keep an eye on the performance metrics there as your setup is quite specific.

Looking at the trace, this issue should be addressed by #13665.

[github-actions]

Thank you for your report; the issue you have reported has just been fixed.

• In case you see a problem with the fix, please comment on this issue.
• In case you see a similar problem, please open a separate issue.
• If you are happy with the outcome, don’t hesitate to support Weblate by making a donation.