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

CHECK TABLE…EXTENDED reports a bogus error on a column prefix index

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index.

    Description

      Corruption found on release build while testing MDEV-37619

      ->/Server_bin/MDEV-37619_RelWithDebInfo<- GIT_SHOW: HEAD -> MDEV-37619, origin/MDEV-37619 ffc5239ddd9c32031ad364111231f9ee26754e1f

      		 
      # 2025-09-15T07:49:34 [74206] ERROR: Executor: The query ' CHECK TABLE t1 EXTENDED  /* E_R Thread4 QNO 1051 CON_ID 38 */ ' passed but has a result set line 'test.t1 check Warning InnoDB: The B-tree of index Marvão_uidx1 is corrupted.'.
      		 
      # 2025-09-15T07:49:34 [74206] ERROR: Executor: Full result of -> CHECK TABLE t1 EXTENDED  /* E_R Thread4 QNO 1051 CON_ID 38 */ <-
      		 
      # 2025-09-15T07:49:34 [74206] test.t1 check Warning InnoDB: The B-tree of index Marvão_uidx1 is corrupted.
      		 
      # 2025-09-15T07:49:34 [74206] test.t1 check error Corrupt
      		 
      # 2025-09-15T07:49:34 [74206] ERROR: Executor: Will exit with exit status STATUS_DATABASE_CORRUPTION(106).

      RR trace is present on pluto:-
      /data/results/1757919698/TBR-2332

      Attachments

        1. TBR-2332.yy
          2 kB
          Saahil Alam
        2. simplify_TBR-2332.cfg
          47 kB
          Saahil Alam
        3. TBR-2332-1.yy
          2 kB
          Saahil Alam

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37838 CHECK TABLE reports bogus corruption on a UNIQUE INDEX that includes NULL

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37189 Assertion `mode == 16 || mode == 12' failed

          • Major - Major loss of function.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history and a freed BLOB

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37831 The B-tree of index FTS_DOC_ID_INDEX is corrupted

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37619 The forced use of THD accessor functions hurts InnoDB performance

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              saahil Saahil Alam
              Marko Mäkelä Marko Mäkelä
              Thirunarayanan Balathandayuthapani Thirunarayanan Balathandayuthapani
              Saahil Alam Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.