Warning message about keyring component metadata query service in error.log

MySQL & MariaDB Percona Server for MySQL 8.0
1

Hello,
After upgrade the Percona MySQL 8.0.23 to 8.0.25 I see every night the warning in error log like this:
2021-08-23T21:00:02.911820Z 229549 [Warning] [MY013712] [Server] No suitable ‘keyring_component_metadata_query’ service implementation found to fulfill the request.

The next plugin is loaded automatically since version 8.0.24 of Oracle MySQL .
root@localhost[(none)]> show plugins;
±--------------------------------±---------±-------------------±-------------------±--------+
| Name | Status | Type | Library | License |
±--------------------------------±---------±-------------------±-------------------±--------+
| daemon_keyring_proxy_plugin | ACTIVE | DAEMON | NULL | GPL |

The keyring component is not installed:
root@localhost[(none)]> SELECT * FROM performance_schema.keyring_component_status;
Empty set (0.00 sec)

Do you know how to configure the server to prevent this message to be appear in the log?

2

Hello @Serhii_Bulieienko,
This is a known upstream bug MySQL Bugs: #103684: Warning issued when querying ps. keyring_component_status
We have to wait for Oracle/MySQL to publish a fix. Feel free to comment on the bug to increase awareness.

4 Likes
3

Hi @matthewb ,

We use database version is 8.0.36
Server version: 8.0.36-28.1 Percona XtraDB Cluster (GPL), Release rel28, Revision bfb687f, WSREP version 26.1.4.3
but we take same warning.
2025-01-02T01:00:01.220429+03:00 126448 [Warning] [MY-013712] [Server] No suitable ‘keyring_component_metadata_query’ service implementation found to fulfill the request.

Is it important warning ?
What kind of problems might we experience as a result of this error?

4

There are no problems with this warning. The bug is still present in 8.0.38, so Oracle isn’t prioritizing this annoyance. You could install the keyring component with defaults to remove the message.

1 Like