We have a problem that the sql server is working hard with SEO Checker. It seems that the SEOChecker_URLHistory have nodes that no longer exists in UmbracoNode and that is the source of the problem it seems
It tries to do alot of deletes in SEOCheckerPageNotFound, SEOCheckerRobots, SEOCheckerQueue, SEOCheckerValidationIssues
It seems to have stuck in a loop and makes 1500 deletes each loop... And does it over and over again.
I'm guessing we have caused the problem when moving from develop to deploy, and also made an update along the way.
Is there a way to fix the old data in the SEO tables?
Nodes in SEOChecker_URLHistory not in UmbracoNode
We have a problem that the sql server is working hard with SEO Checker. It seems that the SEOChecker_URLHistory have nodes that no longer exists in UmbracoNode and that is the source of the problem it seems
It tries to do alot of deletes in SEOCheckerPageNotFound, SEOCheckerRobots, SEOCheckerQueue, SEOCheckerValidationIssues
It seems to have stuck in a loop and makes 1500 deletes each loop... And does it over and over again.
I'm guessing we have caused the problem when moving from develop to deploy, and also made an update along the way.
Is there a way to fix the old data in the SEO tables?
Found this, and it seems to work
https://our.umbraco.org/forum/using-umbraco-and-getting-started/78689-umbraco-node-table-access
is working on a reply...