Hello.
Please check, if weird behavior remains on the latest release (4.1.12). Try to run FLUSH PRIVILEGES after 'drop function' statement and cast a look if mysql.func table is clear. Do you use xxx_deinit in your udf? I mean, is it possible that your function has some problem during deinitialization, so it can't be removed. [EMAIL PROTECTED] wrote: > I can successfully LOAD a UDF in mysql-4.1.10, but I can't DROP it. > MySQL reports that the DROP FUNCTION was OK, but the function still > shows up in the mysql.func table. The function no longer works, but I > have to TRUNCATE the mysql.func table in order to be able to LOAD it > again. I am doing this with the root account so I don't think it's a > privileges problem. See below: > > mysql> create function betatouni returns string soname 'libbeta2.so'; > Query OK, 0 rows affected (0.12 sec) > > mysql> drop function betatouni; > Query OK, 0 rows affected (0.00 sec) > > mysql> select * from func; > +-----------+-----+-------------+----------+ > | name | ret | dl | type | > +-----------+-----+-------------+----------+ > | betatouni | 0 | libbeta2.so | function | > +-----------+-----+-------------+----------+ > 1 row in set (0.00 sec) > > mysql> create function betatouni returns string soname 'libbeta2.so'; > ERROR 1026 (HY000): Error writing file 'mysql.func' (errno: 121) > > Thanks for any help you can provide, > Jeremy > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
