Why does my CREATE CONSTRAINT take so long to complete

When creating a constraint, for example CREATE CONSTRAINT ON (n:ZipCode) ASSERT n.name IS UNIQUE; this will require a lock on all nodes with the label the constraint is being created for, in this case ZipCode If you have another transaction… Read more →

Explore:  


How to properly shutdown a Neo4j database after receiving the message took more than 120 seconds to stop

The neo4j script under the bin/ directory of any standard Neo4j install is the primary means of shutting down a running Neo4j instance. That script accepts a stop argument that will try to shutdown the running instance by sending a… Read more →

Explore:  


Will execution_guard_enabled work in my release of Neo4j?

Background From the beginning, the execution guard was never meant to be used by the general public. However, the feature was there in the product, though undocumented, and it did work for the purpose of preventing long running queries from… Read more →

Explore:  


How do I use Cypher to connect to a RDBMS using JDBC

With the inclusion of java stored procedures in Neo4j 3.x, one can run Cypher to connect to a RDBMS using JDBC. To do so one needs to download and install https://github.com/neo4j-contrib/neo4j-apoc-procedures. After installation of the Neo4j APOC kit, download the… Read more →

Explore:  


Proper File Permissions on Neo4j Server

When installing Neo4j Server, keep in mind that the bin/neo4j executable will need to be run by some OS system user, and that user will need write permissions to some files/directories, specifically to the data directory. That user will also… Read more →

Explore:  


Understanding logical logs and effects of parameters keep_logical_logs and logical_log_rotation_threshold

Neo4j maintains logical logs for incremental backup and cluster consistency. The logical logs are named as follows: pre 2.2 data/graph.db/nioneo_logical.log* 2.2 forward data/graph.db/neostore.transaction.db* When one runs a database backup, via bin/neo4j-backup, if the -to <target directory> has a previous backup,… Read more →

Explore:  


How do I automate the copy of auth files in a clustered environment

In a clustered Neo4j implementation, user authentication files are recorded in each instance at $NEO4J_HOME/data/dbms. Since this defined per each instance in the cluster if for example you change the password of a user on instance 1, for consistency you… Read more →

Explore:  


Explanation of data/log/console.log error of ‘TLS certificate error occurred, unable to start server: Neither RSA, DSA nor EC worked…​’

On bin/neo4j start the data/log/console.log may log an error similar to 2016-01-04 13:32:44.589-0500 INFO Successfully shutdown database 13:33:06.856 [main] DEBUG i.n.u.i.l.InternalLoggerFactory – Using SLF4J as the default logging framework 2016-01-04 13:33:07.437-0500 ERROR Failed to start Neo4j: TLS certificate error occurred, unable… Read more →

Explore:  


Configuring Neo4j to operate on privileged ports

In some environments, users are required to run Neo4j on ports lower than 1024 due to corporate policies. The following is a sample configuration showing how to configure Neo4j 3.5 and newer to listen on those ports. Refer to a… Read more →

Explore:  


When authentication is enabled in Neo4j, how do I call the HA Status REST API without a username/password

One can enable authentication for the Neo4j database by adding the following to the conf/neo4j-server.properties dbms.security.auth_enabled=true In doing so any connections to the database will need to provide a username/password. However for the REST endpoint for HA Status information a… Read more →

Explore:  


How to monitor if a follower is in sync with Leader (Causal Cluster)

To monitor if a Follower is in sync with its Leader, or know how much it is lagging behind, it is possible to check the Last Commited Transaction Id from Leader and Follower. Last Commited Transaction Id can be assessed… Read more →

Explore:  


How do i configure Neo4j so that data/graph.db/messages.log is automatically rotated

As tested and verified with Neo4j 2.3.0, the data/graph.db/messages.log, its size and number of rotated archives is governed by the following parameters in the conf/neo4j.properties file Name Description Default store.internal_log.max_archives Maximum number of history files for the internal log. 7… Read more →

Explore:  


How to install Neo4j in a disconnected environment

Premise: You are working with a private/disconnected environment and would like to install the Neo4j Database using RPM packages as a source. You can download the RPM packages on a separate machine (with internet access) with the following command. Then… Read more →

Explore: