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

MVCC read from index on CHAR or VARCHAR wrongly omits rows

Details

    Description

      origin/10.6 af418bb9ef7e422282dc976640409a6af8fcd58c 2021-04-19T14:04:02+10:00
      		 
       
      		 
      Scenario:
      		 
      1. Start the server, create one table and fill it with 100 rows.
      		 
      2. Session 1 runs in a loop some update like
      		 
           UPDATE table100_innodb_int_autoinc SET `col_varchar_255_ucs2_key` = CONVERT( 'degsotrsfannidwyvkuvlkeslrryhpkeevqmbksdrzadzpyisznignsytihyjixyalxfxpnafjwzgnkbbayklurufrsajtzohanbuvcfyykvtmesobixwipkoihhqykvoejckythjnjshxgohmecmklxryubdexjgxehdiqqui' USING ASCII )
      		 
          Session 2 runs in a loop
      		 
          CHECK TABLE table100_innodb_int_autoinc EXTENDED
      		 
      After short time the CHECK TABLE harvests a
      		 
      test.table100_innodb_int_autoinc check Warning InnoDB: Index 'col_varchar_255_ucs2_key' contains 98 entries, should be 100.
      		 
       
      		 
      sdp:/data/Results/1618846463/TBR-36/dev/shm/vardir/1618846463/4/1/rr

      Attachments

        1. simp_many_indexes.cfg
          43 kB
        2. TBR-36_micro.yy
          0.9 kB
        3. TBR-36.zz
          1 kB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25758 InnoDB spatial indexes miss large geometry fields after MDEV-25459

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

          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

          Activity

            Ascending order - Click to sort in descending order
            mleich Matthias Leich created issue -
            mleich Matthias Leich made changes -
            Field Original Value New Value
            Attachment TBR-36.zz [ 57332 ]
            mleich Matthias Leich made changes -
            Attachment TBR-36_micro.yy [ 57333 ]
            mleich Matthias Leich made changes -
            Attachment simp_many_indexes.cfg [ 57334 ]
            mleich Matthias Leich made changes -
            Assignee Matthias Leich [ mleich ] Marko Mäkelä [ marko ]
            Description
            {noformat}
            origin/10.6 af418bb9ef7e422282dc976640409a6af8fcd58c 2021-04-19T14:04:02+10:00

            Scenario:
            1. Start the server, create one table and fill it with 100 rows.
            2. Session 1 runs in a loop some update like
                 UPDATE table100_innodb_int_autoinc SET `col_varchar_255_ucs2_key` = CONVERT( 'degsotrsfannidwyvkuvlkeslrryhpkeevqmbksdrzadzpyisznignsytihyjixyalxfxpnafjwzgnkbbayklurufrsajtzohanbuvcfyykvtmesobixwipkoihhqykvoejckythjnjshxgohmecmklxryubdexjgxehdiqqui' USING ASCII )
                Session 2 runs in a loop
                CHECK TABLE table100_innodb_int_autoinc EXTENDED
            After short time the CHECK TABLE harvests a
            test.table100_innodb_int_autoinc check Warning InnoDB: Index 'col_varchar_255_ucs2_key' contains 98 entries, should be 100.

            sdp:/data/Results/1618846463/TBR-36/dev/shm/vardir/1618846463/4/1/rr
                 
            {noformat}
            		{noformat}
            origin/10.6 af418bb9ef7e422282dc976640409a6af8fcd58c 2021-04-19T14:04:02+10:00

            Scenario:
            1. Start the server, create one table and fill it with 100 rows.
            2. Session 1 runs in a loop some update like
                 UPDATE table100_innodb_int_autoinc SET `col_varchar_255_ucs2_key` = CONVERT( 'degsotrsfannidwyvkuvlkeslrryhpkeevqmbksdrzadzpyisznignsytihyjixyalxfxpnafjwzgnkbbayklurufrsajtzohanbuvcfyykvtmesobixwipkoihhqykvoejckythjnjshxgohmecmklxryubdexjgxehdiqqui' USING ASCII )
                Session 2 runs in a loop
                CHECK TABLE table100_innodb_int_autoinc EXTENDED
            After short time the CHECK TABLE harvests a
            test.table100_innodb_int_autoinc check Warning InnoDB: Index 'col_varchar_255_ucs2_key' contains 98 entries, should be 100.

            sdp:/data/Results/1618846463/TBR-36/dev/shm/vardir/1618846463/4/1/rr
                 
            {noformat}
            Summary Draft: Corrupt index caused by some UPDATE+CHECK TABLE Corrupt index caused by some concurrent UPDATE+CHECK TABLE
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.6.0 [ 24431 ]
            Labels rr-profile rr-profile-analyzed upstream
            Summary Corrupt index caused by some concurrent UPDATE+CHECK TABLE MVCC read from index on CHAR or VARCHAR wrongly omits rows
            marko Marko Mäkelä made changes -
            Fix Version/s 10.2.38 [ 25207 ]
            Fix Version/s 10.3.29 [ 25206 ]
            Fix Version/s 10.4.19 [ 25205 ]
            Fix Version/s 10.5.10 [ 25204 ]
            Fix Version/s 10.6.1 [ 24437 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            jsantala Jukka Santala made changes -
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels rr-profile-analyzed upstream ServiceNow rr-profile-analyzed upstream
            rob.schwyzer@mariadb.com Rob Schwyzer (Inactive) made changes -
            Labels ServiceNow rr-profile-analyzed upstream 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z rr-profile-analyzed upstream
            serg Sergei Golubchik made changes -
            Labels 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z rr-profile-analyzed upstream rr-profile-analyzed upstream
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 121179 ] MariaDB v4 [ 159166 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201658
            Zendesk active tickets 201658

            People

              marko Marko Mäkelä
              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.