Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.9.5
Description
I was experimenting with what OQGraph is capable of.
My first query was made my MariaDB server killed
The query:
`SELECT * FROM personParentGraph WHERE latch='dijkstras' AND origid=1 AND destid=2;`
My Backing table:
CREATE TABLE personParent ( |
person_id INTEGER UNSIGNED, |
parent_id INTEGER UNSIGNED, |
PRIMARY KEY (person_id, parent_id), |
FOREIGN KEY (person_id) REFERENCES person(id) ON UPDATE CASCADE, |
FOREIGN KEY (parent_id) REFERENCES person(id) ON UPDATE CASCADE |
);
|
I created OQGraph table with this DDL:
CREATE TABLE personParentGraph |
ENGINE=OQGRAPH
|
data_table='personParent' origid='person_id' destid='parent_id'; |
SysLog:
OS: Ubuntu 22.04.1 LTS,
Version: mariadb-server 1:10.9.5+maria~ubu2204 amd64
Apr 4 19:58:19 localhost systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
|
Apr 4 19:58:20 localhost systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL |
Apr 4 19:58:20 localhost systemd[1]: mariadb.service: Failed with result 'oom-kill'. |
Apr 4 19:58:20 localhost systemd[1]: mariadb.service: Consumed 20.742s CPU time. |
|