Having trouble loading bulk static data to neo4j casual cluster

[karthik_shetty]

Hello!
I have a 3 node (CORE - each 4/16 CPU and memory respectively) causal cluster. I have been getting these errors in the application log where I am using golang-neo4j driver to load some static data from a source and create relationships.

Server error: [Neo.TransientError.Transaction.DeadlockDetected] ForsetiClient[6] can’t acquire ExclusiveLock{owner=ForsetiClient[7]} on INDEX_ENTRY(465722023353749244), because holders of that lock are waiting for ForsetiClient[6].
Wait list:ExclusiveLock[

 

Server error: [Neo.ClientError.Cluster.NotALeader] Should only attempt to take locks when leader.

 

Server error: [Neo.ClientError.Cluster.NotALeader] Local instance lost lock token.

 

Server error: [Neo.ClientError.Cluster.NotALeader] No write operations are allowed directly on this database. Writes must pass through the leader. The role of this server is: FOLLOWER

 

Server error: [Neo.DatabaseError.General.UnknownError] Failed to generate record id

Here is my neo4j cluster config:

dbms.active_database=dev
dbms.directories.data=data
dbms.directories.plugins=plugins
dbms.directories.certificates=certificates
dbms.directories.logs=logs
dbms.directories.lib=lib
dbms.directories.run=run
dbms.directories.metrics=metrics
dbms.directories.import=import
dbms.security.auth_enabled=false
dbms.allow_upgrade=true
dbms.memory.heap.initial_size=5100m
dbms.memory.heap.max_size=5100m
dbms.memory.pagecache.size=6800m
dbms.connectors.default_listen_address=0.0.0.0
dbms.connectors.default_advertised_address=host1
dbms.connector.bolt.enabled=true
dbms.connector.bolt.listen_address=:7687
dbms.connector.http.enabled=true
dbms.connector.http.listen_address=:7474
dbms.mode=CORE
causal_clustering.minimum_core_cluster_size_at_formation=3
causal_clustering.minimum_core_cluster_size_at_runtime=3
causal_clustering.discovery_type=LIST
causal_clustering.initial_discovery_members=host1:5000,host2:5000,host3:5000
causal_clustering.discovery_listen_address=0.0.0.0:5000
causal_clustering.transaction_listen_address=0.0.0.0:6000
causal_clustering.raft_listen_address=0.0.0.0:7000
dbms.jvm.additional=-XX:+UseG1GC
dbms.jvm.additional=-XX:-OmitStackTraceInFastThrow
dbms.jvm.additional=-XX:+AlwaysPreTouch
dbms.jvm.additional=-XX:+UnlockExperimentalVMOptions
dbms.jvm.additional=-XX:+TrustFinalNonStaticFields
dbms.jvm.additional=-XX:+DisableExplicitGC
dbms.jvm.additional=-Djdk.tls.ephemeralDHKeySize=2048
dbms.jvm.additional=-Djdk.tls.rejectClientInitiatedRenegotiation=true
dbms.windows_service_name=neo4j
dbms.jvm.additional=-Dunsupported.dbms.udc.source=tarball
dbms.jvm.additional=-Dunsupported.dbms.udc.source=tarball
dbms.udc.enabled=false
browser.allow_outgoing_connections=false

I am connecting to the neo4j cluster using bolt+routing://host1:7687/ from my application to load data.

Has anyone seen these lock issues? Please let me know if there is any solution to fix this? Thanks!

[ehume123]

Hi Karthik, are you using a Neo4j Browser instance or a Sandbox? This could be an error in sourcing from your static data.

[karthik_shetty]

Hi Eric,
I have set up my own 3 node casual cluster and running the queries in my golang api to source the data.
Sorry... I'm pretty new to Neo4j. Did this answer your question?