Thursday, 14 May 2020

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

[MariaDB(MySQL)] How to fix unused shared library of user-defined function error.
e.g. Error related to 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).

No comments:

Post a Comment

(KOR) AI와 지속 가능한 엔지니어링 — 생성은 빠르게, 검증은 철저하게

영어 원문 : https://www.linkedin.com/pulse/ai-sustainable-engineering-generate-fast-verify-thoroughly-yoon-hclqf/ [공지 / 면책 조항] 이 글에 표현된 모든 견해는 전...