Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27339

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.7.2
    • Fix Version/s: 10.7, 10.8, 10.9
    • Component/s: Plugins
    • Labels:
      None

      Description

      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>
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.