How to solve this cypher problem in Galaxybase?
The log shows:
com.graphdbapi.driver.v1.exceptions.DatabaseException:Cypher task execution blocking time overruns
What causes this problem? How to solve it?
I feel like it's because there are too many concurrent queries. Is concurrency not possible? When I was monitoring, I noticed that during certain periods of high queries, disk reads are much higher than disk IO, why is that?
Yes, there are too many Cypher queries in the queue that haven't finished yet, and new Cypher requests have timed out.
Concurrency is limited and can be modified in the 'User Management' section on the page 8888. Each query incurs resource costs, and when concurrency is high, resources become scarce, increasing the overhead of resource switching.
According to your comment on this answer: The node monitoring on page 51314 of Galaxybase uses the Java OSHI library. Both the Java OSHI library and the 'iostat' command in the server can obtain disk information, but the data range and granularity obtained may slightly differ. The Java OSHI library monitors the IO of the entire server, while 'iostat' can provide specific details about a particular device or data disk. Therefore, when the IO speed displayed on the Galaxybase monitoring page is higher than the IO speed obtained from the 'iostat' command in the server, you need to make sure if the server is solely dedicated to serving the graph database. In a multi-node cluster, the monitoring page of Galaxybase also monitors the disk read rate of each node, using the same method. It is important to check if the server hosting the abnormal node has any other IO tasks.
- I need to count the number of connection between two nodes with a certain property
- Gremlin query, get all the nodes 2 - 4 steps from the selected nodes
- Neo4j - Range index vs Text index when checking membership in list of only strings
- Gremlin Console - Connecting to Amazon Neptune with Sig4 signing
- How to make schema less titan graph?How to set schema-default property?
- How to cypher-query against a named graph in Graph Catalog?
- My match/merge process is not creating relationships in the Neo4J database
- Graph generation in Neo4j for GDS computations
- Bipartite to monopartite projection with multiple relationships
- How to use `project` step with `tree` step in Gremlin query
- How to return vertices from different graphs on a single query with ApacheAGE?
- Issue in Cypher Query - org.neo4j.internal.kernel.api.exceptions.EntityNotFoundException
- create_graph Function does not works
- How to use previous step values to filter the next step [GREMLIN]
- Neo4j driver with transaction timeout: how to detect the timeout event?
- Can we get in/out degree of a node in O(1) time for a node in neo4j?
- Neo4j group nodes with property
- How to return nodes and relationships only if a certain condition is true in cypher
- Is there a method to access specific node and relationship data within a graph catalog in neo4j GDS?
- Show Graph results using Neo4j Python driver
- Gremlin Customized Output using project
- Creating Relationships in Neo4j Without Recreating Nodes
- Multiple Neo4j databases from single instance
- How can I import data into Memgraph Cloud?
- How and where data is actually stored in Apache AGE?
- What's the Cypher script to delete a node by ID?
- Gremlin query optimization to remove redundant data from "path" step
- Modeling values in graph DB - vertex or property?
- AWS Neptune Query is blocking all other queries
- In Arcadedb how do I get a list of vertex types that are subtypes to a supertype?