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

Querying OQGraph table fails with error 1017

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

            andymc73 Andrew McDonnell added a comment - - edited

            Once case it fails when the length of the backing store name > length of oqgraph table name
            Although on reflection looking more like a zero terminated problem.

            andymc73 Andrew McDonnell added a comment - - edited Once case it fails when the length of the backing store name > length of oqgraph table name Although on reflection looking more like a zero terminated problem.

            I don't think so. I use the same table names in a different database (with a slightly shorter database name) and there it works fine.

            pprkut Heinz Wiesinger added a comment - I don't think so. I use the same table names in a different database (with a slightly shorter database name) and there it works fine.

            I have pushed the fix for this in my branch https://code.launchpad.net/~andymc73/maria/oqgraph-maintenance , commit 3974

            andymc73 Andrew McDonnell added a comment - I have pushed the fix for this in my branch https://code.launchpad.net/~andymc73/maria/oqgraph-maintenance , commit 3974

            Was lack of C explicit zero termination randomly causing a fail

            andymc73 Andrew McDonnell added a comment - Was lack of C explicit zero termination randomly causing a fail

            This was merged in 10.0.11 and tests currently pass, so I hope I can take the liberty of resolving it...

            andymc73 Andrew McDonnell added a comment - This was merged in 10.0.11 and tests currently pass, so I hope I can take the liberty of resolving it...

            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.