2.4 crashed after 2 weeks

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
brand new version
brand new DB
this happened after 2 weeks online
this is shared hosting with godaddy


Server Error in '/app' Application.

Could not allocate space for object 'dbo.Customer'.'IX_Customer_Email' in database 'DB' 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.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.Customer'.'IX_Customer_Email' in database 'gfadellm' 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:


[SqlException (0x80131904): Could not allocate space for object 'dbo.Customer'.'IX_Customer_Email' in database 'gfadellm' 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.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2072782
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5061884
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +8168800
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +267

[UpdateException: An error occurred while updating the entries. See the inner exception for details.]
   System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +389
   System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) +163
   System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +609
   System.Data.Entity.Internal.InternalContext.SaveChanges() +120

[DbUpdateException: An error occurred while updating the entries. See the inner exception for details.]
   System.Data.Entity.Internal.InternalContext.SaveChanges() +206
   System.Data.Entity.Internal.LazyInternalContext.SaveChanges() +24
   System.Data.Entity.DbContext.SaveChanges() +20
   Nop.Data.EfRepository`1.Insert(T entity) in f:\Own\NopCommerce\Sources\src\Libraries\Nop.Data\EfRepository.cs:41
   Nop.Services.Customers.CustomerService.InsertGuestCustomer() in f:\Own\NopCommerce\Sources\src\Libraries\Nop.Services\Customers\CustomerService.cs:350
   Nop.Web.Framework.WebWorkContext.GetCurrentCustomer() in f:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:117
   Nop.Web.Framework.WebWorkContext.get_CurrentCustomer() in f:\Own\NopCommerce\Sources\src\Presentation\Nop.Web.Framework\WebWorkContext.cs:185
   Nop.Web.MvcApplication.SetWorkingCulture() in f:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:200
   Nop.Web.MvcApplication.Application_AuthenticateRequest(Object sender, EventArgs e) in f:\Own\NopCommerce\Sources\src\Presentation\Nop.Web\Global.asax.cs:144
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
12 years ago
https://www.nopcommerce.com/boards/t/14644/sudden-crash.aspx
12 years ago
this is from the DB itself
you can see that customers table have only 9000 rows and the log which is the most full is at 21000 rows
this should cause errors ???


Customer  dbo  02/02/2012 12:06:44 PM  PRIMARY  9222  
            
Customer_CustomerRole_Mapping  dbo  02/02/2012 12:06:44 PM  PRIMARY  9224  
            
CustomerAddresses  dbo  02/02/2012 12:06:44 PM  PRIMARY  1  
            
CustomerAttribute  dbo  02/02/2012 12:06:44 PM  PRIMARY  8504  
            
CustomerContent  dbo  02/02/2012 12:06:44 PM  PRIMARY  0  
            
CustomerRole  dbo  02/02/2012 12:06:44 PM  PRIMARY  4  
            
LocaleStringResource  dbo  02/02/2012 12:06:44 PM  PRIMARY  3652  
            
LocalizedProperty  dbo  02/02/2012 12:06:44 PM  PRIMARY  0  
            
Log  dbo  02/02/2012 12:06:44 PM  PRIMARY  21117
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.