Neo4j

Hi there, We're using Neo4j 4.2 Enterpise Edition. In our app we have a query like this: MATCH path=(b:BaseHierarchy)-[]->(n:Group)-[:PARENT_OF*]->(c:Client) WHERE n.code = 'XXXXX' AND c.code IN ["AAA","BBB","CCC","DDD"] WITH collect(path) as paths, b WITH b, reduce(a=[], node in reduce(b=[],c in [aa in paths | nodes(aa)] | b + c) | case when node in a then a else a + node end) as nodes, reduce(d=[], relationship in reduce(e=[],f in [dd in paths | relationships(dd)] | e + f) | case when relationship in d then d else d + relationship end) as relationships RETURN b, relationships, nodes; The query runs very fast and I get the result I expect. The goal of this query is to get a node and only SOME of its child (the ones specified in the List). After this query runs, we build its "negated" version which is something like this: MATCH path=(b:BaseHierarchy)-[]->(n:Group)-[:PARENT_OF*]->(c:Client) WHERE n.code = 'XXXXX' AND (NOT c.code IN ["AAA","BBB","CCC","DDD"] WITH collect(path) as paths, b WITH b, reduce(a=[], node in reduce(b=[],c in [aa in paths | nodes(aa)] | b + c) | case when node in a then a else a + node end) as nodes, reduce(d=[], relationship in reduce(e=[],f in [dd in paths | relationships(dd)] | e + f) | case when relationship in d then d else d + relationship end) as relationships RETURN b, relationships, nodes; Note: Please do not mind the reduce, it's there because we're using Spring Data Neo4j and we need it to make things work (we'd have to change versions which isn't feasible to do right now). The query is intended to get all nodes that aren't the ones I selected previously, this is the first approach that worked for us. In this case, the query is VERY slow, sometimes depending on the subgraph it doesn't even finish. I'm aware that one of the reasons this negated version of the query isn't performant because the WHERE clause isn't supposed to be used like this as it is evaluated at every node/level. After researching a bit, I came up with this article Performing pattern negation to multiple nodes - Knowledge Base where it teaches how to use pattern negation but I can't make it work with my query. Would someone give me a hand on how to proceed? Thanks EDIT: I should say that the :Group node has a very large subgraph under it, over 300 direct children and these children may each have more children N times

Hi, We're using Neo4j 4.2 Enterprise Edition and we have a Causal Cluster set up for our pre-prod and prod environments. We've just updated to Neo4j 4.2 and we're using neo4j:// protocol pointing to the cluster DNS address. After the application starts, when I make any requests this exception is thrown (the most important lines): 2021-04-30 12:09:33.781 WARN 1 --- [o4jDriverIO-2-2] org.neo4j.driver.LoadBalancer : Received a recoverable discovery error with server 'ntjerarquias.scib.pre.corp(180.18.196.19):7687', will continue discovery with other routing servers if available. org.neo4j.driver.exceptions.DiscoveryException: Failed to update routing table with server 'ntjerarquias.scib.pre.corp(180.18.196.19):7687'. at org.neo4j.driver.internal.cluster.RediscoveryImpl.handleRoutingProcedureError(RediscoveryImpl.java:259) [neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.RediscoveryImpl.lambda$lookupOnRouter$8(RediscoveryImpl.java:240) [neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:1990) ~[na:1.8.0_272] at org.neo4j.driver.internal.util.Futures.lambda$asCompletionStage$0(Futures.java:97) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:551) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.access$200(DefaultPromise.java:35) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise$1.run(DefaultPromise.java:501) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_272] Caused by: org.neo4j.driver.exceptions.ServiceUnavailableException: Unable to connect to ntjerarquias.scib.pre.corp(180.18.196.19):7687, ensure the database is running and that there is a working network connection to it. at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.databaseUnavailableError(ChannelConnectedListener.java:76) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.operationComplete(ChannelConnectedListener.java:70) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.operationComplete(ChannelConnectedListener.java:37) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:570) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:549) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:263) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] ... 7 common frames omitted Caused by: org.neo4j.driver.internal.shaded.io.netty.channel.ConnectTimeoutException: connection timed out: ntjerarquias.scib.pre.corp/180.18.196.19:7687 at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:261) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] ... 9 common frames omitted 2021-04-30 12:09:33.783 ERROR 1 --- [o4jDriverIO-2-2] org.neo4j.driver.LoadBalancer : Failed to update routing table for database '<default database>'. Current routing table: Ttl 1619777343733, currentTime 1619777373782, routers AddressSet=[], writers AddressSet=[], readers AddressSet=[], database '<default database>'. org.neo4j.driver.exceptions.ServiceUnavailableException: Could not perform discovery for database '<default database>'. No routing server available. at org.neo4j.driver.internal.cluster.RediscoveryImpl.lookupClusterComposition(RediscoveryImpl.java:92) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.RoutingTableHandlerImpl.ensureRoutingTable(RoutingTableHandlerImpl.java:85) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.RoutingTableRegistryImpl.ensureRoutingTable(RoutingTableRegistryImpl.java:56) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.loadbalancing.LoadBalancer.acquireConnection(LoadBalancer.java:99) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.async.NetworkSession.lambda$acquireConnection$20(NetworkSession.java:282) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:995) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2137) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:110) ~[na:1.8.0_272] at org.neo4j.driver.internal.async.NetworkSession.acquireConnection(NetworkSession.java:275) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.async.NetworkSession.lambda$beginTransactionAsync$3(NetworkSession.java:108) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:995) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2137) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:110) ~[na:1.8.0_272] at org.neo4j.driver.internal.async.NetworkSession.beginTransactionAsync(NetworkSession.java:108) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.async.NetworkSession.beginTransactionAsync(NetworkSession.java:99) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.InternalSession.beginTransaction(InternalSession.java:98) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.springframework.data.neo4j.core.transaction.Neo4jTransactionManager.doBegin(Neo4jTransactionManager.java:164) ~[spring-data-neo4j-6.0.3.jar!/:6.0.3] at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:595) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:382) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.3.jar!/:5.3.3] at com.sun.proxy.$Proxy144.findAll(Unknown Source) ~[na:na] at com.gs.scib.jquest.service.segments.segment.SegmentServiceImpl.findAllSegments(SegmentServiceImpl.java:36) ~[classes!/:1.1.0] at com.gs.scib.jquest.controller.SegmentController.getAllSegment(SegmentController.java:74) ~[classes!/:1.1.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_272] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_272] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_272] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_272] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.3.jar!/:5.3.3] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) ~[spring-web-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) ~[tomcat-embed-core-9.0.41.jar!/:4.0.FR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.3.jar!/:5.3.3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.41.jar!/:4.0.FR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.41.jar!/:9.0.41] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_272] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_272] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.41.jar!/:9.0.41] at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_272] Suppressed: org.neo4j.driver.exceptions.DiscoveryException: Failed to update routing table with server 'ntjerarquias.scib.pre.corp(180.18.196.19):7687'. at org.neo4j.driver.internal.cluster.RediscoveryImpl.handleRoutingProcedureError(RediscoveryImpl.java:259) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.RediscoveryImpl.lambda$lookupOnRouter$8(RediscoveryImpl.java:240) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:1990) ~[na:1.8.0_272] at org.neo4j.driver.internal.util.Futures.lambda$asCompletionStage$0(Futures.java:97) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:551) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.access$200(DefaultPromise.java:35) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise$1.run(DefaultPromise.java:501) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] ... 1 common frames omitted Caused by: org.neo4j.driver.exceptions.ServiceUnavailableException: Unable to connect to ntjerarquias.scib.pre.corp(180.18.196.19):7687, ensure the database is running and that there is a working network connection to it. at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.databaseUnavailableError(ChannelConnectedListener.java:76) at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.operationComplete(ChannelConnectedListener.java:70) at org.neo4j.driver.internal.async.connection.ChannelConnectedListener.operationComplete(ChannelConnectedListener.java:37) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:570) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:549) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:263) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) ... 7 common frames omitted Caused by: org.neo4j.driver.internal.shaded.io.netty.channel.ConnectTimeoutException: connection timed out: ntjerarquias.scib.pre.corp/180.18.196.19:7687 at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:261) ... 9 common frames omitted 2021-04-30 12:09:33.788 ERROR 1 --- [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not open a new Neo4j session: Could not perform discovery for database '<default database>'. No routing server available.; nested exception is org.neo4j.driver.exceptions.ServiceUnavailableException: Could not perform discovery for database '<default database>'. No routing server available.] with root cause org.neo4j.driver.exceptions.ServiceUnavailableException: Could not perform discovery for database '<default database>'. No routing server available. at org.neo4j.driver.internal.util.Futures.blockingGet(Futures.java:143) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.InternalSession.beginTransaction(InternalSession.java:98) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.springframework.data.neo4j.core.transaction.Neo4jTransactionManager.doBegin(Neo4jTransactionManager.java:164) ~[spring-data-neo4j-6.0.3.jar!/:6.0.3] at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:595) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:382) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.3.jar!/:5.3.3] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) [tomcat-embed-core-9.0.41.jar!/:9.0.41] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.41.jar!/:9.0.41] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_272] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_272] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.41.jar!/:9.0.41] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_272] Suppressed: org.neo4j.driver.exceptions.DiscoveryException: Failed to update routing table with server 'ntjerarquias.scib.pre.corp(180.18.196.19):7687'. at org.neo4j.driver.internal.cluster.RediscoveryImpl.handleRoutingProcedureError(RediscoveryImpl.java:259) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at org.neo4j.driver.internal.cluster.RediscoveryImpl.lambda$lookupOnRouter$8(RediscoveryImpl.java:240) ~[neo4j-java-driver-4.1.1.jar!/:4.1.1-eac256ab0fe1a26e16b8c683fb90af7d3e0c471c] at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811) ~[na:1.8.0_272] at java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:488) ~[na:1.8.0_272] ... 1 common frames omitted Caused by: org.neo4j.driver.exceptions.ServiceUnavailableException: Unable to connect to ntjerarquias.scib.pre.corp(180.18.196.19):7687, ensure the database is running and that there is a working network connection to it. ... 7 common frames omitted Caused by: org.neo4j.driver.internal.shaded.io.netty.channel.ConnectTimeoutException: connection timed out: ntjerarquias.scib.pre.corp/180.18.196.19:7687 at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:261) ... 9 common frames omitted Suppressed: org.neo4j.driver.internal.util.ErrorUtil$InternalExceptionCause: null What could be the issue? Thanks

Hi, We have a Neo4j Causal Cluster with 3 nodes. Each node has a 20G disk partition designated for Neo4j to use. After upgrading from 3.5 to 4.2, we tried to import data into the Cluster without success. The data to be imported is about 2-3Gb in total. The error is: org.neo4j.internal.kernel.api.exceptions.TransactionFailureException: org.neo4j.kernel.availability.UnavailableException: Timeout waiting for database to become available and allow new transactions. Waited 10s. 2 reasons for blocking: Clustering components have encountered a critical error: No space left on device, Database unavailable. Help? If any details are missing please just ask Thanks

Hi, I'm using Neo4j Enterprise Edition v4.2.1 and Spring Data Neo4j 6.0.3. I have the following Query: MATCH path=(b:BaseHierarchy)-[]->(n:Group)-[:PARENT_OF*]->(c:Client) WHERE n.code = 'BPCEG' AND c.industry = '1005' WITH collect(path) as paths, b WITH b, reduce(a=[], node in reduce(b=[],c in [aa in paths | nodes(aa)] | b + c) | case when node in a then a else a + node end) as nodes, reduce(d=[], relationship in reduce(e=[],f in [dd in paths | relationships(dd)] | e + f) | case when relationship in d then d else d + relationship end) as relationships RETURN b, relationships, nodes; If I execute it in the Neo4j Browser I get the following graph: But if I run the same query using Neo4jTemplate.findOne(query, new HashMap<>(), BaseHierarchyNode.class) The result only includes the first-level children of the blue node BPCEG.