3.2.2(存储分离) 建立外部表，目标表在3.1.3(存储一体)上
3.2.2 > 3.1.3
mysql> insert into external_bc_order_site1_summary_all select * from bc_order_site1_summary_all;
ERROR 1064 (HY000): Unknown error
fe报错日志
2024-02-03 00:26:35,853 INFO (thrift-server-pool-33606|42348) [FrontendServiceImpl.forward():1244] receive forwarded stmt 3337 from FE: 10.141.6.102
2024-02-03 00:26:35,984 INFO (thrift-server-pool-33606|42348) [ExternalOlapTable.updateMetaInternal():601] TableMetaSyncer finish meta update. partition build cost: 0ms, index meta build cost: 0ms, schema rebuild cost: 0ms, tablet meta build cost: 0ms, total cost: 0ms
2024-02-03 00:26:36,050 INFO (thrift-server-pool-33606|42348) [GlobalTransactionMgr.beginRemoteTransaction():193] begin remote txn, label: insert_d57e14a0-c1e7-11ee-89c9-00163e0252b1, txn_id: 2716368
2024-02-03 00:26:36,051 WARN (thrift-server-pool-33606|42348) [StmtExecutor.handleDMLStmt():2124] failed to handle stmt [insert into external_bc_order_site1_summary_all select * from bc_order_site1_summary_all] label: insert_d57e14a0-c1e7-11ee-89c9-00163e0252b1
java.lang.NullPointerException: null
at com.starrocks.server.GlobalStateMgr.createNodesInfo(GlobalStateMgr.java:590) ~[starrocks-fe.jar:?]
at com.starrocks.planner.OlapTableSink.complete(OlapTableSink.java:249) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1881) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:1709) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:659) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:784) ~[starrocks-fe.jar:?]
at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1248) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3976) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3956) ~[starrocks-fe.jar:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
2024-02-03 00:26:36,119 INFO (thrift-server-pool-33606|42348) [GlobalTransactionMgr.abortRemoteTransaction():271] abort remote, txn_id: 2716368
2024-02-03 00:26:36,119 WARN (thrift-server-pool-33606|42348) [StmtExecutor.handleDMLStmtWithProfile():1711] DML statement(insert into external_bc_order_site1_summary_all select * from bc_order_site1_summary_all) process failed.
com.starrocks.common.UserException:
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2171) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:1709) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:659) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:784) ~[starrocks-fe.jar:?]
at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1248) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3976) ~[starrocks-fe.jar:?]
at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:3956) ~[starrocks-fe.jar:?]
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: java.lang.NullPointerException
at com.starrocks.server.GlobalStateMgr.createNodesInfo(GlobalStateMgr.java:590) ~[starrocks-fe.jar:?]
at com.starrocks.planner.OlapTableSink.complete(OlapTableSink.java:249) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1881) ~[starrocks-fe.jar:?]
... 12 more
2024-02-03 00:26:36,119 INFO (thrift-server-pool-33606|42348) [StmtExecutor.execute():710] execute Exception, sql: insert into external_bc_order_site1_summary_all select * from bc_order_site1_summary_all, error:
2024-02-03 00:26:40,748 INFO (statistics meta manager|37) [StatisticsMetaManager.createSampleStatisticsTable():139] create sample statistics table start
2024-02-03 00:26:40,748 INFO (statistics meta manager|37) [Database.checkDataSizeQuota():442] database[_statistics_] data quota: left bytes: 8388608.000 TB / total: 8388608.000 TB
2024-02-03 00:26:40,748 INFO (statistics meta manager|37) [Database.checkReplicaQuota():453] database[_statistics_] replica quota: left number: 9223372036854775807 / total: 9223372036854775807
2024-02-03 00:26:40,761 INFO (statistics meta manager|37) [LocalMetastore.buildPartitions():1890] start to build 1 partitions sequentially for table _statistics_.table_statistic_v1 with 10 replicas
2024-02-03 00:26:40,761 INFO (statistics meta manager|37) [LocalMetastore.buildPartitionsSequentially():1922] build partitions sequentially, send task one by one, all tasks timeout 40s
2024-02-03 00:26:40,763 WARN (thrift-server-pool-3|223) [LeaderImpl.finishTask():188] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.141.4.203, be_port:9060, http_port:8040), task_type:CREATE, signature:10622248, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[create tablet failed]), report_version:17041933110020)
2024-02-03 00:26:40,763 WARN (thrift-server-pool-33465|42186) [LeaderImpl.finishTask():188] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.141.4.204, be_port:9060, http_port:8040), task_type:CREATE, signature:10622247, task_status:TStatus(status_code:RUNTIME_ERROR, error_msgs:[create tablet failed]), report_version:17042510120022)
2024-02-03 00:26:40,763 WARN (thrift-server-pool-3|223) [LeaderImpl.finishTask():236] task type: CREATE, status_code: RUNTIME_ERROR, create tablet failed, backendId: 10225, signature: 10622248
2024-02-03 00:26:40,763 WARN (thrift-server-pool-33465|42186) [LeaderImpl.finishTask():236] task type: CREATE, status_code: RUNTIME_ERROR, create tablet failed, backendId: 10226, signature