==================== Test output for //pkg/planner/indexadvisor:indexadvisor_test (shard 21 of 48): === RUN TestIndexAdvisorTPCH1 [2025/11/07 12:33:46.366 +00:00] [INFO] [store_cache.go:559] ["change store resolve state"] [store=1] [addr=store1] [from=unresolved] [to=resolved] [liveness-state=reachable] [2025/11/07 12:33:46.366 +00:00] [INFO] [bootstrap.go:1215] ["bootstrap tables"] [currVer=0] [targetVer=1] [2025/11/07 12:33:46.370 +00:00] [INFO] [helper.go:189] ["set random timezone for getStmtTimestamp"] [timezone=Asia/Shanghai] [2025/11/07 12:33:46.385 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(6291456) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.393 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(19372) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.414 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(524288) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.423 +00:00] [INFO] [session.go:3832] ["init DDL tables"] [currVer=0] [targetVer=1] [2025/11/07 12:33:46.424 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(65535) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.424 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(65535) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.425 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(65535) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.425 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(65535) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.425 +00:00] [INFO] [session.go:3832] ["init DDL tables"] [currVer=0] [targetVer=2] [2025/11/07 12:33:46.425 +00:00] [INFO] [add_column.go:1339] ["Automatically convert BLOB(65535) to MEDIUMBLOB"] [category=ddl] [2025/11/07 12:33:46.425 +00:00] [INFO] [session.go:3832] ["init DDL tables"] [currVer=0] [targetVer=3] [2025/11/07 12:33:46.427 +00:00] [INFO] [session.go:3832] ["init DDL tables"] [currVer=0] [targetVer=4] [2025/11/07 12:33:46.434 +00:00] [INFO] [tidb.go:94] ["new domain"] [store=ce7a7f31-0b50-478a-9334-ee40ebec4371] ["ddl lease"=500ms] ["stats lease"=-1ns] [2025/11/07 12:33:46.434 +00:00] [WARN] [replayer.go:127] ["cannot write to file"] [path=replayer/test_20251107123346.txt] [2025/11/07 12:33:46.434 +00:00] [INFO] [replayer.go:115] ["use temp dir as plan replayer dir"] [dir=/tmp/tidb/replayer] [2025/11/07 12:33:46.549 +00:00] [WARN] [controller.go:229] ["[resource group controller] server does not save config, load config failed"] [2025/11/07 12:33:46.549 +00:00] [INFO] [controller.go:213] ["load resource controller config"] [config="{\"degraded-mode-wait-duration\":\"0s\",\"ltb-max-wait-duration\":\"30s\",\"ltb-token-rpc-max-delay\":\"1s\",\"request-unit\":{\"read-base-cost\":0.125,\"read-per-batch-base-cost\":0.5,\"read-cost-per-byte\":0.0000152587890625,\"write-base-cost\":1,\"write-per-batch-base-cost\":1,\"write-cost-per-byte\":0.0009765625,\"read-cpu-ms-cost\":0.3333333333333333},\"enable-controller-trace-log\":\"false\",\"token-rpc-params\":{\"wait-retry-interval\":\"50ms\",\"wait-retry-times\":20}}"] [ru-config="{\"ReadBaseCost\":0.125,\"ReadPerBatchBaseCost\":0.5,\"ReadBytesCost\":0.0000152587890625,\"WriteBaseCost\":1,\"WritePerBatchBaseCost\":1,\"WriteBytesCost\":0.0009765625,\"CPUMsCost\":0.3333333333333333,\"LTBMaxWaitDuration\":30000000000,\"WaitRetryInterval\":50000000,\"WaitRetryTimes\":20,\"DegradedModeWaitDuration\":0}"] [keyspace-id=16777214] [2025/11/07 12:33:46.593 +00:00] [INFO] [loader.go:274] ["full load InfoSchema success"] [mode=auto] [isV2=true] [currentSchemaVersion=0] [neededSchemaVersion=0] ["elapsed time"=42.699614ms] [2025/11/07 12:33:46.593 +00:00] [INFO] [syncer.go:454] ["full load and reset schema validator"] [2025/11/07 12:33:46.593 +00:00] [INFO] [ddl.go:894] ["start DDL"] [category=ddl] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] [runWorker=true] [jobVersion=v2] [startMode=bootstrap] [2025/11/07 12:33:46.593 +00:00] [INFO] [ddl.go:869] ["start delRangeManager OK"] [category=ddl] ["is a emulator"=true] [2025/11/07 12:33:46.593 +00:00] [INFO] [env.go:123] ["the ingest sorted directory"] [category=ddl-ingest] ["data path"=/tmp/tidb/tmp_ddl-4000] [2025/11/07 12:33:46.593 +00:00] [WARN] [env.go:61] ["initialize environment failed"] [category=ddl-ingest] ["storage limitation"="only support TiKV storage"] ["current storage"=unistore] ["lightning is initialized"=false] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=loadSchemaInLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=mdlCheckLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=topNSlowQueryLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=infoSyncerKeeper] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=globalConfigSyncerKeeper] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=runawayRecordFlushLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=runawayWatchSyncLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=requestUnitsWriterLoop] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=topologySyncerKeeper] [2025/11/07 12:33:46.593 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=closestReplicaReadCheckLoop] [2025/11/07 12:33:46.593 +00:00] [WARN] [domain.go:920] ["pd / etcd client not provided, won't begin Advancer."] [2025/11/07 12:33:46.594 +00:00] [INFO] [delete_range.go:172] ["start delRange emulator"] [category=ddl] [2025/11/07 12:33:46.594 +00:00] [INFO] [mock.go:88] ["owner manager gets owner"] [ownerKey=/tidb/ddl/fg/owner] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] [2025/11/07 12:33:46.594 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=requestUnitsWriterLoop] [2025/11/07 12:33:46.594 +00:00] [INFO] [job_scheduler.go:369] ["get global state and global state change"] [category=ddl] [oldState=false] [currState=false] [2025/11/07 12:33:46.594 +00:00] [INFO] [job_scheduler.go:381] ["the owner sets owner operator value"] [category=ddl] [ownerOp=none] [2025/11/07 12:33:46.602 +00:00] [INFO] [executor.go:6976] ["system variable tidb_scatter_region not found, use default value"] [category=ddl] [2025/11/07 12:33:46.615 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:2, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710655, TableID:1, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.604 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:46.615 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:2, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710655, TableID:1, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.604 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE OR REPLACE SQL SECURITY INVOKER VIEW mysql.tidb_mdl_view as (\n\t\tSELECT tidb_mdl_info.job_id,\n\t\t\tJSON_UNQUOTE(JSON_EXTRACT(cast(cast(job_meta as char) as json), \"$.schema_name\")) as db_name,\n\t\t\tJSON_UNQUOTE(JSON_EXTRACT(cast(cast(job_meta as char) as json), \"$.table_name\")) as table_name,\n\t\t\tJSON_UNQUOTE(JSON_EXTRACT(cast(cast(job_meta as char) as json), \"$.query\")) as query,\n\t\t\tsession_id,\n\t\t\tcluster_tidb_trx.start_time,\n\t\t\ttidb_decode_sql_digests(all_sql_digests, 4096) AS SQL_DIGESTS\n\t\tFROM mysql.tidb_ddl_job,\n\t\t\tmysql.tidb_mdl_info,\n\t\t\tinformation_schema.cluster_tidb_trx\n\t\tWHERE tidb_ddl_job.job_id=tidb_mdl_info.job_id\n\t\t\tAND CONCAT(',', tidb_mdl_info.table_ids, ',') REGEXP CONCAT(',(', REPLACE(cluster_tidb_trx.related_table_ids, ',', '|'), '),') != 0\n\t);"] [2025/11/07 12:33:46.618 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=2] [job="ID:2, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710655, TableID:1, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.604 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.709 +00:00] [INFO] [loader.go:274] ["full load InfoSchema success"] [mode=auto] [isV2=true] [currentSchemaVersion=0] [neededSchemaVersion=1] ["elapsed time"=71.078493ms] [2025/11/07 12:33:46.709 +00:00] [INFO] [syncer.go:454] ["full load and reset schema validator"] [2025/11/07 12:33:46.713 +00:00] [INFO] [syncer.go:257] ["session manager is nil"] [2025/11/07 12:33:46.713 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=2] [version=1] [2025/11/07 12:33:46.717 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=1] [checkAssumedSvr=false] ["take time"=79.583893ms] [job="ID:2, Type:create view, State:done, SchemaState:public, SchemaID:281474976710655, TableID:1, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.604 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:46.746 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=2] [job="ID:2, Type:create view, State:synced, SchemaState:public, SchemaID:281474976710655, TableID:1, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.604 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.761 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=2] [2025/11/07 12:33:46.768 +00:00] [INFO] [executor.go:6976] ["system variable tidb_scatter_region not found, use default value"] [category=ddl] [2025/11/07 12:33:46.797 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:4, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710595, TableID:3, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.777 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:46.798 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:4, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710595, TableID:3, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.777 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE OR REPLACE VIEW sys.schema_unused_indexes AS\n\t\tSELECT\n\t\t\ttable_schema as object_schema,\n\t\t\ttable_name as object_name,\n\t\t\tindex_name\n\t\tFROM information_schema.cluster_tidb_index_usage\n\t\tWHERE\n\t\t\ttable_schema not in ('sys', 'mysql', 'INFORMATION_SCHEMA', 'PERFORMANCE_SCHEMA') and\n\t\t\tindex_name != 'PRIMARY'\n\t\tGROUP BY table_schema, table_name, index_name\n\t\tHAVING\n\t\t\tsum(last_access_time) is null;"] [2025/11/07 12:33:46.800 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=4] [job="ID:4, Type:create view, State:queueing, SchemaState:none, SchemaID:281474976710595, TableID:3, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.777 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.840 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=1] [neededVer=2] [gotVer=2] ["elapsed time"=335.072µs] [phyTblIDs="[3]"] [actionTypes="[21]"] [diffTypes="[\"create view\"]"] [2025/11/07 12:33:46.841 +00:00] [INFO] [syncer.go:257] ["session manager is nil"] [2025/11/07 12:33:46.841 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=4] [version=2] [2025/11/07 12:33:46.843 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=2] [checkAssumedSvr=false] ["take time"=4.107482ms] [job="ID:4, Type:create view, State:done, SchemaState:public, SchemaID:281474976710595, TableID:3, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.777 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:46.851 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=4] [job="ID:4, Type:create view, State:synced, SchemaState:public, SchemaID:281474976710595, TableID:3, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.777 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.859 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=4] [2025/11/07 12:33:46.864 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:6, Type:create schema, State:queueing, SchemaState:none, SchemaID:5, TableID:0, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.862 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:46.864 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:6, Type:create schema, State:queueing, SchemaState:none, SchemaID:5, TableID:0, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.862 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE DATABASE IF NOT EXISTS test"] [2025/11/07 12:33:46.866 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=6] [job="ID:6, Type:create schema, State:queueing, SchemaState:none, SchemaID:5, TableID:0, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.862 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.869 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=2] [neededVer=3] [gotVer=3] ["elapsed time"=83.058µs] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"] [2025/11/07 12:33:46.871 +00:00] [INFO] [syncer.go:257] ["session manager is nil"] [2025/11/07 12:33:46.871 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=6] [version=3] [2025/11/07 12:33:46.871 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=3] [checkAssumedSvr=false] ["take time"=2.026053ms] [job="ID:6, Type:create schema, State:done, SchemaState:public, SchemaID:5, TableID:0, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:46.862 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:46.875 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=6] [job="ID:6, Type:create schema, State:synced, SchemaState:public, SchemaID:5, TableID:0, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:46.862 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:46.883 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=6] [2025/11/07 12:33:46.883 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=0] [schemaVersion=3] [cur_db=mysql] [sql="CREATE DATABASE IF NOT EXISTS test"] [user=] [2025/11/07 12:33:47.027 +00:00] [INFO] [bootstrap.go:867] ["bootstrap successful"] ["take time"=433.295229ms] [2025/11/07 12:33:47.027 +00:00] [INFO] [job_scheduler.go:279] ["scheduleLoop quit due to context canceled"] [category=ddl] [2025/11/07 12:33:47.027 +00:00] [INFO] [mock.go:100] ["owner manager retire owner"] [ownerKey=/tidb/ddl/fg/owner] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] [2025/11/07 12:33:47.027 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:33:47.027 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:33:47.027 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 1, tp general"] ["take time"=24.919µs] [2025/11/07 12:33:47.027 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 2, tp general"] ["take time"=14.665µs] [2025/11/07 12:33:47.027 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 3, tp general"] ["take time"=13.099µs] [2025/11/07 12:33:47.027 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:33:47.027 +00:00] [INFO] [mock.go:112] ["owner manager is canceled"] [ownerKey=/tidb/ddl/fg/owner] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] [2025/11/07 12:33:47.027 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl] [2025/11/07 12:33:47.027 +00:00] [INFO] [session_pool.go:98] ["closing session pool"] [category=ddl] [2025/11/07 12:33:47.028 +00:00] [INFO] [ddl.go:1145] ["DDL closed"] [category=ddl] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] ["take time"=993.948µs] [2025/11/07 12:33:47.028 +00:00] [INFO] [ddl.go:861] ["stop DDL"] [category=ddl] [ID=8678ebc2-f36c-4487-b8bb-ef6b6c62786c] [2025/11/07 12:33:47.028 +00:00] [INFO] [manager.go:230] ["runaway watch sync loop exit"] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [domain.go:380] ["topNSlowQueryLoop exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [syncer.go:379] ["topology sync loop exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=topNSlowQueryLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=mdlCheckLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=topologySyncerKeeper] [2025/11/07 12:33:47.028 +00:00] [INFO] [syncer.go:302] ["info schema sync loop exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=loadSchemaInLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [domain.go:956] ["closestReplicaReadCheckLoop exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [domain.go:408] ["globalConfigSyncerKeeper exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper] [2025/11/07 12:33:47.028 +00:00] [INFO] [syncer.go:245] ["server info sync loop exited."] [2025/11/07 12:33:47.028 +00:00] [INFO] [manager.go:172] ["runaway record flush loop exit"] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=infoSyncerKeeper] [2025/11/07 12:33:47.028 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop] [2025/11/07 12:33:47.028 +00:00] [INFO] [domain.go:538] ["domain closed"] ["take time"=1.232454ms] [2025/11/07 12:33:47.028 +00:00] [INFO] [session.go:4258] ["bootstrap cluster finished"] [bootMode=bootstrap] [cost=594.146055ms] [2025/11/07 12:33:47.028 +00:00] [INFO] [tidb.go:94] ["new domain"] [store=ce7a7f31-0b50-478a-9334-ee40ebec4371] ["ddl lease"=500ms] ["stats lease"=-1ns] [2025/11/07 12:33:47.050 +00:00] [WARN] [controller.go:229] ["[resource group controller] server does not save config, load config failed"] [2025/11/07 12:33:47.050 +00:00] [INFO] [controller.go:213] ["load resource controller config"] [config="{\"degraded-mode-wait-duration\":\"0s\",\"ltb-max-wait-duration\":\"30s\",\"ltb-token-rpc-max-delay\":\"1s\",\"request-unit\":{\"read-base-cost\":0.125,\"read-per-batch-base-cost\":0.5,\"read-cost-per-byte\":0.0000152587890625,\"write-base-cost\":1,\"write-per-batch-base-cost\":1,\"write-cost-per-byte\":0.0009765625,\"read-cpu-ms-cost\":0.3333333333333333},\"enable-controller-trace-log\":\"false\",\"token-rpc-params\":{\"wait-retry-interval\":\"50ms\",\"wait-retry-times\":20}}"] [ru-config="{\"ReadBaseCost\":0.125,\"ReadPerBatchBaseCost\":0.5,\"ReadBytesCost\":0.0000152587890625,\"WriteBaseCost\":1,\"WritePerBatchBaseCost\":1,\"WriteBytesCost\":0.0009765625,\"CPUMsCost\":0.3333333333333333,\"LTBMaxWaitDuration\":30000000000,\"WaitRetryInterval\":50000000,\"WaitRetryTimes\":20,\"DegradedModeWaitDuration\":0}"] [keyspace-id=16777214] [2025/11/07 12:33:47.095 +00:00] [INFO] [loader.go:274] ["full load InfoSchema success"] [mode=auto] [isV2=true] [currentSchemaVersion=0] [neededSchemaVersion=3] ["elapsed time"=44.992281ms] [2025/11/07 12:33:47.095 +00:00] [INFO] [syncer.go:454] ["full load and reset schema validator"] [2025/11/07 12:33:47.098 +00:00] [INFO] [ddl.go:894] ["start DDL"] [category=ddl] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [runWorker=true] [jobVersion=v2] [startMode=normal] [2025/11/07 12:33:47.098 +00:00] [INFO] [ddl.go:869] ["start delRangeManager OK"] [category=ddl] ["is a emulator"=true] [2025/11/07 12:33:47.098 +00:00] [INFO] [env.go:123] ["the ingest sorted directory"] [category=ddl-ingest] ["data path"=/tmp/tidb/tmp_ddl-4000] [2025/11/07 12:33:47.098 +00:00] [WARN] [env.go:61] ["initialize environment failed"] [category=ddl-ingest] ["storage limitation"="only support TiKV storage"] ["current storage"=unistore] ["lightning is initialized"=false] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=loadSchemaInLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=mdlCheckLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=topNSlowQueryLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=infoSyncerKeeper] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=globalConfigSyncerKeeper] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=runawayRecordFlushLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=runawayWatchSyncLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=requestUnitsWriterLoop] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=topologySyncerKeeper] [2025/11/07 12:33:47.098 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=closestReplicaReadCheckLoop] [2025/11/07 12:33:47.098 +00:00] [WARN] [domain.go:920] ["pd / etcd client not provided, won't begin Advancer."] [2025/11/07 12:33:47.126 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=globalBindHandleWorkerLoop] [2025/11/07 12:33:47.126 +00:00] [WARN] [sysvar_cache.go:50] ["sysvar cache is empty, triggering rebuild"] [2025/11/07 12:33:47.128 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=requestUnitsWriterLoop] [2025/11/07 12:33:47.128 +00:00] [INFO] [mock.go:88] ["owner manager gets owner"] [ownerKey=/tidb/ddl/fg/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:33:47.128 +00:00] [INFO] [delete_range.go:172] ["start delRange emulator"] [category=ddl] [2025/11/07 12:33:47.128 +00:00] [INFO] [mock.go:88] ["owner manager gets owner"] [ownerKey=/tidb/bindinfo/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:33:47.128 +00:00] [INFO] [job_scheduler.go:369] ["get global state and global state change"] [category=ddl] [oldState=false] [currState=false] [2025/11/07 12:33:47.128 +00:00] [INFO] [job_scheduler.go:381] ["the owner sets owner operator value"] [category=ddl] [ownerOp=none] [2025/11/07 12:33:47.184 +00:00] [INFO] [sysvar.go:3218] ["set resource control"] [enable=true] [2025/11/07 12:33:47.189 +00:00] [INFO] [controller.go:530] ["[resource group controller] create resource group cost controller"] [name=default] [2025/11/07 12:33:47.190 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=loadPrivilegeInLoop] [2025/11/07 12:33:47.207 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=LoadSysVarCacheLoop] [2025/11/07 12:33:47.210 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=dumpFileGcChecker] [2025/11/07 12:33:47.211 +00:00] [INFO] [domain.go:1810] ["dumpFileGcChecker started"] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=indexUsageWorker] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=quitStatsOwner] [2025/11/07 12:33:47.211 +00:00] [INFO] [domain.go:2036] ["start load stats sub workers"] [workerCount=6] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=planCacheEvictTrigger] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=planCacheMetricsAndVars] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=readTableCostWorker] [2025/11/07 12:33:47.211 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=loadSigningCertLoop] [2025/11/07 12:33:47.211 +00:00] [INFO] [mock.go:88] ["owner manager gets owner"] [ownerKey=/tidb/stats/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:33:47.211 +00:00] [WARN] [domain.go:1094] ["metering storage uri is empty, metering will be disabled"] [2025/11/07 12:33:47.211 +00:00] [INFO] [domain.go:1179] ["initialize node resource"] [total-cpu=16] [total-mem=342GiB] [total-disk=434.8GiB] [2025/11/07 12:33:47.214 +00:00] [INFO] [wait_group_wrapper.go:141] ["background process started"] [source=domain] [process=distTaskFrameworkLoop] [2025/11/07 12:33:47.215 +00:00] [INFO] [rate_limiter_param.go:98] ["meta kv not found in meta store, initialized to default and persisted"] [key=maxBatchSplitRanges] [value=2048] [2025/11/07 12:33:47.215 +00:00] [INFO] [rate_limiter_param.go:98] ["meta kv not found in meta store, initialized to default and persisted"] [key=maxSplitRangesPerSec] [value=0] [2025/11/07 12:33:47.215 +00:00] [INFO] [rate_limiter_param.go:98] ["meta kv not found in meta store, initialized to default and persisted"] [key=maxIngestInflight] [value=0] [2025/11/07 12:33:47.215 +00:00] [INFO] [rate_limiter_param.go:98] ["meta kv not found in meta store, initialized to default and persisted"] [key=maxIngestPerSec] [value=0] [2025/11/07 12:33:47.215 +00:00] [INFO] [task_manager.go:248] ["scale ttl worker"] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [ttl-worker=task-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [originalCount=0] [newCount=4] [2025/11/07 12:33:47.215 +00:00] [INFO] [task_manager.go:248] ["scale ttl worker"] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [ttl-worker=task-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [originalCount=0] [newCount=4] [2025/11/07 12:33:47.215 +00:00] [INFO] [job_manager.go:511] ["TTL leader to collect delay metrics"] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:33:47.216 +00:00] [INFO] [manager.go:113] ["task executor manager start"] [server-id=:4000] [2025/11/07 12:33:47.216 +00:00] [INFO] [domain.go:1192] ["dist task executor manager started"] [2025/11/07 12:33:47.231 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:8, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:7, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.223 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.231 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:8, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:7, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.223 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS nation (\n\t\t\t\tN_NATIONKEY BIGINT NOT NULL,\n\t\t\t\tN_NAME CHAR(25) NOT NULL,\n\t\t\t\tN_REGIONKEY BIGINT NOT NULL,\n\t\t\t\tN_COMMENT VARCHAR(152),\n\t\t\t\tPRIMARY KEY (N_NATIONKEY))"] [2025/11/07 12:33:47.242 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=8] [conn=1] [job="ID:8, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:7, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.223 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.243 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 7, Table Name: nation)"] [2025/11/07 12:33:47.258 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=3] [neededVer=4] [gotVer=4] ["elapsed time"=330.356µs] [phyTblIDs="[7]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.260 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=8] [version=4] [2025/11/07 12:33:47.262 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=4] [checkAssumedSvr=false] ["take time"=4.945305ms] [job="ID:8, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:7, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.223 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.268 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=8] [conn=1] [job="ID:8, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:7, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.223 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.317 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=8] [2025/11/07 12:33:47.318 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=4] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS nation (\n\t\t\t\tN_NATIONKEY BIGINT NOT NULL,\n\t\t\t\tN_NAME CHAR(25) NOT NULL,\n\t\t\t\tN_REGIONKEY BIGINT NOT NULL,\n\t\t\t\tN_COMMENT VARCHAR(152),\n\t\t\t\tPRIMARY KEY (N_NATIONKEY))"] [user=] [2025/11/07 12:33:47.340 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:10, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:9, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.33 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.341 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:10, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:9, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.33 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS region (\n\t\t\t\tR_REGIONKEY BIGINT NOT NULL,\n\t\t\t\tR_NAME CHAR(25) NOT NULL,\n\t\t\t\tR_COMMENT VARCHAR(152),\n\t\t\t\tPRIMARY KEY (R_REGIONKEY))"] [2025/11/07 12:33:47.347 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=10] [conn=1] [job="ID:10, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:9, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.33 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.348 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 9, Table Name: region)"] [2025/11/07 12:33:47.361 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=4] [neededVer=5] [gotVer=5] ["elapsed time"=357.204µs] [phyTblIDs="[9]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.363 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=10] [version=5] [2025/11/07 12:33:47.369 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=5] [checkAssumedSvr=false] ["take time"=8.444687ms] [job="ID:10, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:9, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.33 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.382 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=10] [conn=1] [job="ID:10, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:9, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.33 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.414 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=10] [2025/11/07 12:33:47.414 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=5] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS region (\n\t\t\t\tR_REGIONKEY BIGINT NOT NULL,\n\t\t\t\tR_NAME CHAR(25) NOT NULL,\n\t\t\t\tR_COMMENT VARCHAR(152),\n\t\t\t\tPRIMARY KEY (R_REGIONKEY))"] [user=] [2025/11/07 12:33:47.434 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:12, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:11, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.42 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.434 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:12, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:11, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.42 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS part (\n\t P_PARTKEY BIGINT NOT NULL,\n\t P_NAME VARCHAR(55) NOT NULL,\n\t P_MFGR CHAR(25) NOT NULL,\n\t P_BRAND CHAR(10) NOT NULL,\n\t P_TYPE VARCHAR(25) NOT NULL,\n\t P_SIZE BIGINT NOT NULL,\n\t P_CONTAINER CHAR(10) NOT NULL,\n\t P_RETAILPRICE DECIMAL(15, 2) NOT NULL,\n\t P_COMMENT VARCHAR(23) NOT NULL,\n\t PRIMARY KEY (P_PARTKEY)\t)"] [2025/11/07 12:33:47.442 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=12] [conn=1] [job="ID:12, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:11, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.42 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.445 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 11, Table Name: part)"] [2025/11/07 12:33:47.472 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=5] [neededVer=6] [gotVer=6] ["elapsed time"=482.791µs] [phyTblIDs="[11]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.474 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=12] [version=6] [2025/11/07 12:33:47.477 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=6] [checkAssumedSvr=false] ["take time"=5.346804ms] [job="ID:12, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:11, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.42 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.485 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=12] [conn=1] [job="ID:12, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:11, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.42 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.501 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=12] [2025/11/07 12:33:47.503 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=6] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS part (\n\t P_PARTKEY BIGINT NOT NULL,\n\t P_NAME VARCHAR(55) NOT NULL,\n\t P_MFGR CHAR(25) NOT NULL,\n\t P_BRAND CHAR(10) NOT NULL,\n\t P_TYPE VARCHAR(25) NOT NULL,\n\t P_SIZE BIGINT NOT NULL,\n\t P_CONTAINER CHAR(10) NOT NULL,\n\t P_RETAILPRICE DECIMAL(15, 2) NOT NULL,\n\t P_COMMENT VARCHAR(23) NOT NULL,\n\t PRIMARY KEY (P_PARTKEY)\t)"] [user=] [2025/11/07 12:33:47.543 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:14, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:13, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.508 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.543 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:14, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:13, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.508 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS supplier (\n S_SUPPKEY BIGINT NOT NULL,\n S_NAME CHAR(25) NOT NULL,\n S_ADDRESS VARCHAR(40) NOT NULL,\n S_NATIONKEY BIGINT NOT NULL,\n S_PHONE CHAR(15) NOT NULL,\n S_ACCTBAL DECIMAL(15, 2) NOT NULL,\n S_COMMENT VARCHAR(101) NOT NULL,\n PRIMARY KEY (S_SUPPKEY))"] [2025/11/07 12:33:47.546 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=14] [conn=1] [job="ID:14, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:13, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.508 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.547 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 13, Table Name: supplier)"] [2025/11/07 12:33:47.564 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=6] [neededVer=7] [gotVer=7] ["elapsed time"=368.573µs] [phyTblIDs="[13]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.567 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=14] [version=7] [2025/11/07 12:33:47.568 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=7] [checkAssumedSvr=false] ["take time"=4.145043ms] [job="ID:14, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:13, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.508 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.573 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=14] [conn=1] [job="ID:14, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:13, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.508 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.587 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=14] [2025/11/07 12:33:47.588 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=7] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS supplier (\n S_SUPPKEY BIGINT NOT NULL,\n S_NAME CHAR(25) NOT NULL,\n S_ADDRESS VARCHAR(40) NOT NULL,\n S_NATIONKEY BIGINT NOT NULL,\n S_PHONE CHAR(15) NOT NULL,\n S_ACCTBAL DECIMAL(15, 2) NOT NULL,\n S_COMMENT VARCHAR(101) NOT NULL,\n PRIMARY KEY (S_SUPPKEY))"] [user=] [2025/11/07 12:33:47.598 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:16, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:15, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.592 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.599 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:16, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:15, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.592 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS partsupp (\n\t PS_PARTKEY BIGINT NOT NULL,\n\t PS_SUPPKEY BIGINT NOT NULL,\n\t PS_AVAILQTY BIGINT NOT NULL,\n\t PS_SUPPLYCOST DECIMAL(15, 2) NOT NULL,\n\t PS_COMMENT VARCHAR(199) NOT NULL,\n\t PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY)\n\t)"] [2025/11/07 12:33:47.601 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=16] [conn=1] [job="ID:16, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:15, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.592 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.602 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 15, Table Name: partsupp)"] [2025/11/07 12:33:47.613 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=7] [neededVer=8] [gotVer=8] ["elapsed time"=399.082µs] [phyTblIDs="[15]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.615 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=16] [version=8] [2025/11/07 12:33:47.621 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=8] [checkAssumedSvr=false] ["take time"=8.120116ms] [job="ID:16, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:15, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.592 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.625 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=16] [conn=1] [job="ID:16, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:15, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.592 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.635 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=16] [2025/11/07 12:33:47.635 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=8] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS partsupp (\n\t PS_PARTKEY BIGINT NOT NULL,\n\t PS_SUPPKEY BIGINT NOT NULL,\n\t PS_AVAILQTY BIGINT NOT NULL,\n\t PS_SUPPLYCOST DECIMAL(15, 2) NOT NULL,\n\t PS_COMMENT VARCHAR(199) NOT NULL,\n\t PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY)\n\t)"] [user=] [2025/11/07 12:33:47.648 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:18, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:17, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.641 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.650 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:18, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:17, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.641 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS customer (\n\t C_CUSTKEY BIGINT NOT NULL,\n\t C_NAME VARCHAR(25) NOT NULL,\n\t C_ADDRESS VARCHAR(40) NOT NULL,\n\t C_NATIONKEY BIGINT NOT NULL,\n\t C_PHONE CHAR(15) NOT NULL,\n\t C_ACCTBAL DECIMAL(15, 2) NOT NULL,\n\t C_MKTSEGMENT CHAR(10) NOT NULL,\n\t C_COMMENT VARCHAR(117) NOT NULL,\n\t PRIMARY KEY (C_CUSTKEY)\n\t)"] [2025/11/07 12:33:47.654 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=18] [conn=1] [job="ID:18, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:17, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.641 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.654 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 17, Table Name: customer)"] [2025/11/07 12:33:47.673 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=8] [neededVer=9] [gotVer=9] ["elapsed time"=388.865µs] [phyTblIDs="[17]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.676 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=18] [version=9] [2025/11/07 12:33:47.682 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=9] [checkAssumedSvr=false] ["take time"=8.917405ms] [job="ID:18, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:17, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.641 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.714 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=18] [conn=1] [job="ID:18, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:17, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.641 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.735 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=18] [2025/11/07 12:33:47.735 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=9] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS customer (\n\t C_CUSTKEY BIGINT NOT NULL,\n\t C_NAME VARCHAR(25) NOT NULL,\n\t C_ADDRESS VARCHAR(40) NOT NULL,\n\t C_NATIONKEY BIGINT NOT NULL,\n\t C_PHONE CHAR(15) NOT NULL,\n\t C_ACCTBAL DECIMAL(15, 2) NOT NULL,\n\t C_MKTSEGMENT CHAR(10) NOT NULL,\n\t C_COMMENT VARCHAR(117) NOT NULL,\n\t PRIMARY KEY (C_CUSTKEY)\n\t)"] [user=] [2025/11/07 12:33:47.754 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:20, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:19, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.738 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.755 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:20, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:19, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.738 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS orders (\n\t O_ORDERKEY BIGINT NOT NULL,\n\t O_CUSTKEY BIGINT NOT NULL,\n\t O_ORDERSTATUS CHAR(1) NOT NULL,\n\t O_TOTALPRICE DECIMAL(15, 2) NOT NULL,\n\t O_ORDERDATE DATE NOT NULL,\n\t O_ORDERPRIORITY CHAR(15) NOT NULL,\n\t O_CLERK CHAR(15) NOT NULL,\n\t O_SHIPPRIORITY BIGINT NOT NULL,\n\t O_COMMENT VARCHAR(79) NOT NULL,\n\t PRIMARY KEY (O_ORDERKEY)\n\t)"] [2025/11/07 12:33:47.758 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=20] [conn=1] [job="ID:20, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:19, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.738 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.759 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 19, Table Name: orders)"] [2025/11/07 12:33:47.796 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=9] [neededVer=10] [gotVer=10] ["elapsed time"=470.803µs] [phyTblIDs="[19]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.799 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=20] [version=10] [2025/11/07 12:33:47.801 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=10] [checkAssumedSvr=false] ["take time"=4.916738ms] [job="ID:20, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:19, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.738 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.806 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=20] [conn=1] [job="ID:20, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:19, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.738 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.820 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=20] [2025/11/07 12:33:47.820 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=10] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS orders (\n\t O_ORDERKEY BIGINT NOT NULL,\n\t O_CUSTKEY BIGINT NOT NULL,\n\t O_ORDERSTATUS CHAR(1) NOT NULL,\n\t O_TOTALPRICE DECIMAL(15, 2) NOT NULL,\n\t O_ORDERDATE DATE NOT NULL,\n\t O_ORDERPRIORITY CHAR(15) NOT NULL,\n\t O_CLERK CHAR(15) NOT NULL,\n\t O_SHIPPRIORITY BIGINT NOT NULL,\n\t O_COMMENT VARCHAR(79) NOT NULL,\n\t PRIMARY KEY (O_ORDERKEY)\n\t)"] [user=] [2025/11/07 12:33:47.857 +00:00] [INFO] [job_submitter.go:133] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:22, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:21, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.824 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2; "] [fast_create=true] [2025/11/07 12:33:47.857 +00:00] [INFO] [executor.go:6691] ["DDL job submitted"] [category=ddl] [job="ID:22, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:21, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.824 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [query="CREATE TABLE IF NOT EXISTS lineitem (\n\t L_ORDERKEY BIGINT NOT NULL,\n\t L_PARTKEY BIGINT NOT NULL,\n\t L_SUPPKEY BIGINT NOT NULL,\n\t L_LINENUMBER BIGINT NOT NULL,\n\t L_QUANTITY DECIMAL(15, 2) NOT NULL,\n\t L_EXTENDEDPRICE DECIMAL(15, 2) NOT NULL,\n\t L_DISCOUNT DECIMAL(15, 2) NOT NULL,\n\t L_TAX DECIMAL(15, 2) NOT NULL,\n\t L_RETURNFLAG CHAR(1) NOT NULL,\n\t L_LINESTATUS CHAR(1) NOT NULL,\n\t L_SHIPDATE DATE NOT NULL,\n\t L_COMMITDATE DATE NOT NULL,\n\t L_RECEIPTDATE DATE NOT NULL,\n\t L_SHIPINSTRUCT CHAR(25) NOT NULL,\n\t L_SHIPMODE CHAR(10) NOT NULL,\n\t L_COMMENT VARCHAR(44) NOT NULL,\n\t PRIMARY KEY (L_ORDERKEY, L_LINENUMBER)\n\t)"] [2025/11/07 12:33:47.868 +00:00] [INFO] [job_worker.go:836] ["run one job step"] [category=ddl] [jobID=22] [conn=1] [job="ID:22, Type:create table, State:queueing, SchemaState:none, SchemaID:5, TableID:21, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.824 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.870 +00:00] [WARN] [ddl.go:713] ["fail to notify DDL event"] [category=ddl] [event="(Event Type: create table, Table ID: 21, Table Name: lineitem)"] [2025/11/07 12:33:47.945 +00:00] [INFO] [loader.go:214] ["diff load InfoSchema success"] [mode=auto] [isV2=true] [currVer=10] [neededVer=11] [gotVer=11] ["elapsed time"=900.234µs] [phyTblIDs="[21]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"] [2025/11/07 12:33:47.949 +00:00] [INFO] [syncer.go:280] ["mdl gets lock, update self version to owner"] [jobID=22] [version=11] [2025/11/07 12:33:47.956 +00:00] [INFO] [schema_version.go:397] ["wait schema version synced success"] [category=ddl] [ver=11] [checkAssumedSvr=false] ["take time"=12.424484ms] [job="ID:22, Type:create table, State:done, SchemaState:public, SchemaID:5, TableID:21, RowCount:0, ArgLen:1, start time: 2025-11-07 12:33:47.824 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [summary="server count: 1"] [2025/11/07 12:33:47.962 +00:00] [INFO] [job_worker.go:435] ["finish DDL job"] [category=ddl] [jobID=22] [conn=1] [job="ID:22, Type:create table, State:synced, SchemaState:public, SchemaID:5, TableID:21, RowCount:0, ArgLen:0, start time: 2025-11-07 12:33:47.824 +0000 UTC, Err:, ErrCount:0, SnapshotVersion:0, Version: v2"] [2025/11/07 12:33:47.982 +00:00] [INFO] [executor.go:6811] ["DDL job is finished"] [category=ddl] [jobID=22] [2025/11/07 12:33:47.983 +00:00] [INFO] [session.go:4770] ["CRUCIAL OPERATION"] [conn=1] [schemaVersion=11] [cur_db=test] [sql="CREATE TABLE IF NOT EXISTS lineitem (\n\t L_ORDERKEY BIGINT NOT NULL,\n\t L_PARTKEY BIGINT NOT NULL,\n\t L_SUPPKEY BIGINT NOT NULL,\n\t L_LINENUMBER BIGINT NOT NULL,\n\t L_QUANTITY DECIMAL(15, 2) NOT NULL,\n\t L_EXTENDEDPRICE DECIMAL(15, 2) NOT NULL,\n\t L_DISCOUNT DECIMAL(15, 2) NOT NULL,\n\t L_TAX DECIMAL(15, 2) NOT NULL,\n\t L_RETURNFLAG CHAR(1) NOT NULL,\n\t L_LINESTATUS CHAR(1) NOT NULL,\n\t L_SHIPDATE DATE NOT NULL,\n\t L_COMMITDATE DATE NOT NULL,\n\t L_RECEIPTDATE DATE NOT NULL,\n\t L_SHIPINSTRUCT CHAR(25) NOT NULL,\n\t L_SHIPMODE CHAR(10) NOT NULL,\n\t L_COMMENT VARCHAR(44) NOT NULL,\n\t PRIMARY KEY (L_ORDERKEY, L_LINENUMBER)\n\t)"] [user=] [2025/11/07 12:33:47.983 +00:00] [INFO] [indexadvisor.go:51] ["fill index advisor option"] [component=index_advisor] [2025/11/07 12:33:47.985 +00:00] [INFO] [indexadvisor.go:67] ["index advisor option filled and start"] [component=index_advisor] [option="{\"MaxNumIndexes\":5,\"MaxIndexWidth\":3,\"MaxNumQuery\":1000,\"Timeout\":30000000000,\"SpecifiedSQLs\":null}"] [2025/11/07 12:33:47.985 +00:00] [INFO] [indexadvisor.go:77] ["what-if optimizer prepared"] [component=index_advisor] [2025/11/07 12:33:47.985 +00:00] [INFO] [indexadvisor.go:139] ["prepare target query set"] [component=index_advisor] [2025/11/07 12:33:48.041 +00:00] [INFO] [indexadvisor.go:176] ["finish query preparation"] [component=index_advisor] [num_query=7] [2025/11/07 12:33:48.194 +00:00] [INFO] [indexadvisor.go:92] ["indexable columns filled"] [component=index_advisor] [indexable-cols=31] [2025/11/07 12:33:48.216 +00:00] [INFO] [slots.go:220] ["initialize slot capacity"] [capacity=16] [2025/11/07 12:33:48.231 +00:00] [INFO] [scheduler_manager.go:319] ["subtask table gc loop start"] [server-id=:4000] [2025/11/07 12:33:48.231 +00:00] [INFO] [scheduler_manager.go:211] ["schedule task loop start"] [server-id=:4000] [2025/11/07 12:33:48.231 +00:00] [INFO] [scheduler_manager.go:461] ["collect loop start"] [server-id=:4000] [2025/11/07 12:33:48.231 +00:00] [INFO] [scheduler_manager.go:385] ["cleanup loop start"] [server-id=:4000] [2025/11/07 12:33:48.232 +00:00] [INFO] [runtime.go:172] ["TimerGroupRuntime loop started"] [groupID=ttl] [2025/11/07 12:33:48.232 +00:00] [INFO] [runtime.go:444] ["create watch chan if possible for timer runtime"] [groupID=ttl] [storeSupportWatch=true] [2025/11/07 12:33:48.365 +00:00] [INFO] [pd.go:434] ["adaptive update ts interval state transition"] [configuredInterval=2s] [prevAdaptiveUpdateInterval=2s] [newAdaptiveUpdateInterval=2s] [requiredStaleness=0s] [prevState=unknown(0)] [newState=normal] [2025/11/07 12:33:49.131 +00:00] [INFO] [info.go:867] [SetTiFlashGroupConfig] [2025/11/07 12:34:21.577 +00:00] [WARN] [indexadvisor.go:97] ["advise indexes failed"] [component=index_advisor] [error="index advisor timeout after 30s"] indexadvisor_tpch_test.go:773: Error Trace: pkg/planner/indexadvisor/indexadvisor_tpch_test.go:773 Error: Received unexpected error: index advisor timeout after 30s Test: TestIndexAdvisorTPCH1 [2025/11/07 12:34:21.578 +00:00] [INFO] [job_scheduler.go:279] ["scheduleLoop quit due to context canceled"] [category=ddl] [2025/11/07 12:34:21.578 +00:00] [INFO] [mock.go:100] ["owner manager retire owner"] [ownerKey=/tidb/ddl/fg/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.578 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:34:21.578 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 4, tp general"] ["take time"=48.297µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 5, tp general"] ["take time"=28.173µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 6, tp general"] ["take time"=23.835µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 7, tp general"] ["take time"=26.193µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 8, tp general"] ["take time"=24.13µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 9, tp general"] ["take time"=24.093µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 10, tp general"] ["take time"=28.122µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [job_worker.go:265] ["DDL worker closed"] [category=ddl] [worker="worker 11, tp general"] ["take time"=24.826µs] [2025/11/07 12:34:21.578 +00:00] [INFO] [ddl_workerpool.go:78] ["closing workerPool"] [category=ddl] [2025/11/07 12:34:21.578 +00:00] [INFO] [mock.go:112] ["owner manager is canceled"] [ownerKey=/tidb/ddl/fg/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.578 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl] [2025/11/07 12:34:21.578 +00:00] [INFO] [session_pool.go:98] ["closing session pool"] [category=ddl] [2025/11/07 12:34:21.581 +00:00] [INFO] [ddl.go:1145] ["DDL closed"] [category=ddl] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] ["take time"=3.180292ms] [2025/11/07 12:34:21.581 +00:00] [INFO] [ddl.go:861] ["stop DDL"] [category=ddl] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.581 +00:00] [INFO] [domain.go:473] ["stopping ttlJobManager"] [2025/11/07 12:34:21.581 +00:00] [INFO] [runtime.go:202] ["TimerGroupRuntime loop exit"] [groupID=ttl] [2025/11/07 12:34:21.581 +00:00] [INFO] [task_manager.go:225] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [ttl-worker=task-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [originalCount=4] [newCount=0] [2025/11/07 12:34:21.581 +00:00] [INFO] [scan.go:377] ["ttlScanWorker loop exited."] [2025/11/07 12:34:21.581 +00:00] [INFO] [scan.go:377] ["ttlScanWorker loop exited."] [2025/11/07 12:34:21.581 +00:00] [INFO] [scan.go:377] ["ttlScanWorker loop exited."] [2025/11/07 12:34:21.581 +00:00] [INFO] [scan.go:377] ["ttlScanWorker loop exited."] [2025/11/07 12:34:21.581 +00:00] [INFO] [task_manager.go:225] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [ttl-worker=task-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [originalCount=4] [newCount=0] [2025/11/07 12:34:21.583 +00:00] [INFO] [del.go:344] ["ttlDeleteWorker loop exited."] [2025/11/07 12:34:21.583 +00:00] [INFO] [del.go:344] ["ttlDeleteWorker loop exited."] [2025/11/07 12:34:21.583 +00:00] [INFO] [del.go:344] ["ttlDeleteWorker loop exited."] [2025/11/07 12:34:21.583 +00:00] [INFO] [del.go:344] ["ttlDeleteWorker loop exited."] [2025/11/07 12:34:21.583 +00:00] [INFO] [job_manager.go:183] ["ttlJobManager loop exited."] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.584 +00:00] [INFO] [job_manager.go:168] ["ttlJobManager loop exited."] [ttl-worker=job-manager] [ttl-worker=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.585 +00:00] [INFO] [domain.go:484] ["ttlJobManager exited."] [2025/11/07 12:34:21.585 +00:00] [INFO] [manager.go:269] ["recoverMetaLoop done"] [server-id=:4000] [2025/11/07 12:34:21.585 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.585 +00:00] [INFO] [domain.go:1209] ["stopping dist task scheduler manager because the current node is not DDL owner anymore"] [id=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.585 +00:00] [INFO] [manager.go:230] ["runaway watch sync loop exit"] [2025/11/07 12:34:21.588 +00:00] [INFO] [domain.go:1439] ["LoadSysVarCacheLoop exited."] [2025/11/07 12:34:21.588 +00:00] [INFO] [domain.go:2917] ["planCacheEvictTrigger exited."] [2025/11/07 12:34:21.588 +00:00] [INFO] [domain.go:2886] ["planCacheMetricsAndVars exited."] [2025/11/07 12:34:21.588 +00:00] [INFO] [syncer.go:379] ["topology sync loop exited."] [2025/11/07 12:34:21.588 +00:00] [INFO] [manager.go:172] ["runaway record flush loop exit"] [2025/11/07 12:34:21.588 +00:00] [INFO] [syncer.go:245] ["server info sync loop exited."] [2025/11/07 12:34:21.588 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=loadSigningCertLoop] [2025/11/07 12:34:21.588 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:2961] ["readTableCostWorker exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:380] ["topNSlowQueryLoop exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [stats_syncload.go:263] ["SubLoadWorker: exits now because the domain is closed."] [category=stats] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:2152] ["indexUsageWorker exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:1814] ["dumpFileGcChecker exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:1365] ["loadPrivilegeInLoop exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:408] ["globalConfigSyncerKeeper exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=mdlCheckLoop] [2025/11/07 12:34:21.589 +00:00] [INFO] [syncer.go:302] ["info schema sync loop exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [domain.go:956] ["closestReplicaReadCheckLoop exited."] [2025/11/07 12:34:21.589 +00:00] [INFO] [mock.go:100] ["owner manager retire owner"] [ownerKey=/tidb/stats/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.589 +00:00] [INFO] [mock.go:100] ["owner manager retire owner"] [ownerKey=/tidb/bindinfo/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.589 +00:00] [INFO] [manager.go:146] ["handle tasks loop done"] [server-id=:4000] [2025/11/07 12:34:21.589 +00:00] [INFO] [scheduler_manager.go:325] ["subtask history table gc loop exits"] [server-id=:4000] [2025/11/07 12:34:21.589 +00:00] [INFO] [scheduler_manager.go:472] ["collect loop exits"] [server-id=:4000] [2025/11/07 12:34:21.589 +00:00] [INFO] [scheduler_manager.go:391] ["cleanup loop exits"] [server-id=:4000] [2025/11/07 12:34:21.589 +00:00] [INFO] [scheduler_manager.go:217] ["schedule task loop exits"] [server-id=:4000] [2025/11/07 12:34:21.589 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=LoadSysVarCacheLoop] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=planCacheEvictTrigger] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=planCacheMetricsAndVars] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=topologySyncerKeeper] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=infoSyncerKeeper] [2025/11/07 12:34:21.590 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=readTableCostWorker] [2025/11/07 12:34:21.590 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.590 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.590 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.590 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=topNSlowQueryLoop] [2025/11/07 12:34:21.591 +00:00] [INFO] [stats_syncload.go:253] ["SubLoadWorker: exited."] [category=stats] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=indexUsageWorker] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=dumpFileGcChecker] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=loadPrivilegeInLoop] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=loadSchemaInLoop] [2025/11/07 12:34:21.591 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop] [2025/11/07 12:34:21.591 +00:00] [INFO] [mock.go:112] ["owner manager is canceled"] [ownerKey=/tidb/stats/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.591 +00:00] [INFO] [mock.go:112] ["owner manager is canceled"] [ownerKey=/tidb/bindinfo/owner] [ID=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.592 +00:00] [INFO] [domain.go:1211] ["dist task scheduler manager stopped"] [id=c28a20a1-b9e1-4656-9e30-fd8749a8868d] [2025/11/07 12:34:21.593 +00:00] [INFO] [domain.go:1194] ["stopping dist task executor manager"] [2025/11/07 12:34:21.593 +00:00] [INFO] [domain.go:1196] ["dist task executor manager stopped"] [2025/11/07 12:34:21.594 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=distTaskFrameworkLoop] [2025/11/07 12:34:21.593 +00:00] [INFO] [domain.go:1578] ["globalBindHandleWorkerLoop exited."] [2025/11/07 12:34:21.594 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=globalBindHandleWorkerLoop] [2025/11/07 12:34:21.593 +00:00] [INFO] [wait_group_wrapper.go:150] ["background process exited"] [source=domain] [process=quitStatsOwner] [2025/11/07 12:34:21.595 +00:00] [INFO] [domain.go:538] ["domain closed"] ["take time"=17.099587ms] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:567] ["Closing database"] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:592] ["Memtable flushed"] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:596] ["Compaction finished"] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:615] ["BlobManager finished"] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:619] ["ResourceManager finished"] [2025/11/07 12:34:21.596 +00:00] [INFO] [db.go:625] ["Waiting for closer"] --- FAIL: TestIndexAdvisorTPCH1 (35.27s) === NAME FAIL coverage: 10.2% of statements -- Coverage runner: Not collecting coverage for failed test. The following commands failed with status 1 /home/jenkins/.tidb/tmp/19ac355537c088f115bff442ef24604f/sandbox/linux-sandbox/32392/execroot/__main__/bazel-out/k8-fastbuild/bin/pkg/planner/indexadvisor/indexadvisor_test_/indexadvisor_test.runfiles/__main__/pkg/planner/indexadvisor/indexadvisor_test_/indexadvisor_test ================================================================================