When attempting to push to cloud from Neo4j.com desktop where there are native legacy indexes present, the push-to cloud will fail with the following error.
ERROR: Source dumpfile has legacy indexes enabled, which we do not support. User needs to manually follow instructions in neo4j logs to upgrade indexes.
To resolve the issue carry out the following steps :
- If you are not on version 3.5, upgrade your local database to the latest 3.5 following these instructions : https://neo4j.com/docs/operations-manual/current/upgrade/deployment-upgrading/#upgrade-instructions-3x
- In your local graph, use
CALL db.constraints() YIELD description
to get a list of the indexes and their types. This will also provide the sequential list of commands to drop and then recreate the indexes.
UNWIND ["DROP", "CREATE"] AS command
RETURN command + " " + description - Within Browser, select the "Enable multi statement query editor" under the browser settings, as indicated in the attached image.
- Take the list of commands from 2) and copy them in one list of multiple queries into Browser and run those queries.
- After the indexes are recreated, attempt the push-to-cloud command again.
Comments
0 comments
Please sign in to leave a comment.