From: Parzival <par...@gm...> - 2015-10-26 12:56:49
|
Hello all, I am using Firebird 2.5.x (in 32 and 64bit) with a WPF .net application and entity framework. The WPF application uses MVVM and has a viewmodel (that owns the context) and a model (that shares the context of the viewmodel. I have recognized that I get this error message in firebird.log: BAURADAR (Server) Mon Oct 26 13:48:38 2015 INET/inet_error: read errno = 10054 What is the correct way to close the connection in a way that this error does not pop up? I tried already to close it explizitly in the desctructor of the viewmodel, but it did not change anything: DESTRUCTOR() IF SELF:_efContext:Database:Connection:State == ConnectionState.Open SELF:_efContext:Database:Connection:Close() SELF:_efContext:Database:Connection:Dispose() SELF:_efContext:Dispose() ENDIF RETURN Thanks Niko |
From: Jiří Č. <ji...@ci...> - 2015-10-26 13:42:14
|
Are you using connection pooling? How was the application closed - regular close or killed from debugger? -- Mgr. Jiří Činčura Independent IT Specialist |
From: Parzival <par...@gm...> - 2015-10-26 14:16:33
|
Hello Jiri, on a kill inside the debugger or a crash of my app I accept the Firebird.log Error. I use connection pooling. The ConnectionString Builder looks like this: _fbConnectionStringBuilder := fbConnectionStringBuilder{} _fbConnectionStringBuilder:Database := _database _fbConnectionStringBuilder:DataSource := _server _fbConnectionStringBuilder:Charset := "ISO8859_1" _fbConnectionStringBuilder:Role := "BAURADAR_ADMIN" _fbConnectionStringBuilder:Port := 3050 _fbConnectionStringBuilder:Dialect := 3 _fbConnectionStringBuilder:ConnectionLifeTime := 15 _fbConnectionStringBuilder:Pooling := .T. _fbConnectionStringBuilder:MinPoolSize := 10 _fbConnectionStringBuilder:MaxPoolSize := 50 _fbConnectionStringBuilder:PacketSize := 8192 _fbConnectionStringBuilder:ServerType := 0 _efsb := EntityConnectionStringBuilder{} _efsb:Provider := "FirebirdSql.Data.FirebirdClient" _efSB:Metadata := _efMetaData _efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" + _server + ";initial catalog=" + _database + ";role=BAURADAR_ADMIN;" I tried to add FbConnection.ClearAllPools(), but it did not make a difference. Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Montag, 26. Oktober 2015 14:42 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: *** GMX Spamverdacht *** Re: [Firebird-net-provider] Correct closing of an entity framework connection Are you using connection pooling? How was the application closed - regular close or killed from debugger? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2015-10-26 19:30:20
|
On Mon, Oct 26, 2015, at 15:16, Parzival wrote: > _fbConnectionStringBuilder:Pooling := .T. Just for the sake of testing, can you turn it off. Then the connection is closed immediately. And we should see whether there's something dangling or not. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Parzival <par...@gm...> - 2015-11-01 09:42:07
|
Hello Jiri, I tried now to set the ConnectionPooling to false and the error message is not shown any more in firebird.log. I see also that there is no pending connection in the during times I don´t read or write. I was also able to prevent the error message by putting this FbConnection.ClearAllPools() into the DESCTRUCTOR() What does this mean in terms of performance, when I remove the ConnectionPooling? At the moment I am using a gobal context for the whole application. Is this ok or not ok? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Montag, 26. Oktober 2015 20:30 An: fir...@li... Betreff: *** GMX Spamverdacht *** Re: [Firebird-net-provider] *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection On Mon, Oct 26, 2015, at 15:16, Parzival wrote: > _fbConnectionStringBuilder:Pooling := .T. Just for the sake of testing, can you turn it off. Then the connection is closed immediately. And we should see whether there's something dangling or not. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2015-11-02 05:40:13
|
On Sun, Nov 1, 2015, at 10:41, Parzival wrote: > I tried now to set the ConnectionPooling to false and the error > message is not shown any more in firebird.log. It's same cause as http://tracker.firebirdsql.org/browse/DNET-632, which is fixed. It will be released with next version. > What does this mean in terms of performance, when I remove the > ConnectionPooling? You might see some slower connection opening if you're on high latency network. > At the moment I am using a gobal context for the whole application. Is > this ok or not ok? If the application is not running 24/7, it's mostly not a problem. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Parzival <par...@gm...> - 2015-11-03 14:12:02
|
Hello Jiri, the app is a regular business app (no 24x7). What is the planned schedule for 4.8.x? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Montag, 02. November 2015 06:40 An: For users and developers of the Firebird .NET providers <fir...@li...> Betreff: Re: [Firebird-net-provider] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection On Sun, Nov 1, 2015, at 10:41, Parzival wrote: > I tried now to set the ConnectionPooling to false and the error > message is not shown any more in firebird.log. It's same cause as http://tracker.firebirdsql.org/browse/DNET-632, which is fixed. It will be released with next version. > What does this mean in terms of performance, when I remove the > ConnectionPooling? You might see some slower connection opening if you're on high latency network. > At the moment I am using a gobal context for the whole application. Is > this ok or not ok? If the application is not running 24/7, it's mostly not a problem. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2015-11-03 14:24:51
|
On Tue, Nov 3, 2015, at 15:11, Parzival wrote: > What is the planned schedule for 4.8.x? What do you mean? -- Mgr. Jiří Činčura Independent IT Specialist |
From: emel <em...@em...> - 2015-11-03 13:26:19
|
2015.11.02. 6:40 keltezéssel, Jiří Činčura írta: >> At the moment I am using a gobal context for the whole application. Is >> >this ok or not ok? > If the application is not running 24/7, it's mostly not a problem. But only when 'ConnectionPooling is false', is it? Must I unhand a context, if I had got it from pool, when i don't use it? eMeL |
From: Jiří Č. <ji...@ci...> - 2015-11-03 13:34:17
|
On Tue, Nov 3, 2015, at 14:09, emel wrote: > But only when 'ConnectionPooling is false', is it? No. > Must I unhand a context, if I had got it from pool, when i don't use it? There's no pool for context. Only connections. -- Mgr. Jiří Činčura Independent IT Specialist |
From: Parzival <par...@gm...> - 2015-11-03 14:30:05
|
Hi, when do you plan to release the next version of the .net provider with this fix? Thanks Niko -----Ursprüngliche Nachricht----- Von: Jiří Činčura [mailto:ji...@ci...] Gesendet: Dienstag, 03. November 2015 15:25 An: fir...@li... Betreff: Re: [Firebird-net-provider] *** GMX Spamverdacht *** Re: *** GMX Spamverdacht *** Re: Correct closing of an entity framework connection On Tue, Nov 3, 2015, at 15:11, Parzival wrote: > What is the planned schedule for 4.8.x? What do you mean? -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Jiří Č. <ji...@ci...> - 2015-11-03 14:36:50
|
On Tue, Nov 3, 2015, at 15:29, Parzival wrote: > when do you plan to release the next version of the .net provider with > this fix? The beta will go out sometime this week or early next week. Beta because of the migrations and some network changes. Although tests are OK, you never know. -- Mgr. Jiří Činčura Independent IT Specialist |