Nop 4.0 Site goes down with High Load

Hello

Our site is in Azure with 14 GB of RAM and 100 DTU.
Site goes down for few minutes whenever there is high traffic .

We have tried a lot to identify issues, but so far we could not succeed.

From event log we could see below error, then after site goes down.

Application: Nop.Web.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.InvalidOperationException
   at System.Data.Entity.Core.Objects.ObjectStateManager.FixupKey(System.Data.Entity.Core.Objects.EntityEntry)
   at System.Data.Entity.Core.Objects.EntityEntry.AcceptChanges()
   at System.Data.Entity.Core.Objects.ObjectContext.AcceptAllChanges()
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(System.Data.Entity.Core.Objects.SaveOptions, System.Data.Entity.Infrastructure.IDbExecutionStrategy, Boolean)

Exception Info: System.InvalidOperationException
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(System.Data.Entity.Core.Objects.SaveOptions, System.Data.Entity.Infrastructure.IDbExecutionStrategy, Boolean)
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.Func`1<Int32>)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(System.Data.Entity.Core.Objects.SaveOptions, Boolean)
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at Nop.Data.EfRepository`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].Insert(System.__Canon)
   at Nop.Services.Logging.DefaultLogger.InsertLog(Nop.Core.Domain.Logging.LogLevel, System.String, System.String, Nop.Core.Domain.Customers.Customer)
   at Nop.Services.Logging.LoggingExtensions.FilteredLog(Nop.Services.Logging.ILogger, Nop.Core.Domain.Logging.LogLevel, System.String, System.Exception, Nop.Core.Domain.Customers.Customer)
   at Nop.Services.Logging.LoggingExtensions.Error(Nop.Services.Logging.ILogger, System.String, System.Exception, Nop.Core.Domain.Customers.Customer)
   at Nop.Services.Tasks.TaskThread.Run()
   at Nop.Services.Tasks.TaskThread.TimerHandler(System.Object)
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()


If any one has got the same issues. then please help me to resolve this issues

Have you done any kind of customization in your nopcommerce site?

any 3rd party plugins or theme?

Did you solve this?

We have similar problem on our own server :/

Maybe you solve it?

Hi Mohsin!

How is it going now with your site?

Could you please share more details on how much traffic are you getting like requests/sec and its demographics?

That error which you posted seems like related with many-to-many keys in your db.

We have also made our logging async to make it non-blocking.

Happy to help further.

Thanks,
Mandeep

Yes,

Some issue with 4.0

Kindly contact here for better performance of your store.