GoDaddy upgraded their plesk servers and my canary in a coal mine site is having major problems. The site goes down with the this error message:
System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'dbo.EventLog'.'PK_EventLogMaster' in database 'Database Name' because the 'PRIMARY' filegroup is full.
My schedulehistory log has over 35000 items.
I'm on DNN 8.04 with some Mandeeps Live extensions.
I tried delete from eventlog
I was able to get the site back up after that, and I found and installed the ScheduleHistory extension from IowaGurus. (Thanks for that!) I was able to run the items, but it didn't delete the schedulehistory log items.
I went into the scheduler and changed everything to one week for pinging, etc. to try to buy some time.
I went into the event viewer and got the following errors all with saying that access to that file is denied? But according to my permissions, everything has full read/write access to that directory and subdirectories?
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:bf627dec-a6d0-4d44-9296-e795f7d41675
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:nClUreaxfbMenNWYa78Rcg==
Message:Access to the path 'G:\PleskVhosts\onesexyscooter.com\httpdocs\App_Data\Search\segments_159r8' is denied.
StackTrace:
at Lucene.Net.Store.SimpleFSDirectory.OpenInput(String name, Int32 bufferSize) at Lucene.Net.Store.FSDirectory.OpenInput(String name) at Lucene.Net.Index.SegmentInfos.Read(Directory directory, String segmentFileName) at Lucene.Net.Index.SegmentInfos.AnonymousClassFindSegmentsFile.DoBody(String segmentFileName) at Lucene.Net.Index.SegmentInfos.FindSegmentsFile.Run(IndexCommit commit) at Lucene.Net.Index.SegmentInfos.Read(Directory directory) at Lucene.Net.Index.IndexWriter.Init(Directory d, Analyzer a, Boolean create, IndexDeletionPolicy deletionPolicy, Int32 maxFieldLength, IndexingChain indexingChain, IndexCommit commit) at Lucene.Net.Index.IndexWriter..ctor(Directory d, Analyzer a, MaxFieldLength mfl) at DotNetNuke.Services.Search.Internals.LuceneControllerImpl.get_Writer() at DotNetNuke.Services.Search.Internals.LuceneControllerImpl.Delete(Query query) at DotNetNuke.Services.Search.Internals.InternalSearchControllerImpl.DeleteSearchDocumentInternal(SearchDocument searchDocument, Boolean autoCommit) at DotNetNuke.Services.Search.Internals.InternalSearchControllerImpl.DeleteSearchDocument(SearchDocument searchDocument) at DotNetNuke.Services.Search.SearchEngine.DeleteRemovedObjects() at DotNetNuke.Services.Search.SearchEngineScheduler.DoWork()
InnerMessage:
InnerStackTrace:
Source:Lucene.Net
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name:
--------------------------------------
I don't care about this site, but there are other sites that I work on that has vital information for the elderly in our communities. I'm afraid that this will happen to those sites when GoDaddy does their upgrade.
Thanks for any help.
Found this from Sebastian (very helpful)
If no search are displayed just after you installed DNN, you don’t need to worry – the search indexer needs a couple of minutes to build up. But if this happens, after you added quite some content, there might be several reasons:
If the search index got corrupted, you’ll have to delete and rebuild the search index tables manually.
DNN 7.1.0 and later is using Lucene.Net search engine, which stores its index in file system. To clear the index, remove all files inside /app_data/search. This folder is not accessible via the DNN file manager, you need to connect using FTP, WebDAV or RDP to delete the files.
---------------------------------------------------------------------
Now I just have to figure out how to delete the schedulehistory log?
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.