Upgrade 10.5 -> 10.7 fails MariaDB tried to use the ... compression, but its provider plugin is not loaded

Workflow

1. Bootstrap and start DB server  MariaDB 10.5.14

     origin/10.5 2776635cb98d35867447d375fdc04a44ef11a697 2021-12-16

2. Create some initial data and run some DDL/DML in one session.

3. Dump schemas and table data

4. Send SIGTERM to DB server and wait till its finished

5. Restart with 10.7.2

    origin/10.7 92a4e76a2c1c15fb44dc0cb05e06d5aa408a8e35 2021-12-14

    fails like

     2021-12-20 18:51:01 0 [Warning] mysqld: MariaDB tried to use the LZO compression, but its provider plugin is not loaded

     2021-12-20 18:51:01 0 [ERROR] InnoDB: Failed to read page 3 from file './test/t7.ibd': Table is compressed or encrypted but uncompress or decrypt failed.

     ...    <=== IMHO already this sufficient bad.

     2021-12-20 18:51:02 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).

     2021-12-20 18:51:02 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

             <== This might be from whatever good or bad reason.

pluto:/data/results/1640025904/TBR-1313A/dev/shm/rqg/1640025904/62/1/rr

_RR_TRACE_DIR="." rr replay --mark-stdio mysqld-1

          # Fate of the server startet with 10.5 till arrival of SIGTERM

_RR_TRACE_DIR="." rr replay --mark-stdio mysqld-2

          # Fate of the server startet with 10.7

pluto:/data/results/1640025904/TBR-1313A/dev/shm/rqg/1640025904/62/1/data_orig/

          # Copy of the data directory before the restart attempt with 10.7

Reproducing the problem with RQG is not difficult.

And roughly any compression algorithm used within the test 

(Snappy, LZMA, LZO, ...) showed somewhere up.

RQG

====

# git clone https://github.com/mleich1/rqg --branch experimental RQG

#

# GIT_SHOW: HEAD -> experimental, origin/experimental 62e549d1b378ee71215e439c95eb5b1519434137 2021-12-20T18:19:03+01:00

# rqg.pl  : Version 4.0.4 (2021-12)

#

# $RQG_HOME/rqg.pl \

# --grammar=conf/mariadb/innodb_compression_encryption.yy \

# --gendata=conf/mariadb/innodb_compression_encryption.zz \

# --max_gd_duration=1800 \

# --mysqld=--loose-innodb_encryption_rotate_key_age=2 \

# --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \

# --mysqld=--loose-idle_write_transaction_timeout=0 \

# --mysqld=--loose-idle_transaction_timeout=0 \

# --mysqld=--loose-idle_readonly_transaction_timeout=0 \

# --mysqld=--connect_timeout=60 \

# --mysqld=--interactive_timeout=28800 \

# --mysqld=--slave_net_timeout=60 \

# --mysqld=--net_read_timeout=30 \

# --mysqld=--net_write_timeout=60 \

# --mysqld=--loose-table_lock_wait_timeout=50 \

# --mysqld=--wait_timeout=28800 \

# --mysqld=--lock-wait-timeout=86400 \

# --mysqld=--innodb-lock-wait-timeout=50 \

# --no-mask \

# --queries=10000000 \

# --seed=random \

# --reporters=Backtrace \

# --reporters=ErrorLog \

# --reporters=Deadlock1 \

# --reporters=Upgrade1 \

# --validators=None \

# --mysqld=--log_output=none \

# --mysqld=--log_bin_trust_function_creators=1 \

# --mysqld=--loose-debug_assert_on_not_freed_memory=0 \

# --engine=InnoDB \

# --restart_timeout=240 \

# --upgrade-test \

# --mysqld=--plugin-load-add=file_key_management.so \

# --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \

# --duration=120 \

# --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \

# --mysqld=--loose-innodb_read_only_compressed=OFF \

# --mysqld=--innodb_stats_persistent=on \

# --mysqld=--innodb_adaptive_hash_index=off \

# --mysqld=--log-bin \

# --mysqld=--sync-binlog=1 \

# --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \

# --mysqld=--loose-max-statement-time=30 \

# --threads=9 \

# --mysqld=--innodb-use-native-aio=0 \

# --mysqld=--loose-gdb \

# --mysqld=--loose-debug-gdb \

# --rr=Extended \

# --rr_options=--chaos --wait \

# --mysqld=--innodb_undo_tablespaces=3 \

# --mysqld=--innodb_undo_log_truncate=ON \

# --vardir_type=fast \

# --mysqld=--innodb_page_size=32K \

# --mysqld=--innodb-buffer-pool-size=24M \

# --mysqld=--loose-innodb_log_files_in_group=2 \

# --no_mask \

# <local settings>