Hi Erick You are not closing your connections, that is your fault.
Check all the "new fbconnection()" statements and verify if they are inside a using statement. Unless you have a million users, you'll hardly ever hit the "100 truly concurrent" users if you have normal website. Some connections just remain open, this connectionpool timeout is merely a symptom, not a problem. -----Oorspronkelijk bericht----- Van: Erick Perez [mailto:webmail...@yahoo.es] Verzonden: woensdag 4 april 2012 17:39 Aan: For users and developers of the Firebird .NET providers Onderwerp: [Firebird-net-provider] CheckMaxPoolSize error Hello, I get this error messages when the connections pool is full: System.SystemException: Timeout exceeded. at FirebirdSql.Data.Firebird.FbConnectionPool.CheckMaxPoolSize() at FirebirdSql.Data.Firebird.FbConnectionPool.CheckOut() at FirebirdSql.Data.Firebird.FbConnection.Open() But i shouldn't get this error because ConnectionLifeTime=10 in connectionstring: <add key="connecstring" value="charset=ISO8859_1;Connection LifeTime=10;database=/home/domains/db/websites.fdb;user=sysdba;password=mast erkey;datasource=localhost"/> I have tried to clear the pool when i add this line in the global.asax void Session_End(object sender, EventArgs e) { FirebirdSql.Data.FirebirdClient.FbConnection.ClearAllPools(); } But connections pool never dies, this action is ignored I've done a test on a webform, i try to see the number of connections in the pool when is full or almost full Label1.Text = FirebirdSql.Data.FirebirdClient.FbConnection.ConnectionPoolsCount.ToString (); The result is 1 all the time..., i don't understand why I get this issue on different OS (windows 2003 server and FreeBSD), i've tried all latest versions (ADO.Net Firebird, 2.5.2, 2.7.0, 2.7.5 too) ---------------------------------------------------------------------------- -- Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
