IT/MySQL(MariaDB)
How to fix unused shared library of user defined function error
쓸만한게없네
2017. 5. 23. 16:10
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).