+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Error: The transaction log for database 'CMS' is full.

Error: The transaction log for database 'CMS' is full.

2 posts, 0 answered
  1. Annie
    Annie avatar
    123 posts
    Registered:
    08 Apr 2009
    03 Aug 2009
    Link to this post
    Hi,

    We are having a problem with the transaction logs, every couple of weeks we get the following error on sitefinity: how can we fix this problem?

    Server Error in '/' Application.


    The transaction log for database 'CMS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

    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.Data.SqlClient.SqlException: The transaction log for database 'CMS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

    Source Error:

    Line 27:       void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    Line 28:       {
    Line 29:               e.Authenticated = UserManager.Default.ValidateUser(this.Login1.UserName, this.Login1.Password);
    Line 30:       }
    Line 31: 


    Source File: c:\Websites\www\Sitefinity\Login.aspx.cs    Line: 29

    Stack Trace:

    [SqlException (0x80131904): The transaction log for database 'CMS' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
       System.Data.SqlClient.SqlDataReader.get_MetaData() +62
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
       System.Data.SqlClient.SqlCommand.ExecuteReader() +84
       Nolics.ORMapper.DataProviders.SqlServer2005Provider.BeginUpdate(Connection con) +224
       Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +90
       Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +755
       Nolics.ORMapper.Base.Transaction.Commit() +10
       Telerik.DataAccess.AspnetProviders.TelerikMembershipProvider.CheckAttemptCounts(User user, String pass, String pass2) +813
       Telerik.DataAccess.AspnetProviders.TelerikMembershipProvider.CheckPassword(User user, String password, Boolean& userIsApproved) +83
       Telerik.DataAccess.AspnetProviders.TelerikMembershipProvider.ValidateUser(String username, String password) +90
       Telerik.Security.UserManager.ValidateUser(String username, String password) +17
       Admin_Login.Login1_Authenticate(Object sender, AuthenticateEventArgs e) in c:\Websites\www\Sitefinity\Login.aspx.cs:29
       System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +106
       System.Web.UI.WebControls.Login.AttemptLogin() +105
       System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
       System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
       System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

     

    thanks,

    Annie

  2. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    03 Aug 2009
    Link to this post
    Hi Annie,

    It seems there are too many transactions happening with your SQL tables, so the log file fills quickly. Here's a nice article on what you can do frequently to stop this issue. Still, before reconfiguring your SQL Server, please make sure that you keep a backup of at least a day, so you could roll back the database in case of emergency.

    Kind regards,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the newTelerik Support Portal.
    Check out the tipsfor optimizing your support resource searches.
2 posts, 0 answered