Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Relationships not deleted in ON_DISK_TRANSACTIONAL #1920

Open
matea16 opened this issue Apr 9, 2024 · 0 comments
Open

Relationships not deleted in ON_DISK_TRANSACTIONAL #1920

matea16 opened this issue Apr 9, 2024 · 0 comments
Labels
bug bug community community Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime on-disk Reach - VeryFew Reach - VeryFew Severity - S2 Severity - S2

Comments

@matea16
Copy link

matea16 commented Apr 9, 2024

Memgraph version
2.15.1.

Running Memgraph with Docker compose and ON_DISK_TRANSACTIONAL storage mode. After importing a simple dataset from cypherl file and running MATCH (n) DETACH DELETE n;, relationships are left hanging

To Reproduce
Steps to reproduce the behavior:

  1. Run Memgraph in ON_DISK_TRANSACTIONAL storage mode
  2. import the following simple cypherl file:
CREATE INDEX ON :__mg_vertex__(__mg_id__);
CREATE (:__mg_vertex__:`Node` {__mg_id__: 0, `id`: 1});
CREATE (:__mg_vertex__:`Node` {__mg_id__: 1, `id`: 2});
CREATE (:__mg_vertex__:`Node` {__mg_id__: 2, `id`: 3});
MATCH (u:__mg_vertex__), (v:__mg_vertex__) WHERE u.__mg_id__ = 0 AND v.__mg_id__ = 1 CREATE (u)-[:`CONNECTED_TO`]->(v);
MATCH (u:__mg_vertex__), (v:__mg_vertex__) WHERE u.__mg_id__ = 0 AND v.__mg_id__ = 2 CREATE (u)-[:`CONNECTED_TO`]->(v);
MATCH (u:__mg_vertex__), (v:__mg_vertex__) WHERE u.__mg_id__ = 1 AND v.__mg_id__ = 2 CREATE (u)-[:`CONNECTED_TO`]->(v);
DROP INDEX ON :__mg_vertex__(__mg_id__);
MATCH (u) REMOVE u:__mg_vertex__, u.__mg_id__;
  1. Run MATCH (n) DETACH DELETE n;

Additional context
Expected behavior is a clear database, but relationships are still shown in the count. After trying to import the .cypherl file again and choosing "Drop database and start from scratch", relationships keep pilling up

@matea16 matea16 added bug bug community community Effort - Unknown Effort - Unknown Severity - S2 Severity - S2 Frequency - EveryTime Frequency - EveryTime Reach - VeryFew Reach - VeryFew labels Apr 9, 2024
@gitbuda gitbuda added the on-disk label May 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug bug community community Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime on-disk Reach - VeryFew Reach - VeryFew Severity - S2 Severity - S2
Projects
Development

No branches or pull requests

2 participants