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

Killed CREATE SEQUENCE leaves sequence in unusable state

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3.8
    • Component/s: Sequences
    • Labels:
      None

      Description

      Note: Run with --repeat=N if it's not reproducible right away.

      --connect (con1,localhost,root,,test)
      --let $conid= `SELECT CONNECTION_ID()`
      --send
      	CREATE SEQUENCE s;
      --connection default
      --eval KILL $conid
      --error 0,ER_NO_SUCH_TABLE
      SELECT NEXTVAL(s);
       
      # Cleanup
      DROP SEQUENCE s;
      

      The test case above kills a connection in the process of creating a sequence. Expected outcomes are that the sequence either doesn't get created, or is fully functional. However, most often it's created, but remains unusable, attempts to refer to it end up with ER_KEY_NOT_FOUND:

      10.3 96cee524fe

      mysqltest: At line 8: query 'SELECT NEXTVAL(s)' failed with wrong errno 1032: 'Can't find record in 's'', instead of 0...
      

      It fails nearly every time for me, but it's still a race condition, so sometimes it misses the mark. Run with --repeat if it doesn't fail for you.

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: