Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
I changed my backup/restore routine and used gbak instead of the FBRestore class. That helps no more shutdowns now. There seems to be something wrong with FBRestore. Calling the class is pretty straight. So I don't see a ~usage~ error of that class. FbRestore restore = new FbRestore(); restore.BackupFiles.Add(new FbBackupFile(fromPath)); restore.ConnectionString = connectionString; restore.Options = FbRestoreFlags.Create; restore.PageSize = 4096; restore.Verbose = true; restore.ServiceOutput += delegate(object sender, ServiceOutputEventArgs e) { callback(e.Message); }; restore.Execute(); -Ursprüngliche Nachricht- Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] Gesendet: Donnerstag, 7. Juli 2016 18:19 An: For users and developers of the Firebird .NET providers <firebird-net-provider@lists.sourceforge.net> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently Checked. No dangling connections in the transaction pool after backup restore. Then when the ~connection shutdown~ error state is reached only 3.0 connections are in the pool. If i wasn't clear I can't create any connection in that state. Not even create a new Database and connect to that. Any connection will throw a ~connection shutdown~ Exception after that state is reached. It is not dependent to a certain database. Feels more like the hole embedded Firebird client is in a shutdown state then :( -Ursprüngliche Nachricht- Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] Gesendet: Donnerstag, 7. Juli 2016 17:42 An: For users and developers of the Firebird .NET providers <firebird-net-provider@lists.sourceforge.net> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -Ursprüngliche Nachricht- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-pro
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
Checked. No dangling connections in the transaction pool after backup restore. Then when the ~connection shutdown~ error state is reached only 3.0 connections are in the pool. If i wasn't clear I can't create any connection in that state. Not even create a new Database and connect to that. Any connection will throw a ~connection shutdown~ Exception after that state is reached. It is not dependent to a certain database. Feels more like the hole embedded Firebird client is in a shutdown state then :( -Ursprüngliche Nachricht- Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] Gesendet: Donnerstag, 7. Juli 2016 17:42 An: For users and developers of the Firebird .NET providers <firebird-net-provider@lists.sourceforge.net> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -Ursprüngliche Nachricht- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
I call FbConnection.ClearPool before backup. So there shouldn't be any 2.5 connections to that database still hanging around. The backup restore I do is inplace. I have replaced the fdb database in its original location (2.5 before a 3.0 version afterwards). I assume if I had 2.5er connections still in the pool that won't be allowed since there would be open handles to the database and I couldn't replace the file then? I will check if clearing the pool when I'm running into the ~ connection shutdown~ error state helps. But I doubt that this problem has something to do with the connection pool. -Ursprüngliche Nachricht- Von: Jiří Činčura [mailto:j...@cincura.net] Gesendet: Donnerstag, 7. Juli 2016 17:31 An: firebird-net-provider@lists.sourceforge.net Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
> To get that fixed I need to > restart the process. Are you sure. Isn't just cleaning the pool for that connection enough? -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
Hi, it looked good at first. But I have a problem when upgrading a database from 2.5 to 3.0 in the process. Means I first open the database with the 2.5 client then do a backup/restore cycle via the FbBackup/FBRestore classes (Backup with the 2.5 fbembed.dll in the connectionstring, restore with the 3.0 fbembed.dll). I can then use the database for, looks like, 60 seconds. After that I get an IscException (connection shutdown, error code 335544528) for any 3.0 database currently used in that process. To get that fixed I need to restart the process. Anything in the provider or firebird itself with a 60 seconds timing? -Ursprüngliche Nachricht- Von: Ralf Jansen [mailto:ralf.jan...@mailstore.com] Gesendet: Mittwoch, 22. Juni 2016 12:36 An: For users and developers of the Firebird .NET providers <firebird-net-provider@lists.sourceforge.net> Betreff: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently Seems to work in a short test. I will go that route further and see if there are some major stumbling blocks in the way (the provider's connection pooling for example). -Original Message- From: Jiří Činčura [mailto:j...@cincura.net] Sent: Mittwoch, 22. Juni 2016 11:12 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > Should that work? Can both libraries coexist? Can the Net. Provider > cope with that scenario? I think yes. Just use the ClientLibrary and point it to correct DLLs. -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
Seems to work in a short test. I will go that route further and see if there are some major stumbling blocks in the way (the provider's connection pooling for example). -Original Message- From: Jiří Činčura [mailto:j...@cincura.net] Sent: Mittwoch, 22. Juni 2016 11:12 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently > Should that work? Can both libraries coexist? Can the Net. Provider > cope with that scenario? I think yes. Just use the ClientLibrary and point it to correct DLLs. -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] using fb 2.5 and 3.0 embedded concurrently
> Should that work? Can both libraries coexist? Can the Net. Provider cope > with that scenario? I think yes. Just use the ClientLibrary and point it to correct DLLs. -- Mgr. Jiří Činčura Independent IT Specialist -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider