Downgrade from 2.5 to 2.1

[Anderson Farias]

Hi all,

I've put myself on a trap. A couple os weeks ago, without noticing I could not use Firebird 2.5 Classic on a Linux distro based on GLIBC 2.5, I have upgraded a production database/enviroment from Firebird 2.1 to 2.5. 

After the migration, we had already 2 database corruptions (before moving to 2.5, this database/system had run for 7 years first with Fb 1.5 and later 2.1 without a single problem), after what we finally discovered about the Glibc 2.5 problem. We can't for now change to a newer Linux distro with updated GLIBC, so we uninstalled Firebird 2.5 Classic and installed Super Server.

The problem now is that Super Server is not using the full (SMP) processing power of the hardware, than slowing things down.

So, we need to get back to Firebird 2.1 Classic but could not figure out how to do that (tried some options without success).

Anyone ?

[Fabiano - Desenvolvimento SCI]

Maybe you are confusing yourself:

"The problem now is that Super Server is not usi ng the full (SMP)
processing power of the hardware, than slowing things down"

"So, we need to get back to Firebird 2.1 Classic but could not figure out
how to do that (tried some options without success)."

So, you know you need install FB Classic, but you said that you is using FB
Super Server.

So, install FB 2.1 Classic for SMP support.

[Anderson Farias]

Hi Fabiano, thanks for jumping in.

As I stated before, I can't just install Classic Server, 'couse the database was upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc 2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can use Firebird 2.1 Classic.


Regards,



Em Quinta-feira, 28 de Novembro de 2013 15:36, Fabiano - Desenvolvimento SCI <***@sci10.com.br> escreveu:

 
Maybe you are confusing yourself:
“The problem now is that Super Server is not usi ng the
full (SMP) processing power of the hardware, than slowing things down”
“So, we need to get back to Firebird 2.1 Classic but could
not figure out how to do that (tried some options without success).”
So, you know you need install FB Classic, but you said that you
is using FB Super Server.
So, install FB 2.1 Classic for SMP support.

[Leyne, Sean]

Post by Anderson Farias
As I stated before, I can't just install Classic Server, 'couse the database was
upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc
2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can
use Firebird 2.1 Classic.

In that case, you will need to:
- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases


Sean


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/

[Anderson Farias]

Hi Sean, thanks for the guidance. That's what I was affraid of.  :(


Regards,



Em Quinta-feira, 28 de Novembro de 2013 15:49, "Leyne, Sean" <***@BroadViewSoftware.com> escreveu:

 

Post by Anderson Farias
As I stated before, I can't just install Classic Server, 'couse the database was
upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc
2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can
use Firebird 2.1 Classic.

In that case, you will need to:
- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases


Sean

[f***@gmail.com]

Before run insert statements, disable all table triggers, so if you have
some trigger that modify data, it will not modify anything.
After running entire insert script, enable all table triggers!

Hi Sean, thanks for the guidance. That's what I was affraid of. :(
Regards,
Em Quinta-feira, 28 de Novembro de 2013 15:49, "Leyne, Sean"

Post by Anderson Farias
As I stated before, I can't just install Classic Server, 'couse the

database was

Post by Anderson Farias
upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with

glibc

Post by Anderson Farias
2.5. So, I need a way to downgrade the database back to ODS 11.1, so I

can

Post by Anderson Farias
use Firebird 2.1 Classic.

- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases
Sean

[m***@panonnet.net]

Hi Sean, thanks for the guidance. That's what I was affraid of. :(

It really isn't a big deal.

1. dump old database schema using "isql -x"
2. create a new database and create objects "isql -i"
3. use fbcopy with "e" switch to copy all the data

FBCopy disables triggers by default, so all your data is the same. It also copies generator values.

http://www.firebirdfaq.org/fbcopy.php







Regards,

As I stated before, I can't just install Classic Server, 'couse the database was
upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc
2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can
use Firebird 2.1 Classic.

In that case, you will need to:
- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases


Sean

[Anderson Farias]

Thanks for the helpful tips Fabiano and Milan


Ragards



Em Domingo, 1 de Dezembro de 2013 12:32, "***@panonnet.net" <***@panonnet.net> escreveu:

 

Post by Anderson Farias
Hi Sean, thanks for the guidance. That's what I was affraid of.  :(

It really isn't a big deal.

1. dump old database schema using "isql -x"
2. create a new database and create objects "isql -i"
3. use fbcopy with "e" switch to copy all the data

FBCopy disables triggers by default, so all your data is the same. It also copies generator values.

http://www.firebirdfaq.org/fbcopy.php





Regards,



Em Quinta-feira, 28 de Novembro de 2013 15:49, "Leyne, Sean" <***@...> escreveu:

 

Post by Anderson Farias
As I stated before, I can't just install Classic Server, 'couse the database was

Post by Anderson Farias
upgraded to v2.5 (ODS 11.2) and v.2.5 Classic Server cannot be used with glibc
2.5. So, I need a way to downgrade the database back to ODS 11.1, so I can
use Firebird 2.1 Classic.

In that case, you will need to:
- Extract a metadata script for the existing database
- Create a new empty database using v2.1
- Apply the metadata script
- 'Pump' the data between the v2.5 and v2.1 databases


Sean