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

Sequence gets corrupted and produces ER_KEY_NOT_FOUND (Can't find record) after ALTER .. ORDER BY

Details

    Description

      CREATE SEQUENCE s;
      		 
      ALTER TABLE s ORDER BY cache_size;
      		 
      SELECT NEXTVAL(s);
      		 
       
      		 
      DROP SEQUENCE s;

      10.3 765ae6e8

      		 
      mysqltest: At line 3: query 'SELECT NEXTVAL(s)' failed: 1032: Can't find record in 's'

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19977 Assertion `(0xFUL & mode) == LOCK_S || (0xFUL & mode) == LOCK_X' failed in lock_rec_lock

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22927 ER_KEY_NOT_FOUND or Assertion `(0xFUL & mode) == LOCK_S || (0xFUL & mode) == LOCK_X' failed upon sequence operations

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16397 ER_KEY_NOT_FOUND upon attempt to LOAD DATA into sequence

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19303 Valgrind warnings about uninitialised values in dtuple_validate or mi_rrnd or ma_rrnd upon UPDATE/DELETE .. ORDER BY from sequence

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova added a comment -

            The issue should only have a moderate-to-low importance to users, as such an ALTER is an unlikely operation, even though not impossible; but it badly affects tests, because ER_KEY_NOT_FOUND usually indicates data corruption and thus cannot be suppressed without increasing risks of getting false negatives.

            elenst Elena Stepanova added a comment - The issue should only have a moderate-to-low importance to users, as such an ALTER is an unlikely operation, even though not impossible; but it badly affects tests, because ER_KEY_NOT_FOUND usually indicates data corruption and thus cannot be suppressed without increasing risks of getting false negatives.
            elenst Elena Stepanova made changes -
            Labels affects-tests
            elenst Elena Stepanova made changes -
            monty Michael Widenius made changes -
            Assignee Oleksandr Byelkin [ sanja ] Michael Widenius [ monty ]
            monty Michael Widenius added a comment -

            Added a test to ensure one can't use ALTER TABLE ORDER BY with sequences

            monty Michael Widenius added a comment - Added a test to ensure one can't use ALTER TABLE ORDER BY with sequences
            monty Michael Widenius made changes -
            issue.field.resolutiondate 2020-06-07 13:33:05.0 2020-06-07 13:33:05.588
            monty Michael Widenius made changes -
            Fix Version/s 10.5.4 [ 24264 ]
            Fix Version/s 10.3.24 [ 24306 ]
            Fix Version/s 10.4.14 [ 24305 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96329 ] MariaDB v4 [ 156108 ]

            People

              monty Michael Widenius
              elenst Elena Stepanova
              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.