List of all server notification codes

If a part of a query contains multiple disconnected patterns, this will build a cartesian product between all those parts. This may produce a large amount of data and slow down query processing. While occasionally intended, it may often be possible to reformulate the query that avoids the use of this cross product, perhaps by adding a relationship between the different parts or by using OPTIONAL MATCH (identifier is: (p))

In case a Cartesian product is needed, nothing can be done to improve this query. In many cases, however, you might not need a combination of all children and parents, and that is when this query could be improved. If for example, you need the children and the children’s parents, you can improve this query by rewriting it to the following:

MATCH (c:Child)-[:ChildOf]->(p:Parent) RETURN c, p

Using shortest path with an unbounded pattern will likely result in long execution times. It is recommended to use an upper limit to the number of node hops in your pattern.

If you have a big graph, this query might be very slow. Consider adding an upper limit.

MATCH p=shortestPath((n)-[*..8]->(m))
WHERE n <> m
RETURN p

Using shortest path with an exhaustive search fallback might cause query slow down since shortest path graph algorithms might not work for this use case. It is recommended to introduce a WITH to separate the MATCH containing the shortest path from the existential predicates on that path.

Separate the predicate by introducing a WITH after the MATCH clause.

MATCH p = shortestPath(()-[*..42]-())
WITH p
WHERE ANY(n in nodes(p) WHERE n:Label)
RETURN p

Using LOAD CSV followed by a MATCH or MERGE that matches a non-indexed label will most likely not perform well on large data sets. Please consider using a schema index.

Create an index on the label and property you match.

CREATE INDEX FOR (n:Person) ON (n.name)

Using LOAD CSV with a large data set in a query where the execution plan contains the Eager operator could potentially consume a lot of memory and is likely to not perform well. See the Neo4j Manual entry on the Eager operator for more information and hints on how problems could be avoided.

See the Cypher Manual → Eager operator for more information and hints on how to avoid problems. In this specific case, the query could be rewritten to the following:

LOAD CSV FROM 'file:///ignore/ignore.csv' AS line
CALL {
    WITH line
    MATCH (n:Person{name:line[0]}) DELETE n
}
RETURN line

Using a dynamic property makes it impossible to use an index lookup for this query (indexed label is: Person)

If there is an index for (n:Person) ON (n.name), it will not be used for the above query because the query is using a dynamic property. Therefore, if there is an index, it is better to use the constant value. For example, if prop is equal to name, the following query would be able to use the index:

MATCH (n:Person) WHERE n.name IS NOT NULL RETURN n;

Using a dynamic property makes it impossible to use an index lookup for this query (indexed type is: KNOWS)

Similar to dynamic node properties, use a constant value if possible, especially when there is an index on the relationship property. For example, if { $prop } is equal to since, you can rewrite the query to:

MATCH ()-[r: KNOWS]->() WHERE r.since IS NOT NULL RETURN r

The hinted join was not planned. This could happen because no generated plan contained the join key, please try using a different join key or restructure your query. (hinted join key identifier is: a)

The JOIN hint cannot be applied because its specified variable is before the OPTIONAL MATCH and, therefore, is already bound. The only option for this query is to either remove the hint or modify the query to allow it to be used.

The hinted index does not exist, please check the schema (index is: INDEX FOR (a:`Label`) ON (a.id))

The hinted index does not exist, make sure the label and property are spelled correctly. If the spelling is correct, either create the index or remove the hint from the query.

The hinted index does not exist, please check the schema (index is: INDEX FOR ()-[r:`Rel`]-() ON (r.id))

The hinted index does not exist, make sure the relationship type and property are spelled correctly. If the spelling is correct, either create the index or remove the hint from the query.

The home database provided does not currently exist in the DBMS. This command will not take effect until this database is created. (HOME DATABASE: nej4)

Verify that the home database name is not misspelled.

One of the labels in your query is not available in the database, make sure you didn’t misspell it or that the label is available when you run this statement in your application (the missing label name is: Perso)

Verify that the label is not misspelled. If you plan to create nodes with that label in the future, then no change is needed.

One of the relationship types in your query is not available in the database, make sure you didn’t misspell it or that the label is available when you run this statement in your application (the missing relationship type is: NonExistingType)

Verify that the relationship type is not misspelled. If you plan to create relationships of this type in the future, no change is needed.

One of the property names in your query is not available in the database, make sure you didn’t misspell it or that the label is available when you run this statement in your application (the missing property name is: nme)

Verify that the property key is not misspelled. If you plan to create that property key in the future, no change is needed.

The query contains an aggregation function that skips null values.

Selected runtime is unsupported for this query, please use a different runtime instead or fallback to default. (Pipelined does not yet support the plans including ShowIndexes, use another runtime.)

Use a different runtime or remove the runtime option to run the query with the default runtime:

SHOW INDEXES YIELD *

Databases and aliases with unescaped . are deprecated unless to indicate that they belong to a composite database. Names containing . should be escaped. (Name: foo.bar)

If not intended for a composite database, escape the name with the character `.

CREATE DATABASE `foo.bar`

All subqueries in a UNION [ALL] should have the same ordering for the return columns. Using differently ordered return items in a UNION [ALL] clause is deprecated and will be removed in a future version.

Use the same order for the return columns in all subqueries combined by a UNION clause.

RETURN 'val' as one, 'val' as two
UNION
RETURN 'val' as one, 'val' as two

The Unicode character \u0085 is deprecated for unescaped identifiers and will be considered as a whitespace character in the future. To continue using it, escape the identifier by adding backticks around the identifier my\u0085identifier.

The semantics of using colon in the separation of alternative relationship types will change in a future version. (Please use ':A|B|C' instead)

Remove the colon inside the relationship type expression.

MATCH (a)-[:A|B|C]-() RETURN *

The use of nodes or relationships for setting properties is deprecated and will be removed in a future version. Please use properties() instead.

Use the properties() function to get all properties from b.

MATCH (a)-[]-(b)
SET a = properties(b)

The use of nodes or relationships for setting properties is deprecated and will be removed in a future version. Please use properties() instead.

Use the properties() function to get all properties from r.

MATCH (a)-[r]-(b)
SET a += properties(r)

The use of shortestPath and allShortestPaths with fixed length relationships is deprecated and will be removed in a future version. Please use a path with a length of 1 [r*1..1] instead or a Match with a limit.

If the relationship length is fixed, there is no reason to search for the shortest path. Instead, you can rewrite it to the following:

MATCH (a: Start)-[r]->(b: End) RETURN b LIMIT 1

The query used a deprecated runtime option. ('runtime=interpreted' is deprecated, please use 'runtime=slotted' instead)

Runtime interpreted is deprecated and another runtime is used instead. Alternatively, you can remove the runtime option to use the default runtime.

MATCH (n) RETURN n

The text-1.0 provider for text indexes is deprecated and will be removed in a future version. Please use text-2.0 instead.

Update the option indexProvider with the value text-2.0.

CREATE TEXT INDEX FOR (n:Label) ON (n.prop) OPTIONS {indexProvider : 'text-2.0'}

The query used a deprecated procedure: 'unsupported.dbms.shutdown'.

Remove the use of the deprecated procedure. If there is a suggested replacement, update to use the replacement instead.

The query used a deprecated function: id.

Use the function elementId() instead.

MATCH (a)
RETURN elementId(a)

'(where {p: 5})' is deprecated. It is replaced by '(`where` {p: 5})'.

To continue using variables with this name, use backticks to escape the variable name:

MATCH (`where` {p: 5})
RETURN `where`.p

'-[where {p: 5}]-' is deprecated. It is replaced by '-[`where` {p: 5}]-'.

To continue using variables with this name, use backticks to escape the variable name:

MATCH ()-[`where` {p: 5}]->()
RETURN `where`.p

'…​ + m:A' is deprecated. It is replaced by '…​ + (m:A)'.

Parenthesize the label expression predicate on the right-hand side of +:

MATCH (n)-[r]->(m)
WITH m, n.truthCodes AS listOfBooleans
RETURN listOfBooleans + (m:A)

'…​ + r:C|D' is deprecated. It is replaced by '…​ + (r:C|D)'.

Parenthesize the label expression predicate on the right-hand side of +:

MATCH (n)-[r]->(m)
WITH r, n.truthCodes AS listOfBooleans
RETURN listOfBooleans + (r:C|D)

INTEGER' is deprecated. It is replaced by 'WHEN `is` :: INTEGER'.

To continue using variables with this name in simple CASE expressions, use backticks to escape the variable name:

MATCH (n)
WITH n, n.internationalStandard AS `is`
RETURN CASE n
  WHEN `is` :: INTEGER THEN "ISO/IEC" + `is`
  ELSE `is`
END AS standardsName

'WHEN contains + 1 INTEGER' is deprecated. It is replaced by 'WHEN `contains` + 1 INTEGER'.

To continue using variables with this name in simple CASE expressions, use backticks to escape the variable name:

MATCH p = (:A)-[:HAS]->(:B)
WITH p, size(relationships(p)) AS `contains`
RETURN CASE size(nodes(p))
  WHEN `contains` + 1 THEN "okay"
  ELSE "not okay"
END AS check

'WHEN contains - 1 INTEGER' is deprecated. It is replaced by 'WHEN `contains` - 1 INTEGER'.

To continue using variables with this name in simple CASE expressions, use backticks to escape the variable name:

MATCH p = (:A)-[:HAS]->(:B)
WITH p, size(nodes(p)) AS `contains`
RETURN CASE size(relationships(p))
  WHEN `contains` - 1 THEN "okay"
  ELSE "not okay"
END AS check

'WHEN in[0] INTEGER' is deprecated. It is replaced by 'WHEN `in`[0] INTEGER'.

To continue using variables with this name in simple CASE expressions, use backticks to escape the variable name:

MATCH (c:Client)-[:MAKES]->(t:Transaction)
WITH t, c.ibanNumbers AS `in`
RETURN CASE t.ibanNumber
  WHEN `in`[0] THEN "used main account"
  ELSE "used different account"
END AS check

'WHEN in["mainAccount"] INTEGER' is deprecated. It is replaced by 'WHEN `in`["mainAccount"] INTEGER'.

To continue using variables with this name in simple CASE expressions, use backticks to escape the variable name:

MATCH (in:Client)-[:MAKES]->(t:Transaction)
RETURN CASE t.ibanNumber
  WHEN `in`["mainAccount"] THEN "used main account"
  ELSE "used different account"
END AS check

The Cypher query option connectComponentsPlanner is deprecated and will be removed without a replacement. The product’s default behavior of using a cost-based IDP search algorithm when combining sub-plans will be kept. For more information, see Cypher manual → Cypher planner.

REVOKE ROLE reader FROM jane has no effect.

The user does not have the role. See Status Codes documentation for more information.

Verify that this is the intended role and user.

REVOKE DENY WRITE ON GRAPH * FROM reader has no effect.

The role does not have the privilege. See Status Codes documentation for more information.

Verify that this is the intended privilege and role.

GRANT ROLE admin TO john has no effect.

The user already has the role. See Status Codes documentation for more information.

Verify that this is the intended role and user.

GRANT TRAVERSE ON GRAPH * NODE * TO reader has no effect.

The role already has the privilege. See Status Codes documentation for more information.

Verify that this is the intended privilege and role.

REVOKE ROLE manager FROM jane has no effect.

Role does not exist. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Verify that this is the intended role and that it is spelled correctly.

REVOKE ROLE reader FROM alice has no effect.

User does not exist. Make sure nothing is misspelled. This notification will become an error in a future major version.

Verify that this is the intended user and that it is spelled correctly.

REVOKE GRANT WRITE ON GRAPH * FROM manager has no effect.

Role does not exist. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Verify that this is the intended role and that it is spelled correctly.

REVOKE GRANT WRITE ON GRAPH neo3j FROM editor has no effect.

Database neo3j does not exist. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Verify that this is the intended graph and that it is spelled correctly.

REVOKE GRANT ACCESS ON DATABASE neo3j FROM editor has no effect.

Database neo3j does not exist. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Verify that this is the intended database and that it is spelled correctly.

REVOKE GRANT CREATE ON GRAPH $graph FROM PUBLIC has no effect.

Parameterized database and graph names do not support wildcards. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Use GRAPH * without the parameter to revoke the privilege on all graphs.

REVOKE GRANT ACCESS ON DATABASE $database FROM PUBLIC has no effect.

Parameterized database and graph names do not support wildcards. Make sure nothing is misspelled. This notification will become an error in a future major version. See Status Codes documentation for more information.

Use DATABASE * without the parameter to revoke the privilege on all databases.

The auth provider unknownProvider is not defined in the configuration. Verify that the spelling is correct or define unknownProvider in the configuration.

Make sure that the given provider is correct, or replace it if not. If it is correct, make sure to add it as a known auth provider in one or both of dbms.security.authentication_providers and dbms.security.authorization_providers.

The auth provider unknownProvider is not defined in the configuration. Verify that the spelling is correct or define unknownProvider in the configuration.

Make sure that the given provider is correct, or replace it if not. If it is correct, make sure to add it as a known auth provider in one or both of dbms.security.authentication_providers and dbms.security.authorization_providers.

Enable linked users through the dbms.security.require_local_user setting. Until enabled, the new external auth will be ignored, and current external auth behaviors will continue to apply.

Enable linked users through the dbms.security.require_local_user setting. Until enabled, the new external auth will be ignored, and current external auth behaviors will continue to apply.

Server 123e4567-e89b-12d3-a456-426614174000 is already enabled. Verify that this is the intended server.

Server 123e4567-e89b-12d3-a456-426614174000 is already cordoned. Verify that this is the intended server.

No databases were reallocated. No better allocation is currently possible.

Scenario 1: The cluster is already balanced. For example, when there are three servers, each hosting databases foo and bar, meaning all databases are allocated to all servers.

Server(s) 123e4567-e89b-12d3-a456-426614174000 are cordoned. This can impact allocation decisions.

The requested topology matched the current topology. No allocations were changed.

CREATE RANGE INDEX labelProperyRangeIndex IF NOT EXISTS FOR (e:Label) ON (e.property) has no effect.

RANGE INDEX existingRangeIndex FOR (e:Label) ON (e.property) already exists.

CREATE TEXT INDEX myIndex IF NOT EXISTS FOR ()-[e:REL_TYPE]-() ON (e.property) has no effect.

RANGE INDEX myIndex FOR (e:Label) ON (e.property) already exists.

Choose a different name for the new index and try again.

CREATE TEXT INDEX myIndex2 IF NOT EXISTS FOR ()-[r:REL_TYPE]-() ON (r.property)

CREATE CONSTRAINT nodeKeyLabelPropertyConstraint IF NOT EXISTS FOR (e:Label) REQUIRE (e.property) IS NODE KEY has no effect.

CONSTRAINT nodeKeyLabelPropertyConstraint FOR (e:Label) REQUIRE (e.property) IS NODE KEY already exists.

CREATE CONSTRAINT myConstraint IF NOT EXISTS FOR (e:Label2) REQUIRE (e.property2) IS NOT NULL has no effect.

CONSTRAINT myConstraint FOR (e:Label) REQUIRE (e.property) IS NODE KEY already exists.

Choose a different name for the new constraint and try again.

CREATE CONSTRAINT myConstraint2 IF NOT EXISTS FOR (n:Label2) REQUIRE (n.property2) IS NOT NULL

DROP INDEX nonExistingIndex IF EXISTS has no effect.

nonExistingIndex does not exist.

Verify that this is the intended index and that it is spelled correctly.

DROP CONSTRAINT nonExistingConstraint IF EXISTS has no effect.

nonExistingConstraint does not exist.

Verify that this is the intended constraint and that it is spelled correctly.

Variable in subquery is shadowing a variable with the same name from the outer scope. If you want to use that variable instead, it must be imported into the subquery using importing WITH clause. (the shadowing variable is: n)

If the intended behavior of the query is for the variable in the subquery to be a new variable, then nothing needs to be done. If the intended behavior is to use the variable from the outer query, it needs to be imported to the subquery using the WITH clause.

MATCH (n)
CALL {
  WITH n
  MATCH (n)--(m)
  RETURN m
}
RETURN *

The use of OPTIONAL is redundant as CALL db.createLabel is a void procedure.

If the intended behavior of the query is to use a void procedure, the OPTIONAL keyword can be removed without impacting the query.

CALL db.createLabel("A")

Optional is redundant in the case of a unit subquery. The use of OPTIONAL on unit subqueries have no effect and can be removed.

If the intended behavior of the query is for the subquery not to return any values, the OPTIONAL keyword can be removed without impacting the query.

UNWIND [1, 2, 3] AS x
CALL (x) {
   CREATE({i:x})
}

Did not supply query with enough parameters. The produced query plan will not be cached and is not executable without EXPLAIN. (Missing parameters: param)

Provide the parameter to be able to cache the plan.