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 logreusewaitdesc 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.
[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...
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.
[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?
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 logreusewaitdesc 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.SqlHelper
1.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:221umbraco.BasePages.BasePage.doLogin(User u) +438
umbraco.cms.presentation.login.Button1Click(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?
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=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...
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=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?
I think what happened is I was deleting content and accidentaly closed out of the page if that helps
Fixed it, the database was just full for some reason, gotta address that but it is fixed. Thanks guys!
is working on a reply...
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.