[#MDEV-32181] Compression provider packages don't have dependency on exact server version

Compression provider plugins do not load with a wrong version of the server, but doesn't get upgraded through dependencies.

[buildbot@rocky84-amd64 ~]$ rpm -qa | grep MariaDB

MariaDB-provider-bzip2-10.10.5-1.el8.x86_64

MariaDB-server-10.10.5-1.el8.x86_64

MariaDB-common-10.10.5-1.el8.x86_64

MariaDB-shared-10.10.5-1.el8.x86_64

MariaDB-client-10.10.5-1.el8.x86_64

[buildbot@rocky84-amd64 ~]$ sudo dnf -y upgrade MariaDB-server

MariaDB                                                                                                                                                   6.7 kB/s | 3.4 kB     00:00

Dependencies resolved.

==========================================================================================================================================================================================

 Package                                         Architecture                            Version                                           Repository                                Size

==========================================================================================================================================================================================

Upgrading:

 MariaDB-server                                  x86_64                                  10.10.6-1.el8                                     mariadb                                   27 M

Transaction Summary

==========================================================================================================================================================================================

Upgrade  1 Package

Sep 15 17:37:01 rocky84-amd64 mariadbd[163582]: 2023-09-15 17:37:01 0 [Note] Starting MariaDB 10.10.6-MariaDB source revision cce155cc901a573d68ccda856bbf53e90edef15d as process 163582

Sep 15 17:37:01 rocky84-amd64 mariadbd[163582]: 2023-09-15 17:37:01 0 [ERROR] mariadbd: Can't open shared library 'provider_bzip2.so' (errno: 8, API version for DAEMON plugin provider_bzip2 not supported by this version of the server)

...

Sep 15 17:37:01 rocky84-amd64 mariadbd[163582]: 2023-09-15 17:37:01 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'provider_bzip2=force_plus_permanent'

Sep 15 17:37:01 rocky84-amd64 mariadbd[163582]: 2023-09-15 17:37:01 0 [ERROR] Aborting

Sep 15 17:37:01 rocky84-amd64 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING

Sep 15 17:37:01 rocky84-amd64 systemd[1]: mariadb.service: Failed with result 'exit-code'.

[MDEV-32181] Compression provider packages don't have dependency on exact server version Created: 2023-09-15 Updated: 2023-09-18
Status:	Open
Project:	MariaDB Server
Component/s:	Packaging, Platform RedHat, Plugins
Affects Version/s:	10.10, 10.11, 11.0, 11.1, 11.2
Fix Version/s:	10.11, 11.0, 11.1

[MDEV-32181] Compression provider packages don't have dependency on exact server version Created: 2023-09-15 Updated: 2023-09-18