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.