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

CHECK TABLE harvests InnoDB: Index 'abdcef' contains 10001 entries, should be 10000

    XMLWordPrintable

    Details

      Description

      ,

      Scenario:
      1. Start the server and generate some initial data (table tab1 with 10000 records, row_format REDUNDANT )
           Tests with row_format DYNAMIC showed the same issue
      2. 33 sessions run concurrent UPDATEs (autocommit) on tab1
      3. SIGKILL server during 2. is ongoing
      4. Restart attempt with success
      5. CHECK TABLE `test`.`tab1` harvests  (formatting made by RQG)
      VAR1 = [
                [
                  'test.tab1',
                  'check',
                  'Warning',
                  'InnoDB: Index \'abdcef\' contains 10001 entries, should be 10000.'
                ],
                [
                  'test.tab1',
                  'check',
                  'error',
                  'Corrupt'
                ]
              ];
      The server error log gets the entry
      [ERROR] InnoDB: Flagged corruption of `abdcef` in table `test`.`tab1` in CHECK TABLE; Wrong count
       
      sdp:/data/Results/1621959041/TBR-36-CR/dev/shm/vardir/1621959041/115/1/rr
      _RR_TRACE_DIR="." rr replay --mark-stdio mysqld-0 # Fate of server till SIGKILL
      _RR_TRACE_DIR="." rr replay --mark-stdio mysqld-1 # Fate of Server since Restart
       
      GIT_SHOW: HEAD, origin/bb-10.5-monty, origin/10.5 c80cecb5e3e509d37929b4f446edf9b6c636b98f 2021-05-23T19:53:38+03:00
       
      Maybe the current problem is a sibling of  MDEV-21109.
       
       
      RQG
      ====
      git clone https://github.com/mleich1/rqg --branch experimental RQG
       
      perl rqg.pl \
      --gendata=MDEV-25783.zz \
      --max_gd_duration=600 \
      --grammar=MDEV-25783.yy \
      --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=CrashRecovery1 \
      --validators=None \
      --mysqld=--log_output=none \
      --mysqld=--log-bin \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --engine=InnoDB \
      --restart_timeout=240 \
      --duration=100 \
      --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
      --mysqld=--innodb_stats_persistent=on \
      --mysqld=--innodb_adaptive_hash_index=on \
      --threads=33 \
      --mysqld=--innodb-use-native-aio=0 \
      --rr=Extended \
      --rr_options="--wait" \
      --mysqld=--innodb_page_size=4K \
      --mysqld=--innodb-buffer-pool-size=5M \
      --duration=300 \
      --no_mask \
      --workdir=<local settings> \
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --script_debug=_nix_
      

        Attachments

        1. data.tar.bz2
          3.28 MB
        2. data2.tar.bz2
          3.00 MB
        3. MDEV-25783.yy
          0.2 kB
        4. MDEV-25783.zz
          2 kB

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              mleich Matthias Leich
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration