0

Some details are as follows The nebula version is 3.5.0. The deployment method is Standalone. And the installation method is RPM. The hardware memory is 8g。 Disk (SSD recommended)

I want to know that when I execute MATCH (v:model) RETURN v SKIP 9000000 LIMIT 1000, nebula-graphd crashes toally Not sure the quering way I use is right or not. Or there are other nGQL queries?

The vertex data volume is 10 million Query statement I use is MATCH (v:model) RETURN v SKIP 9000000 LIMIT 1000; Executing the above query statement, the CUP spikes directly to 781%.

nebula-graphd is crashed.

[root@bogon ~]# sudo /root/database/nebula-graph/3.5.0/scripts/nebula.service status all
[WARN] The maximum files allowed to open might be too few: 1024
[INFO] nebula-metad(18fd7b1): Running as 32163, Listening on 9559
[INFO] nebula-graphd(18fd7b1): Exited
[INFO] nebula-storaged(18fd7b1): Running as 32371, Listening on 9779


**对应nebula-graphd错误日志**
E20230606 09:50:43.122964  1095 StorageClientBase-inl.h:227] Request to "127.0.0.1":9779 failed: Channel got EOF. Check for server hitting connection limit, server connection idle timeout, and server crashes.
E20230606 09:50:43.685348   901 StorageClientBase-inl.h:143] There some RPC errors: RPC failure in StorageClient: Channel got EOF. Check for server hitting connection limit, server connection idle timeout, and server crashes.
E20230606 09:50:44.250437   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 5
E20230606 09:50:44.250527   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 4
E20230606 09:50:44.250533   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 3
E20230606 09:50:44.250538   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 1
E20230606 09:50:44.250542   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 2
E20230606 09:50:44.250547   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 6
E20230606 09:50:44.250552   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 10
E20230606 09:50:44.250556   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 11
E20230606 09:50:44.250560   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 9
E20230606 09:50:44.250566   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 8
E20230606 09:50:44.250569   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 7
E20230606 09:50:44.250573   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 12
E20230606 09:50:44.250578   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 13
E20230606 09:50:44.250582   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 14
E20230606 09:50:44.250597   903 StorageAccessExecutor.h:47] AppendVerticesExecutor failed, error E_RPC_FAILURE, part 15
E20230606 09:50:44.250741   903 QueryInstance.cpp:151] Storage Error: RPC failure, probably timeout., query: MATCH (v:model) RETURN v SKIP 9000000 LIMIT 1000;
I20230606 09:53:56.374083  1410 FunctionUdfManager.cpp:93] Load UDF so library: /home/nebula/dev/nebula/udf/
E20230606 09:53:56.374212  1410 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!

0 Answers0