Neo4j

Hello friends! Today at 8am PST we will be making some changes to login across all Neo4j properties, including here at community.neo4j.com . We expect that the change will smooth the registration and login process, but should not affect any current users. This does require any action on your part. However, there may be hiccups. If you experience problems logging in, please reach out to the community team at community@neo4j.com or to me directly as abk on Discord. Best, ABK

Do any of the hosted/managed Neo4j solutions support deploying custom procedures, i.e. placing a jar in the plugin folders?

I'm apparently locked out of neo4J enterprise, with the following complaint: Neo.ClientError.Security.AuthenticationRateLimit: The client has provided incorrect authentication details too many times in a row. This neo4j-enterprise instance has been running fine for awhile and has multiple databases. While I have backups, I'd like to avoid a re-install if possible. I'm rationalizing neo4j credentials across the toolchain on the platform -- I'm using the official drivers for both Python and nodejs/javascript. I'm attempting to follow DRY and best practices and collect credentials from the environment -- eventually encrypted in a reasonably secure approach. For now, the credentials (username and password) are in plaintext files that export NEO4J_USERNAME and NEO4J_PASSWORD . Not surprisingly, there have been some typos and failed attempts. Although I think these are now correct, I'm now seeing the above error. I also have LetsEncrypt certificates installed and I think the browser is listening on 7473 (though I'm not sure). Is there some way to adjust or relax this limit while I'm doing do development? Do I really need to reinstall Neo4J to make it go away?

I have created a community using community detection algorithm, On top of that I need to apply Page rank algorithm. For each community I want to know which customer is the most influential. So can anyone please tell how to do it and what is the syntax?

There are several nodes: Variety. Each node is connected with the nodes :Control (no treatment applied), :P1R - one treatment is applied and :P2B another treatment is applied. Each node ( :Control, :P1R, :P2B) is connected to the :Protein node by the relation :CONTAINS (contains a certain percentage of protein). The protein content of each variety must be determined. Is such a variant of the subgraph possible? How can it be determined to which variety the value in the Protein node belongs?

I need to integrate a graph database in my existing setup and due to compliance restrictions I have to stick with Neptune. The development is painful since I have a ruby backend that does not provide much support for gremlin. Neptune does not support cypher for production at this point. So I need a development setup and I was hoping for a local installation of neo4j. It looks though like gremlin is not really supported in neo4j. All the info I got was pointing to cypher. Any ideas on how to get neo4j working with gremlin so that I can use it for local development?

I'm seeing HUGE changes in performance for the same query while running on a dedicated CentOS 7 system with adequate RAM, CPU, and disk. I'd like guidance in discovering the cause and how to fix it. I'm running neo4j-enterprise v4.4.3.1. The platform is a CentOS 7 system running on a dedicated AWS EC2 "t2-large" instance. I am starting with the same db dump (created with neo4j-admin ), and adding the same data using the same query. When I say "huge changes in performance", I mean that the same insertion job (a sequence of queries) sometimes finishes in 2903 seconds (just over 48 minutes) and sometimes takes 15792 seconds (4 hours and 23 minutes). That's a factor of FIVE! This query has been running daily on earlier versions for more than a year, and always runs in about 45-50 minutes. In almost 2 years of experience with Neo4J enterprise, this is the first time I've seen anything like this. I see no difference in the log files between a fast and slow run. I use Python scripts to run this, so it's being run with the same command line, the same database, and the same data each time. The RAM utilization seems fixed at 75% (according to top ) while Neo4J is running. I'm accustomed to that. On fast runs, the CPU utilization (according to top ) is often between 40% and 100%. On slow runs, it is often 3-4% and never above 10%. At the moment, it is in the middle of another run and is already slow. I know, from examining the console output, that it is the middle of a neo4j-intensive query. Here is what the first lines of top show while this query is running: # top top - 16:57:17 up 8:01, 3 users, load average: 1.04, 1.08, 1.18 Tasks: 211 total, 1 running, 210 sleeping, 0 stopped, 0 zombie %Cpu(s): 0.2 us, 0.3 sy, 0.0 ni, 50.3 id, 49.0 wa, 0.0 hi, 0.0 si, 0.2 st KiB Mem : 8007412 total, 131620 free, 6417452 used, 1458340 buff/cache KiB Swap: 2097148 total, 1488380 free, 608768 used. 1328000 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 6468 root 20 0 8633976 5.6g 4944 S 2.7 73.2 21:53.56 java 38 root 20 0 0 0 0 S 0.3 0.0 2:05.73 kswapd0 1 root 20 0 125744 1600 896 S 0.0 0.0 0:02.23 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd Neo4J is the only Java app installed on the system. It's using only 2.7% of the CPU -- no wonder it's glacially slow! According to show transactions (in the Neo4J browser), there are two transactions active: query-2605 : "call apoc.periodic.iterate("MATCH (target:FIPSItem)<-[:FEATURE]-(dp:Datapoint {datasetID: 'nytimes.20220112.us-counties'}) WHERE dp.dailyCaseCount IS NOT NULL AND dp.dailyDeathCount IS NOT NULL AND dp.cumulativeDeathCount IS NOT NULL AND dp.cumulativeCaseCount IS NOT NULL RETURN target, dp AS dpTarget ", "MATCH (target)-[:ADJOINS]-(neighbor:FIPSItem)<-[FEATURE]-(dpNeighbor: Datapoint {datasetID: 'nytimes.20220112.us-counties', pertainsDate: dpTarget.pertainsDate}) WHERE dpNeighbor.dailyCaseCount IS NOT NULL AND dpNeighbor.dailyDeathCount IS NOT NULL AND dpNeighbor.cumulativeDeathCount IS NOT NULL AND dpNeighbor.cumulativeCaseCount IS NOT NULL WITH dpTarget, stDevP(dpNeighbor.cumulativeCaseCount - dpTarget.cumulativeCaseCount) AS cumulativeCaseCountEdgeIntensity, stDevP(dpNeighbor.cumulativeDeathCount - dpTarget.cumulativeDeathCount) AS cumulativeDeathCountEdgeIntensity, stDevP(dpNeighbor.dailyCaseCount - dpTarget.dailyCaseCount) AS dailyCaseCountEdgeIntensity, stDevP(dpNeighbor.dailyDeathCount - dpTarget.dailyDeathCount) AS dailyDeathCountEdgeIntensity MERGE (analysisResult: AnalysisResult {analysisResultID: 'zeetix.analysis_tools.edgeIntensityAnalyzer.20220201163906.' + dpTarget.datapointID }) SET analysisResult.datapointID = dpTarget.datapointID, analysisResult.cumulativeCaseCountEdgeIntensity = cumulativeCaseCountEdgeIntensity, analysisResult.cumulativeDeathCountEdgeIntensity = cumulativeDeathCountEdgeIntensity, analysisResult.dailyCaseCountEdgeIntensity = dailyCaseCountEdgeIntensity, analysisResult.dailyDeathCountEdgeIntensity = dailyDeathCountEdgeIntensity WITH dpTarget, analysisResult MATCH (analysisRun: AnalysisRun {analysisRunID: 'zeetix.analysis_tools.edgeIntensityAnalyzer.20220201163906'}) MERGE (analysisResult)-[:ANALYSIS_RUN]->(analysisRun) MERGE (dpTarget)-[:ANALYSIS_RESULT]->(analysisResult) ", {batchSize:500})" and query-2814 : "UNWIND $_batch AS _batch WITH _batch.target AS target,_batch.dpTarget AS dpTarget MATCH (target)-[:ADJOINS]-(neighbor:FIPSItem)<-[FEATURE]-(dpNeighbor: Datapoint {datasetID: 'nytimes.20220112.us-counties', pertainsDate: dpTarget.pertainsDate}) WHERE dpNeighbor.dailyCaseCount IS NOT NULL AND dpNeighbor.dailyDeathCount IS NOT NULL AND dpNeighbor.cumulativeDeathCount IS NOT NULL AND dpNeighbor.cumulativeCaseCount IS NOT NULL WITH dpTarget, stDevP(dpNeighbor.cumulativeCaseCount - dpTarget.cumulativeCaseCount) AS cumulativeCaseCountEdgeIntensity, stDevP(dpNeighbor.cumulativeDeathCount - dpTarget.cumulativeDeathCount) AS cumulativeDeathCountEdgeIntensity, stDevP(dpNeighbor.dailyCaseCount - dpTarget.dailyCaseCount) AS dailyCaseCountEdgeIntensity, stDevP(dpNeighbor.dailyDeathCount - dpTarget.dailyDeathCount) AS dailyDeathCountEdgeIntensity MERGE (analysisResult: AnalysisResult {analysisResultID: 'zeetix.analysis_tools.edgeIntensityAnalyzer.20220201163906.' + dpTarget.datapointID }) SET analysisResult.datapointID = dpTarget.datapointID, analysisResult.cumulativeCaseCountEdgeIntensity = cumulativeCaseCountEdgeIntensity, analysisResult.cumulativeDeathCountEdgeIntensity = cumulativeDeathCountEdgeIntensity, analysisResult.dailyCaseCountEdgeIntensity = dailyCaseCountEdgeIntensity, analysisResult.dailyDeathCountEdgeIntensity = dailyDeathCountEdgeIntensity WITH dpTarget, analysisResult MATCH (analysisRun: AnalysisRun {analysisRunID: 'zeetix.analysis_tools.edgeIntensityAnalyzer.20220201163906'}) MERGE (analysisResult)-[:ANALYSIS_RUN]->(analysisRun) MERGE (dpTarget)-[:ANALYSIS_RESULT]->(analysisResult) " There are indices defined on all reference property names, constraints defined on the various IDs (the code generates a unique ID for each instance of a labeled node), and I've defined label and node indices according to the documentation. I've seen references to "metrics" in the new documentation, but I don't see how to connect those metrics to what I'm seeing. So far as I know, I've not turned on any of that. I dialed back the batch size of the above query to 500 to see if I was somehow running out of memory. Why is the CPU utilization so low? Why do these queries sometimes take so long? I've been chasing this since last week, and I've run out of things to look at. I invite guidance about what to instrument and how to do so. Is there some combination of neo4j.conf that restrict CPU utilization? What could make Neo4J spend so little time doing anything when there is so much to be done?

HI, I have a question on the way 4.0.12 up to neo4j 4.2 (versions) audits LOGIN actions. I am using 4.0.12 version, when I login ( remote/local login ) using cypher-shell client and I check the 2 log files In the query.log I get this 2 log lines, but there is no information here that can indicate that I did a login. I see only the CALL db.ping() action, but this action can be run even when the user is already login to the database so it does not help. log line from 4.0.12 2022-01-13 23:48:28.970+0000 INFO Query started: id:7 - 0 ms: bolt-session bolt neo4j-cypher-shell/v4.4.3 client/127.0.0.1:57806 server/127.0.0.1:7687> neo4j - MY_USER - CALL db.ping() - {} - {} 2022-01-13 23:48:28.972+0000 INFO id:7 - 1 ms: bolt-session bolt neo4j-cypher-shell/v4.4.3 client/127.0.0.1:57806 server/127.0.0.1:7687> neo4j - MY_USER - CALL db.ping() - {} - {} I know that in the previous versions when I did a LOGIN I would get 2 log lines with RETURN 1, that I could use to identify that it is a success login example : 2022-01-11T01:27:12.983561+00:00 2022-01-11 01: 27:06.914+0000 INFO Query started: id:466 - 0 ms: (planning: 0, waiting: 0) - 0 page hits, 0 page faults - bolt-session#011bolt#011neo4j-cypher-shell/v4.2.2#011#011client/MY_IP:40984#011server/SERVER_IP:7687>#011neo4j - MY_USER- RETURN 1 - {} - {} 2022-01-11T01:27:12.983561+00:00 2022-01-11 01: 27:06.915+0000 INFO id:466 - 0 ms: (planning: 0, waiting: 0) - 0 page hits, 0 page faults - bolt-session#011bolt#011neo4j-cypher-shell/v4.2.2#011#011client/MY_IP:40984#011server/SERVER_IP:7687>#011neo4j - MY_USER- RETURN 1 - {} - {} The login is also in the security.log, but here the only information that I get is the database user name . I don't have the: client_ip, server_ip, application program, network protocol Could this information be added here in the 'security.log" ? example of current log , for a login action 2022-01-13 23:48:28.886+0000 INFO [my_user]: logged in 2022-01-13 23:48:28.966+0000 INFO [my_user]: logged in

I run neo4j-enterprise on a reasonably up-to-date CentOS 7 system running on an AWS EC2 "t2-large" instance. I've just successfully updated neo4j-enterprise to v4.4.3, the current version. # yum update neo4j-enterprise ... Updating : neo4j-enterprise-4.4.3-1.noarch 1/2 Cleanup : neo4j-enterprise-4.4.2-1.noarch 2/2 Verifying : neo4j-enterprise-4.4.3-1.noarch 1/2 Verifying : neo4j-enterprise-4.4.2-1.noarch 2/2 Updated: neo4j-enterprise.noarch 0:4.4.3-1 Complete! I notice that although I got a new version of "labs", the apoc jar has not been updated: # ls -l labs total 15692 -rwxr-xr-x 1 neo4j neo4j 16049698 Jan 5 04:06 apoc-4.4.0.1-core.jar -rwxr-xr-x 1 neo4j neo4j 11330 Jan 5 04:06 LICENSE -rwxr-xr-x 1 neo4j neo4j 1131 Jan 5 04:06 README.txt I had expected to see something like apoc-4.4.3.1-core.jar or something with "4.4.3" in its name. I'm debugging a failed query that uses apoc, and seeing 38 complaints about failures in apoc-4.4.0.1-core.jar . I don't know if these are consequential or not, the version mismatch between the apoc jar and neo4j has my attention. Here's what the complaints look like (I'm in /var/log/neo4j as root): # grep Failed debug.log 2022-01-27 19:29:28.924+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.s3.S3Aws` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/amazonaws/auth/AWSCredentials 2022-01-27 19:29:28.925+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.s3.S3Aws$1` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/amazonaws/services/s3/model/S3ObjectInputStream 2022-01-27 19:29:28.926+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.s3.S3URLConnection` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/amazonaws/ClientConfiguration 2022-01-27 19:29:28.938+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.google.cloud.GCStorageURLConnection` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/google/cloud/storage/Storage 2022-01-27 19:29:28.941+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.hdfs.HDFSUtils` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/hadoop/fs/FSDataOutputStream 2022-01-27 19:29:28.942+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `apoc.util.hdfs.HDFSUtils$1` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/hadoop/fs/FSDataInputStream 2022-01-27 19:29:29.043+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.gui.TreeViewer$VariableExtentProvide` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/abego/treelayout/NodeExtentProvider 2022-01-27 19:29:29.044+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.gui.TreePostScriptGenerator` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/abego/treelayout/Configuration 2022-01-27 19:29:29.192+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.gui.TreeViewer` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/abego/treelayout/TreeForTreeLayout 2022-01-27 19:29:29.244+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.gui.TreePostScriptGenerator$VariableExtentProvide` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/abego/treelayout/NodeExtentProvider 2022-01-27 19:29:29.282+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.unicode.UnicodeDataTemplateController` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/ibm/icu/text/UnicodeSet 2022-01-27 19:29:29.535+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.v4.gui.TreeLayoutAdaptor` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/abego/treelayout/TreeForTreeLayout 2022-01-27 19:29:29.715+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `com.jayway.jsonpath.spi.json.GsonJsonProvider` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/google/gson/JsonElement 2022-01-27 19:29:29.741+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `com.jayway.jsonpath.spi.json.JsonOrgJsonProvider` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/json/JSONException 2022-01-27 19:29:29.745+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `com.jayway.jsonpath.spi.mapper.GsonMappingProvider$1` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/google/gson/Gson 2022-01-27 19:29:29.746+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `com.jayway.jsonpath.spi.mapper.GsonMappingProvider$2` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: com/google/gson/Gson 2022-01-27 19:29:29.873+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationNodePointer` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodePointer 2022-01-27 19:29:29.873+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationNodeIteratorBase` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodeIterator 2022-01-27 19:29:29.874+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationNodeIteratorAttribute` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodeIterator 2022-01-27 19:29:29.875+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationNodeIteratorChildren` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodeIterator 2022-01-27 19:29:29.875+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationNodePointerFactory` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodePointerFactory 2022-01-27 19:29:29.876+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.XPathExpressionEngine` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodePointerFactory 2022-01-27 19:29:29.876+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.XPathContextFactory` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/JXPathContext 2022-01-27 19:29:29.877+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.tree.xpath.ConfigurationAttributePointer` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jxpath/ri/model/NodePointer 2022-01-27 19:29:29.922+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.io.VFSFileSystem` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/vfs2/FileSystemException 2022-01-27 19:29:29.996+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.interpol.ExprLookup` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/jexl2/JexlContext 2022-01-27 19:29:30.001+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.reloading.VFSFileHandlerReloadingDetector` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/commons/vfs2/FileSystemException 2022-01-27 19:29:30.033+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.resolver.CatalogResolver` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/xml/resolver/CatalogManager 2022-01-27 19:29:30.034+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.resolver.CatalogResolver$Catalog` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/xml/resolver/Catalog 2022-01-27 19:29:30.035+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.resolver.CatalogResolver$CatalogManager` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/xml/resolver/CatalogManager 2022-01-27 19:29:30.036+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.spring.ConfigurationPropertySource` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/springframework/core/env/EnumerablePropertySource 2022-01-27 19:29:30.036+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.configuration2.spring.ConfigurationPropertiesFactoryBean` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/springframework/beans/factory/InitializingBean 2022-01-27 19:29:30.473+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `module-info` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: module-info is not a class because access_flag ACC_MODULE is set 2022-01-27 19:29:32.512+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.xerces.util.XMLCatalogResolver` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/xml/resolver/readers/CatalogReader 2022-01-27 19:29:33.225+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.antlr.runtime.tree.DOTTreeGenerator` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/antlr/stringtemplate/StringTemplate 2022-01-27 19:29:33.372+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.logging.impl.AvalonLogger` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/avalon/framework/logger/Logger 2022-01-27 19:29:33.373+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.logging.impl.Log4JLogger` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/log4j/Priority 2022-01-27 19:29:33.375+0000 WARN [o.n.k.a.p.GlobalProcedures] Failed to load `org.apache.commons.logging.impl.LogKitLogger` from plugin jar `/var/lib/neo4j/plugins/apoc-4.4.0.1-core.jar`: org/apache/log/Logger Have I missed a manual step to download an appropriate apoc jar?

Hello. I have the kafka connect source running with the following properties the query is: MATCH (n:Note) WHERE n.createdAt > $lastCheck RETURN id(n) as id, n.id AS nid, n.createdAt AS createdAt This never publishes data to my topic. If I change the CYPHER to remove the $lastCheck, something like: MATCH (n:Note) RETURN n.id as nid, n.createdAt as createdAt it works fine. Does anyone have experience getting the kafka connect source query to work using $lastCheck ? I can't poll my data otherwise making this whole thing totally useless.

Hi, I have just installed neo4j on Raspberry (Debian server only). I enable services, but: When I start the service (Or after reboot), neoj start, but the dbms not (Neo4j one). If I execute the command line "neo4j console", neo4j start, and the dbms also ... If I compare the service log as the "neo4j console" output, there are identical ... What is the problem with the service ? Service log : janv. 07 11:42:04 Poulailler systemd[1]: neo4j.service: Consumed 3min 1.716s CPU time. janv. 07 11:50:34 Poulailler systemd[1]: Started Neo4j Graph Database. janv. 07 11:50:47 Poulailler neo4j[1480]: Directories in use: janv. 07 11:50:47 Poulailler neo4j[1480]: home: /var/lib/neo4j janv. 07 11:50:47 Poulailler neo4j[1480]: config: /etc/neo4j janv. 07 11:50:47 Poulailler neo4j[1480]: logs: /var/log/neo4j janv. 07 11:50:47 Poulailler neo4j[1480]: plugins: /var/lib/neo4j/plugins janv. 07 11:50:47 Poulailler neo4j[1480]: import: /var/lib/neo4j/import janv. 07 11:50:47 Poulailler neo4j[1480]: data: /var/lib/neo4j/data janv. 07 11:50:47 Poulailler neo4j[1480]: certificates: /var/lib/neo4j/certificates janv. 07 11:50:47 Poulailler neo4j[1480]: licenses: /var/lib/neo4j/licenses janv. 07 11:50:47 Poulailler neo4j[1480]: run: /var/lib/neo4j/run janv. 07 11:50:47 Poulailler neo4j[1480]: Starting Neo4j. janv. 07 11:51:03 Poulailler neo4j[1497]: 2022-01-07 10:51:03.300+0000 INFO Note that since you did not explicitly set the port in dbms.connecto> janv. 07 11:51:03 Poulailler neo4j[1497]: 2022-01-07 10:51:03.380+0000 INFO Starting... janv. 07 11:51:08 Poulailler neo4j[1497]: 2022-01-07 10:51:08.528+0000 INFO This instance is ServerId{45894f4c} (45894f4c-dee0-4947-bfb8-8507bf3> janv. 07 11:51:21 Poulailler neo4j[1497]: 2022-01-07 10:51:21.723+0000 INFO ======== Neo4j 4.4.2 ======== janv. 07 11:51:38 Poulailler neo4j[1497]: 2022-01-07 10:51:38.105+0000 INFO Performing postInitialization step for component 'security-users' wi> janv. 07 11:51:38 Poulailler neo4j[1497]: 2022-01-07 10:51:38.107+0000 INFO Updating the initial password in component 'security-users' janv. 07 11:51:39 Poulailler neo4j[1497]: 2022-01-07 10:51:39.126+0000 INFO Bolt enabled on [0:0:0:0:0:0:0:0]:7687. janv. 07 11:51:47 Poulailler neo4j[1497]: 2022-01-07 10:51:47.479+0000 INFO Remote interface available at http://localhost:7474/ janv. 07 11:51:47 Poulailler neo4j[1497]: 2022-01-07 10:51:47.516+0000 INFO id: 80AA7AB8090B5317E7D095B8D311272C9511A3EA79E6A23BD8D92A5D58EB0E21 janv. 07 11:51:47 Poulailler neo4j[1497]: 2022-01-07 10:51:47.518+0000 INFO name: system janv. 07 11:51:47 Poulailler neo4j[1497]: 2022-01-07 10:51:47.519+0000 INFO creationDate: 2022-01-06T15:53:07.598Z janv. 07 11:51:47 Poulailler neo4j[1497]: 2022-01-07 10:51:47.520+0000 INFO Started. lines 733-776/776 (END)

What needed was to give some examples of CREATE queries of nodes and relationships, so it can understand the schema. Then you ask with natural language what query to generate: it can write queries even for Suffix string search using ENDS WITH and the engine could understand that an actor is a person with relation ACTED_IN . """ Create an openCypher query filtering only the actors whose names end with "s" """ query = """ MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WHERE p.name ENDS WITH 's' RETURN p """

Hello I have setup two separate Neo4j servers, both of version 4.4.0. I am using neo4j-admin dump from one to create an archive to then use neo4j-admin load on the other to transfer specific databases between them. The tool fails with "Not a valid neo4j archive" when attempting to load the data to the second instance. I have come across this "fix" but it does not work. I have also tried to list the contents of the backup archive via the gzip tool and a custom Python script and both give the same error, leading me to believe that indeed, the neo4j-admin tool is producing an invalid file. There is also the point of which compressor is used in the end by neo4j-admin ? Is it zstd, gzip or something else? If i try to list files with either the gzip or zstd command line utilities, I am getting the same error in both of them ("No, this is not a gzip file", "No, this is not a zstd file")... Is it possible to get some clarity on these issues? (There are no logs from the servers because they are shutdown in both cases during the whole backup-restore process, but here is what --verbose from neo4j-admin says: org.neo4j.cli.CommandFailedException: Not a valid Neo4j archive: ./backup at org.neo4j.commandline.dbms.LoadCommand.load(LoadCommand.java:155) at org.neo4j.commandline.dbms.LoadCommand.execute(LoadCommand.java:85) at org.neo4j.cli.AbstractCommand.call(AbstractCommand.java:60) at org.neo4j.cli.AbstractCommand.call(AbstractCommand.java:30) at picocli.CommandLine.executeUserObject(CommandLine.java:1743) at picocli.CommandLine.access$900(CommandLine.java:145) at picocli.CommandLine$RunLast.handle(CommandLine.java:2101) at picocli.CommandLine$RunLast.handle(CommandLine.java:2068) at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:1935) at picocli.CommandLine.execute(CommandLine.java:1864) at org.neo4j.cli.AdminTool.execute(AdminTool.java:78) at org.neo4j.cli.AdminTool.main(AdminTool.java:59) Caused by: org.neo4j.dbms.archive.IncorrectFormat: ./backup at org.neo4j.dbms.archive.Loader.openArchiveIn(Loader.java:172) at org.neo4j.dbms.archive.Loader.load(Loader.java:74) at org.neo4j.commandline.dbms.LoadCommand.load(LoadCommand.java:131) ... 11 more Caused by: java.io.IOException: Decompression error: Unknown frame descriptor at com.github.luben.zstd.ZstdInputStream.readInternal(ZstdInputStream.java:147) at com.github.luben.zstd.ZstdInputStream.read(ZstdInputStream.java:107) at java.base/java.io.FilterInputStream.read(FilterInputStream.java:107) at org.neo4j.dbms.archive.CompressionFormat$2.decompress(CompressionFormat.java:79) at org.neo4j.dbms.archive.CompressionFormat.decompress(CompressionFormat.java:148) at org.neo4j.dbms.archive.CompressionFormat.decompress(CompressionFormat.java:125) at org.neo4j.dbms.archive.Loader.openArchiveIn(Loader.java:156) ... 13 more Suppressed: java.util.zip.ZipException: Not in GZIP format at java.base/java.util.zip.GZIPInputStream.readHeader(GZIPInputStream.java:166) at java.base/java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:80) at java.base/java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:92) at org.neo4j.dbms.archive.CompressionFormat$1.decompress(CompressionFormat.java:52) at org.neo4j.dbms.archive.CompressionFormat.decompress(CompressionFormat.java:148) at org.neo4j.dbms.archive.CompressionFormat.decompress(CompressionFormat.java:132) ... 14 more Any ideas on this one? All the best AA

Hi, Creating databases via Python and Jupyter notebooks. For the most part working well and am using neo python driver. Here is where I am having some trouble. I have a data frame with the data to bring into Neo4J, a document number and a date. Some of the document do not have valid dates and the value in the field is "null" as a string. It setting the data I would like to trap for these and ignore that row of data. If I run the code below it does not seem to complete and I am using the Jupyter signal in the line number as a gauge. When the cell is executing it has an "*". Using that the cell never completes. If I go to browser in Neo4J and examine the nodes the date fields seem correctly populated. Any idea why it would not complete? def set_patent_date(tx,case,issue): result = tx.run("MATCH (a:patent{num:$case}) set a.issued = date($issue)", case=case, issue=issue) with driver.session() as session: for patent in PAT.itertuples(): if patent.date != 'null': testcase = session.write_transaction(set_patent_date,patent.num,patent.date) driver.close() Andy

I completed this course and was trying to download the certificate and I wasn't able to do so. Eventually, when I tried to refresh the page, I ran into the error shown in the attachment. "Error while loading the data, please refresh the page." I tried different browsers and restarted my computer. I see this error once I sign in. Can someone please help? Thanks so much! Prad

Hi, I am trying to generate SVO triplets to below text. Can you help me to choose a verb as relation? "Normal cells stop growing when they encounter other cells" Thanks, Dinesh K.

What is the difference from temporal operators vs temporal functions?

I am a developer using Neo4j Desktop and apparently my software license key expired 11/20/21. I have searched to find out how to renew the license and cannot find out how to do it. Can someone please point me in the right direction?