Re: using fb 2.5 and 3.0 embedded concurrently

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: using fb 2.5 and 3.0 embedded concurrently

Ralf Jansen
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:[hidden email]]
Gesendet: Mittwoch, 22. Juni 2016 12:36
An: For users and developers of the Firebird .NET providers <[hidden email]>
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:[hidden email]]
Sent: Mittwoch, 22. Juni 2016 11:12
To: [hidden email]
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&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: using fb 2.5 and 3.0 embedded concurrently

Jiří Činčura-2
> 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&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: using fb 2.5 and 3.0 embedded concurrently

Ralf Jansen
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: [hidden email]
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&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: using fb 2.5 and 3.0 embedded concurrently

Ralf Jansen
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 17:42
An: For users and developers of the Firebird .NET providers <[hidden email]>
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: [hidden email]
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&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: using fb 2.5 and 3.0 embedded concurrently

Ralf Jansen
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 18:19
An: For users and developers of the Firebird .NET providers <[hidden email]>
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 17:42
An: For users and developers of the Firebird .NET providers <[hidden email]>
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:[hidden email]]
Gesendet: Donnerstag, 7. Juli 2016 17:31
An: [hidden email]
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&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider