U8 Umbraco locks database on document type save

Questions
1

Hey there,

We have a Umbraco v8 project that has been giving us some trouble.

Whenever we perform a save on a document type that is widely used across our Umbraco, it fails and we cannot perform anything in the backoffice.
We noticed that are queries blocking any other from being run and once we “kill” them, it all comes back to normal - until it happens again.

One of those blocking queries is this one:

This image shows dense code from a database query, likely used for extracting versioned data from an Umbraco property. (Captioned by AI)
This image shows dense code from a database query, likely used for extracting versioned data from an Umbraco property. (Captioned by AI)1920×566 296 KB

Another blocking query is this one:
(@0 int)SELECT value FROM umbracoLock WITH (REPEATABLEREAD) WHERE id=@0

Has anyone come across any similar with this?

Thanks

2

You know that Umbraco 8 is end of life and doesn’t get any updates anymore, right? Just checking :slight_smile: But are you at least on the latest version of 8?

1 Like
3

Thanks Luuk.

Yes, we are quite aware of the EOL status of umbraco v8. Unfortunately, we don’t have the client’s permission to upgrade it to v9 and we won’t have until this issue is fixed.

And yes, we are running the latest version of v8 :slight_smile:

4

From the query it looks like you might have a lot of versions for each node, I can recommend this package to help clean them up:
https://our.umbraco.com/packages/website-utilities/unversion/

If you’re a bit more daring (take backups!!) then raw SQL queries could help as well, I haven’t tested any of these so please be careful: