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

Change the error when table schema mismatch happens

    XMLWordPrintable

Details

    Description

      Workflow
      1. A session connects and creates the table t1 and inserts one record.
          CREATE TABLE t1 (col1 INT, col2 INT, col3 INT, col4 TEXT) ENGINE = InnoDB ;
          ALTER TABLE t1 ADD PRIMARY KEY ( col4(10), col2 ) ;
          INSERT INTO t1 (col2,col4) VALUES(2, 'Sooo inportant data');
          Mode is auto commit.
      2. The same session runs random
           ALTER TABLE t1 FORCE         or
           ALTER TABLE t1 ADD COLUMN extra INT; ALTER TABLE t1 DROP COLUMN col3 ; ALTER TABLE t1 CHANGE COLUMN extra col3 INT ;
      3. At some point of time the server process gets killed (SIGKILL).
      4. The server gets restartet.
      5. Now
           SHOW KEYS FROM `test`.`t1` harvests  (~ 1 case on 50 runs)
          1932: Table 'test.t1' doesn't exist in engine.
      6. RQG kills the server process with SIGKILL because of 5.
       
      origin/10.4 cfbbf5424bc68a31a996ab42a253f2c96365599c 2020-04-29T11:50:03+03:00
      no matter if compiled with debug or not
      
      

      Attachments

        1. 000047.log
          833 kB
          Matthias Leich
        2. mdev-22140.patch
          0.8 kB
          Thirunarayanan Balathandayuthapani

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            mleich Matthias Leich
            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.