Galera Server: Unknown Option

[Brian LaVallee]

Not important, low priority, and just something that I tired....
File it away however you like, but personally think it would be nice to have Galera support.

After a few tries... I was able to add the OQGRAPH to MariaDB-Galera-10.0.12-centos6-i686-server. (rpm --nodeps)

Anyway, it installed cleanly, was listed under 'show engines', but wouldn't create an a table.

MariaDB [test]> CREATE TABLE oq_graph (
    -> 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='oq_backing' origid='origid' destid='destid';
ERROR 1911 (HY000): Unknown option 'data_table'

[Federico Razzoli (santec)]

I was unable to find out if OQGRAPH can reliably be used with MariaDB+Galera. Galera support is very important for me, because I need to move from native replication to Galera.

[Arjen Lentz (arjen-lentz)]

Hi Federico
That error 1911 Unknown option is most curious, because of course the data_table option is definitely known.
The code might be reporting back the wrong error, so we need to work out what the actual problem was.

OQGRAPH should work with Galera, provided you use InnoDB backing tables.
If it doesn't, that'd be a bug.

All that said, if you are able to report the bug on MariaDB's JIRA tracker, that'd be great - that's where everything happens these days. I have assigned the issue here to Andrew McDonnell anyway, so he will be aware.
thanks

[Nirbhay Choubey (nirbhay)]

Upstream bug : https://mariadb.atlassian.net/browse/MDEV-8240