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. |
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| 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: ``` 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. ``` |
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: {code:sql} 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 ); {code} I created OQGraph table with this DDL: {code:sql} CREATE TABLE personParentGraph ENGINE=OQGRAPH data_table='personParent' origid='person_id' destid='parent_id'; {code} SysLog: {code:bash} 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. {code} |
| 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: {code:sql} 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 ); {code} I created OQGraph table with this DDL: {code:sql} CREATE TABLE personParentGraph ENGINE=OQGRAPH data_table='personParent' origid='person_id' destid='parent_id'; {code} SysLog: {code:bash} 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. {code} |
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: {code:sql} 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 ); {code} I created OQGraph table with this DDL: {code:sql} CREATE TABLE personParentGraph ENGINE=OQGRAPH data_table='personParent' origid='person_id' destid='parent_id'; {code} SysLog: OS: Ubuntu 22.04.1 LTS, Version: mariadb-server 1:10.9.5+maria~ubu2204 amd64 {code:bash} 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. {code} |
| Assignee | Andrew Hutchings [ JIRAUSER52179 ] |
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Affects Version/s | 10.9.5 [ 28519 ] |
| Fix Version/s | 10.9 [ 26905 ] |
| Labels | bug | bug not-10.4 |
| Fix Version/s | 10.11 [ 27614 ] |
| Fix Version/s | 10.9 [ 26905 ] |
| Assignee | Andrew Hutchings [ JIRAUSER52179 ] |