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

Querying OQGraph table fails with error 1017

    Details

    • Type: Bug
    • Status: Closed
    • 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)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              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.

              Show
              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.
              Hide
              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.

              Show
              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.
              Hide
              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

              Show
              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
              Hide
              andymc73 Andrew McDonnell added a comment -

              Was lack of C explicit zero termination randomly causing a fail

              Show
              andymc73 Andrew McDonnell added a comment - Was lack of C explicit zero termination randomly causing a fail
              Hide
              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...

              Show
              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

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: