Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Evan 344 posts 99 karma points
    Apr 01, 2009 @ 17:15
    Evan
    0

    BIG PROBLEM, Please help ASAP

    I dont know what happened but when I went to my content on my umbraco v4 install, this is what came up!

    Server Error in '/' Application.
    The transaction log for database 'Georges' is full. To find out why space in the log cannot be reused, see the logreusewaitdesc 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 'Georges' is full. To find out why space in the log cannot be reused, see the log
    reusewaitdesc column in sys.databases

    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:

    [SqlException (0x80131904): The transaction log for database 'Georges' is full. To find out why space in the log cannot be reused, see the logreusewaitdesc column in sys.databases]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
    System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
    System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
    Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
    Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
    umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) in d:\inetpub\wwwroot\ccnet\Source\Umbraco 4.0\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:64
    umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\inetpub\wwwroot\ccnet\Source\Umbraco 4.0\umbraco\datalayer\SqlHelper.cs:217<br /> <br /> [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]<br /> umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\inetpub\wwwroot\ccnet\Source\Umbraco 4.0\umbraco\datalayer\SqlHelper.cs:221
    umbraco.BasePages.BasePage.doLogin(User u) +438
    umbraco.cms.presentation.login.Button1
    Click(Object sender, EventArgs e) +264
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
    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


    Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

    What do I do?

  • Ismail Mayat 4511 posts 10092 karma points MVP 2x admin c-trib
    Apr 01, 2009 @ 17:21
    Ismail Mayat
    0

    Looks like your error log / content versions has filled up the database. You need to dump the transaction log you need to run script see here for one

    Also you might want to download and install client tools so that the ubmracolog tables can be cleared out on a regular basis.

    Regards

    Ismail

  • Evan 344 posts 99 karma points
    Apr 01, 2009 @ 17:23
    Evan
    0

    [quote=imayat12]Looks like your error log / content versions has filled up the database. You need to dump the transaction log you need to run script see here for one

    Also you might want to download and install client tools so that the ubmracolog tables can be cleared out on a regular basis.

    Regards

    Ismail
    [/quote]
    What table in the database holds this information, I really do not want to dump the database, if I could just clear out the log table that would work right...

  • Ismail Mayat 4511 posts 10092 karma points MVP 2x admin c-trib
    Apr 01, 2009 @ 17:27
    Ismail Mayat
    0

    you are not dumping the database just the transaction log. You could try clearing the umbracoLog table

    delete from umbracolog

    this may clear up enough space. You will need client tools to clean up versions. However not sure it will connect becuase your transaction log is full

    However I have had this issue in the past and i dumped the transction log. After that i setup scheduled db jobs that run nightly they cleared out the umbraco log table. Then shrunk the databases and did backup.

    Regards

    Ismail

  • Evan 344 posts 99 karma points
    Apr 01, 2009 @ 17:30
    Evan
    0

    [quote=imayat12]you are not dumping the database just the transaction log. You could try clearing the umbracoLog table

    delete from umbracolog

    this may clear up enough space. You will need client tools to clean up versions. However not sure it will connect becuase your transaction log is full

    However I have had this issue in the past and i dumped the transction log. After that i setup scheduled db jobs that run nightly they cleared out the umbraco log table. Then shrunk the databases and did backup.

    Regards

    Ismail[/quote]
    So if I go in and clear out the umbracolog table I should be good to go and everything will be how it was before this happened right?

  • Evan 344 posts 99 karma points
    Apr 01, 2009 @ 17:31
    Evan
    0

    I think what happened is I was deleting content and accidentaly closed out of the page if that helps

  • Evan 344 posts 99 karma points
    Apr 01, 2009 @ 18:46
    Evan
    0

    Fixed it, the database was just full for some reason, gotta address that but it is fixed. Thanks guys!

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies