About the Community

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

About the Community

Hi there, I'm working on our Data Reload cypher script. We've already moved from DETACH DELETEing the whole database and then loading everything from scratch to use MERGE clause. This helps preventing the machine run out of memory which is good. Now I've detected that sometimes while using MERGE, it will create a new relationship (as expected) but the previous one won't be updated bringing us to a situation where a node has two active parents (big No No for us). Here's an example. This is a small part of our cypher script where the new relationships are being created. USING PERIODIC COMMIT 500 LOAD CSV FROM 'file:///DATA_FILE.txt' AS row FIELDTERMINATOR '~' WITH row[1] as Code, row[11] AS Parent MATCH (child:Client {code: Code}) MATCH (parent:Client {code: Parent}) MERGE (parent)-[r:PARENT_OF]->(child) ON CREATE SET r.isActive= TRUE, r.startDate= apoc.temporal.format(datetime(), 'iso_instant'), r.updatedBy= 'System'; As I said before, it is creating new relationships as expected but I want to also update the previous relationship, if there's any, updating a property to set it to false. This is what I've tried so far: USING PERIODIC COMMIT 500 LOAD CSV FROM 'file:///DATA_FILE.txt' AS row FIELDTERMINATOR '~' WITH row[1] as Code, row[11] AS Parent OPTIONAL MATCH (child:Client {code: Code})<-[oldRel:PARENT_OF]-(oldParent:Client) MATCH (newParent:Client {code: Parent}) MERGE (newParent)-[newRel:PARENT_OF]->(child) ON CREATE SET oldRel.isActive = FALSE, oldRel.endDate = apoc.temporal.format(datetime(), 'iso_instant'), oldRel.updatedBy = 'System', newRel.isActive= TRUE, newRel.startDate= apoc.temporal.format(datetime(), 'iso_instant'), newRel.updatedBy= 'System'; Does this makes any sense?

Hi, I'm trying to using neo4j in Grails , however when I configured the neo4j db connection in the groovy config (Attached Below) , the neo4j db crashed in very short time and recovered soon, but my service will not reconnect to neo4j db unless I restarts the service. Is there a solution that we can auto reconnect to neo4j that we do not need to restart the service again? Have you encountered similar problems related?What's the solution? Thank you very much! ''' environments { development { perEnvironmentDomain="-dev.$gtlcOnlyDomain" apiRoots() apis() grails { // neo4j datasource neo4j { url="bolt://cm-graphdb" username='neo4jUser' password='neo4jPassword' } '''

Hello ! made a first installation of Neo4j Desktop using the procedure indicated in Debian - Operations Manual The last installation instruction was : vincent2718@vincent2718-HP-Laptop-17-ca0xxx:~$ sudo apt-get install neo4j=1:4.2.7 [sudo] Mot de passe de vincent2718 : I then attempted to run me4j from the terminal using neo4j console but it failed with this return vincent2718@vincent2718-HP-Laptop-17-ca0xxx:~$ neo4j console Directories in use: home: /var/lib/neo4j config: /etc/neo4j logs: /var/log/neo4j plugins: /var/lib/neo4j/plugins import: /var/lib/neo4j/import data: /var/lib/neo4j/data certificates: /var/lib/neo4j/certificates run: /var/run/neo4j Starting Neo4j. WARNING: Max 1024 open files allowed, minimum of 40000 recommended. See the Neo4j manual. 2021-06-04 09:06:37.401+0000 INFO Starting... ERROR StatusLogger RollingFileManager (/var/log/neo4j/debug.log) java.io.FileNotFoundException: /var/log/neo4j/debug.log (Permission non accordée) java.io.FileNotFoundException: /var/log/neo4j/debug.log (Permission non accordée) at java.base/java.io.FileOutputStream.open0(Native Method) at java.base/java.io.FileOutputStream.open(FileOutputStream.java:298) at java.base/java.io.FileOutputStream.<init>(FileOutputStream.java:237) at java.base/java.io.FileOutputStream.<init>(FileOutputStream.java:158) at org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory.createManager(RollingFileManager.java:678) at org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory.createManager(RollingFileManager.java:648) at org.neo4j.logging.shaded.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:113) at org.neo4j.logging.shaded.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:100) at org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager.getFileManager(RollingFileManager.java:205) at org.neo4j.logging.shaded.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:146) at org.neo4j.logging.log4j.LogConfig.createRollingFileAppender(LogConfig.java:183) at org.neo4j.logging.log4j.LogConfig.getAppender(LogConfig.java:152) at org.neo4j.logging.log4j.LogConfig.configureLogging(LogConfig.java:105) at org.neo4j.logging.log4j.LogConfig$Builder.build(LogConfig.java:293) at org.neo4j.graphdb.factory.module.GlobalModule.createLogService(GlobalModule.java:337) at org.neo4j.graphdb.factory.module.GlobalModule.<init>(GlobalModule.java:174) at org.neo4j.graphdb.facade.DatabaseManagementServiceFactory.createGlobalModule(DatabaseManagementServiceFactory.java:252) at org.neo4j.graphdb.facade.DatabaseManagementServiceFactory.build(DatabaseManagementServiceFactory.java:126) at org.neo4j.server.CommunityBootstrapper.createNeo(CommunityBootstrapper.java:36) at org.neo4j.server.NeoBootstrapper.start(NeoBootstrapper.java:134) at org.neo4j.server.NeoBootstrapper.start(NeoBootstrapper.java:90) at org.neo4j.server.CommunityEntryPoint.main(CommunityEntryPoint.java:35) 2021-06-04 09:06:37.663+0000 ERROR Failed to start Neo4j on dbms.connector.http.listen_address, a socket address. If missing port or hostname it is acquired from dbms.default_listen_address. java.lang.IllegalStateException: ManagerFactory [org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager$RollingFileManagerFactory@182b435b] unable to create manager for [/var/log/neo4j/debug.log] with data [org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager$FactoryData@4d0402b[pattern=/var/log/neo4j/debug.log.%i, append=true, bufferedIO=true, bufferSize=8192, policy=SizeBasedTriggeringPolicy(size=20971520), strategy=DefaultRolloverStrategy(min=1, max=7, useMax=false), advertiseURI=null, layout=org.neo4j.logging.log4j.Neo4jLogLayout@2fa7ae9, filePermissions=null, fileOwner=null]] at org.neo4j.logging.shaded.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:115) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.shaded.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:100) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.shaded.log4j.core.appender.rolling.RollingFileManager.getFileManager(RollingFileManager.java:205) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.shaded.log4j.core.appender.RollingFileAppender$Builder.build(RollingFileAppender.java:146) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.log4j.LogConfig.createRollingFileAppender(LogConfig.java:183) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.log4j.LogConfig.getAppender(LogConfig.java:152) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.log4j.LogConfig.configureLogging(LogConfig.java:105) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.logging.log4j.LogConfig$Builder.build(LogConfig.java:293) ~[neo4j-logging-4.2.7.jar:4.2.7] at org.neo4j.graphdb.factory.module.GlobalModule.createLogService(GlobalModule.java:337) ~[neo4j-4.2.7.jar:4.2.7] at org.neo4j.graphdb.factory.module.GlobalModule.<init>(GlobalModule.java:174) ~[neo4j-4.2.7.jar:4.2.7] at org.neo4j.graphdb.facade.DatabaseManagementServiceFactory.createGlobalModule(DatabaseManagementServiceFactory.java:252) ~[neo4j-4.2.7.jar:4.2.7] at org.neo4j.graphdb.facade.DatabaseManagementServiceFactory.build(DatabaseManagementServiceFactory.java:126) ~[neo4j-4.2.7.jar:4.2.7] at org.neo4j.server.CommunityBootstrapper.createNeo(CommunityBootstrapper.java:36) ~[neo4j-4.2.7.jar:4.2.7] at org.neo4j.server.NeoBootstrapper.start(NeoBootstrapper.java:134) [neo4j-4.2.7.jar:4.2.7] at org.neo4j.server.NeoBootstrapper.start(NeoBootstrapper.java:90) [neo4j-4.2.7.jar:4.2.7] at org.neo4j.server.CommunityEntryPoint.main(CommunityEntryPoint.java:35) [neo4j-4.2.7.jar:4.2.7] 2021-06-04 09:06:37.707+0000 INFO Neo4j Server shutdown initiated by request 2021-06-04 09:06:37.708+0000 INFO Stopped. I suspected a problem with licence keys and authorizations and I went to the procedure on neo4j.com site for downloading the file neo4j-desktop-1.4.5-x86_64.AppImage making it executable. I filled in the various forms and entered the activation key. I have then be able to make my first run and create a database graph with 3 nodes and 2 relations, even saving a few cypher files but after closing browser and desktop interface I am unable to find a proper way to enter into neo4j desktop. Is is neither listed in the installed applications nor reachable thru the terminal. The command neo4j version gives the return neo4j 4.2.7 and the command neo4j console terminates with the same error as before. Putting directly the url http://localhost:7474/browser/ does not work either. The only way I have is to start from running the *.appimage executable file. Should I remove the first installation version 4.2.7 ? I noticed indeed that the available version int the second installation is 4.2.5. Thanks for your help. Regards Vincent

Hi, I am running neo4j in kubernetes. I expose it via nginx ingress one url for port 7474 - neo4j-url:443 one url for port 7687 - neo4bolt-url:443 everything was working fine I am able to open neo4j-url/browser and connect to neo4j+s://neo4bolt-url:443 But I was trying to connect from my local machine via python script from neo4j import GraphDatabase driver = GraphDatabase.driver("neo4j+s://neo4bolt-url:443", auth=("neo4j","password")) session = driver.session() query = """ MATCH (ee:Person) WHERE ee.from = "Sweden" RETURN ee.name as name """ results = session.run(query) print(results["name"]) I am getting this error Unable to retrieve routing information Traceback (most recent call last): File "db.py", line 14, in <module> results = session.run(query) File "C:\anaconda\lib\site-packages\neo4j\work\simple.py", line 221, in run self._connect(self._config.default_access_mode, database=self._config.database) File "C:\anaconda\lib\site-packages\neo4j\work\simple.py", line 122, in _connect bookmarks=self._bookmarks File "C:\anaconda\lib\site-packages\neo4j\io\__init__.py", line 1118, in acquire bookmarks=bookmarks File "C:\anaconda\lib\site-packages\neo4j\io\__init__.py", line 1087, in _select_address access_mode=access_mode, database=database, bookmarks=bookmarks File "C:\anaconda\lib\site-packages\neo4j\io\__init__.py", line 1069, in ensure_routing_table_is_fresh self.update_routing_table(database=database, bookmarks=bookmarks) File "C:\anaconda\lib\site-packages\neo4j\io\__init__.py", line 1041, in update_routing_table raise ServiceUnavailable("Unable to retrieve routing information") neo4j.exceptions.ServiceUnavailable: Unable to retrieve routing information Not sure what is the problem, any tip ? Thank you

I'm starting a new project and have a core logic(some kind of business analytic) implemented with Neo4j and Spring Boot/SDN5. Right now I'm struggling with the following architectural question - is it a good idea to build the entire application only on Neo4j database or for example leave analytical part on Neo4j and in additional implement the operational part of the application with RDBMS like PostgreSQL. I hope that Neo4j is mature enough to hold all kind of the application data… I mean the data that I typically store in PostgreSQL may be stored also in Neo4j. Please advise - should I go with Neo4j only or no.

0 I wrote a python script to configure Weblogic Domain. I can see there is an error when im trying to execute with the below lines. I tried debugging with different options and still it is throwing the same error. Please help me out here. AttributeError: 'NoneType' object has no attribute 'split' Exporting the Properties to variables.. Problem invoking WLST - Traceback (innermost last): File "/test/wls_domain_creation.py", line 304, in ? File "/test/wls/wls_domain_creation.py", line 61, in export_properties Here are the lines 61 and 304 machines = _dict.get("machines").split(',') export_properties() Thanks in advance