[Pkg-firebird-general] Bug#307279: Still waiting for sumbitter to provide more information

[Damyan Ivanov]

Christian Winkel wrote:
> Hi
> 
> I stopped using the Debianpacket. I now use the original tar.tz from
> http://firebird.sourceforge.net/.

Sorry to hear this.

> You can get the Database from:
> http://www.synerpy.de/index.php?seite=download&nav=download
> 
> The UDF is attached.
> 
> The Original Orrormessage was:
> 
> ------
> ISC Fehlernummer: 335544343
> 
> ISC Fehlermeldung:
> invalid request BLR at offset 771
> funktion F_LRTRIM is not defined
> module name or entrypoint could not be found
> ------
> 
> It worked without a change of the Database or UDF after changeing to the
>  tar.gz. of the server.

There is no definition of F_LRTRIM neither in fbudf.sql nor in ib_udf.sql.
I've grep'ed all files in the zip, no F_LRTRIM there.

$ objdump -T *.so|grep -i trim
0001365c g    DF .text  00000082 F_BlobIsEmptyAfterTrim
00014e60 g    DF .text  00000073 F_Trim
00014dec g    DF .text  00000073 F_RTrim
00014d78 g    DF .text  00000073 F_LTrim
000016c0 g    DF .text  00000073  Base        IB_UDF_rtrim
000014a0 g    DF .text  0000005e  Base        IB_UDF_ltrim
0001365c g    DF .text  00000082 F_BlobIsEmptyAfterTrim
00014e60 g    DF .text  00000073 F_Trim
00014dec g    DF .text  00000073 F_RTrim
00014d78 g    DF .text  00000073 F_LTrim
000017e0 g    DF .text  00000073  Base        IB_UDF_rtrim
000015c0 g    DF .text  0000005e  Base        IB_UDF_ltrim
00006d5c g    DF .text  00000035  Base        fn_trim
00006c8c g    DF .text  0000005a  Base        fn_ltrim
00006d94 g    DF .text  0000008f  Base        fn_repeattrim
00006ce8 g    DF .text  00000073  Base        fn_rtrim

See? No F_LRTRIM. So the error you get is caused by an UDF in some other library.


On a side note, the reason for a pre-compiled UDF to not work with debian
package and otherwise work with upstream distribution *may be* in the different
compile environments. When you identify the udf library containing F_LRTRIM
function, can you give me the source that I can try compiling myself?


Thank you for helping improve debian packages of firebird.


dam
-- 
Damyan Ivanov                              Creditreform Bulgaria
divanov at creditreform.bg              http://www.creditreform.bg/
phone: +359(2)928-2611, 929-3993            fax: +359(2)920-0994
mob. +359(88)856-6067               dam at jabber.minus273.org/Gaim
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-firebird-general/attachments/20051021/414fa6a5/signature.pgp