cobalt hare
I'm upgrading an existing site and I try to remove a composition link from one of the document types in Umbraco 10.
Short while later it gives back with a timeout exception.
I researched on this error and attempted to apply Connection Timeout to the connection string and again tried a few times and this didn't resolve. Logs state the exact same message.
Is there anything else I can try?
wheat fossil
Yea thats annoying 😦
I ran into the same issue last week, and I just pulled the DB locally, upgraded it, restored it online
Is your site by any chance behind Cloudflare? I also had issue with getting a db upgraded when behind cloudflare, however on the backend it actually still was upgrading (however the frontend would fail)
cobalt hare
Is your site by any chance behind Cloudflare? I also had issue with getting a d...
I don't believe so but I'll double check. Thanks for your input!
cobalt hare
Copying the database locally didn't resolve the issue..... Anything else to see what the issue could be?
In addition I noticed the UmbracoLock take is being queried. When I try to open this table in SSMS it been stuck on trying to load the first 1000 records (default setting when opening up a table)..... Wondering if this table is the problem?
river knoll
How did you update the connection string?
cobalt hare
How did you update the connection string?
In the appsettings.json file. I added Connection Timeout=0 to Umbracodbdsn (at the end).
I noticed when opening up the UmbracoLock table it took around 15 minutes so I think this may be something to look into? Using the latest version of Umbraco 10
river knoll
Could be that there's a read lock on the table, or there's somehting really wrong with your database. You can enable query store on your database to see what the slow and or resource consuming queries are. You can do this by right clicking your database, click options, click "Query store" on the left, and change the "Operation Mode" to "Read Write".
Then make sure you remove the composition so that the slow queries are running, afterwards you can check your query store. This is a new node underneath your database, open it and double click "Top resource consuming queries"
cobalt hare
Then make sure you remove the composition so that the slow queries are running, ...
How would I remove the composition? I see all the other menus? Thx
FYI I don't see anything listed under the Umbraco lock table> constraints