[MDEV-26230] mysql_upgrade fails to load type_mysql_json due to insufficient maturity level Created: 2021-07-23  Updated: 2022-03-03  Resolved: 2022-03-03

Status: Closed
Project: MariaDB Server
Component/s: Plugins, Scripts & Clients
Affects Version/s: 10.5, 10.6
Fix Version/s: 10.5.16

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Rucha Deodhar
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26231 mysql_upgrade attempts to remove plug... In Review

 Description   

When mysql_upgrade encounters MySQL JSON type, it attempts to load type_mysql_json. In reality it cannot do so, because the plugin is Alpha, and the default allowed plugin maturity level for GA releases is gamma:

10.5 5518c320

installing plugin for MYSQL_JSON data type
ERROR 1126 (HY000) at line 1: Can't open shared library 'type_mysql_json.so' (errno: 1, Loading of alpha plugin MYSQL_JSON is prohibited by --plugin-maturity=gamma)

It can be especially problematic for Debian package installation, as it runs mysql_upgrade automatically.



 Comments   
Comment by Sergei Golubchik [ 2021-12-29 ]

bumped to beta, will bump to gamma after the 2022-Q1 release

Comment by Sergei Golubchik [ 2022-02-21 ]

rucha174, could you please change the maturity of the mysql_json plugin to gamma?

Comment by Rucha Deodhar [ 2022-02-21 ]

serg sure

Comment by Rucha Deodhar [ 2022-02-21 ]

Patch: https://github.com/MariaDB/server/commit/e431f4b6e0fff25c3042aad205732b2862aee793

Comment by Sergei Golubchik [ 2022-03-02 ]

e431f4b6e0fff25c3042aad205732b2862aee793 is, obviously, ok to push.

Just make sure all tests pass, because the plugin maturity level can show up in some test results that will need to be updated. So, just double-check tests are fine (or fix results if needed) — and then, please, push

Comment by Rucha Deodhar [ 2022-03-03 ]

double checked that all tests are passing.

Generated at Thu Feb 08 09:43:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.