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

Crash recovery: SHOW KEYS .. harvests 1696: Failed to read from the .par file

    XMLWordPrintable

Details

    Description

      origin/10.7 f3785f099c2f0f251f39632928e822328abe9a02 2022-09-13T08:48:40+03:00
       
      Scenario:
      1, Start the server and generate some initial data.
      2. One session runs a DDL/DML mix.
      3. Intentional kill of the server
      4. Restart of the server with success
      5. SHOW KEYS FROM `test`.`s` harvested 1696: Failed to read from the .par file
      6. RQG reacts with killing the DB server
       
      # git clone https://github.com/mleich1/rqg --branch experimental RQG
      #
      # GIT_SHOW: HEAD -> experimental, origin/experimental 9c333aebe04973365c0b91b363957f00362f2605 2022-09-12T18:19:28+02:00
      # rqg.pl  : Version 4.0.6 (2022-05)
      #
      # $RQG_HOME/rqg.pl \
      # --duration=150 \
      # --queries=10000000 \
      # --no_mask \
      # --seed=random \
      # --max_gd_duration=1200 \
      # --rpl_mode=none \
      # --engine=InnoDB \
      # --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      # --mysqld=--log-output=none \
      # --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
      # --mysqld=--loose-idle_transaction_timeout=0 \
      # --mysqld=--loose-max-statement-time=30 \
      # --mysqld=--loose-plugin-load-add=provider_lz4.so \
      # --mysqld=--log_bin_trust_function_creators=1 \
      # --mysqld=--loose-table_lock_wait_timeout=50 \
      # --mysqld=--net_read_timeout=30 \
      # --mysqld=--innodb_page_size=16K \
      # --mysqld=--interactive_timeout=28800 \
      # --mysqld=--file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
      # --mysqld=--loose-idle_write_transaction_timeout=0 \
      # --mysqld=--loose-innodb_read_only_compressed=OFF \
      # --mysqld=--connect_timeout=60 \
      # --mysqld=--sync-binlog=1 \
      # --mysqld=--plugin-load-add=file_key_management.so \
      # --mysqld=--net_write_timeout=60 \
      # --mysqld=--innodb-lock-wait-timeout=50 \
      # --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      # --mysqld=--loose-innodb_evict_tables_on_commit_debug=on \
      # --mysqld=--lock-wait-timeout=86400 \
      # --mysqld=--innodb-buffer-pool-size=8M \
      # --mysqld=--wait_timeout=28800 \
      # --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      # --mysqld=--slave_net_timeout=60 \
      # --mysqld=--log-bin \
      # --reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog \
      # --validators=None \
      # --grammar=conf/mariadb/partitions_innodb.yy \
      # --threads=1 \
      # <local settings>
       
      1. - 3. of the scenario
      pluto:/data/results/1663590139/DD-DIFF-partitioning$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio mysqld-1
      4. - 6. of the scenario
      pluto:/data/results/1663590139/DD-DIFF-partitioning$ _RR_TRACE_DIR=./1/rr/ rr replay --mark-stdio mysqld-2
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.