Subject | Re[2]: [firebird-support] Re: Problem with UDF when migrating from 2.1 to 2.5 |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2012-01-06T23:06:43Z |
Hello, Marcin!
Saturday, January 7, 2012, 1:52:22 AM, you wrote:
MB> I have new hardware for FB 2.5, so now I have two servers that I can
MB> compare...
Well, I know some cases when library being used for a long time
started to crash server on new hardware of FB version, just because
it become loaded or executed at another memory region.
Anyway, seems that your new server hasn't some files, needed by
that UDF.
MB> Does restore process compile procedures?
no, and never did. Result of SQL/PSQL compilation is BLR,
wich is stored in system tables (procedures, triggers, views, check
constraints). BLR is being recompiled only on ALTER statement.
Gbak is only checks BLR dependencies on restore.
MB> I hardly remember, but probably
MB> I had not been able to restore database without UDF libraries...
Yes, you are able to do that. gbak will show you WARNING (not ERROR)
that dll/so for some function does not exist, and that's it, and if
you will not call this udf directly or indirectly, database
will work well without this UDFs.
--
Dmitry Kuzmenko, www.ib-aid.com
Saturday, January 7, 2012, 1:52:22 AM, you wrote:
>> windows FreeUDFLib to Linux? As I know, there is some kind ofMB> Yes, I'm 100% sure - I have FB 2.1 with these libraries up and running.
>> subset of FreeUDFLib, ported to C and thus compilable on Linux.
MB> I have new hardware for FB 2.5, so now I have two servers that I can
MB> compare...
Well, I know some cases when library being used for a long time
started to crash server on new hardware of FB version, just because
it become loaded or executed at another memory region.
Anyway, seems that your new server hasn't some files, needed by
that UDF.
MB> Does restore process compile procedures?
no, and never did. Result of SQL/PSQL compilation is BLR,
wich is stored in system tables (procedures, triggers, views, check
constraints). BLR is being recompiled only on ALTER statement.
Gbak is only checks BLR dependencies on restore.
MB> I hardly remember, but probably
MB> I had not been able to restore database without UDF libraries...
Yes, you are able to do that. gbak will show you WARNING (not ERROR)
that dll/so for some function does not exist, and that's it, and if
you will not call this udf directly or indirectly, database
will work well without this UDFs.
--
Dmitry Kuzmenko, www.ib-aid.com