NebulaGraph 3.6.0 在龙蜥（Anolis）8.2 上占用大量内存

JayceCao · 2024 年1 月 16 日 04:31

nebula 版本：

CleanShot 2024-01-16 at 12.02.52@2x1856×564 110 KB
部署方式：单机
安装方式：Docker
是否上生产环境：N
发行版：Anolis OS 8.2
内核版本：4.19.91-24.8.an8.x86_64
硬件信息
- 磁盘：

Device Model:     HUS726040ALA610
Serial Number:    K4GM2V4B
LU WWN Device Id: 5 000cca 25dc8adb9
Firmware Version: T7R4
User Capacity:    4,000,787,030,016 bytes [4.00 TB]

- CPU：

Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz，24 核

- 内存：

问题的具体描述：根据文档，导入 basketballplayer 数据，执行文档中的查询语句。过了一段时间发现终端输入字符时很卡，看监控发现内存被打满。

CleanShot 2024-01-16 at 12.15.45@2x2158×972 310 KB
graphd error 日志：

# graph
Log file created at: 2024/01/16 01:35:36
Running on machine: a9bd83544cfe
Running duration (h:mm:ss): 0:00:00
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20240116 01:35:36.694566    38 QueryInstance.cpp:151] SpaceNotFound: Space not existed!, query: drop space basketballplayer;
E20240116 01:53:08.886267    39 Serializer.h:43] Thrift serialization is only defined for structs and unions, not containers thereof. Attemping to serialize a value of type `nebula::Value`.
E20240116 01:54:17.842634    37 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 01:57:20.158600    39 QueryInstance.cpp:151] SyntaxError: syntax error near `) RETURN', query: MATCH (v:player{name:"Tim Duncan"})--(v2:player{name:"Shaquille O'Neal") RETURN v2;
E20240116 01:59:17.842994   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:04:17.843129   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:09:17.843317   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:14:17.977002   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:19:20.608579   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:20:01.765075    36 QueryInstance.cpp:151] SemanticError: Expression (id(team)=="team204") not supported yet, query: LOOKUP ON team WHERE id(team) == "team204" YIELD team.name AS name;
E20240116 02:21:58.326303    42 OptimizerUtils.cpp:683] No valid index found
E20240116 02:22:40.066740    36 QueryInstance.cpp:151] SemanticError: Alias used but not defined: `e', query: MATCH (v:player{name: "Shaquille O'Neal"}) RETURN e;
E20240116 02:24:20.649152   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:28:59.153226    42 QueryInstance.cpp:151] SyntaxError: syntax error near `| LOOKUP', query: MATCH (v:player{name: "Shaquille O'Neal"})-[e:serve]-() | LOOKUP ON team WHERE id(team) == id(e) YIELD team.name;
E20240116 02:29:20.672649   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:34:20.672813   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:34:38.254338    37 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY e.serve.start_year;
E20240116 02:38:26.796097    42 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY e.start_year;
E20240116 02:39:20.836097   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:40:01.259109    41 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY p.serve.start_year;
E20240116 02:44:21.108278   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:49:22.173306   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:54:24.298856   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:59:26.880333   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 03:04:40.607980   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 03:07:38.239843    55 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:07:39.145464    56 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:10:17.099110   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!

# graph1
Log file created at: 2024/01/16 03:11:31
Running on machine: ef0d8b38e384
Running duration (h:mm:ss): 0:00:01
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20240116 03:11:31.880359    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:13:45.141377    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2

# graph2
Log file created at: 2024/01/16 03:07:38
Running on machine: e71b825ec24d
Running duration (h:mm:ss): 0:00:02
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20240116 03:07:38.239845    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:11:31.880359    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:12:52.339529    65 MetaClient.cpp:772] Send request to "metad1":9559, exceed retry limit
E20240116 03:13:03.741664    65 MetaClient.cpp:773] RpcResponse exception: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:13:15.548482    61 MetaClient.cpp:192] Heartbeat failed, status:RPC failure in MetaClient: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:14:12.564050    67 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2

graphd info 日志：

# graph
Log file created at: 2024/01/16 03:14:47
Running on machine: a9bd83544cfe
Running duration (h:mm:ss): 0:00:00
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
I20240116 03:14:47.852543     1 GraphDaemon.cpp:122] Starting Graph HTTP Service
I20240116 03:14:47.913209     7 WebService.cpp:124] Web service started on HTTP[19669]
I20240116 03:14:47.913270     1 GraphDaemon.cpp:136] Number of networking IO threads: 24
I20240116 03:14:47.913282     1 GraphDaemon.cpp:145] Number of worker threads: 24
I20240116 03:14:47.940410     1 MetaClient.cpp:80] Create meta client to "metad1":9559
I20240116 03:14:47.940448     1 MetaClient.cpp:81] root path: /usr/local/nebula, data path size: 0
I20240116 03:14:47.965989    51 ThriftClientManager-inl.h:67] resolve "metad0":9559 as "172.25.0.4":9559
I20240116 03:14:48.952415     1 GraphDaemon.cpp:176] Signal 15(Terminated) received, stopping this server
I20240116 03:14:49.008836    51 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.164445    52 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.185679    53 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.238219    54 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.297188    55 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.320494    56 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.364967    57 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.398056    58 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.400260    59 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.457556    60 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.516129    61 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.526012    62 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.533581    63 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.557780    64 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.559803    65 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.568444     1 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 03:14:49.568464     1 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 03:14:49.568470     1 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 03:14:49.568475     1 MetaClient.cpp:3269] Load leader ok
I20240116 03:14:49.570077    66 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.624908    67 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.709306     1 MetaClient.cpp:162] Register time task for heartbeat!
I20240116 03:14:49.712251    68 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.712882     1 GraphSessionManager.cpp:337] Total of 1 sessions are loaded
I20240116 03:14:49.713513     1 MemoryUtils.cpp:171] MemoryTracker set static ratio: 0.8
I20240116 03:14:49.715866    71 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 03:14:49.729043     1 Snowflake.cpp:17] WorkerId init success: 2
I20240116 03:14:49.730340    74 GraphServer.cpp:63] Starting nebula-graphd on graphd:9669

# graph1
Log file created at: 2024/01/16 01:30:28
Running on machine: ef0d8b38e384
Running duration (h:mm:ss): 0:00:00
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
I20240116 01:30:28.098479     1 GraphDaemon.cpp:122] Starting Graph HTTP Service
I20240116 01:30:28.101351     7 WebService.cpp:124] Web service started on HTTP[19669]
I20240116 01:30:28.101406     1 GraphDaemon.cpp:136] Number of networking IO threads: 24
I20240116 01:30:28.101418     1 GraphDaemon.cpp:145] Number of worker threads: 24
I20240116 01:30:28.106415     1 MetaClient.cpp:80] Create meta client to "metad1":9559
I20240116 01:30:28.106446     1 MetaClient.cpp:81] root path: /usr/local/nebula, data path size: 0
I20240116 01:30:28.117405    51 ThriftClientManager-inl.h:67] resolve "metad0":9559 as "172.25.0.4":9559
I20240116 01:30:29.119930    51 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.121471    52 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.122524    53 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.123416    54 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.140060    55 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.141055    56 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.142002    57 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.143028    58 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.143446     1 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 0 space
I20240116 01:30:29.143460     1 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 0 space
I20240116 01:30:29.143464     1 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 0 space
I20240116 01:30:29.143468     1 MetaClient.cpp:3269] Load leader ok
I20240116 01:30:29.144042    59 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.145054    60 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.145917     1 MetaClient.cpp:162] Register time task for heartbeat!
I20240116 01:30:29.146606    61 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.146989     1 GraphSessionManager.cpp:337] Total of 0 sessions are loaded
I20240116 01:30:29.147253     1 MemoryUtils.cpp:171] MemoryTracker set static ratio: 0.8
I20240116 01:30:29.147802    64 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:29.148766     1 Snowflake.cpp:17] WorkerId init success: 2
I20240116 01:30:29.148994    67 GraphServer.cpp:63] Starting nebula-graphd on graphd1:9669
I20240116 01:30:39.454906    66 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:49.457366    68 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:59.460359    69 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:09.471248    70 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:19.476728    71 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:29.485121    72 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:39.487741    73 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:49.492321    74 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:59.503998    75 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:09.510124    76 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:19.521700    77 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:29.523311    78 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:35:39.679320    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 0 space
I20240116 01:35:39.679358    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 0 space
I20240116 01:35:39.679363    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 0 space
I20240116 01:35:39.679366    62 MetaClient.cpp:3269] Load leader ok
I20240116 01:35:49.687975    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 01:35:49.688001    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 0 space
I20240116 01:35:49.688005    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 0 space
I20240116 01:35:49.688010    62 MetaClient.cpp:3269] Load leader ok
I20240116 01:35:59.701759    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 01:35:59.701786    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 01:35:59.701794    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 01:35:59.701798    62 MetaClient.cpp:3269] Load leader ok
I20240116 01:36:19.714409    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 01:36:19.714444    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 01:36:19.714452    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 01:36:19.714457    62 MetaClient.cpp:3269] Load leader ok
I20240116 02:59:38.558979    52 ThriftClientManager-inl.h:67] resolve "metad1":9559 as "172.25.0.2":9559
E20240116 03:11:31.880359    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:13:45.141377    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
I20240116 03:14:27.100344    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 03:14:27.201112    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 03:14:27.201146    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 03:14:27.201151    62 MetaClient.cpp:3269] Load leader ok
I20240116 03:14:36.127177     1 GraphDaemon.cpp:176] Signal 15(Terminated) received, stopping this server
I20240116 03:14:37.637274    62 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 03:14:37.637305    62 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 03:14:37.637311    62 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 03:14:37.637315    62 MetaClient.cpp:3269] Load leader ok
I20240116 03:14:42.507504    67 GraphServer.cpp:74] nebula-graphd on graphd1:9669 has been stopped
I20240116 03:14:42.583534     1 GraphDaemon.cpp:161] The graph Daemon stopped
I20240116 03:14:42.583567     1 GraphServer.cpp:109] The graph server has been stopped

# graph2 
Log file created at: 2024/01/16 01:30:28
Running on machine: e71b825ec24d
Running duration (h:mm:ss): 0:00:00
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
I20240116 01:30:28.012300     1 GraphDaemon.cpp:122] Starting Graph HTTP Service
I20240116 01:30:28.015218     7 WebService.cpp:124] Web service started on HTTP[19669]
I20240116 01:30:28.015261     1 GraphDaemon.cpp:136] Number of networking IO threads: 24
I20240116 01:30:28.015275     1 GraphDaemon.cpp:145] Number of worker threads: 24
I20240116 01:30:28.019630     1 MetaClient.cpp:80] Create meta client to "metad2":9559
I20240116 01:30:28.019651     1 MetaClient.cpp:81] root path: /usr/local/nebula, data path size: 0
I20240116 01:30:28.030588    51 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.034197    52 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.035327    53 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.036329    54 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.037362    55 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.060190    56 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.061537    57 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.062619    58 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.063141     1 MetaClient.cpp:3269] Load leader ok
I20240116 01:30:28.063670    59 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.064589    60 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.066671     1 MetaClient.cpp:162] Register time task for heartbeat!
I20240116 01:30:28.067392    63 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.067811     1 GraphSessionManager.cpp:337] Total of 0 sessions are loaded
I20240116 01:30:28.068130     1 MemoryUtils.cpp:171] MemoryTracker set static ratio: 0.8
I20240116 01:30:28.068781    65 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:28.073123     1 Snowflake.cpp:17] WorkerId init success: 0
I20240116 01:30:28.073371    66 GraphServer.cpp:63] Starting nebula-graphd on graphd2:9669
I20240116 01:30:38.548943    67 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:48.557371    68 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:30:58.566351    69 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:08.578078    70 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:18.584359    71 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:28.586759    72 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:38.598575    73 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:48.610188    74 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:31:58.621779    75 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:08.633555    76 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:18.645252    77 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:32:28.656338    78 ThriftClientManager-inl.h:67] resolve "metad2":9559 as "172.25.0.3":9559
I20240116 01:35:38.799141    61 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 0 space
I20240116 01:35:38.799176    61 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 0 space
I20240116 01:35:38.799182    61 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 0 space
I20240116 01:35:38.799187    61 MetaClient.cpp:3269] Load leader ok
I20240116 01:35:58.821540    61 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 01:35:58.821614    61 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 01:35:58.821622    61 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 01:35:58.821627    61 MetaClient.cpp:3269] Load leader ok
I20240116 01:36:18.845428    61 MetaClient.cpp:3263] Load leader of "storaged0":9779 in 1 space
I20240116 01:36:18.845459    61 MetaClient.cpp:3263] Load leader of "storaged1":9779 in 1 space
I20240116 01:36:18.845467    61 MetaClient.cpp:3263] Load leader of "storaged2":9779 in 1 space
I20240116 01:36:18.845472    61 MetaClient.cpp:3269] Load leader ok
I20240116 02:49:24.184162    60 ThriftClientManager-inl.h:67] resolve "metad0":9559 as "172.25.0.4":9559
E20240116 03:07:38.239845    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:11:31.880359    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:12:52.339529    65 MetaClient.cpp:772] Send request to "metad1":9559, exceed retry limit
E20240116 03:13:03.741664    65 MetaClient.cpp:773] RpcResponse exception: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:13:15.548482    61 MetaClient.cpp:192] Heartbeat failed, status:RPC failure in MetaClient: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:14:12.564050    67 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
I20240116 03:14:24.560225    67 ThriftClientManager-inl.h:67] resolve "metad1":9559 as "172.25.0.2":9559
I20240116 03:14:36.069981     1 GraphDaemon.cpp:176] Signal 15(Terminated) received, stopping this server
I20240116 03:14:44.207587    66 GraphServer.cpp:74] nebula-graphd on graphd2:9669 has been stopped
I20240116 03:14:44.208636     1 GraphDaemon.cpp:161] The graph Daemon stopped
I20240116 03:14:44.208659     1 GraphServer.cpp:109] The graph server has been stopped

graph warn 日志

# graph
Log file created at: 2024/01/16 01:35:36
Running on machine: a9bd83544cfe
Running duration (h:mm:ss): 0:00:00
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
W20240116 01:35:36.694096    40 SpaceExecutor.cpp:116] Get space ID failed when prepare text index: basketballplayer
W20240116 01:35:36.694535    40 SpaceExecutor.cpp:125] Drop space `basketballplayer' failed: SpaceNotFound: Space not existed!
E20240116 01:35:36.694566    38 QueryInstance.cpp:151] SpaceNotFound: Space not existed!, query: drop space basketballplayer;
E20240116 01:53:08.886267    39 Serializer.h:43] Thrift serialization is only defined for structs and unions, not containers thereof. Attemping to serialize a value of type `nebula::Value`.
E20240116 01:54:17.842634    37 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 01:57:20.158600    39 QueryInstance.cpp:151] SyntaxError: syntax error near `) RETURN', query: MATCH (v:player{name:"Tim Duncan"})--(v2:player{name:"Shaquille O'Neal") RETURN v2;
E20240116 01:59:17.842994   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:04:17.843129   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:09:17.843317   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:14:17.977002   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:19:20.608579   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:20:01.765075    36 QueryInstance.cpp:151] SemanticError: Expression (id(team)=="team204") not supported yet, query: LOOKUP ON team WHERE id(team) == "team204" YIELD team.name AS name;
E20240116 02:21:58.326303    42 OptimizerUtils.cpp:683] No valid index found
E20240116 02:22:40.066740    36 QueryInstance.cpp:151] SemanticError: Alias used but not defined: `e', query: MATCH (v:player{name: "Shaquille O'Neal"}) RETURN e;
E20240116 02:24:20.649152   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:28:59.153226    42 QueryInstance.cpp:151] SyntaxError: syntax error near `| LOOKUP', query: MATCH (v:player{name: "Shaquille O'Neal"})-[e:serve]-() | LOOKUP ON team WHERE id(team) == id(e) YIELD team.name;
E20240116 02:29:20.672649   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:34:20.672813   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:34:38.254338    37 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY e.serve.start_year;
E20240116 02:38:26.796097    42 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY e.start_year;
E20240116 02:39:20.836097   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:40:01.259109    41 QueryInstance.cpp:151] SemanticError: Only column name can be used as sort item, query: MATCH p=(v:player{name:"Shaquille O'Neal"})-[e:serve]-(t) RETURN p ORDER BY p.serve.start_year;
E20240116 02:44:21.108278   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:49:22.173306   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:54:24.298856   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 02:59:26.880333   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 03:04:40.607980   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!
E20240116 03:07:38.239843    55 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:07:39.145464    56 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:10:17.099110   412 FunctionUdfManager.cpp:41] UDF Folder doesn't Exist!

# graph1
Log file created at: 2024/01/16 03:11:31
Running on machine: ef0d8b38e384
Running duration (h:mm:ss): 0:00:01
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20240116 03:11:31.880359    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:13:45.141377    54 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2

# graph2
Log file created at: 2024/01/16 03:07:38
Running on machine: e71b825ec24d
Running duration (h:mm:ss): 0:00:01
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20240116 03:07:38.239845    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad0': Name or service not known (error=-2): Unknown error -2
E20240116 03:11:31.880359    65 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2
E20240116 03:12:52.339529    65 MetaClient.cpp:772] Send request to "metad1":9559, exceed retry limit
E20240116 03:13:03.741664    65 MetaClient.cpp:773] RpcResponse exception: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:13:15.548482    61 MetaClient.cpp:192] Heartbeat failed, status:RPC failure in MetaClient: apache::thrift::transport::TTransportException: Connection not open: apache::thrift::transport::TTransportException: AsyncSocketException: setReadCallback() called with socket in invalid state, type = Socket not open
E20240116 03:14:12.564050    67 ThriftClientManager-inl.h:70] Failed to resolve address for 'metad1': Name or service not known (error=-2): Unknown error -2

steam · 2024 年1 月 16 日 04:32

看下这个帖子。

steam · 2024 年1 月 16 日 07:38

JayceCao:

E20240116 02:28:59.153226    42 QueryInstance.cpp:151] SyntaxError: syntax error near `| LOOKUP', query: MATCH (v:player{name: "Shaquille O'Neal"})-[e:serve]-() | LOOKUP ON team WHERE id(team) == id(e) YIELD team.name;

这个语句是有问题的，不能 openCypher（MATCH）和 nGQL（LOOKUP）混用，会报错。

steam · 2024 年1 月 16 日 07:41

你看下找你资源使用情况，其实 cpu 和 memory 占用高的是 qemu-kvm 也就是你的虚拟机。

JayceCao · 2024 年1 月 16 日 08:05

nebula 内存占用情况是第二张图，graphd 进程实际占用 24G 内存。重启了 nebula 之后就好了，当时忘了看后台有没有正在运行的查询，可能是哪个查询很耗时，容器重建了，命令历史也没了，看后续能不能再触发这个问题。

steam · 2024 年1 月 16 日 08:07

根据第二楼的那个内存占用整合帖，如果你做查询的时候也在做数据写入的话，是会导致你遇到的这种使用内存暴涨的情况的。

JayceCao · 2024 年1 月 16 日 08:10

没有写入数据，只是查询。

steam · 2024 年1 月 16 日 10:50

那等你下次遇到的时候再记录下呀。

system · 2024 年2 月 15 日 10:50

此话题已在最后回复的 30 天后被自动关闭。不再允许新回复。