[MDEV-13931] OQgraph fails to create graph table - Ubuntu 16.04 Created: 2017-09-28  Updated: 2017-11-05  Resolved: 2017-11-05

Status: Closed
Project: MariaDB Server
Component/s: Plugins
Affects Version/s: 10.0.31
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mr A Kitson Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Ubuntu 16.04
mariadb-server - 10.0.31-0ubuntu0.16.04.2
OQGraph - mariadb-plugin-oqgraph 10.0.24-7


 Description   

The creation of the graph table does not work as described:

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';

Using the workaround does not work either:

SET GLOBAL oqgraph_allow_create_integer_latch=1;
 
 
 
CREATE TABLE oq_old (
 
  latch SMALLINT UNSIGNED 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';



 Comments   
Comment by Elena Stepanova [ 2017-09-30 ]

Please specify what exactly does not work, and how.

Comment by Mr A Kitson [ 2017-10-02 ]

@elena

As per original post. Creation of table fails. in both cases I get

[HY000][1005] Can't create table `test`.`oq_graph|oq_old` (errno: 140 "Wrong create options")

Comment by Elena Stepanova [ 2017-10-02 ]

Please run SHOW WARNINGS right after you get the error, and paste the full output. Please also attach your cnf file(s) or the output of SHOW VARIABLES.

Generated at Thu Feb 08 08:09:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.