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

Number of indexes in OQGraph backing table differs in InnoDB and .frm

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      INSTALL SONAME 'ha_oqgraph';
       
      CREATE TABLE oq_backing (origid INT UNSIGNED NOT NULL, destid INT UNSIGNED NOT NULL, PRIMARY KEY (origid, destid), KEY (destid)) ENGINE=InnoDB;
      CREATE TABLE oq (latch VARCHAR(32) NULL, origid BIGINT UNSIGNED NULL, destid BIGINT UNSIGNED NULL, weight DOUBLE NULL, seq BIGINT UNSIGNED NULL, linkid BIGINT UNSIGNED NULL, KEY (latch, origid, destid) USING HASH, KEY (latch, destid, origid) USING HASH) ENGINE=OQGRAPH data_table='oq_backing' origid='origid' destid='destid';
      SELECT * FROM oq WHERE latch = 1 AND destid = 35976;
      ALTER TABLE oq_backing ADD KEY ind1 (origid, destid);
      SELECT * FROM oq WHERE latch = 0;
      

      10.3 0ca3aaa7

      SELECT * FROM oq WHERE latch = 0;
      latch	origid	destid	weight	seq	linkid
      Warnings:
      Warning	1082	InnoDB: Table test/oq_backing contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB 
      bug.ref2 'innodb'                        [ fail ]  Found warnings/errors in server log file!
              Test ended at 2022-12-21 15:20:57
      line
      2022-12-21 15:20:56 9 [ERROR] InnoDB: Table test/oq_backing contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB  Have you mixed up .frm files from different installations? See https://mariadb.com/kb/en/innodb-troubleshooting/
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.