The apoc.periodic.truncate procedure doesn't provide a feedback if fails

[neo-technology-build-agent]

Issue by vga91
Wednesday Oct 27, 2021 at 12:26 GMT
Originally opened as neo4j-contrib/neo4j-apoc-procedures#2266

---

The apoc.periodic.truncate procedure doesn't provide a feedback if fails (for example if dbms.memory.transaction.database_max_size is reached)

Expected Behavior (Mandatory)

Should fails

Actual Behavior (Mandatory)

Doesn't return nothing and doesn't cancel all db.

Steps (Mandatory)

1. Create a relatively big graph, for example unwind range(0, 9999) as range create (:Node)-[:REL]->(:Other)
2. Set dbms.memory.transaction.database_max_size=10M in neo4j.conf and restart
3. CALL apoc.periodic.truncate

Versions

• OS: Mac BigSur
• Neo4j: 4.3.3
• Neo4j-Apoc: 4.3.0.3

[hvub]

Related: #56

In current versions of Neo4j (5.25.1) there is no dbms.memory.transaction.database_max_size option, cf. https://neo4j.com/docs/operations-manual/current/configuration/configuration-settings/

Please note — as pointed out neo4j/neo4j#13097) — that "any local memory within a CALL is not counted towards the transaction memory limit due to current limitations in our procedure API". This may improve in the future.