Jdbc方式查询外部表突然不好用了无法查询出结果

💬 StarRocks 用户问答
#1

【详述】jdbc外部表，原本oracle和hive都好用，现在无法查询，执行时间达到1200秒后自动结束，没有结果，且SHOW RESOURCES; 等操作也没反应了，其他业务数据可以正常查询
【背景】在不好用之前曾经多次添加mongo的resource和删除mongo resource的操作
【业务影响】
【StarRocks版本】例如：2.5.2
【集群规模】1 fe 8be
【机器信息】8c32g
【联系方式】社区群12 TuTu
【附件】
fe.log

2023-03-20 17:17:07,416 INFO (thrift-server-pool-4506566|4727484) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:41998)
2023-03-20 17:17:07,417 INFO (thrift-server-pool-4506580|4727498) [DatabaseTransactionMgr.commitTransaction():479] transaction:[TransactionState. txn_id: 11111394, label: 1c0bbfc2-1810-447f-b5ae-111fff4f5786, db id: 835769, table id list: 2624413, callback id: 7225845, coordinator: FE: 172.16.4.127, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1679303826787, commit time: 1679303827416, finish time: -1, write cost: 629ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=9, unselectedRows=0, receivedBytes=10359, taskExecutionTimeMs=626, taskId=TUniqueId(hi:2020919698154079359, lo:-5355324077771892858), jobId=7225845, progress=KafkaProgress [partitionIdToOffset=0_1367340]]] successfully committed
2023-03-20 17:17:07,428 INFO (PUBLISH_VERSION|21) [PublishVersionDaemon.publishVersionForOlapTable():125] send publish tasks for txn_id: 11111394
2023-03-20 17:17:07,430 INFO (starrocks-mysql-nio-pool-8831|4724873) [QeProcessorImpl.registerQuery():81] register query id = fc8afa5f-c6ff-11ed-88fa-00163e09a0ba, job: -1
2023-03-20 17:17:07,490 INFO (PUBLISH_VERSION|21) [DatabaseTransactionMgr.finishTransaction():1036] finish transaction TransactionState. txn_id: 11111394, label: 1c0bbfc2-1810-447f-b5ae-111fff4f5786, db id: 835769, table id list: 2624413, callback id: 7225845, coordinator: FE: 172.16.4.127, transaction status: VISIBLE, error replicas num: 0, replica ids: , prepare time: 1679303826787, commit time: 1679303827416, finish time: 1679303827488, write cost: 629ms, wait for publish cost: 12ms, publish rpc cost: 52ms, finish txn cost: 8ms, publish total cost: 72ms, total cost: 701ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=9, unselectedRows=0, receivedBytes=10359, taskExecutionTimeMs=626, taskId=TUniqueId(hi:2020919698154079359, lo:-5355324077771892858), jobId=7225845, progress=KafkaProgress [partitionIdToOffset=0_1367340]] successfully
2023-03-20 17:17:07,519 INFO (thrift-server-pool-4506567|4727485) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:42006)
2023-03-20 17:17:07,532 INFO (thrift-server-pool-4506601|4727519) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.124, port:43278)
2023-03-20 17:17:07,535 INFO (starrocks-mysql-nio-pool-8831|4724873) [QeProcessorImpl.unregisterQuery():91] deregister query id fc8afa5f-c6ff-11ed-88fa-00163e09a0ba
2023-03-20 17:17:07,535 INFO (thrift-server-pool-4506602|4727520) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.124, port:43280)
2023-03-20 17:17:07,535 INFO (thrift-server-pool-4506602|4727520) [QeProcessorImpl.reportExecStatus():130] ReportExecStatus() failed, query does not exist, fragment_instance_id=fc8afa5f-c6ff-11ed-88fa-00163e09a0bb, query_id=fc8afa5f-c6ff-11ed-88fa-00163e09a0ba,
2023-03-20 17:17:07,573 INFO (nioEventLoopGroup-7-13|318) [RestBaseAction.handleRequest():56] receive http request. url=/api/dwd/ljkc_fip_operatinglog/_stream_load
2023-03-20 17:17:07,573 INFO (nioEventLoopGroup-7-13|318) [LoadAction.executeWithoutPassword():92] redirect load action to destination=TNetworkAddress(hostname:172.16.4.124, port:8040), db: dwd, tbl: ljkc_fip_operatinglog, label: null
2023-03-20 17:17:07,586 INFO (thrift-server-pool-4506603|4727521) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:42120)
2023-03-20 17:17:07,586 INFO (thrift-server-pool-4506603|4727521) [FrontendServiceImpl.loadTxnCommit():958] receive txn commit request. db: dwd_flink, tbl: ljkc_gl_detail, txn_id: 11111395, backend: 172.16.4.128
2023-03-20 17:17:07,588 INFO (thrift-server-pool-4506603|4727521) [DatabaseTransactionMgr.commitTransaction():479] transaction:[TransactionState. txn_id: 11111395, label: e74589e1-556b-46e8-8237-3de9b1aa4923, db id: 835769, table id list: 2624542, callback id: 7225848, coordinator: FE: 172.16.4.127, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1679303826931, commit time: 1679303827587, finish time: -1, write cost: 656ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=7, unselectedRows=0, receivedBytes=14989, taskExecutionTimeMs=552, taskId=TUniqueId(hi:-1781866476661422360, lo:-9063707651142432477), jobId=7225848, progress=KafkaProgress [partitionIdToOffset=0_4148579]]] successfully committed
2023-03-20 17:17:07,591 INFO (PUBLISH_VERSION|21) [PublishVersionDaemon.publishVersionForOlapTable():125] send publish tasks for txn_id: 11111395
2023-03-20 17:17:07,598 INFO (pool-15-thread-3|610712) [DatabaseTransactionMgr.beginTransaction():308] begin transaction: txn_id: 11111397 with label bbefa685-c099-4d65-82cb-6a852a9693f8 from coordinator FE: 172.16.4.127, listner id: 3814341
2023-03-20 17:17:07,598 INFO (pool-15-thread-3|610712) [StreamLoadPlanner.plan():233] load job id: bbefa685-c099-4d65-82cb-6a852a9693f8 tx id -1 parallel 0 compress NO_COMPRESSION replicated false quorum MAJORITY
2023-03-20 17:17:07,675 INFO (thrift-server-pool-4506604|4727522) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.124, port:43282)
2023-03-20 17:17:07,675 INFO (thrift-server-pool-4506604|4727522) [FrontendServiceImpl.loadTxnBegin():882] receive txn begin request, db: dwd, tbl: ljkc_fip_operatinglog, label: 3584e7f0-a280-4931-b9e7-56e8037eb88a, backend: 172.16.4.124
2023-03-20 17:17:07,675 INFO (thrift-server-pool-4506604|4727522) [DatabaseTransactionMgr.beginTransaction():308] begin transaction: txn_id: 11111398 with label 3584e7f0-a280-4931-b9e7-56e8037eb88a from coordinator BE: 172.16.4.124, listner id: -1
2023-03-20 17:17:07,683 INFO (PUBLISH_VERSION|21) [DatabaseTransactionMgr.finishTransaction():1036] finish transaction TransactionState. txn_id: 11111395, label: e74589e1-556b-46e8-8237-3de9b1aa4923, db id: 835769, table id list: 2624542, callback id: 7225848, coordinator: FE: 172.16.4.127, transaction status: VISIBLE, error replicas num: 0, replica ids: , prepare time: 1679303826931, commit time: 1679303827587, finish time: 1679303827682, write cost: 656ms, wait for publish cost: 4ms, publish rpc cost: 81ms, finish txn cost: 10ms, publish total cost: 95ms, total cost: 751ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=7, unselectedRows=0, receivedBytes=14989, taskExecutionTimeMs=552, taskId=TUniqueId(hi:-1781866476661422360, lo:-9063707651142432477), jobId=7225848, progress=KafkaProgress [partitionIdToOffset=0_4148579]] successfully
2023-03-20 17:17:07,776 INFO (thrift-server-pool-4506605|4727523) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.124, port:43288)
2023-03-20 17:17:07,776 INFO (thrift-server-pool-4506605|4727523) [FrontendServiceImpl.streamLoadPut():1195] receive stream load put request. db:dwd, tbl: ljkc_fip_operatinglog, txn_id: 11111398, load id: fd442689-22d7-05d6-ae3e-0eaba5257583, backend: 172.16.4.124
2023-03-20 17:17:07,777 INFO (thrift-server-pool-4506605|4727523) [StreamLoadPlanner.plan():233] load job id: fd442689-22d7-05d6-ae3e-0eaba5257583 tx id 11111398 parallel 0 compress NO_COMPRESSION replicated false quorum MAJORITY
2023-03-20 17:17:07,823 INFO (thrift-server-pool-4506568|4727486) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:42008)
2023-03-20 17:17:07,913 INFO (thrift-server-pool-4506606|4727524) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.124, port:43296)
2023-03-20 17:17:07,913 INFO (thrift-server-pool-4506606|4727524) [FrontendServiceImpl.loadTxnCommit():958] receive txn commit request. db: dwd, tbl: ljkc_fip_operatinglog, txn_id: 11111398, backend: 172.16.4.124
2023-03-20 17:17:07,915 INFO (PUBLISH_VERSION|21) [PublishVersionDaemon.publishVersionForOlapTable():125] send publish tasks for txn_id: 11111398
2023-03-20 17:17:07,915 INFO (thrift-server-pool-4506606|4727524) [DatabaseTransactionMgr.commitTransaction():479] transaction:[TransactionState. txn_id: 11111398, label: 3584e7f0-a280-4931-b9e7-56e8037eb88a, db id: 3640148, table id list: 3661366, callback id: -1, coordinator: BE: 172.16.4.124, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1679303827675, commit time: 1679303827913, finish time: -1, write cost: 238ms, reason: attachment: com.starrocks.load.loadv2.ManualLoadTxnCommitAttachment@1a3dd82b] successfully committed
2023-03-20 17:17:07,937 INFO (PUBLISH_VERSION|21) [DatabaseTransactionMgr.finishTransaction():1036] finish transaction TransactionState. txn_id: 11111398, label: 3584e7f0-a280-4931-b9e7-56e8037eb88a, db id: 3640148, table id list: 3661366, callback id: -1, coordinator: BE: 172.16.4.124, transaction status: VISIBLE, error replicas num: 0, replica ids: , prepare time: 1679303827675, commit time: 1679303827913, finish time: 1679303827935, write cost: 238ms, wait for publish cost: 2ms, publish rpc cost: 11ms, finish txn cost: 9ms, publish total cost: 22ms, total cost: 260ms, reason: attachment: com.starrocks.load.loadv2.ManualLoadTxnCommitAttachment@1a3dd82b successfully
2023-03-20 17:17:07,964 INFO (thrift-server-pool-4506569|4727487) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.104, port:50254)
2023-03-20 17:17:07,965 INFO (thrift-server-pool-4506570|4727488) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.104, port:50256)
2023-03-20 17:17:07,972 INFO (starrocks-mysql-nio-pool-8831|4724873) [QeProcessorImpl.registerQuery():81] register query id = fcddae42-c6ff-11ed-88fa-00163e09a0ba, job: -1
2023-03-20 17:17:08,074 INFO (thrift-server-pool-4506607|4727525) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:42130)
2023-03-20 17:17:08,077 INFO (starrocks-mysql-nio-pool-8831|4724873) [QeProcessorImpl.unregisterQuery():91] deregister query id fcddae42-c6ff-11ed-88fa-00163e09a0ba
2023-03-20 17:17:08,078 INFO (thrift-server-pool-4506608|4727526) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.128, port:42132)
2023-03-20 17:17:08,078 INFO (thrift-server-pool-4506608|4727526) [QeProcessorImpl.reportExecStatus():130] ReportExecStatus() failed, query does not exist, fragment_instance_id=fcddae42-c6ff-11ed-88fa-00163e09a0bb, query_id=fcddae42-c6ff-11ed-88fa-00163e09a0ba,
2023-03-20 17:17:08,105 INFO (thrift-server-pool-4506571|4727489) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.129, port:52840)
2023-03-20 17:17:08,118 INFO (nioEventLoopGroup-7-14|334) [RestBaseAction.handleRequest():56] receive http request. url=/api/dwd/kc_wms_location_inventory/_stream_load
2023-03-20 17:17:08,118 INFO (nioEventLoopGroup-7-14|334) [LoadAction.executeWithoutPassword():92] redirect load action to destination=TNetworkAddress(hostname:172.16.4.114, port:8044), db: dwd, tbl: kc_wms_location_inventory, label: null
2023-03-20 17:17:08,208 INFO (thrift-server-pool-4506572|4727490) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.129, port:52842)
2023-03-20 17:17:08,216 INFO (thrift-server-pool-4506609|4727527) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.114, port:46616)
2023-03-20 17:17:08,216 INFO (thrift-server-pool-4506609|4727527) [FrontendServiceImpl.loadTxnCommit():958] receive txn commit request. db: dwd_flink, tbl: obc_order_b2c_order_warehouse_in_resume, txn_id: 11111397, backend: 172.16.4.114
2023-03-20 17:17:08,218 INFO (thrift-server-pool-4506609|4727527) [DatabaseTransactionMgr.commitTransaction():479] transaction:[TransactionState. txn_id: 11111397, label: bbefa685-c099-4d65-82cb-6a852a9693f8, db id: 835769, table id list: 2620258, callback id: 3814341, coordinator: FE: 172.16.4.127, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1679303827598, commit time: 1679303828216, finish time: -1, write cost: 618ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=7, unselectedRows=0, receivedBytes=5485, taskExecutionTimeMs=516, taskId=TUniqueId(hi:-4904518375791047323, lo:-9022000308328950792), jobId=3814341, progress=KafkaProgress [partitionIdToOffset=0_663138]]] successfully committed
2023-03-20 17:17:08,219 INFO (PUBLISH_VERSION|21) [PublishVersionDaemon.publishVersionForOlapTable():125] send publish tasks for txn_id: 11111397
2023-03-20 17:17:08,220 INFO (thrift-server-pool-4506610|4727528) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.114, port:46618)
2023-03-20 17:17:08,220 INFO (thrift-server-pool-4506610|4727528) [FrontendServiceImpl.loadTxnBegin():882] receive txn begin request, db: dwd, tbl: kc_wms_location_inventory, label: 8a830822-8ad1-4339-b1cc-9930208eda6f, backend: 172.16.4.114
2023-03-20 17:17:08,220 INFO (thrift-server-pool-4506610|4727528) [DatabaseTransactionMgr.beginTransaction():308] begin transaction: txn_id: 11111399 with label 8a830822-8ad1-4339-b1cc-9930208eda6f from coordinator BE: 172.16.4.114, listner id: -1
2023-03-20 17:17:08,241 INFO (PUBLISH_VERSION|21) [DatabaseTransactionMgr.finishTransaction():1036] finish transaction TransactionState. txn_id: 11111397, label: bbefa685-c099-4d65-82cb-6a852a9693f8, db id: 835769, table id list: 2620258, callback id: 3814341, coordinator: FE: 172.16.4.127, transaction status: VISIBLE, error replicas num: 0, replica ids: , prepare time: 1679303827598, commit time: 1679303828216, finish time: 1679303828239, write cost: 618ms, wait for publish cost: 3ms, publish rpc cost: 12ms, finish txn cost: 8ms, publish total cost: 23ms, total cost: 641ms, reason: attachment: RLTaskTxnCommitAttachment [filteredRows=0, loadedRows=7, unselectedRows=0, receivedBytes=5485, taskExecutionTimeMs=516, taskId=TUniqueId(hi:-4904518375791047323, lo:-9022000308328950792), jobId=3814341, progress=KafkaProgress [partitionIdToOffset=0_663138]] successfully
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:42288, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:42288, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:39528, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:39528, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:44542, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:44542, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:36064, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:36064, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:36872, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:36872, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:56836, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:56836, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:37170, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:37170, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:47194, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:47194, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:49962, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:49962, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:54608, query timeout: 3600
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:54608, kill connection: false
2023-03-20 17:17:08,316 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 10.0.1.211:58628, query timeout: 3600
2023-03-20 17:17:08,317 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 10.0.1.211:58628, kill connection: false
2023-03-20 17:17:08,317 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.checkTimeout():616] kill query timeout, remote: 172.16.4.127:51740, query timeout: 3600
2023-03-20 17:17:08,317 WARN (Connect-Scheduler-Check-Timer-0|14) [ConnectContext.kill():561] kill query, 172.16.4.127:51740, kill connection: false
2023-03-20 17:17:08,321 INFO (thrift-server-pool-4506611|4727529) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.114, port:46624)
2023-03-20 17:17:08,321 INFO (thrift-server-pool-4506611|4727529) [FrontendServiceImpl.streamLoadPut():1195] receive stream load put request. db:dwd, tbl: kc_wms_location_inventory, txn_id: 11111399, load id: a64c0250-07ac-f629-763e-baacdd001f8d, backend: 172.16.4.114
2023-03-20 17:17:08,321 INFO (thrift-server-pool-4506611|4727529) [StreamLoadPlanner.plan():233] load job id: a64c0250-07ac-f629-763e-baacdd001f8d tx id 11111399 parallel 0 compress NO_COMPRESSION replicated false quorum MAJORITY
2023-03-20 17:17:08,458 INFO (thrift-server-pool-4506573|4727491) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.129, port:52844)
2023-03-20 17:17:08,600 INFO (thrift-server-pool-4506574|4727492) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.130, port:53876)
2023-03-20 17:17:08,600 INFO (thrift-server-pool-4506575|4727493) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.130, port:53878)
2023-03-20 17:17:08,740 INFO (pool-15-thread-7|610717) [DatabaseTransactionMgr.beginTransaction():308] begin transaction: txn_id: 11111400 with label a2e8565f-032d-4bde-868d-c28481ce7413 from coordinator FE: 172.16.4.127, listner id: 3814346
2023-03-20 17:17:08,740 INFO (pool-15-thread-7|610717) [StreamLoadPlanner.plan():233] load job id: a2e8565f-032d-4bde-868d-c28481ce7413 tx id -1 parallel 0 compress NO_COMPRESSION replicated false quorum MAJORITY
2023-03-20 17:17:08,741 INFO (thrift-server-pool-4506576|4727494) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.104, port:50268)
2023-03-20 17:17:08,827 INFO (thrift-server-pool-4506612|4727530) [ThriftServerEventProcessor.createContext():97] create thrift context. client: TNetworkAddress(hostname:172.16.4.114, port:46646)
2023-03-20 17:17:08,827 INFO (thrift-server-pool-4506612|4727530) [FrontendServiceImpl.loadTxnCommit():958] receive txn commit request. db: dwd, tbl: kc_wms_location_inventory, txn_id: 11111399, backend: 172.16.4.114
2023-03-20 17:17:08,829 INFO (thrift-server-pool-4506612|4727530) [DatabaseTransactionMgr.commitTransaction():479] transaction:[TransactionState. txn_id: 11111399, label: 8a830822-8ad1-4339-b1cc-9930208eda6f, db id: 3640148, table id list: 3649496, callback id: -1, coordinator: BE: 172.16.4.114, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1679303828220, commit time: 1679303828827, finish time: -1, write cost: 607ms, reason: attachment: com.starrocks.load.loadv2.ManualLoadTxnCommitAttachment@4e959609] successfully committed
2023-03-20 17:17:08,836 INFO (PUBLISH_VERSION|21) [PublishVersionDaemon.publishVersionForOlapTable():125] send publish tasks for txn_id: 11111399
2023-03-20 17:17:08,844 INFO (thrift-server-pool-4506578|4727496) [ThriftServerEventProcessor.deleteContext():112] delete thrift context. client: TNetworkAddress(hostname:172.16.4.104, port:50270)
2023-03-20 17:17:08,910 INFO (ReportHandler|141) [ReportHandler.tabletReport():337] backend[42565] reports 91398 tablet(s). report version: 16775708259164

#2

be.info
I0320 17:21:35.461194 13524 task_worker_pool.cpp:512] batch flush 1 txn publish task(s). #dir:1 flush:7ms finish_task_rpc:0ms
I0320 17:21:35.461202 13524 task_worker_pool.cpp:490] get publish version task txn_id: 11112398 priority queue size: 1
I0320 17:21:35.461326 13488 tablet_updates.cpp:512] commit rowset tablet:3807209 version:4606 txn_id: 11112398 0200000001387b6f794f4d14a9e2711f9960968f34dd77ae rowset:4010 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.461328 13491 tablet_updates.cpp:512] commit rowset tablet:3807205 version:4606 txn_id: 11112398 0200000001387b6e794f4d14a9e2711f9960968f34dd77ae rowset:6163 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.461342 13488 publish_version.cpp:110] Publish txn success tablet:3807209 version:4606 tablet_max_version:4606 partition:3807204 txn_id: 11112398 rowset:0200000001387b6f794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.461345 13491 publish_version.cpp:110] Publish txn success tablet:3807205 version:4606 tablet_max_version:4606 partition:3807204 txn_id: 11112398 rowset:0200000001387b6e794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.461381 13494 tablet_updates.cpp:512] commit rowset tablet:3807233 version:4606 txn_id: 11112398 0200000001387b70794f4d14a9e2711f9960968f34dd77ae rowset:6165 #seg:1 #delfile:0 #row:3 size:14.82 KB #pending:0
I0320 17:21:35.461408 13494 publish_version.cpp:110] Publish txn success tablet:3807233 version:4606 tablet_max_version:4606 partition:3807204 txn_id: 11112398 rowset:0200000001387b70794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.461406 13488 tablet_updates.cpp:512] commit rowset tablet:3807237 version:4606 txn_id: 11112398 0200000001387b71794f4d14a9e2711f9960968f34dd77ae rowset:6163 #seg:1 #delfile:0 #row:3 size:14.91 KB #pending:0
I0320 17:21:35.461421 13488 publish_version.cpp:110] Publish txn success tablet:3807237 version:4606 tablet_max_version:4606 partition:3807204 txn_id: 11112398 rowset:0200000001387b71794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.462622 13524 publish_version.cpp:185] publish_version success. txn_id: 11112398 #partition:1 #tablet:4 time:2ms #already_finished:0
I0320 17:21:35.472168 16800 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:3807205 version:4606 txn_id: 11112398 total del/row:1/72917 0% rowset:6163 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:11ms(0/11/0/0)
I0320 17:21:35.473104 13524 task_worker_pool.cpp:512] batch flush 1 txn publish task(s). #dir:1 flush:10ms finish_task_rpc:0ms
I0320 17:21:35.474524 13562 rowset_merger.cpp:242] compaction merge finished. tablet=3807053 #key=2 algorithm=VERTICAL_COMPACTION column_group_size=9 input(entry=6 rows=30062 del=0 actual=30062 bytes=2.15 MB) output(rows=30062 chunk=10 bytes=2.13 MB) duration: 90ms
I0320 17:21:35.475728 16837 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:3807209 version:4606 txn_id: 11112398 total del/row:3/73281 0% rowset:4010 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:15ms(0/15/0/0)
I0320 17:21:35.477515 13562 tablet_updates.cpp:1354] commit compaction tablet:3807053 version:6941.1 rowset:5619 #seg:1 #row:30062 size:2.13 MB #pending:0 state_memory:2.91 MB
I0320 17:21:35.477581 16837 tablet_updates.cpp:1382] apply_compaction_commit start tablet:3807053 version:6941.1 rowset:5619
I0320 17:21:35.478263 16836 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:3807237 version:4606 txn_id: 11112398 total del/row:5/73144 0% rowset:6163 #seg:1 #op(upsert:3 del:0) #del:2+3=5 #dv:2 duration:16ms(0/15/0/1)
I0320 17:21:35.479324 16840 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:3807233 version:4606 txn_id: 11112398 total del/row:4/73180 0% rowset:6165 #seg:1 #op(upsert:3 del:0) #del:1+3=4 #dv:2 duration:18ms(0/17/0/1)
I0320 17:21:35.493273 16820 data_consumer.cpp:266] kafka consume done: e64afd7398ca250c-f56d4fbdf99d01b5, grp: b241a872571752c9-3545a18119041fbb. cancelled: 0, left time(ms): 14499, total cost(ms): 501, consume cost(ms): 501, received rows: 2, put rows: 2
I0320 17:21:35.493291 16820 data_consumer_group.cpp:80] all consumers are finished. shutdown queue. group id: b241a872571752c9-3545a18119041fbb
I0320 17:21:35.493295 13465 data_consumer_group.cpp:130] consumer group done: b241a872571752c9-3545a18119041fbb. consume time(ms)=501, received rows=2, received bytes=9299, eos: 1, left_time: 14499, left_bytes: 4294957997, blocking get time(us): 501482, blocking put time(us): 0
I0320 17:21:35.493306 13465 data_consumer.cpp:365] kafka consumer cancelled. e64afd7398ca250c-f56d4fbdf99d01b5
I0320 17:21:35.495031 16837 tablet_updates.cpp:1558] apply_compaction_commit finish tablet:3807053 version:6941.1 total del/row:104/773359 0% rowset:5619 #row:30062 #del:0 #delvec:1 duration:18ms(1/5/12)
I0320 17:21:35.497153 13547 local_tablets_channel.cpp:343] LocalTabletsChannel txn_id: 11112402 load_id: aaf3ad8e-7390-4def-a38c-ace994881d65 commit 4 tablets: 2625829,2625817,2625801,2625797
I0320 17:21:35.497228 13192 txn_manager.cpp:213] Commit txn successfully. tablet: 2625817, txn_id: 11112402, rowsetid: 0200000001387b8e794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.497246 7143 txn_manager.cpp:213] Commit txn successfully. tablet: 2625829, txn_id: 11112402, rowsetid: 0200000001387b8f794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.497256 13195 txn_manager.cpp:213] Commit txn successfully. tablet: 2625801, txn_id: 11112402, rowsetid: 0200000001387b8d794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.497342 16827 data_consumer.cpp:266] kafka consume done: 38438474d54471f6-47a3e1d168fc958a, grp: 0e45e8df613fc2e2-63f232500c4101ba. cancelled: 0, left time(ms): 14498, total cost(ms): 502, consume cost(ms): 502, received rows: 2, put rows: 2
I0320 17:21:35.497349 16827 data_consumer_group.cpp:80] all consumers are finished. shutdown queue. group id: 0e45e8df613fc2e2-63f232500c4101ba
I0320 17:21:35.497354 13459 data_consumer_group.cpp:130] consumer group done: 0e45e8df613fc2e2-63f232500c4101ba. consume time(ms)=502, received rows=2, received bytes=3180, eos: 1, left_time: 14498, left_bytes: 4294964116, blocking get time(us): 502673, blocking put time(us): 0
I0320 17:21:35.497362 13459 data_consumer.cpp:365] kafka consumer cancelled. 38438474d54471f6-47a3e1d168fc958a
I0320 17:21:35.498939 13546 local_tablets_channel.cpp:343] LocalTabletsChannel txn_id: 11112403 load_id: 8872cd58-a5de-48f2-b558-ba36d8579173 commit 4 tablets: 2621863,2621839,2621831,2621827
I0320 17:21:35.499018 4378 txn_manager.cpp:213] Commit txn successfully. tablet: 2621831, txn_id: 11112403, rowsetid: 0200000001387b91794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.499058 4378 txn_manager.cpp:213] Commit txn successfully. tablet: 2621827, txn_id: 11112403, rowsetid: 0200000001387b90794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.507143 13195 txn_manager.cpp:213] Commit txn successfully. tablet: 2621839, txn_id: 11112403, rowsetid: 0200000001387b92794f4d14a9e2711f9960968f34dd77ae #segment:1 #delfile:0
I0320 17:21:35.509755 13194 txn_manager.cpp:213] Commit txn successfully. tablet: 2625797, txn_id: 11112402, rowsetid: 0200000001387b8c794f4d14a9e2711f9960968f34dd77ae #segment:1 #delfile:0
I0320 17:21:35.510396 7143 txn_manager.cpp:213] Commit txn successfully. tablet: 2621863, txn_id: 11112403, rowsetid: 0200000001387b93794f4d14a9e2711f9960968f34dd77ae #segment:1 #delfile:0
I0320 17:21:35.513190 13562 tablet_manager.cpp:647] Found the best tablet to compact. compaction_type=update tablet_id=2628501 highest_score=196949702
I0320 17:21:35.513212 13562 tablet_updates.cpp:1847] update compaction start tablet:2628501 version:8232 score:196949696 pick:7/valid:7/all:8 10533,10534,10535,10536,10537,10538,10539 #rows:30987->30987 bytes:4.20 MB->4.20 MB(estimate)
I0320 17:21:35.517643 13547 local_tablets_channel.cpp:343] LocalTabletsChannel txn_id: 11112404 load_id: a16070de-1ecf-410f-9606-95507e179cf5 commit 4 tablets: 2621732,2621716,2621700,2621696
I0320 17:21:35.517686 7143 txn_manager.cpp:213] Commit txn successfully. tablet: 2621732, txn_id: 11112404, rowsetid: 0200000001387b97794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.517722 13195 txn_manager.cpp:213] Commit txn successfully. tablet: 2621696, txn_id: 11112404, rowsetid: 0200000001387b94794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.517735 13192 txn_manager.cpp:213] Commit txn successfully. tablet: 2621716, txn_id: 11112404, rowsetid: 0200000001387b96794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.525666 13194 txn_manager.cpp:213] Commit txn successfully. tablet: 2621700, txn_id: 11112404, rowsetid: 0200000001387b95794f4d14a9e2711f9960968f34dd77ae #segment:1 #delfile:0
I0320 17:21:35.538044 13545 local_tablets_channel.cpp:343] LocalTabletsChannel txn_id: 11112405 load_id: 8f2681ff-4d0d-4677-8ec8-4a888de66078 commit 4 tablets: 2625047,2625043,2625027,2625023
I0320 17:21:35.538096 13194 txn_manager.cpp:213] Commit txn successfully. tablet: 2625047, txn_id: 11112405, rowsetid: 0200000001387b9b794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.538125 7143 txn_manager.cpp:213] Commit txn successfully. tablet: 2625027, txn_id: 11112405, rowsetid: 0200000001387b99794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.538137 13195 txn_manager.cpp:213] Commit txn successfully. tablet: 2625023, txn_id: 11112405, rowsetid: 0200000001387b98794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.541770 13192 txn_manager.cpp:213] Commit txn successfully. tablet: 2625043, txn_id: 11112405, rowsetid: 0200000001387b9a794f4d14a9e2711f9960968f34dd77ae #segment:1 #delfile:0
I0320 17:21:35.565740 13544 local_tablets_channel.cpp:483] LocalTabletsChannel txn_id: 11112407 load_id: eb519fa8-335c-4325-a176-cb9900ce1bc4 open delta writer: [2625094:0][2625090:0][2625082:0][2625078:0] failed_tablets:
I0320 17:21:35.610877 3923 task_worker_pool.cpp:158] Submit task success. type=PUBLISH_VERSION, signature=11112401, task_count_in_queue=1
I0320 17:21:35.610884 13524 task_worker_pool.cpp:490] get publish version task txn_id: 11112401 priority queue size: 1
I0320 17:21:35.611045 13488 tablet_updates.cpp:512] commit rowset tablet:2621782 version:9959 txn_id: 11112401 0200000001387b88794f4d14a9e2711f9960968f34dd77ae rowset:12771 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.611047 13494 tablet_updates.cpp:512] commit rowset tablet:2621810 version:9959 txn_id: 11112401 0200000001387b8a794f4d14a9e2711f9960968f34dd77ae rowset:7754 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.611052 13489 tablet_updates.cpp:512] commit rowset tablet:2621798 version:9959 txn_id: 11112401 0200000001387b89794f4d14a9e2711f9960968f34dd77ae rowset:12756 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.611066 13488 publish_version.cpp:110] Publish txn success tablet:2621782 version:9959 tablet_max_version:9959 partition:2621779 txn_id: 11112401 rowset:0200000001387b88794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.611071 13494 publish_version.cpp:110] Publish txn success tablet:2621810 version:9959 tablet_max_version:9959 partition:2621779 txn_id: 11112401 rowset:0200000001387b8a794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.611078 13489 publish_version.cpp:110] Publish txn success tablet:2621798 version:9959 tablet_max_version:9959 partition:2621779 txn_id: 11112401 rowset:0200000001387b89794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.611078 13491 tablet_updates.cpp:512] commit rowset tablet:2621814 version:9959 txn_id: 11112401 0200000001387b8b794f4d14a9e2711f9960968f34dd77ae rowset:12763 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.611131 13491 publish_version.cpp:110] Publish txn success tablet:2621814 version:9959 tablet_max_version:9959 partition:2621779 txn_id: 11112401 rowset:0200000001387b8b794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.611155 13524 publish_version.cpp:185] publish_version success. txn_id: 11112401 #partition:1 #tablet:4 time:0ms #already_finished:0
I0320 17:21:35.623041 16800 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:2621798 version:9959 txn_id: 11112401 total del/row:20788/3575941 0% rowset:12756 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:12ms(0/12/0/0)
I0320 17:21:35.624125 13524 task_worker_pool.cpp:512] batch flush 1 txn publish task(s). #dir:1 flush:13ms finish_task_rpc:0ms
I0320 17:21:35.627435 16840 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:2621782 version:9959 txn_id: 11112401 total del/row:20698/3577385 0% rowset:12771 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:16ms(0/16/0/0)
I0320 17:21:35.628118 16837 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:2621814 version:9959 txn_id: 11112401 total del/row:20488/3573013 0% rowset:12763 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:17ms(0/17/0/0)
I0320 17:21:35.628949 16836 tablet_updates.cpp:1051] apply_rowset_commit finish. tablet:2621810 version:9959 txn_id: 11112401 total del/row:20772/3576565 0% rowset:7754 #seg:0 #op(upsert:0 del:0) #del:0+0=0 #dv:0 duration:18ms(0/18/0/0)
I0320 17:21:35.630298 13546 local_tablets_channel.cpp:343] LocalTabletsChannel txn_id: 11112406 load_id: af8e1185-d70e-46d3-a646-1feb21a2b1b0 commit 4 tablets: 2625919,2625915,2625911,2625883
I0320 17:21:35.630367 13194 txn_manager.cpp:213] Commit txn successfully. tablet: 2625911, txn_id: 11112406, rowsetid: 0200000001387b9e794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.630383 13195 txn_manager.cpp:213] Commit txn successfully. tablet: 2625915, txn_id: 11112406, rowsetid: 0200000001387b9f794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.630396 13192 txn_manager.cpp:213] Commit txn successfully. tablet: 2625919, txn_id: 11112406, rowsetid: 0200000001387ba0794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.630409 7143 txn_manager.cpp:213] Commit txn successfully. tablet: 2625883, txn_id: 11112406, rowsetid: 0200000001387b9d794f4d14a9e2711f9960968f34dd77ae #segment:0 #delfile:0
I0320 17:21:35.652284 13562 rowset_merger.cpp:242] compaction merge finished. tablet=2628501 #key=2 algorithm=VERTICAL_COMPACTION column_group_size=13 input(entry=7 rows=30987 del=0 actual=30987 bytes=4.20 MB) output(rows=30987 chunk=11 bytes=4.17 MB) duration: 139ms
I0320 17:21:35.654590 13562 tablet_updates.cpp:1354] commit compaction tablet:2628501 version:8232.1 rowset:10540 #seg:1 #row:30987 size:4.17 MB #pending:0 state_memory:2.11 MB
I0320 17:21:35.654630 16836 tablet_updates.cpp:1382] apply_compaction_commit start tablet:2628501 version:8232.1 rowset:10540
I0320 17:21:35.671432 16836 tablet_updates.cpp:1558] apply_compaction_commit finish tablet:2628501 version:8232.1 total del/row:3282/1681056 0% rowset:10540 #row:30987 #del:0 #delvec:1 duration:16ms(0/3/13)
I0320 17:21:35.687618 13562 tablet_manager.cpp:647] Found the best tablet to compact. compaction_type=update tablet_id=2628477 highest_score=196928908
I0320 17:21:35.687637 13562 tablet_updates.cpp:1847] update compaction start tablet:2628477 version:8232 score:196928912 pick:7/valid:7/all:8 10526,10527,10528,10529,10530,10531,10532 #rows:31156->31156 bytes:4.24 MB->4.24 MB(estimate)
I0320 17:21:35.749897 13321 tablet_sink.cpp:1441] Olap table sink statistics. load_id: aaf3ad8e-7390-4def-a38c-ace994881d65, txn_id: 11112402, add chunk time(ms)/wait lock time(ms)/num: {10003:(13)(0)(1)} {7795613:(14)(0)(1)} {7256462:(15)(0)(1)} {7813291:(0)(0)(1)} {7813337:(251)(0)(1)} {7813312:(0)(0)(1)} {42565:(0)(0)(1)} {10008:(13)(0)(1)}
I0320 17:21:35.750095 13321 profile_report_worker.cpp:24] unregister_non_pipeline_load fragment_instance_id=aaf3ad8e-7390-4def-a38c-ace994881d66
I0320 17:21:35.750162 13321 plan_fragment_executor.cpp:480] Fragment aaf3ad8e-7390-4def-a38c-ace994881d66:(Active: 755.981ms, non-child: 0.00%)
OlapTableSink:(Active: 258.390ms, non-child: 34.18%)
- TxnID: 11112402
- IndexNum: 1
- ReplicatedStorage: false
FILE_SCAN_NODE (id=0):(Active: 499.807ms, non-child: 66.11%)
FileScanner:
FilePRead:
W0320 17:21:35.750470 13465 thrift_rpc_helper.cpp:63] retrying call frontend service after 100 ms, address=TNetworkAddress(hostname=172.16.4.127, port=9020), reason=write() send(): Broken pipe
I0320 17:21:35.777055 13317 tablet_sink.cpp:1441] Olap table sink statistics. load_id: 8872cd58-a5de-48f2-b558-ba36d8579173, txn_id: 11112403, add chunk time(ms)/wait lock time(ms)/num: {7795613:(0)(0)(1)} {10003:(12)(0)(1)} {7256462:(0)(0)(1)} {7813291:(273)(0)(1)} {7813337:(247)(0)(1)} {7813312:(7)(0)(1)} {10008:(0)(0)(1)} {42565:(5)(0)(1)}
I0320 17:21:35.777161 13317 profile_report_worker.cpp:24] unregister_non_pipeline_load fragment_instance_id=8872cd58-a5de-48f2-b558-ba36d8579174
I0320 17:21:35.777230 13317 plan_fragment_executor.cpp:480] Fragment 8872cd58-a5de-48f2-b558-ba36d8579174:(Active: 781.510ms, non-child: 0.00%)
OlapTableSink:(Active: 280.422ms, non-child: 35.88%)
- TxnID: 11112403
- IndexNum: 1
- ReplicatedStorage: false
FILE_SCAN_NODE (id=0):(Active: 502.072ms, non-child: 64.24%)
FileScanner:
FilePRead:
W0320 17:21:35.777401 13459 thrift_rpc_helper.cpp:63] retrying call frontend service after 100 ms, address=TNetworkAddress(hostname=172.16.4.127, port=9020), reason=No more data to read.
I0320 17:21:35.792989 3923 task_worker_pool.cpp:158] Submit task success. type=PUBLISH_VERSION, signature=11112405, task_count_in_queue=1
I0320 17:21:35.792999 3923 task_worker_pool.cpp:158] Submit task success. type=PUBLISH_VERSION, signature=11112406, task_count_in_queue=1
I0320 17:21:35.792996 13524 task_worker_pool.cpp:490] get publish version task txn_id: 11112405 priority queue size: 1
I0320 17:21:35.793118 13491 tablet_updates.cpp:512] commit rowset tablet:2625023 version:8085 txn_id: 11112405 0200000001387b98794f4d14a9e2711f9960968f34dd77ae rowset:6696 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.793135 13491 publish_version.cpp:110] Publish txn success tablet:2625023 version:8085 tablet_max_version:8085 partition:2625016 txn_id: 11112405 rowset:0200000001387b98794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.793164 13494 tablet_updates.cpp:512] commit rowset tablet:2625043 version:8085 txn_id: 11112405 0200000001387b9a794f4d14a9e2711f9960968f34dd77ae rowset:10403 #seg:1 #delfile:0 #row:1 size:8.30 KB #pending:0
I0320 17:21:35.793190 13494 publish_version.cpp:110] Publish txn success tablet:2625043 version:8085 tablet_max_version:8085 partition:2625016 txn_id: 11112405 rowset:0200000001387b9a794f4d14a9e2711f9960968f34dd77ae
I0320 17:21:35.793210 13488 tablet_updates.cpp:512] commit rowset tablet:2625027 version:8085 txn_id: 11112405 0200000001387b99794f4d14a9e2711f9960968f34dd77ae rowset:6353 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.793210 13489 tablet_updates.cpp:512] commit rowset tablet:2625047 version:8085 txn_id: 11112405 0200000001387b9b794f4d14a9e2711f9960968f34dd77ae rowset:10402 #seg:0 #delfile:0 #row:0 size:0 #pending:0
I0320 17:21:35.793233 13488 publish_version.cpp:110] Publish txn success tablet:2625027 version:8085 tablet_max_version:8085 partition:2625016 txn_id: 11112405 rowset:0200000001387b99794f4d14a9e2711f9960968f34dd77ae

#3

执行卡住的时候打个fe的jstack，发一下jstack

#4

log.txt (757.6 KB)

#5

你好，有发现是什么原因吗

京ICP备2022026421号-1