Install component 'file://component_percona_udf' is failing post upgrade to 8.4

MySQL & MariaDB
, , ,
1

Hi,

I just upgraded my percona server from 8.0 to 8.4

Iam trying to run below commad

Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.

* Run the following command to install these functions (fnv_64, fnvta_64, murmur_hash)：

mysql -e “INSTALL COMPONENT’file://component_percona_udf’”

It fails with error -

mysql -e “INSTALL COMPONENT 'file://component_percona_udf”

ERROR 3529 (HYO00) at line 1: Cannot load component from specified URN: Tfile:/icomponent_percona_udf’

Could any one help in resolving this

2

mysql -e "INSTALL COMPONENT 'file://component_percona_udf'"

3

I was using same query

4

Hi @srikar_arutla ,

Verify the component so file is present under plugindir, mostly /usr/lib/mysql/plugin/

ls -lhtr /usr/lib/mysql/plugin/component_percona_udf.so

Ensure mysql user can read it, no selinux etc to block it. Check if any hints in error log.

That’s what is written in the troubleshooting step: Percona Toolkit UDFs - Percona Server for MySQL

Thanks,

K

5

Hi @srikar_arutla,
There must be some other underlying issue because this worked fine for me:

mysql [localhost:8405] {msandbox} ((none)) > INSTALL COMPONENT 'file://component_percona_udf';
Query OK, 0 rows affected (0.03 sec)

mysql [localhost:8405] {msandbox} ((none)) > SELECT * FROM mysql.component;
+--------------+--------------------+------------------------------------+
| component_id | component_group_id | component_urn                      |
+--------------+--------------------+------------------------------------+
|            1 |                  1 | file://component_percona_telemetry |
|            2 |                  2 | file://component_percona_udf       |
+--------------+--------------------+------------------------------------+
2 rows in set (0.00 sec)