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)☁️ AWS Solutions Architect Associate 자격증 취득 여정

  !저의 경험 , 팁 , 그리고 SAA-C03 자격증 합격을 위한 노하우 공유! 조금 늦은 포스팅이지만 , 꼭 공유하고 싶었던 이야기입니다 . 회사 내 주변 동료들이 자주 이렇게 말하곤 했습니다 . “ 님 실...