How to fix unused shared library of user defined function error.

e.g. libmy_json_udf_path.so (json user function)


Error Messages on errorlog file.

[ERROR] Can't open shared library 'libmy_json_udf_path.so' (errno: 0, cannot open shared object file: No such file or directory)


Check mysql.func table.

select * from mysql.func;



Delete data on mysql.func and mysql.install_jsonudfs.

delete from mysql.func

where dl = 'libmy_json_udf_path.so';


DROP PROCEDURE IF EXISTS mysql.install_jsonudfs;


Restart MySQL(MariaDB).

+ Recent posts