Forums (Obsolete)

Member

hortvision - 4/26/2011 4:20:27 AM

Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

G'day,

I've been hunting through the forums and can't find anyone that has the same issue so have posted a new thread.

On CMS login I am getting the error below. I gather that everytime something is done on the site an event is logged? I also assume after looking carefully at the error that the event log is large and is preventing me logging in because it can't fit another event in the database. If I could login to the CMS I could clear the event log I think? But it won't let me.
I'm not sure how to increase the space on the server and am convinced that I still have plenty of space, I'm not sure how to clear out the database manually via ftp either.

Could you please make some suggestion on how to get in and then what I need to do to prevent a reoccurance of the problem?

Cheers

-------------------------------------------------------------------------------------------------------

[DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ([EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName], [EventUserAgent], [EventUrlReferrer] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName, @EventUserAgent, @EventUrlReferrer); SELECT SCOPE_IDENTITY() AS [EventID]: caused exception: Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database 'kentico_hortvision_com_au' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ([EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName], [EventUserAgent], [EventUrlReferrer] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName, @EventUserAgent, @EventUrlReferrer); SELECT SCOPE_IDENTITY() AS [EventID]: caused exception: Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database 'kentico_hortvision_com_au' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ([EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName], [EventUserAgent], [EventUrlReferrer] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName, @EventUserAgent, @EventUrlReferrer); SELECT SCOPE_IDENTITY() AS [EventID]: caused exception: Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database 'kentico_hortvision_com_au' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.]
CMS.DataProviderSQL.DataConnection.ExecuteNonQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +205
CMS.DataEngine.GeneralConnection.ExecuteNonQuery(QueryParameters query) +326
CMS.DataEngine.GeneralConnection.ExecuteNonQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) +105
CMS.DataEngine.GeneralConnection.ExecuteNonQuery(String queryName, Object[,] parameters) +21
CMS.DataEngine.SimpleDataClass.Insert(Boolean getId) +222
CMS.EventLog.EventLogProvider.LogEvent(String eventType, DateTime eventTime, String source, String eventCode, Int32 userId, String userName, Int32 nodeId, String documentName, String ipAddress, String eventDescription, Int32 siteId, String eventUrl) +990
CMS.SiteProvider.UserInfoProvider.AuthenticateUser(String userName, String password, String siteName, Boolean login) +871
CMS.SiteProvider.UserInfoProvider.AuthenticateUser(String userName, String password, String siteName) +11
CMS.MembershipProvider.CMSMembershipProvider.ValidateUser(String username, String password) +26
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +119
System.Web.UI.WebControls.Login.AttemptLogin() +115
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Kentico Developer

kentico_helenag - 4/26/2011 4:46:56 AM

RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

Hello,

I would recommend you deleting logs in the CMS_EventLog table and then decrease the value in Site manager -> Settings -> System -> Log size. You can set up what should be logged in the Event log by web.config parameters.

Best regards,
Helena Grulichova

Member

hortvision - 4/27/2011 3:48:57 AM

RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

Thanks Helena,

I need to be able to access the CMS to delete the logs in the CMS_Eventlog table don't I?

My ISP says that I have reached my 50mb database limit and I fear I won't be able to delete the logs with out paying for more so I can get in.

Is 50mb a sustainable size limit for a database?

cheers

Steve

Member

hortvision - 4/27/2011 5:47:00 AM

RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

Thanks Helena,

Managed to get my ISP to allow some breathing space so I could log on. Have cleaned out the event log and set it to 250 instead of the default 1,000. I also cleared the cache and the allocated memory and dropped the allocated memory stat seems to be ranging within 50mb, but only just. Any other tricks to being more frugal with memory? Its worth trying as my ISP wants to charge another AU$22/month for an extra 50mb (that's a lot).

I would like to modify the web.config file as per the link you provided but can't seem to locate the right one. is it in the root folder?

Do you have any other tricks for reducing the space required for this website. Is it worth deleting any of the sample sites I'm not using?

Cheers

Kentico Developer

kentico_helenag - 4/27/2011 1:42:16 PM

RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

Hi,

if you use workflow and do not need it, please remove the workflow. It will save a lot of database space. If you have some installed (sample) sites in your installation which you do not use, delete them. The file attachments can consume a lot of space. By the way, you can delete the records of CMS_EventLog table directly in the database.

The database size depends on current installation (and its sites). I would recommend you developing your site on a local machine where you can check the actual database size and decide the extra space need according to it. You can also consider different hosting where they can provide more DB space.

Best regards,
Helena Grulichova


Member	hortvision - 4/29/2011 10:18:32 PM Removing Workflow Thanks Helena, I'm currently attempting to work out how to access the database's directly. When you say 'remove the workflow', do you mean delete some files from the server? Thanks for all your help. Cheers


Kentico Developer	kentico_helenag - 5/2/2011 7:04:08 AM RE:Removing Workflow Hi, you configure the workflow in Site manager -> Development -> Workflows (documentation for workflows). By default, it is not configured. If you use workflow, it stores all the versions of documents in the database (the CMS_VersionHistory table). Best regards, Helena Grulichova


Member	aandrews-surveying - 11/29/2012 4:35:49 PM RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database Hi Helena, Has this changed in version 7? I don't see Log size under System. I have the same issue. The event log has eaten up everything on the drive and threatens to take over the entire west coast of the United States if I can't stop it. :P Help! :)


Kentico Consulting	kentico_borisp - 11/29/2012 9:43:20 PM RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database Hello, You can find this setting under System > General: The version history length can be configured in Versioning & Synchronization > Object versioning > Version history: Best regards, Boris Pocatko

Member

aandrews-surveying - 11/30/2012 4:19:46 PM

RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database

Thanks, Boris!

I found the Event Log after looking around.

I cleaned out the event log in SQL Server and then set the event log to 500 (as opposed to 1,000). We'll see how that works.

Is there a recommendation for best practices on the versioning history settings?


Kentico Consulting	kentico_borisp - 11/30/2012 7:19:40 PM RE:Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database Hello, There aren't any recommended values for those settings, since each project is different. The default values should usually be fine. Best regards, Boris Pocatko