You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2022/12/07 06:03:00 UTC
[jira] [Reopened] (IOTDB-4450) [ StandAloneConsensus] Very low write performance at 100k timeseries per dev
[ https://issues.apache.org/jira/browse/IOTDB-4450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
刘珍 reopened IOTDB-4450:
-----------------------
rel/1.0 1206_cbf7291 1副本1C1D 与 master_0421_8db8876 单机版对比
测试机器 fit 192.168.130.1
BM在192.168.130.2 /data1/bm_v1 （使用的配置文件iotdb_2997_lastquery.conf）
> [ StandAloneConsensus] Very low write performance at 100k timeseries per dev
> ----------------------------------------------------------------------------
>
> Key: IOTDB-4450
> URL: https://issues.apache.org/jira/browse/IOTDB-4450
> Project: Apache IoTDB
> Issue Type: Bug
> Components: mpp-cluster
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: 刘珍
> Assignee: Yukun Zhou
> Priority: Major
> Attachments: 1_dev_10w_sensor.conf, image-2022-09-19-18-21-11-615.png, ip72_datanode_logs.tar.gz, ip74_logs.tar.gz, screenshot-1.png
>
>
> m_0918_a28329e
> 3C3D ，StandAloneConsensus，在单个设备包含的序列较多时，写入性能变得非常慢（写入超时，全部失败）。
> 1用户，1dev，10w序列，batch size=2，LOOP=10，即每序列写入20个点，相同数据库配置
> 与新单机的性能对比：
> !image-2022-09-19-18-21-11-615.png!
> ip2（bm连接的节点）error日志：
> 2022-09-19 16:59:48,447 [pool-25-IoTDB-ClientRPC-Processor-5$20220919_085928_00004_3.1.0] ERROR o.a.i.d.m.p.s.FragmentInstanceDispatcherImpl:190 - can't connect to node TEndPoint(ip:192.168.10.74, port:9003)
> org.apache.thrift.TException: Error in calling method sendPlanNode
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:94)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.sendPlanNode(<generated>)
> at org.apache.iotdb.db.mpp.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchRemote(FragmentInstanceDispatcherImpl.java:177)
> at org.apache.iotdb.db.mpp.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchOneInstance(FragmentInstanceDispatcherImpl.java:145)
> at org.apache.iotdb.db.mpp.plan.scheduler.FragmentInstanceDispatcherImpl.dispatchWriteSync(FragmentInstanceDispatcherImpl.java:125)
> at org.apache.iotdb.db.mpp.plan.scheduler.FragmentInstanceDispatcherImpl.dispatch(FragmentInstanceDispatcherImpl.java:96)
> at org.apache.iotdb.db.mpp.plan.scheduler.ClusterScheduler.start(ClusterScheduler.java:101)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.schedule(QueryExecution.java:264)
> at org.apache.iotdb.db.mpp.plan.execution.QueryExecution.start(QueryExecution.java:184)
> at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:146)
> at org.apache.iotdb.db.mpp.plan.Coordinator.execute(Coordinator.java:160)
> at org.apache.iotdb.db.service.thrift.impl.ClientRPCServiceImpl.insertTablet(ClientRPCServiceImpl.java:995)
> at org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$insertTablet.getResult(IClientRPCService.java:3512)
> at org.apache.iotdb.service.rpc.thrift.IClientRPCService$Processor$insertTablet.getResult(IClientRPCService.java:3492)
> 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.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:834)
> Caused by: org.apache.thrift.TException: Error in calling method recv_sendPlanNode
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:94)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.recv_sendPlanNode(<generated>)
> at org.apache.iotdb.mpp.rpc.thrift.IDataNodeRPCService$Client.sendPlanNode(IDataNodeRPCService.java:442)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.CGLIB$sendPlanNode$123(<generated>)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d$$FastClassByCGLIB$$7b038c6e.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:55)
> ... 19 common frames omitted
> Caused by: org.apache.thrift.TException: Error in calling method receiveBase
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:94)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.receiveBase(<generated>)
> at org.apache.iotdb.mpp.rpc.thrift.IDataNodeRPCService$Client.recv_sendPlanNode(IDataNodeRPCService.java:455)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.CGLIB$recv_sendPlanNode$11(<generated>)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d$$FastClassByCGLIB$$7b038c6e.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:55)
> ... 25 common frames omitted
> Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
> at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:178)
> at org.apache.thrift.transport.TTransport.readAll(TTransport.java:109)
> at org.apache.iotdb.rpc.TElasticFramedTransport.readFrame(TElasticFramedTransport.java:112)
> at org.apache.iotdb.rpc.TElasticFramedTransport.read(TElasticFramedTransport.java:107)
> at org.apache.thrift.transport.TTransport.readAll(TTransport.java:109)
> at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:463)
> at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:361)
> at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:244)
> at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d.CGLIB$receiveBase$138(<generated>)
> at org.apache.iotdb.commons.client.sync.SyncDataNodeInternalServiceClient$$EnhancerByCGLIB$$b12b10d$$FastClassByCGLIB$$7b038c6e.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at org.apache.iotdb.commons.client.sync.SyncThriftClientWithErrorHandler.intercept(SyncThriftClientWithErrorHandler.java:55)
> ... 31 common frames omitted
> Caused by: java.net.SocketTimeoutException: Read timed out
> at java.base/java.net.SocketInputStream.socketRead0(Native Method)
> at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
> at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
> at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
> at java.base/java.io.BufferedInputStream.fill(BufferedInputStream.java:252)
> at java.base/java.io.BufferedInputStream.read1(BufferedInputStream.java:292)
> at java.base/java.io.BufferedInputStream.read(BufferedInputStream.java:351)
> at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:176)
> ... 43 common frames omitted
> 测试环境
> 1. 192.168.10.71/72/73/74 48核384G
> bm在ip71
> confignode配置参数
> MAX_HEAP_SIZE="8G"
> schema_region_consensus_protocol_class=org.apache.iotdb.consensus.standalone.StandAloneConsensus
> data_region_consensus_protocol_class=org.apache.iotdb.consensus.standalone.StandAloneConsensus
> schema_replication_factor=1
> data_replication_factor=1
> connection_timeout_ms=3600000
> DataNode配置
> MAX_HEAP_SIZE="256G"
> MAX_DIRECT_MEMORY_SIZE="32G"
> max_connection_for_internal_service=300
> enable_timed_flush_seq_memtable=true
> seq_memtable_flush_interval_in_ms=3600000
> seq_memtable_flush_check_interval_in_ms=600000
> enable_timed_flush_unseq_memtable=true
> unseq_memtable_flush_interval_in_ms=3600000
> unseq_memtable_flush_check_interval_in_ms=600000
> max_deduplicated_path_num=1000000
> max_waiting_time_when_insert_blocked=3600000
> query_timeout_threshold=36000000
> 2. bm配置见附件
--
This message was sent by Atlassian Jira
(v8.20.10#820010)