Products

Solutions

Learn More

Partners

Community

Blog

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Server blocked by excessive calls to DNN_GetFolderPermissionsByPortalAndPathServer blocked by excessive calls to DNN_GetFolderPermissionsByPortalAndPath
Previous
 
Next
New Post
6/6/2019 8:32 AM
 

I want to manually delete entries in the DNN_Folders table that point to non-existent filestore and am looking for a reality-check before I do so. Here is why I want to do it:

I had an issue that on SOME portals, any attempt to access HTML Editor config, or to use the Browse Server functionality via inserting link in the HTML Editor results in a non-responsive thread and every portal stops responding.  I switched from the old CK Editor Provider to the new DNN Connect versions and this changed the character of the issue - instead of w3wp.exe spinning forever it is now SQL Server that runs constantly at 25% CPU.

I ran an SQL Trace and discovered the issue is caused by thousand upon thousand of calls to DNN_GetFolderPermissionsByPortalAndPath, and the parameter for each include a path that does not exist in the portal in question (e.g. exec sp_executesql N';Exec dbo.DNN_GetFolderPermissionsByPortalAndPath @0, @1',N'@0 int,@1 nvarchar(4000)',@0=47,@1=N'Users/116/48/37748/') - and portals/47/users/116 does NOT exist on disc

I think the root cause might be that a couple of years ago I suffered a spam registration attack and ended up with an apparent user base of over a quarter of a million users. After closing the hole that was allowing the spam bots in, I manually deleted most of the user accounts from the DNN_Users table (yes, yes, I know I shouldn't have done that now!). I subsequently deleted all the underlying empty folders in the portals/users folders for the affected portals.

So that brings us up to date, and now I see the problem I reported above only in those portals where the spam attacks occurred, and only tracing non-existent folders - this leads me to believe the iterative calls are being driven by entries in the DNN_Folders table - where those non-existent folders DO still exist.

My suspicion is that if I write a procedure to scan the DNN Folders table, and delete all entries where the nominated folders does NOT exist in the underlying filestore, my latest problem MAY be fixed. I am aware the DNN_Folders table contains a heirarchy (ie each entry has a parentid) and I shall have to be careful to delete from the bottom up, as it were.

Obviously I will test this on a restored backup first, but if anyone out there has any further insights or advice I would be most grateful to receive it. 

TIA

Steve

 

 
New Post
6/7/2019 9:55 AM
 

Absent any replies to this I thought I'd report my findings. Having written the procedures I outlined above, I deleted all rows in the Folders table that referenced non-existent folders on disc. The site now responds instantaneously to clicks on the browser server button via the HTML editor.  This is still running on a test site only ATM. I might make a full backup of the production Folders table before running the procedures there, so if I hit faults I can resurrect the table contents, rather then having to roll back to an old, full-site backup. I wonder how long it will be before I get up nerve to apply this to production!

 

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Server blocked by excessive calls to DNN_GetFolderPermissionsByPortalAndPathServer blocked by excessive calls to DNN_GetFolderPermissionsByPortalAndPath


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out