dirknaudts schrieb:

>
> Hi,
>
> FB 1.5 running on RH9, NPTL disabled (LD_ASSUME_KERNEL option from
> rel notes)
>
> I declared a couple of udf's in my DB, which point to tbudf
> (libtbudf.so)
>
> one of these udf's is UDF_RIGHT
> DECLARE EXTERNAL FUNCTION UDF_RIGHT
> CSTRING(254),
> INTEGER
> RETURNS CSTRING(254)
> ENTRY_POINT 'udf_Right' MODULE_NAME 'tbudf'
>
> which is used in an after update trigger on a table.
> I can update records in this table during a certain time without any
> problems.
> at a certain moment FB gives me the following error :
> invalid request BLR at offset 1443 function UFD_RIGHT is not defined
> module name or entry point could not be found invalid token error
> Code 23.
>
> When I open IBexpert to connect to the DB, and try to use one of the
> UDF's in sql editor like 'select udf_right('TEST',2) from
> rdb$database' it returns me the same message. (also when I use others
> like UDF_LEFT)
>
> Only stopping and starting FB server helps, after that I can use the
> udf's again (without changing anything in my DB!).
>
> this was done on a fresh DB-restore to make sure I hadn't messed
> anything up before my test.
>
> The same DB restored on my second server doesn't have this problem.
>
> Has anyone experienced anything similar ?
>
> thanks,
> best regards,
>
> Dirk Naudts.
>

I have experienced the same error message after changing/recompiling my
UDFs. Sometimes I can't access the UDFs anymore, and after another
recompile (more often only after changing something in the UDF but
sometimes also after just recompiling it) FB finds the entry point again.

I don't offer any solution but would also be very interested in any...
Urs