Downgrade from 4 to 2.5

[Hugo Eyng | Datamais]

Hello, Firends.

I need to downgrade a DB from version 4.0 to version 2.5.

What is the best way to do it? Some hint?

Atenciosamente,

[Dimitry Sibiryakov]

Hugo Eyng | Datamais wrote 18.05.2023 15:06:
> What is the best way to do it? Some hint?

Create a database from script and pump data. There is no other way.

--
WBR, SD.

[Tomasz Tyrakowski]

On 18.05.2023 at 15:06, Hugo Eyng | Datamais wrote:
> Hello, Firends.
>
> I need to downgrade a DB from version 4.0 to version 2.5.
>
> What is the best way to do it? Some hint?

Could you share the reasons of your decision to downgrade? I'm in the
process of writing down detailed upgrade plans from 2.5 to 4.02 on ~90
production servers (based on information in Carlos Cantu's book) and if
there are any serious reasons convincing you to downgrade, knowing them
beforehand and making some contingency plans would be a great help for me.

regards
Tomasz

[Hugo Eyng | Datamais]

  Hello, Dimitry.

Thank you for your answer.

I guessed that would be the best answer. Now confirmed.

Regards

Atenciosamente,

Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/45dfab3d-26c9-14a7-ee02-18307bb08381%40ibphoenix.com.

[Hugo Eyng | Datamais]

Hello, Thomasz

I did not any cutomoziation/convertion in our software to use it with FB 4. I just setup the firebird.conf to not use  GMT in datetime fields.

The software is running well, but just in one customer. As some issues begun to happen in that customer I considered  go back to FB 2.5. But to be honest, I don´t believe that the version of the DB is causing the issues.

I can not say that you will not face a kind of trouble, because I don´t know what resoureces of FB you use. In my case, I don´t use advanced resources, so I could say that the migration from 2.5 to 4.0 was not a great effort and did not raise great problems.

Atenciosamente,

Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/e4ed054c-8c3e-3912-005a-8b09224503aa%40sol-system.pl.

[Karol Bieniaszewski]

Hi

 

As i am also interested, then ,must say that hard to follow your answer:

 

>> i don´t believe that the version of the DB is causing the issues.

 

DB not causing a problem but you back with DB to previous version?

 

Regards,

Karol Bieniaszewski

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAPjsPP3%3DikAQdoUUyPVt9HK91fnDYTOUhVM69nF3A0%2B1JV4K9g%40mail.gmail.com.

 

[Hugo Eyng | Datamais]

Hello, Karol.

What I mean is that I am not sure about what causes the issue I am facing. As I tried a lot of options and did not succeed, and the only thing I saw different between the installation in the customer I I am talking about and others is that this customer has FB 4 and the others have FB 2.5.
So, I didn´t say I was downgrading FB even it is not the problem, if I would be sure that FB 4 was not the problem, why would I downgrade it. Do not make sense.

Downgrade FB 4 to FB 2.5 is a try, just to eliminate this possibility.

Atenciosamente,

Hugo

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4QMZ2s2PPyz1yJL%40smtp.poczta.onet.pl.

[Ertan Küçükoglu]

Hello Hugo,

Would you share details of your specific problem? Maybe there is a solution for it in FirebirdSQL 4.0.

Thanks & Regards,

Ertan

Hugo Eyng | Datamais <hugo...@gmail.com>, 18 May 2023 Per, 20:36 tarihinde şunu yazdı:

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAPjsPP1uSaQgp26zRua6agfBXzQtDTT6bB2R4AyLc5%2BokC%2BKXg%40mail.gmail.com.

[Hugo Eyng | Datamais]

Hello, Ertan.

Is a generic problem. The software aleatory freezes during the operation. 

As is aleatory I could not reproduce or debug it, so I have to make a diagnostic trying to identify differences between that customer and others. One difference is the FB version.

Atenciosamente,

Hugo

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAH2i4yf0tTBJ5-n%3D%3DSBj%2BamLOoOey8RXccTvgoQ6Pjx8%3D9YHDg%40mail.gmail.com.

[Dimitry Sibiryakov]

Hugo Eyng | Datamais wrote 18.05.2023 20:31:
> As is aleatory I could not reproduce or debug it, so I have to make a diagnostic
> trying to identify differences between that customer and others.

Actually it is quite easy to diagnose. All you need is to look at call stacks
during the freeze using Process Explorer. Alternatively you can ask the customer
to create memory dump and then analyze it with debugger.

--
WBR, SD.

[Carlos H. Cantu]

Actually the diferences may not be so obvious. For example, it can be related to the way that customer uses your software. An example: if the customer does something that produces a considerable number of backversions/garbage, there will be a lot of garbage to be collected at some point and this can cause the feeling that it frozen when actually it is just collection tons of garbage.

 

A simple example of this is can be demonstrated with the following sequence... using an exclusive connection:

 

1) Delete all the records from a huge table with millions of records.

2) Commit

 

so far this should have been fast.

 

3) Run a simple select * from that (now empty) table. You will see that it can take minutes or even hours to the select to return an empty dataset! That's because it found a huge amount of garbage (the deleted records) and collected it while visiting the data pages.

[]s

Carlos

www.firebirdnews.org - www.FireBase.com.br

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAPjsPP0stRN_ZuzdsOJhBnNyev6wDkfUrx8yu2bmeoV40cWv2w%40mail.gmail.com.

[Elmar Haneke]

> What I mean is that I am not sure about what causes the issue I am
> facing. As I tried a lot of options and did not succeed, and the only
> thing I saw different between the installation in the customer I I am
> talking about and others is that this customer has FB 4 and the others
> have FB 2.5.

That means your application is designed for FB 2.5. and you get a
problem reported from an customer using the software with FB4.0.

In this case it might help to user gbak utility from FB2.5 to backup
database from FB4 server. I have sucessfully done so in case of FB3.
It's worth trying on FB4.


Elmar

[Hugo Eyng | Datamais]

Thank you, Elmar.

I will try this way

Atenciosamente,

Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/751a797c-2aa6-da18-02ac-0d9c55deecea%40haneke.de.