Re: Duplicated key in connection pool

[Maurizio Bucco]

Hi, same error with mysql.data connector.net version 8.1.0 in a web site, this the error details:

Exception information:
Exception type: System.ArgumentException
Exception message: An item with the same key has already been added.

Request information:
Request URL:xxxxxxx
Request path: /Category/Giochi
User host address: 120.245.61.6
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\xxxxx

Thread information:
Thread ID: 111
Thread account name: IIS APPPOOL\xxxxx
Is impersonating: False
Stack trace: at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at MySql.Data.MySqlClient.MySqlPoolManager.<GetPoolAsync>d__21.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySql.Data.MySqlClient.MySqlConnection.<OpenAsync>d__91.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at WebMatrix.Data.Database.EnsureConnectionOpen()
at WebMatrix.Data.Database.<QueryInternal>d__22.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at WebMatrix.Data.Database.Query(String commandText, Object[] parameters)
at elsql..ctor(String utente, List`1 categoria, Boolean Singole, List`1 tipologia, List`1 stato, Int64 NumRecordPagina, Int64 Pagina, String Ordine, List`1 lingua, String prezzi, String searchstr, List`1 sottocat, List`1 rarita, Boolean backorder, Boolean invisibili)
at ASP._Page_prodotti_int_vbhtml.Execute() in C:\inetpub\siti\gametrade.it\prodotti_int.vbhtml:line 87
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
at System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors)
at System.Web.WebPages.WebPage.ExecutePageHierarchy()
at System.Web.WebPages.StartPage.ExecutePageHierarchy()
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
at System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext)


In connection string I have ConnectionLifeTime=30;Pooling=True;Max Pool Size=10;ConnectionReset=False;

Are there any known fixes? The previous version I used 8.0.16 didn't give this problem but I can't do a revert.

Thanks Best regards,
Maurizio