AW: AW: AW: AW: [firebird-support] Architecture
-verbose :) I remember me. So I can see what table is he problematic one. Have a nice weekend, Thomas, many Thanks :) -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 8. Januar 2016 17:28 An: firebird-support@yahoogroups.com Betreff: Re: AW: AW: AW: [firebird-support] Architecture > Yes, Thomas, > > it woks with 2.1. In the release notes of 2.5.X is written: > > Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would > throw the error "value exceeds the range for valid timestamp". > > But where can I search 200 Tables... Read Paul's blog on using -v for the restore etc ... -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > -Ursprüngliche Nachricht- > Von: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Gesendet: Freitag, 8. Januar 2016 17:07 > An: firebird-support@yahoogroups.com > Betreff: Re: AW: AW: [firebird-support] Architecture > >> now, the switches works fine, I had forget the Charset -fix_fss_d >> ISO8859_1 >> >> It works fine, but there is another problem to fix. Now I get the >> error, that value exceeds the range for valid timestamps. How can I >> fix > this issue? > > * When does that happen during the restore? > * Does a backup *AND* restore with Firebird 2.1 works? > > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird FB TraceManager, IB > LogManager, Database Health Check, Tuning etc. > >> I have installed fb as cs without superclassic under 32 Bit Win7 the >> 32 Bit Version >> >> -Ursprüngliche Nachricht- >> Von: firebird-support@yahoogroups.com >> [mailto:firebird-support@yahoogroups.com] >> Gesendet: Freitag, 8. Januar 2016 16:51 >> An: firebird-support@yahoogroups.com >> Betreff: Re: AW: [firebird-support] Architecture >> >>> Thanks. For some Years, we have had in use the superserver, but >>> since we have a quadcore CPU, we are using cs. >>> >>> UDFs can I replace with build in functions >> >> I guess you can imagine that you first need to do that before backing >> up and restoring? >> >>> Now, I have restored the database with 2.5, but.. Errors :( Now I >>> have seen the new switches -fix_fss_d and m, but now I get another >>> error, no character set were found. >> >> * What is the character set of your database used when you have >> created the database in the past? >> * What is the exact error message? >> * How did you install Firebird 2.5? >> >> Is there another way to migrate? With the scripts while >>> running 2.1? >> >> backup/restore via gbak is the preferred solution, because it also >> moves data. Of course, you still can create an empty Firebird 2.5 >> based database with a DDL script and then pump your data with a tool >> from your source into the destination database. >> >> >> -- >> With regards, >> Thomas Steinmaurer >> http://www.upscene.com/ >> >> Professional Tools and Services for Firebird FB TraceManager, IB >> LogManager, Database Health Check, Tuning etc. >> >> >> >>> >>> thanks >>> >>> -Ursprüngliche Nachricht- >>> Von: firebird-support@yahoogroups.com >>> [mailto:firebird-support@yahoogroups.com] >>> Gesendet: Freitag, 8. Januar 2016 16:37 >>> An: firebird-support@yahoogroups.com >>> Betreff: Re: [firebird-support] Architecture >>> >>> Hello Olaf, >>> >>>> Hello, >>>> >>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to >>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit >>>> installation of Firebird too? >>> >>> From an operational POV, a main factor with moving from 32-bit >>> to 64-bit is if you are using (third-party) UDF libraries. You need >>> them to be compiled with a 64-bit compiler if you want to run Firebird 64-bit. >>> >>> Other than that, I guess it depends on your planned load, especially >>> addressable RAM by the Firebird server process. If still intend to >>> run with ClassicServer, then each connection spawns its own process, >>> thus you probably won't hit the addressable RAM limit with Firebird > 32-bit. >>> That might be different with Firebird SuperCla
AW: AW: AW: [firebird-support] Architecture
Yes, Thomas, it woks with 2.1. In the release notes of 2.5.X is written: Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw the error "value exceeds the range for valid timestamp". But where can I search 200 Tables... -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 8. Januar 2016 17:07 An: firebird-support@yahoogroups.com Betreff: Re: AW: AW: [firebird-support] Architecture > now, the switches works fine, I had forget the Charset -fix_fss_d > ISO8859_1 > > It works fine, but there is another problem to fix. Now I get the > error, that value exceeds the range for valid timestamps. How can I fix this issue? * When does that happen during the restore? * Does a backup *AND* restore with Firebird 2.1 works? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > I have installed fb as cs without superclassic under 32 Bit Win7 the > 32 Bit Version > > -Ursprüngliche Nachricht- > Von: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Gesendet: Freitag, 8. Januar 2016 16:51 > An: firebird-support@yahoogroups.com > Betreff: Re: AW: [firebird-support] Architecture > >> Thanks. For some Years, we have had in use the superserver, but since >> we have a quadcore CPU, we are using cs. >> >> UDFs can I replace with build in functions > > I guess you can imagine that you first need to do that before backing > up and restoring? > >> Now, I have restored the database with 2.5, but.. Errors :( Now I >> have seen the new switches -fix_fss_d and m, but now I get another >> error, no character set were found. > > * What is the character set of your database used when you have > created the database in the past? > * What is the exact error message? > * How did you install Firebird 2.5? > > Is there another way to migrate? With the scripts while >> running 2.1? > > backup/restore via gbak is the preferred solution, because it also > moves data. Of course, you still can create an empty Firebird 2.5 > based database with a DDL script and then pump your data with a tool > from your source into the destination database. > > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird FB TraceManager, IB > LogManager, Database Health Check, Tuning etc. > > > >> >> thanks >> >> -Ursprüngliche Nachricht- >> Von: firebird-support@yahoogroups.com >> [mailto:firebird-support@yahoogroups.com] >> Gesendet: Freitag, 8. Januar 2016 16:37 >> An: firebird-support@yahoogroups.com >> Betreff: Re: [firebird-support] Architecture >> >> Hello Olaf, >> >>> Hello, >>> >>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to >>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit >>> installation of Firebird too? >> >>From an operational POV, a main factor with moving from 32-bit to >> 64-bit is if you are using (third-party) UDF libraries. You need them >> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit. >> >> Other than that, I guess it depends on your planned load, especially >> addressable RAM by the Firebird server process. If still intend to >> run with ClassicServer, then each connection spawns its own process, >> thus you probably won't hit the addressable RAM limit with Firebird 32-bit. >> That might be different with Firebird SuperClassic (32-bit), because >> this is a single process architecture. >> >> I connect with odbc. Known Issues while migration, >>> metadata etc. ? >> >> The usual path is creating a gbak-based backup with Firebird 2.1 and >> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you >> can check with gstat -h afterwards). >> >> On the client side, make sure that you are using a version of the >> Firebird client library matching the server version. Bitness (32-bit vs. >> 64-bit) of the client library is driven by your application and not >> by the Firebird server. So, if you are application is 32-bit (Delphi >> 32-bit?) use a Firebird 32-bit client library and ODBC driver. >> >> Hope this helps. >> >> -- >> With regards, >> Thomas Steinmaurer >> http://www.upscene.com/ >> >> Professional Tools and Services for Firebird FB TraceManager, IB >> LogManager, Database Health Check, Tuning etc. >> >> >> >> >> >> >> ++ >> >> Visit http://www.firebirdsql.org and click the Documentation item on >> the main (top) menu. Try FAQ and other links from the left-side menu > there. >> >> Also search the knowledgebases at >> http://www.ibphoenix.com/resources/documents/ >> >> ++ >> >>
Re: AW: AW: AW: [firebird-support] Architecture
> Yes, Thomas, > > it woks with 2.1. In the release notes of 2.5.X is written: > > Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw > the error "value exceeds the range for valid timestamp". > > But where can I search 200 Tables... Read Paul's blog on using -v for the restore etc ... -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > -Ursprüngliche Nachricht- > Von: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Gesendet: Freitag, 8. Januar 2016 17:07 > An: firebird-support@yahoogroups.com > Betreff: Re: AW: AW: [firebird-support] Architecture > >> now, the switches works fine, I had forget the Charset -fix_fss_d >> ISO8859_1 >> >> It works fine, but there is another problem to fix. Now I get the >> error, that value exceeds the range for valid timestamps. How can I fix > this issue? > > * When does that happen during the restore? > * Does a backup *AND* restore with Firebird 2.1 works? > > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird FB TraceManager, IB LogManager, > Database Health Check, Tuning etc. > >> I have installed fb as cs without superclassic under 32 Bit Win7 the >> 32 Bit Version >> >> -Ursprüngliche Nachricht- >> Von: firebird-support@yahoogroups.com >> [mailto:firebird-support@yahoogroups.com] >> Gesendet: Freitag, 8. Januar 2016 16:51 >> An: firebird-support@yahoogroups.com >> Betreff: Re: AW: [firebird-support] Architecture >> >>> Thanks. For some Years, we have had in use the superserver, but since >>> we have a quadcore CPU, we are using cs. >>> >>> UDFs can I replace with build in functions >> >> I guess you can imagine that you first need to do that before backing >> up and restoring? >> >>> Now, I have restored the database with 2.5, but.. Errors :( Now I >>> have seen the new switches -fix_fss_d and m, but now I get another >>> error, no character set were found. >> >> * What is the character set of your database used when you have >> created the database in the past? >> * What is the exact error message? >> * How did you install Firebird 2.5? >> >> Is there another way to migrate? With the scripts while >>> running 2.1? >> >> backup/restore via gbak is the preferred solution, because it also >> moves data. Of course, you still can create an empty Firebird 2.5 >> based database with a DDL script and then pump your data with a tool >> from your source into the destination database. >> >> >> -- >> With regards, >> Thomas Steinmaurer >> http://www.upscene.com/ >> >> Professional Tools and Services for Firebird FB TraceManager, IB >> LogManager, Database Health Check, Tuning etc. >> >> >> >>> >>> thanks >>> >>> -Ursprüngliche Nachricht- >>> Von: firebird-support@yahoogroups.com >>> [mailto:firebird-support@yahoogroups.com] >>> Gesendet: Freitag, 8. Januar 2016 16:37 >>> An: firebird-support@yahoogroups.com >>> Betreff: Re: [firebird-support] Architecture >>> >>> Hello Olaf, >>> Hello, I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation of Firebird too? >>> >>> From an operational POV, a main factor with moving from 32-bit to >>> 64-bit is if you are using (third-party) UDF libraries. You need them >>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit. >>> >>> Other than that, I guess it depends on your planned load, especially >>> addressable RAM by the Firebird server process. If still intend to >>> run with ClassicServer, then each connection spawns its own process, >>> thus you probably won't hit the addressable RAM limit with Firebird > 32-bit. >>> That might be different with Firebird SuperClassic (32-bit), because >>> this is a single process architecture. >>> >>> I connect with odbc. Known Issues while migration, metadata etc. ? >>> >>> The usual path is creating a gbak-based backup with Firebird 2.1 and >>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you >>> can check with gstat -h afterwards). >>> >>> On the client side, make sure that you are using a version of the >>> Firebird client library matching the server version. Bitness (32-bit vs. >>> 64-bit) of the client library is driven by your application and not >>> by the Firebird server. So, if you are application is 32-bit (Delphi >>> 32-bit?) use a Firebird 32-bit client library and ODBC driver. >>> >>> Hope this helps. >>> >>> -- >>> With regards, >>> Thomas Steinmaurer >>> http://www.upscene.com/ >>> >>> Professional Tools and Services for Firebird FB TraceManager, IB >>> LogManager, Database Health Check, Tuning etc. >>> >>> >>> >>> >>> >>> >>>