Timeout exceptions in Umbraco 10
# help-with-umbracot
Terminator
08/22/2023, 1:23 PMI'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?
a
Ambert
08/22/2023, 2:29 PMYea thats annoying 😦
Ambert
08/22/2023, 2:30 PMI ran into the same issue last week, and I just pulled the DB locally, upgraded it, restored it online
Ambert
08/22/2023, 2:31 PMIs 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)
t
Terminator
08/22/2023, 3:01 PMI don't believe so but I'll double check. Thanks for your input!
Terminator
08/23/2023, 8:03 AMCopying the database locally didn't resolve the issue..... Anything else to see what the issue could be?
Terminator
08/23/2023, 8:12 AMIn 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?
m
Maarten
08/23/2023, 11:32 AMHow did you update the connection string?
t
Terminator
08/23/2023, 12:14 PMIn 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
m
Maarten
08/23/2023, 12:16 PMCould 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".
Maarten
08/23/2023, 12:17 PMThen 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"
Maarten
08/23/2023, 12:17 PMt
Terminator
08/23/2023, 1:26 PMHow would I remove the composition? I see all the other menus? Thx
Terminator
08/23/2023, 1:31 PMFYI I don't see anything listed under the Umbraco lock table> constraints
Terminator
08/24/2023, 1:11 PMIs there anything else I could try?
5 Views