write WAL failed for SQL error

[A-M-K-G]

这里使用的版本是0.12.2-SNAPSHOT
在尝试写入数据的时候出现了write WAL failed for SQL错误：
java.sql.BatchUpdateException:
org.apache.iotdb.db.exception.StorageEngineException: org.apache.iotdb.db.exception.WriteProcessException: root.00HZ020001-861854040009076/0: /data/data/iotdb/sbin/./../data/data/unsequence/root.00HZ020001-861854040009076/0/0/1628850185018-2-0-0.tsfile write WAL failed for SQL: "insert into root.00HZ020001-861854040009076.signalNoiseRatio(timestamp,systemtime,value) values(2021-07-25 14:15:00,1627193720000,131.0);"

请问是什么原因以及有什么办法能解决呢

[HTHou]

我单独执行这条语句也会报错。

IoTDB> insert into root.00HZ020001-861854040009076.signalNoiseRatio(timestamp,systemtime,value) values(2021-07-25 14:15:00,1627193720000,131.0);
Msg: 401: Error occurred while parsing SQL to physical plan: line 1:82 mismatched input 'value' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, INTO...

[HTHou]

原因是 #3621 把 value 这个词变成了sql关键字，造成了语法报错。

[A-M-K-G]

这里是iotdb的错误日志
logs.zip

[HTHou]

我在日志里看到了 堆外内存OOM的信息。wal失败就是因为这个原因。
想问一下具体配置，内存开了多大，多少个客户端连接，多少个存储组？

2021-08-16 17:32:26,355 [pool-9-IoTDB-RPC-Client-745] ERROR o.a.i.d.c.IoTDBDefaultThreadExceptionHandler:31 - Exception in thread pool-9-IoTDB-RPC-Client-745-4151 
java.lang.OutOfMemoryError: Direct buffer memory
	at java.nio.Bits.reserveMemory(Bits.java:695)
	at java.nio.DirectByteBuffer.<init>(DirectByteBuffer.java:123)
	at java.nio.ByteBuffer.allocateDirect(ByteBuffer.java:311)
	at org.apache.iotdb.db.engine.storagegroup.StorageGroupProcessor.getWalDirectByteBuffer(StorageGroupProcessor.java:303)
	at org.apache.iotdb.db.writelog.manager.MultiFileLogNodeManager.getNode(MultiFileLogNodeManager.java:90)
	at org.apache.iotdb.db.engine.storagegroup.TsFileProcessor.getLogNode(TsFileProcessor.java:996)
	at org.apache.iotdb.db.engine.storagegroup.TsFileProcessor.insert(TsFileProcessor.java:195)
	at org.apache.iotdb.db.engine.storagegroup.StorageGroupProcessor.insertToTsFileProcessor(StorageGroupProcessor.java:1049)
	at org.apache.iotdb.db.engine.storagegroup.StorageGroupProcessor.insert(StorageGroupProcessor.java:828)
	at org.apache.iotdb.db.engine.StorageEngine.insert(StorageEngine.java:544)
	at org.apache.iotdb.db.qp.executor.PlanExecutor.insert(PlanExecutor.java:1318)
	at org.apache.iotdb.db.qp.executor.PlanExecutor.insert(PlanExecutor.java:1300)
	at org.apache.iotdb.db.qp.executor.PlanExecutor.processNonQuery(PlanExecutor.java:249)
	at org.apache.iotdb.db.service.TSServiceImpl.executeNonQuery(TSServiceImpl.java:1134)
	at org.apache.iotdb.db.service.TSServiceImpl.executeNonQueryPlan(TSServiceImpl.java:1872)
	at org.apache.iotdb.db.service.TSServiceImpl.executeInsertRowsPlan(TSServiceImpl.java:376)
	at org.apache.iotdb.db.service.TSServiceImpl.executeBatchList(TSServiceImpl.java:457)
	at org.apache.iotdb.db.service.TSServiceImpl.executeBatchStatement(TSServiceImpl.java:513)
	at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeBatchStatement.getResult(TSIService.java:2398)
	at org.apache.iotdb.service.rpc.thrift.TSIService$Processor$executeBatchStatement.getResult(TSIService.java:2378)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
	at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:248)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

[A-M-K-G]

Maximum memory allocation pool = 8000MB, initial memory allocation pool = 800MB
客户端连接只有一个，存储组是1313个

[HTHou]

wal_buffer_size 应当小于 8000MB / 存储组数量
1313个存储组太多了，我们建议的存储组数量是CPU核数。

[A-M-K-G]

好的，我尝试调整一下结构减少存储组数量
另外目前的时间序列个数是15600个，这个数量的时间序列会不会有影响呢

[HTHou]

好的，我尝试调整一下结构减少存储组数量
另外目前的时间序列个数是15600个，这个数量的时间序列会不会有影响呢

没有影响

[A-M-K-G]

好的，十分感谢