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

Assertion `err == DB_SUCCESS' failed. in btr_block_get_func during crash recovery

    XMLWordPrintable

Details

    Description

      Workflow:
      1. Start server and create a table
      2. One session runs random
           ALTER TABLE t1 ADD KEY ( col2 ), ADD KEY ( col1 ) ;
           TRUNCATE TABLE t1;
      3. Kill (SIGKILL) the process of the DB server 
      4. The attempt to restart that server fails with
           2020-04-25 19:18:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2754798
          2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 83, since the redo log references ./test/t1.ibd with space ID 82.
          2020-04-25 19:18:53 0 [Note] InnoDB: Ignoring data file './test/t1.ibd' with space ID 82. Another data file called ./test/#sql-ib97.ibd exists with the same space ID.
          mysqld: storage/innobase/include/btr0btr.h:241: buf_block_t* btr_block_get_func(const dict_index_t&, ulint, ulint, bool, const char*, unsigned int, mtr_t*): Assertion `err == DB_SUCCESS' failed.
         200425 19:18:54 [rr 40350 5231][ERROR] mysqld got signal 6 ;
       
      origin/10.5 2b2dcf34f7325872b03534ebca31c396f449330f with some local changes
      which should not play a significant role because the bug was observed without
      these changes too.
       
      No replay (336 attempts) on origin/10.4 6dab094fbd31ef93a1d51b1b9c867188b2f958c3 2020-04-27T09:22:36+02:00
       
      rqg.pl \
      --duration=100 \
      --queries=10000000 \
      --threads=1 \
      --no_mask \
      --seed=random \
      --engine=InnoDB \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --sqltrace=MarkErrors \
      --rpl_mode=none \
      --mysqld=--lock-wait-timeout=86400 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --mysqld=--log-bin \
      --mysqld=--loose-max-statement-time=30 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --mysqld=--loose_innodb_lock_schedule_algorithm=fcfs \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--connect_timeout=60 \
      --mysqld=--log-output=none \
      --mysqld=--innodb_page_size=4K \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --mysqld=--innodb_stats_persistent=off \
      --mysqld=--wait_timeout=28800 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --reporters=Backtrace,CrashRecovery1,Deadlock1,ErrorLog \
      --validators=None \
      --grammar=MDEV-22369.yy \
      --workdir=<local settings> \
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --script_debug=_nix_ \
      --rr=Server
      

      Attachments

        1. MDEV-22369.log
          114 kB
        2. MDEV-22369.yy
          0.6 kB
        3. simp_MDEV-22369.cfg
          45 kB

        Issue Links

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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