Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Warning issued when querying ps. keyring_component_status

Description

when querying performance_schema.keyring_component_status while keyring plugin wasn't installed causes to put a warning in the error log:

 

mysql [localhost:27329] {msandbox} (test) > SELECT @@VERSION; +-----------+ | @@VERSION | +-----------+ | 8.0.29-21 | +-----------+ 1 row in set (0.00 sec) mysql [localhost:27329] {msandbox} (test) > SELECT * FROM performance_schema.keyring_component_status; Empty set (0.00 sec)

 

 

From the error log:

[COR-SER] [eder.santos@tp-support03 msb_8_0_29]$ grep "keyring" data/msandbox.err 2022-08-22T22:09:47.565396Z 10 [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request.

 

It is part of the upstream bug - https://bugs.mysql.com/bug.php?id=103684
mysql [localhost:8030] {msandbox} ((none)) > select version();
-----------

version()

-----------

8.0.30

-----------
1 row in set (0.00 sec)

mysql [localhost:8030] {msandbox} ((none)) > SELECT * FROM performance_schema.keyring_component_status;
Empty set (0.00 sec)
 

From the error log:

2022-08-25T06:57:50.520356Z 9 [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request.

 

When using PMM, it is generating this message into the error log frequently. so patching this up, doesn't pollute the log file.

 

Environment

None

AFFECTED CS IDs

CS0029557

Smart Checklist

Activity

Show:

Aaditya Dubey September 2, 2022 at 9:52 AM

Hi  ,

 

Thank you for the report.
Verified as described.

mysql [localhost:8029] {msandbox} (test) > SELECT @@VERSION; +-----------+ | @@VERSION | +-----------+ | 8.0.29-21 | +-----------+ 1 row in set (0.00 sec) mysql [localhost:8029] {msandbox} (test) >  SELECT * FROM performance_schema.keyring_component_status; Empty set (0.00 sec) 2022-09-02T09:48:35.078772Z 9 [Warning] [MY-013712] [Server] No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request.

Details

Assignee

Reporter

Upstream Bug URL

MySQL Bugs: #103684: Warning issued when querying ps. keyring_component_status
MySQL Bugs: #103684: Warning issued when querying ps. keyring_component_status

Affects versions

Priority

Smart Checklist

Created August 25, 2022 at 7:16 AM
Updated March 6, 2024 at 10:01 AM

Flag notifications