为了更快的定位您的问题,请提供以下信息,谢谢
【详述】3.2.4-613f0b5 向3.2.8-759cc78 通过StarRocks外表 insert into 的方式导入数据报错。
Getting analyzing error. Detail message: Tablet lost replicas. Check if any backend is down or not. tablet_id: 238775, replicas: 10104:0/-1/0/0:NORMAL:NIL,. 两个集群均为存算分离版本
【背景】做过哪些操作?
【业务影响】
【是否存算分离】是
【StarRocks版本】例如:3.2.4-613f0b5 -> 3.2.8-759cc78
【集群规模】例如:3fe(1 follower+2observer)+5be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【表模型】例如:明细模型
【导入或者导出方式】例如:select insert
【联系方式】lixinzhuang1996@163.com
【附件】
2024-08-15 20:36:23,986 WARN (thrift-server-pool-49287817|49929402) [QueryRuntimeProfile.waitForProfileFinished():236] failed to get profile within 5 seconds
2024-08-15 20:36:27,650 INFO (autovacuum-pool1-t172|31203875) [AutovacuumDaemon.vacuumPartitionImpl():201] Vacuumed data_map.OSSLoadTable_17617794.564044 hasError=false vacuumedFiles=30 vacuumedFileSize=0 visibleVersion=6 minRetainVersion=6 minActiveTxnId=184158 cost=147ms
2024-08-15 20:36:28,986 WARN (thrift-server-pool-49287817|49929402) [QueryRuntimeProfile.waitForProfileFinished():236] failed to get profile within 5 seconds
2024-08-15 20:36:29,801 INFO (starrocks-mysql-nio-pool-40902|49929113) [ExternalOlapTable.updateMetaInternal():601] TableMetaSyncer finish meta update. partition build cost: 0ms, index meta build cost: 2ms, schema rebuild cost: 0ms, tablet meta build cost: 5ms, total cost: 7ms
2024-08-15 20:36:29,806 INFO (starrocks-mysql-nio-pool-40902|49929113) [GlobalTransactionMgr.beginRemoteTransaction():198] begin remote txn, label: insert_fef891f0-5b02-11ef-96ec-fa163e0d1d2e, txn_id: 3805
2024-08-15 20:36:29,810 INFO (starrocks-mysql-nio-pool-40902|49929113) [StmtExecutor.execute():698] execute Exception, sql: /* ApplicationName=DBeaver 24.1.1 - SQLEditor <Script-40.sql> */ INSERT INTO migrate_11_127_125_247_data_map.OSSLoadTable_17080758 SELECT * FROM data_map.OSSLoadTable_17080758 WHERE dt
>= ‘0000-01-01’ AND dt
< ‘2024-06-26’, error: Getting analyzing error. Detail message: Tablet lost replicas. Check if any backend is down or not. tablet_id: 238775, replicas: 10104:0/-1/0/0:NORMAL:NIL,.
2024-08-15 20:36:30,033 INFO (autovacuum-pool1-t171|31203469) [AutovacuumDaemon.vacuumPartitionImpl():201] Vacuumed data_map.OSSLoadTable_17152048.538017 hasError=false vacuumedFiles=6 vacuumedFileSize=0 visibleVersion=2 minRetainVersion=2 minActiveTxnId=184158 cost=516ms
2024-08-15 20:36:31,805 INFO (autovacuum-pool1-t176|31205092) [AutovacuumDaemon.vacuumPartitionImpl():201] Vacuumed data_map.OSSLoadTable_13958984.558714 hasError=false vacuumedFiles=6 vacuumedFileSize=0 visibleVersion=2 minRetainVersion=2 minActiveTxnId=184158 cost=284ms
2024-08-15 20:36:32,206 INFO (starrocks-mysql-nio-pool-40902|49929113) [ConnectScheduler.unregisterConnection():155] Connection closed. remote=11.116.221.210:27056, connectionId=18204487
2024-08-15 20:36:32,208 INFO (starrocks-mysql-nio I/O-4|143) [AcceptListener.handleEvent():79] Connection established. remote=/11.116.221.210:43002, connectionId=18204515
2024-08-15 20:36:32,208 INFO (starrocks-mysql-nio-pool-40902|49929113) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 49929113. remote=/11.116.221.210:43002, connectionId=18204515
2024-08-15 20:36:32,214 INFO (starrocks-mysql-nio-pool-40902|49929113) [QeProcessorImpl.registerQuery():108] register query id = 006f7a81-5b03-11ef-96ec-fa163e0d1d2e