My Prior PLESK backups were around 300 MB, consistently. Now they are 1.6GB. Host says it's due to database size, and exceptions.
Backup history: Before upgrade to 9.3.1 - Full site backup is 329MB
After upgrade to 9.3.1 and 3 months later, with very little changes to the site, no file uploads - Full site backup is 1.6GB Now, today after updating to 9.4.1 a few days ago, the database itself is 1.9GB
How do I get rid of all those exceptions in the log?
In Site Settings, ADMIN LOG, there were only 522 items listed, which I cleared.
When I visit /Admin/Site-Log -- it is blank. There is no log and there is no module to view/clear.
Thanks.
Over 1GB is in my dbo.Exceptions table. Something with Lucene.net which may be the search provider in DNN core?
How do I stop this from happening going forward?
at Lucene.Net.Util.BitVector.Get(Int32 bit) at Lucene.Net.Index.SegmentTermDocs.ReadNoTf(Int32[] docs, Int32[] freqs, Int32 length) at Lucene.Net.Index.SegmentTermDocs.Read(Int32[] docs, Int32[] freqs) at Lucene.Net.Search.TermScorer.NextDoc() at Lucene.Net.Search.ConstantScoreQuery.ConstantScorer.NextDoc() at Lucene.Net.Search.ConjunctionScorer..ctor(Similarity similarity, Scorer[] scorers) at Lucene.Net.Search.BooleanScorer2.CountingConjunctionSumScorer(List`1 requiredScorers) at Lucene.Net.Search.BooleanScorer2.MakeCountingSumScorerSomeReq() at Lucene.Net.Search.BooleanScorer2.MakeCountingSumScorer() at Lucene.Net.Search.BooleanScorer2..ctor(Similarity similarity, Int32 minNrShouldMatch, List`1 required, List`1 prohibited, List`1 optional) at Lucene.Net.Search.BooleanQuery.BooleanWeight.Scorer(IndexReader reader, Boolean scoreDocsInOrder, Boolean topScorer) at Lucene.Net.Index.DocumentsWriter.ApplyDeletes(IndexReader reader, Int32 docIDStart) at Lucene.Net.Index.DocumentsWriter.ApplyDeletes(SegmentInfos infos) at Lucene.Net.Index.IndexWriter.ApplyDeletes() at Lucene.Net.Index.IndexWriter.DoFlushInternal(Boolean flushDocStores, Boolean flushDeletes) at Lucene.Net.Index.IndexWriter.DoFlush(Boolean flushDocStores, Boolean flushDeletes) at Lucene.Net.Index.IndexWriter.PrepareCommit(IDictionary`2 commitUserData) at Lucene.Net.Index.IndexWriter.Commit(IDictionary`2 commitUserData) at DotNetNuke.Services.Search.Internals.LuceneControllerImpl.Commit() at DotNetNuke.Services.Search.Internals.InternalSearchControllerImpl.Commit() at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork()
For my personal tracking, I am re-indexing content per this post https://www.dnnsoftware.c...arch-not-working-721
Of note.... when I go to Settings...Site Log, even logged in as a host.. it is blank. Should there be a module there to view the site log? mydomain.com/Admin/Site-Log has no modules or content...
This github issue may relate
This one and this other one are two with Schedule History issues
Sabastian said this:
if you want to purge the schedule history, you should just execute TRUNCATE TABLE {databaseOwner}[{objectQualifier}EventLog] in BersonaBar > Settings > SQL console.
Purging Eventlog is a different task, and due to some changes in DNN 7.4, you may use my TruncateEventlog script (which does not require TurboScripts to be installed). My TurboScripts however try to provide better automated maintenance of the log tables, but require proper application of the scripts (and I am still working on the version for DNN 9.4.x)
https://github.com/dnnsof...Platform/issues/3205
Maybe this can help
Thanks --
Is there no Exceptions log viewer in DNN? Where I can clear the Exceptions log?
I logged in with SQL studio and ran "TRUNCATE TABLE [databasename].[dbo].[Exceptions]" and now the Exceptions table has 0 records.
__________________
To identify the table as culprit in SQL Studio... Right Click on the database, Hit Reports... Standard Reports...Disk Usage by Top Tables
Sort by size
_________________
My dbo.ScheduleHistory is also large.. but only 5mb. Is there a way to safely clear this within the DNN GUI? I hate clearing with scripts that could have unintended consequences...
https://github.com/dnnwer...runcateEventlog2.sql
This should do them all that are needed. Thanks Sebastian!
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.