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

InnoDB: Ignoring strange row from mysql.innodb_index_stats after valid DDL.

    XMLWordPrintable

    Details

      Description

      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      CREATE TABLE t1 ( col1 INTEGER, col2 INTEGER ) ENGINE = InnoDB;
      ALTER TABLE t1 ADD PRIMARY KEY ( col2, col1 ) ;
      ALTER TABLE t1 DROP PRIMARY KEY, ADD INDEX ( col2, col1 ) ;
      ALTER TABLE t1 ADD PRIMARY KEY ( col2, col1 ) ;
      ALTER TABLE t1 ADD PRIMARY KEY ( col2, col1 ) ;
      main.strange_row 'innodb'                [ fail ]
              Test ended at 2021-06-17 12:30:27
       
      CURRENT_TEST: main.strange_row
      mysqltest: At line 8: query 'ALTER TABLE t1 ADD PRIMARY KEY ( col2, col1 ) ' failed: <Unknown> (2013): Lost connection to server during query
           The crash is caused by changing ib::info to ib::fatal in storage/innobase/dict/dict0stats.cc.
       
      The server error log shows
      2021-06-17 12:30:25 0 [Note] /data/Server_bin/bb-10.6-MDEV-25062H_asan/bin/mariadbd: ready for connections.
      Version: '10.6.2-MariaDB-debug-log'  socket: '/data/Server_bin/bb-10.6-MDEV-25062H_asan/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      2021-06-17 12:30:26 4 [ERROR] [FATAL] InnoDB: Ignoring strange row from mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 't1' AND index_name = 'col2' AND stat_name = 'n_diff_pfx03'; because stat_name is out of range, the index has 2 unique columns
       
      bb-10.6-MDEV-25062 commit 3fdd9844f3567f58f60693e4fa8979fa3fefe929
      origin/10.6 commit f778a5d5e2aaff7c58000f9e2423a809db14747c
      

        Attachments

        1. info_to_fatal.diff
          0.8 kB
        2. strange_row.opt
          0.1 kB
        3. strange_row.test
          0.3 kB

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration