OQGRAPH

using MySQL version: 5.0.85-d10-ourdelta-sail

I have a graph in which I want to be able to dynamically update the weights of any edge from a given vertex.

Currently, there are ~115,000 connections.

I tried grabbing all the out- and in-edges for a given node and then for each relationship (as suggested from documentation):

UPDATE relationships SET weight = 100 WHERE destid = 1 and origid = 2;

However, this takes approximately 45 - 60 seconds per relationship.

I also tried this:

UPDATE relationships SET weight = 100 WHERE destid = 1 AND latch = 0;

Hoping to subsequently run the same command for departing edges. However, this is the error message I get:

ERROR 1194 (HY000): Table 'relationships' is marked as crashed and should be repaired

I'v tried to create several self pointing edges for ex: INSERT INTO `test_graph`.`edge` (`latch`, `origid`, `destid`, `weight`, `seq`, `linkid`) VALUES (NULL, '1', '1', NULL, NULL, NULL);

Running the same query leads to creating a doublicate record Unique Error doesn't fires

using: 5.0.87-d10-ourdelta-sail66 on ubuntu 9.10

PS. Also self looping edges become undeletable try: DELETE FROM `test_graph`.`edge` WHERE origid=1;

P.S. It doesn't happens every time. It seems that it happens under some strange conditions, I'll will try to analyse but I have no additional information

Is this a bug or am I simply doing something wrong?

I have the following table:
MariaDB [test]> select * from test_model_oqgraph;
+-------+--------+--------+--------+------+--------+
| latch | origid | destid | weight | seq | linkid |
+-------+--------+--------+--------+------+--------+
| NULL | 1 | 2 | 1 | NULL | NULL |
| NULL | 2 | 3 | 1 | NULL | NULL |
+-------+--------+--------+--------+------+--------+
2 rows in set (0.00 sec)

If I do this I get the out edges correctly:
MariaDB [test]> select * from test_model_oqgraph where latch=0 and origid=2;
+-------+--------+--------+--------+------+--------+
| latch | origid | destid | weight | seq | linkid |
+-------+--------+--------+--------+------+--------+

Tried to follow the INSTALL doc and I got this after 'make':

make[2]: Entering directory `/local/tmp/openquery/oqgraph/engine/src'
if /bin/sh ../libtool --preserve-dup-deps --tag=CXX --mode=compile g++ -DHAVE_CONFIG_H -I. -I. -I. -DDBUG_ON -DSAFE_MUTEX -DUNIV_MUST_NOT_INLINE -DEXTRA_DEBUG -DFORCE_INIT_OF_VARS -DSAFEMALLOC -DPEDANTIC_SAFEMALLOC -DSAFE_MUTEX -DHAVE_OQGRAPH -I/local/tmp/mysql-5.1.45/sql -I/local/tmp/mysql-5.1.45/include -I/local/tmp/mysql-5.1.45/regex -I/local/tmp/mysql-5.1.45 -g -O2 -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQL_DYNAMIC_PLUGIN -MT oqgraph_engine_la-ha_oqgraph.lo -MD -MP -MF ".deps/oqgraph_engine_la-ha_oqgraph.Tpo" -c -o oqgraph_engine_la-ha_oqgraph.lo `test -f 'ha_oqgraph.cc' || echo './'`ha_oqgraph.cc; \