Server Error in '/' Application.

Too many connections

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: MySql.Data.MySqlClient.MySqlException: Too many connections

Source Error:


Line 117:        public static Models.ad GetRandomAd()
Line 118:        {
Line 119:            using (var db = new Models.classif_newContext())
Line 120:            {
Line 121:                int count = db.ads.Count();

Source File: D:\langlass\Softlifecell.ClassifiedsForFree\Softlifecell.ClassifiedsForFree\AdUtil.cs    Line: 119

Stack Trace:


[MySqlException (0x80004005): Too many connections]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +343
   MySql.Data.MySqlClient.NativeDriver.Open() +258
   MySql.Data.MySqlClient.Driver.Open() +39
   MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +331
   MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +316
   MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +152
   MySql.Data.MySqlClient.MySqlPool.GetConnection() +60
   MySql.Data.MySqlClient.MySqlConnection.Open() +1218
   System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +40

[EntityException: The underlying provider failed on Open.]
   System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +217
   System.Data.EntityClient.EntityConnection.Open() +129
   System.Data.Objects.ObjectContext.EnsureConnection() +85
   System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +42
   System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +41
   System.Linq.Enumerable.Single(IEnumerable`1 source) +152
   Softlifecell.ClassifiedsForFree.AdUtil.GetRandomAd() in D:\langlass\Softlifecell.ClassifiedsForFree\Softlifecell.ClassifiedsForFree\AdUtil.cs:119
   Softlifecell.ClassifiedsForFree.AdUtil.GetPlaceCategoryAdsByDistinct(String place, String category, Int32 skip, Int32 take) in D:\langlass\Softlifecell.ClassifiedsForFree\Softlifecell.ClassifiedsForFree\AdUtil.cs:754
   Softlifecell.ClassifiedsForFree.Controllers.PlaceCategoryController.PlaceCategoryAds(String ufname1, String ufname2, Nullable`1 page) in D:\langlass\Softlifecell.ClassifiedsForFree\Softlifecell.ClassifiedsForFree\Controllers\PlaceCategoryController.cs:25
   lambda_method(Closure , ControllerBase , Object[] ) +248
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +280
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
   System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +33
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +80
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +396
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +396
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +32
   System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +187
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +30
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +44
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +25
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +431
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +75
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +158


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4110.0