Thought I'd give an update on my experience with this issue.
I have tried the no-cache route, that seems to always just peg the SQL cpu's to 100%.
However, after noticing some event log issues (and the fact SQL always times out trying to get into it ), I truncated the EventLog table, made sure that all the event log 'max' records we're reasonable, and restarted the app.
Within seconds the event log General Exception buffers we're filled (500 entries), so it looks like this is a constant issue. However, i am getting a different but similar error now.
DNN 4.8.0
AssemblyVersion: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider:
ExceptionGUID:
InnerException: An item with the same key has already been added.
FileName:
FileLineNumber: -1
FileColumnNumber: -1
Method:
StackTrace:
Message: System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at DotNetNuke.Services.FileSystem.FolderController.FillFolderInfoDictionary(IDataReader dr)
Source:
This happens constantly, and it keeps the SQL and App pools churning.. as the limit is always hit, and it's constanlty being deleted and refreshed with new errors.
This is on a production server with fairly light traffic (perhaps 1-2k visitors a day), it's becoming quite a chore to not know how to alieviate this issue, and have the event log run like a ticker tape...
Any help would be appreciated