【详述】sr3.3存算分离版本设置默认存储卷无效
【背景】从sr3.1升级到3.3，之前在fe conf里面配置了hdfs存储卷，现在用命令创建了HA的hdfs存储卷，设置了HA HDFS为默认存储卷，但是实际建表的时候还是用了之前的存储卷，fe log里面也没有什么报错。
【业务影响】无法使用HA HDFS存储卷
【是否存算分离】 是
【StarRocks版本】3.3.6
【集群规模】1fe+3be（fe与be混部）
【联系方式】zain_chou@163.com|StarRocks 社区群24
【附件】
默认存储卷会关联到database, 需要drop database重建才会关联到新的storage volume, 你这种情况如果可以重建database, 可以重新create database, 不能的话, create table显式指定一下storage volume属性.
需要, 可以drop force这个_statistics_ db, FE会重建.
好的，十分感谢，那请问下_statistics_这个db的表需要重建成新存储卷吗？我担心hdfs主备切换的时候会有影响
好的，十分感谢~~直接drop force就行是吧？不用重启fe
老师，我删除后，发现后台日志有报错，看来这个表要手动创建？：
RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
在github上报个issue吧
OK，这个表的DDL可以先给下吗？我手动创建下先
收到，感谢！
已提issue
after drop db statistics ,some tables cannot be automatically rebuilt · Issue #54384 · StarRocks/starrocks
FE日志里搜索loads_history有其它相关的日志吗?
2024-12-26 15:50:05.606+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:51:05.607+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:52:05.608+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:53:05.609+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:54:05.610+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:55:05.611+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:56:05.612+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:57:05.613+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:58:05.615+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 15:59:05.616+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:00:05.617+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:01:05.618+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:02:05.619+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:03:05.620+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:04:05.621+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:05:05.622+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:06:05.623+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:07:05.625+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:08:05.626+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:09:05.627+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:10:05.628+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:11:05.629+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:12:05.630+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:13:05.632+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:14:05.633+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:15:05.634+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:16:05.635+08:00 ERROR (Load history syncer|55) [RepoExecutor.executeDML():76] RepoExecutor execute SQL INSERT INTO statistics.loads_history SELECT * FROM information_schema.loads WHERE load_finish_time IS NOT NULL AND load_finish_time < NOW() - INTERVAL 1 MINUTE AND load_finish_time > ( SELECT COALESCE(MAX(load_finish_time), ‘0001-01-01 00:00:00’) FROM statistics.loads_history); failed: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: execute sql failed: Getting analyzing error. Detail message: Table loads_history is not found…
Caused by: com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: Table loads_history is not found.
2024-12-26 16:16:40.633+08:00 INFO (starrocks-mysql-nio-pool-1400|518350) [LocalMetastore.buildPartitions():1778] start to build 1 partitions sequentially for table statistics.loads_history with 3 replicas
2024-12-26 16:16:40.673+08:00 INFO (starrocks-mysql-nio-pool-1400|518350) [LocalMetastore.onCreate():2209] Successfully create table: loads_history-402146, in database: statistics-390611
2024-12-26 16:17:05.860+08:00 INFO (thrift-server-pool-501667|520234) [LocalMetastore.buildPartitions():1778] start to build 2 partitions sequentially for table statistics.loads_history with 6 replicas
2024-12-26 16:17:08.126+08:00 INFO (autovacuum-pool1-t7|215) [AutovacuumDaemon.vacuumPartitionImpl():208] Vacuumed statistics.loads_history.402161 hasError=false vacuumedFiles=0 vacuumedFileSize=0 visibleVersion=2 minRetainVersion=2 minActiveTxnId=368913 cost=1ms
2024-12-26 16:17:08.127+08:00 INFO (autovacuum-pool1-t8|216) [AutovacuumDaemon.vacuumPartitionImpl():208] Vacuumed statistics.loads_history.402165 hasError=false vacuumedFiles=0 vacuumedFileSize=0 visibleVersion=2 minRetainVersion=2 minActiveTxnId=368913 cost=2ms
2024-12-26 16:20:08.227+08:00 INFO (autovacuum-pool1-t7|215) [AutovacuumDaemon.vacuumPartitionImpl():208] Vacuumed statistics.loads_history.402161 hasError=false vacuumedFiles=0 vacuumedFileSize=0 visibleVersion=5 minRetainVersion=5 minActiveTxnId=368935 cost=1ms
2024-12-26 16:20:08.227+08:00 INFO (autovacuum-pool1-t6|214) [AutovacuumDaemon.vacuumPartitionImpl():208] Vacuumed statistics.loads_history.402165 hasError=false vacuumedFiles=0 vacuumedFileSize=0 visibleVersion=2 minRetainVersion=2 minActiveTxnId=368935 cost=1ms
