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

Querying OQGraph table fails with error 1017

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.10
    • 10.0.11
    • None
    • CentOS 6

    Description

      I created an OQGraph table and pointed it to an existing MyISAM table that already contains data. Upon querying the OQGraph table I see

      MariaDB [MidSchipDB_unstable]> SELECT * FROM version_history;
      ERROR 1017 (HY000): Can't find file: './MidSchipDB_unstable/db_history@=Cܹ' (errno: 2 "No such file or directory")

      My setup is:

      MariaDB [MidSchipDB_unstable]> SHOW CREATE TABLE db_history \G
             Table: db_history
      Create Table: CREATE TABLE `db_history` (
        `version` varchar(10) NOT NULL,
        `updateJSON` mediumtext,
        `prevVersion` varchar(10) NOT NULL,
        `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0',
        `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0',
        PRIMARY KEY (`prevNodeID`,`nodeID`),
        KEY `prevVersion` (`prevVersion`) USING BTREE,
        KEY `version` (`version`) USING BTREE,
        KEY `nodeID` (`nodeID`)
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8
      1 row in set (0.00 sec)
       
      MariaDB [MidSchipDB_unstable]> SELECT COUNT(*) FROM db_history;
      +----------+
      | COUNT(*) |
      +----------+
      |      129 |
      +----------+
      1 row in set (0.00 sec)

      MariaDB [MidSchipDB_unstable]> CREATE TABLE IF NOT EXISTS version_history (
          ->     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='db_history'
          ->   origid='prevNodeID'
          ->   destid='nodeID';
      Query OK, 0 rows affected (0.01 sec)

      Attachments

        Issue Links

          Activity

            People

              andymc73 Andrew McDonnell
              pprkut Heinz Wiesinger
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.