【详述】问题详细描述
【背景】做过哪些操作？创建表时间超时，查询和插入操作正常；重启BE后又正常
【业务影响】
【StarRocks版本】1.19.3
【报错信息】
CREATE TABLE IF NOT EXISTS test.test
(
guid VARCHAR(32) not null,
month date not null,
amount DECIMAL(18,6),
column_1 CHAR(1)
)
PRIMARY KEY(guid,month)
PARTITION BY RANGE(month) (
START (“2017-01-01”) END (“2022-01-01”) EVERY (INTERVAL 1 MONTH)
) DISTRIBUTED BY HASH(month) BUCKETS 5
PROPERTIES(“replication_num” = “1”)
1064 - fail to create tablet: timed out. unfinished replicas(3/200): 47656(10.100.29.36) 47658(10.100.29.36) 47660(10.100.29.36) timeout=200s
时间: 200.074s
【详细日志】
2022-01-07 03:13:19,709 WARN (starrocks-mysql-nio-pool-77|4687) [Catalog.waitForFinished():3764] fail to create tablet: timed out. unfinished replicas(3/200): 47656(10.100.29.36) 47658(10.100.29.36) 47660(10.100.29.36) timeout=200s
2022-01-07 03:13:19,709 WARN (starrocks-mysql-nio-pool-77|4687) [StmtExecutor.handleDdlStmt():1210] DDL statement(CREATE TABLE IF NOT EXISTS test.test
(
guid VARCHAR(32) not null,
month date not null,
amount DECIMAL(18,6),
column_1 CHAR(1)
)
PRIMARY KEY(guid,month)
PARTITION BY RANGE(month) (
START (“2017-01-01”) END (“2022-01-01”) EVERY (INTERVAL 1 MONTH)
) DISTRIBUTED BY HASH(month) BUCKETS 5
PROPERTIES(“replication_num” = “1”)) process failed.
com.starrocks.common.DdlException: fail to create tablet: timed out. unfinished replicas(3/200): 47656(10.100.29.36) 47658(10.100.29.36) 47660(10.100.29.36) timeout=200s
at com.starrocks.catalog.Catalog.waitForFinished(Catalog.java:3766) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.sendCreateReplicaTasksAndWaitForFinished(Catalog.java:3718) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.buildPartitionsSequentially(Catalog.java:3596) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.buildPartitions(Catalog.java:3565) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createOlapTable(Catalog.java:4032) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createTable(Catalog.java:3018) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DdlExecutor.execute(DdlExecutor.java:115) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1202) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:425) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:248) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:397) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:633) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$485(ReadListener.java:54) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_152]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_152]
2022-01-07 03:13:20,154 WARN (thrift-server-pool-3|175) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47216
2022-01-07 03:13:21,651 WARN (thrift-server-pool-2|159) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47220
2022-01-07 03:13:22,653 WARN (thrift-server-pool-9|4640) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47222
2022-01-07 03:13:23,551 WARN (thrift-server-pool-1|155) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47224
2022-01-07 03:13:24,055 WARN (thrift-server-pool-3|175) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47226
2022-01-07 03:13:26,752 WARN (thrift-server-pool-0|154) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47230
2022-01-07 03:13:26,854 WARN (thrift-server-pool-2|159) [MasterImpl.finishTask():203] cannot find task. type: CREATE, backendId: 37137, signature: 47228
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():689] failed add to meta. tablet[46984], backend[37137]. db[-1] does not exist
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():702] delete tablet[46984 - 28023857] from backend[37137] because not found in meta
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():689] failed add to meta. tablet[46986], backend[37137]. db[-1] does not exist
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():702] delete tablet[46986 - 28023857] from backend[37137] because not found in meta
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():689] failed add to meta. tablet[46988], backend[37137]. db[-1] does not exist
日志一直报上面这两个WARN：
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():689] failed add to meta. tablet[46986], backend[37137]. db[-1] does not exist
2022-01-07 03:13:26,952 WARN (Thread-48|97) [ReportHandler.deleteFromBackend():702] delete tablet[46986 - 28023857] from backend[37137] because not found in meta
【补充】
创建非分区表也一样报错：
CREATE TABLE IF NOT EXISTS test.test_unique
(
month VARCHAR(8) not null,
amount DECIMAL(18,6)
)
PRIMARY KEY(month)
DISTRIBUTED BY HASH(month) BUCKETS 10
PROPERTIES(“replication_num” = “1”)
1064 - fail to create tablet: timed out. unfinished replicas(1/1): 49073(10.100.29.36) timeout=10s
时间: 10.027s
