oqgraph-dev team mailing list archive

[Andrew McDonnell <bugs@xxxxxxxxxxxxxxxxxxx>]

bug 1195735 only handles TRUNCATE TABLE case - because when the count is updated to zero this is picked up.
But otherwise, this goes into an infinite loop now instead of returning the wrong count...

So as guessed, changes to underlying data not getting reflected.
Maybe we need to re-open the table when a new random scan is started...

-- 
You received this bug notification because you are a member of OQgraph
developers, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/796647

Title:
  oqgraphv3. Read only but no updates from basetable

Status in OQGraph Engine for MariaDB:
  Confirmed

Bug description:
  Moin,
  MariaDB [test]> select * from  information_schema.PLUGINS where PLUGIN_NAME="OQGRAPH"\G
  *************************** 1. row ***************************
             PLUGIN_NAME: OQGRAPH
          PLUGIN_VERSION: 3.0
           PLUGIN_STATUS: ACTIVE
             PLUGIN_TYPE: STORAGE ENGINE
     PLUGIN_TYPE_VERSION: 50300.0
          PLUGIN_LIBRARY: ha_oqgraph.so
  PLUGIN_LIBRARY_VERSION: 0.0
           PLUGIN_AUTHOR: Arjen Lentz & Antony T Curtis, Open Query
      PLUGIN_DESCRIPTION: Open Query Graph Computation Engine (http://openquery.com/graph)
          PLUGIN_LICENSE: GPL
         PLUGIN_MATURITY: Unknown
     PLUGIN_AUTH_VERSION: Unknown
  MariaDB [test]> select version();
  +---------------------+
  | version()           |
  +---------------------+
  | 5.3.0-MariaDB-alpha |
  +---------------------+

  Its great you can use persistent tables to store the graph. A drawback with version v3 is if you chenge the base/persistent table it is ignored by the memory-table. Dropping/creating the memory-table is a workaround.
  MariaDB [test]> desc base;
  +--------+---------+------+-----+---------+-------+
  | Field  | Type    | Null | Key | Default | Extra |
  +--------+---------+------+-----+---------+-------+
  | von    | int(11) | NO   | PRI | NULL    |       |
  | nach   | int(11) | NO   | PRI | NULL    |       |
  | weight | double  | NO   |     | NULL    |       |
  +--------+---------+------+-----+---------+-------+
  MariaDB [test]> desc graph; 
  +--------+----------------------+------+-----+---------+-------+
  | Field  | Type                 | Null | Key | Default | Extra |
  +--------+----------------------+------+-----+---------+-------+
  | latch  | smallint(5) unsigned | YES  | MUL | NULL    |       |
  | origid | bigint(20) unsigned  | YES  |     | NULL    |       |
  | destid | bigint(20) unsigned  | YES  |     | NULL    |       |
  | weight | double               | YES  |     | NULL    |       |
  | seq    | bigint(20) unsigned  | YES  |     | NULL    |       |
  | linkid | bigint(20) unsigned  | YES  |     | NULL    |       |
  +--------+----------------------+------+-----+---------+-------+

  3 rows in the basetable:
  MariaDB [test]> SELECT * FROM base;
  +-----+------+--------+
  | von | nach | weight |
  +-----+------+--------+
  |   3 |    5 |      2 |
  |   5 |    4 |      1 |
  |   5 |    6 |      1 |
  +-----+------+--------+

  and in the graph-table
  MariaDB [test]> SELECT * from graph;
  +-------+--------+--------+--------+------+--------+
  | latch | origid | destid | weight | seq  | linkid |
  +-------+--------+--------+--------+------+--------+
  |  NULL |      3 |      5 |      2 | NULL |   NULL |
  |  NULL |      5 |      4 |      1 | NULL |   NULL |
  |  NULL |      5 |      6 |      1 | NULL |   NULL |
  +-------+--------+--------+--------+------+--------+

  but:
  MariaDB [test]> insert into base values(6,3,1);
  MariaDB [test]> SELECT * FROM base;
  +-----+------+--------+
  | von | nach | weight |
  +-----+------+--------+
  |   3 |    5 |      2 |
  |   5 |    4 |      1 |
  |   5 |    6 |      1 |
  |   6 |    3 |      1 |
  +-----+------+--------+

  MariaDB [test]> SELECT * from graph;
  +-------+--------+--------+--------+------+--------+
  | latch | origid | destid | weight | seq  | linkid |
  +-------+--------+--------+--------+------+--------+
  |  NULL |      3 |      5 |      2 | NULL |   NULL |
  |  NULL |      5 |      4 |      1 | NULL |   NULL |
  |  NULL |      5 |      6 |      1 | NULL |   NULL |
  +-------+--------+--------+--------+------+--------+

  Is this going to be fixed?
  Or a design-issue?

  Regards
  Erkan
  (btw: why do I need keys on the base-table?)

To manage notifications about this bug go to:
https://bugs.launchpad.net/oqgraph/+bug/796647/+subscriptions