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

Querying OQGraph table fails with error 1017

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      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

              Assignee:
              andymc73 Andrew McDonnell
              Reporter:
              pprkut Heinz Wiesinger
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration