Studio hangs on DB update until I restart the website

[boyanov]

Quick summary

I use one website and some plugins, Loco specifically. When I update a translation, the website hangs and will not respond until I do STOP & START from the Studio UI. Also, the procession starts to run at 10-15% all the time - I see this in Process Explorer.

I noticed that the Loco will save the PO file but not the MO file, so it might not be a DB issue.

THIS IS NOT a Loco bug; it does not happen on any other instance that is not on Studio.

Steps to reproduce

1. I have a website and installed some plugins, Loco specifically.
2. I have a dozen strings already translated, and it has worked before.

What you expected to happen

When I edit a string and want to save it, it should complete the operation successfully.

What actually happened

When I edit a string and want to save it, it hangs.

Impact

One

Available workarounds?

No and the app is unusable

Platform

Windows

Logs or notes

I have no way of looking at any logs to provide you with other info,

[boyanov]

Screenshots from Process Explorer:

[wojtekn]

@boyanov thanks for reporting the issue. I've checked it on Mac, and couldn't reproduce it. We will check it on Windows.

[stephanethomas]

Hi @boyanov! I tried to reproduce it on Windows to no avail. If possible, would you be able to provide us with a Jetpack backup of your site (or any random/test site that only has the Loco plugin and where you noticed the same issue) that we could import in Studio?

[boyanov]

@stephanethomas, I will create a local site and provide you with a backup.

Please note that the issue appears after you have a larger number of strings to translate - like 20 or more.

Is there a way to look at any logs where I could spot the root cause of the issue?

Also, how do I provide you with the backup file, an attachment here?

[boyanov]

After many experiments, I can say that it is related to the number of Loco entries per plugin. Is it related to the use of SQLite? I don't know, but certainly, when I have 14 Loco entries, the bug starts to show up.

Running a copy from export/import allows you to reproduce it every time.

What is frustrating is that I don't have a way to look at logs to see what might cause the issue.

[Robertght]

@boyanov Feel free to share the Jetpack Backup through a Google Drive link with a "Anyone with a link" sharing option enabled.

I also tested this on my end and updated about 20+ strings and I couldn't see any issues in the process.