Tag Archives: Neo4j error

[Solved] Neo4j error: Cannot merge the following node because of null property value for ‘casualty’

Execute the following command in neo4j:

LOAD CSV WITH HEADERS  FROM "file:///accident.csv" AS line
MERGE (p:accident{id:line.id,name:line.code,casualty:line.casualty})

 

Report an error:

Cannot merge the following node because of null property value for 'casualty': (:accident {casualty: null}) (Failure when processing file '/E:/Program/...../neo4j-community-4.4.8/import/accident.csv' on line 2.)

Cause: In the first time the entity is created and the casualty value in the file is empty.
Solution: Change merge to create

Source: Explanation of error “Cannot merge node using null property value for” – Knowledge Base

[Solved] Neo4j Error: Error occurred during initialization of VM Incompatible minimum and maximum heap sizes spec

The run instruction neo4j console displays the following error messages

WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See the Neo4j manual.
Starting Neo4j Server console-mode...
Using additional JVM arguments:  -server -XX:+DisableExplicitGC -Dorg.neo4j.server.properties=conf/neo4j-server.properties -Djava.util.logging.config.file=conf/logging.properties -Dlog4j.configuration=file:conf/log4j.properties -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Xms512m -Xmx1024 #as large as you canm
Error occurred during initialization of VM
Incompatible minimum and maximum heap sizes specified

I suspected that the problem was the configuration of my Neo4j parameters. so I open the file neo4j-wrapper.conf,(sudo) vim neo4j-wrapper.conf

later, I delete the note “`#as large you kan“  after the wrapper.java.maxmemory=10240 , it can run normally, and the results are as follows:

root@VM-12-7-ubuntu:/home/thicker/GNN/FIRST/neo4j/bin# neo4j console
WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See the Neo4j manual.
Starting Neo4j Server console-mode...
Using additional JVM arguments:  -server -XX:+DisableExplicitGC -Dorg.neo4j.server.properties=conf/neo4j-server.properties -Djava.util.logging.config.file=conf/logging.properties -Dlog4j.configuration=file:conf/log4j.properties -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Xms512m -Xmx10240m
2022-07-23 08:15:48.452+0000 INFO  [API] Setting startup timeout to: 120000ms based on -1
2022-07-23 08:15:48.508+0000 INFO  [Configuration] WARNING! Physical memory(8003MB) is less than assigned JVM memory(10451MB). Continuing but with available JVM memory set to available physical memory
2022-07-23 08:15:49.724+0000 INFO  [API] Successfully started database
2022-07-23 08:15:49.777+0000 INFO  [API] Starting HTTP on port :7474 with 40 threads available
2022-07-23 08:15:49.904+0000 INFO  [API] Enabling HTTPS on port :7473
2022-07-23 08:15:49.905+0000 INFO  [API] No SSL certificate found, generating a self-signed certificate..
2022-07-23 08:15:50.133+0000 INFO  [API] Mounted discovery module at [/]
2022-07-23 08:15:50.159+0000 INFO  [API] Loaded server plugin "GremlinPlugin"
2022-07-23 08:15:50.160+0000 INFO  [API]   GraphDatabaseService.execute_script: execute a Gremlin script with 'g' set to the Neo4j2Graph and 'results' containing the results. Only results of one object type is supported.
2022-07-23 08:15:50.160+0000 INFO  [API] Mounted REST API at [/db/data/]
2022-07-23 08:15:50.162+0000 INFO  [API] Mounted management API at [/db/manage/]
2022-07-23 08:15:50.162+0000 INFO  [API] Mounted webadmin at [/webadmin]
2022-07-23 08:15:50.162+0000 INFO  [API] Mounted Neo4j Browser at [/browser]
2022-07-23 08:15:50.204+0000 INFO  [API] Mounting static content at [/webadmin] from [webadmin-html]
2022-07-23 08:15:50.243+0000 INFO  [API] Mounting static content at [/browser] from [browser]
16:15:50.245 [main] WARN  o.e.j.server.handler.ContextHandler - o.e.j.s.ServletContextHandler@21da484c{/,null,null} contextPath ends with /
16:15:50.245 [main] WARN  o.e.j.server.handler.ContextHandler - Empty contextPath
16:15:50.247 [main] INFO  org.eclipse.jetty.server.Server - jetty-9.0.5.v20130815
16:15:50.267 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.h.MovedContextHandler@6d97768d{/,null,AVAILABLE}
16:15:50.340 [main] INFO  o.e.j.w.StandardDescriptorProcessor - NO JSP Support for /webadmin, did not find org.apache.jasper.servlet.JspServlet
16:15:50.349 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.w.WebAppContext@660e8081{/webadmin,jar:file:/home/thicker/GNN/FIRST/neo4j/system/lib/neo4j-server-2.1.5-static-web.jar!/webadmin-html,AVAILABLE}
16:15:50.703 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@31621b95{/db/manage,null,AVAILABLE}
16:15:50.903 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@12fb3db8{/db/data,null,AVAILABLE}
16:15:50.917 [main] INFO  o.e.j.w.StandardDescriptorProcessor - NO JSP Support for /browser, did not find org.apache.jasper.servlet.JspServlet
16:15:50.918 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.w.WebAppContext@3fe9713a{/browser,jar:file:/home/thicker/GNN/FIRST/neo4j/system/lib/neo4j-browser-2.1.5.jar!/browser,AVAILABLE}
16:15:51.097 [main] INFO  o.e.j.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@21da484c{/,null,AVAILABLE}
16:15:51.105 [main] INFO  o.e.jetty.server.ServerConnector - Started ServerConnector@db18be0{HTTP/1.1}{0.0.0.0:7474}
16:15:51.497 [main] INFO  o.e.jetty.server.ServerConnector - Started ServerConnector@56a2b12b{SSL-HTTP/1.1}{0.0.0.0:7473}
2022-07-23 08:15:51.497+0000 INFO  [API] Server started on: http://0.0.0.0:7474/
2022-07-23 08:15:51.498+0000 INFO  [API] Remote interface ready and available at [http://0.0.0.0:7474/]

Then run the instruction “`neo4j start“ to display the following error messages

root@VM-12-7-ubuntu:~# neo4j start
WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See the Neo4j manual.
Using additional JVM arguments:  -server -XX:+DisableExplicitGC -Dorg.neo4j.server.properties=conf/neo4j-server.properties -Djava.util.logging.config.file=conf/logging.properties -Dlog4j.configuration=file:conf/log4j.properties -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Xms512m -Xmx10240m
Starting Neo4j Server...process [17130]... waiting for server to be ready.... Failed to start within 120 seconds.
Neo4j Server failed to start, please check the logs for details.
If startup is blocked on a long recovery, use '/home/thicker/GNN/FIRST/neo4j/bin/neo4j start-no-wait' to give the startup more time.

Follow the prompt and run the command ` ` ` neo4j start-no-wait “

[Solved] Neo4j error: Import-Module & neo4j Neo.ClientError.Security.Unauthorized

Error reporting record

1. Import module: failed to load the specified module. Solution:

Solution: find the neo4j PS1 file in the bin directory, open it, find the import module, and change the relative path to the absolute path, that is,

"D:\Neo4j\neo4j-community-3.5.25\bin\Neo4j-Management.psd1"

2. When changing the password, neo4j Neo.ClientError.Security.Unauthorized

Solution: open neo4j.conf in the conf folder and delete the comment in front of #dbms.security.auth_enabled=false