Skip to content

Console Output

Skipping 2,105 KB.. Full Log
[2024/05/05 15:32:36.276 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=579] [conn=2097160] [category=ddl] [job="ID:579, Type:add column, State:running, SchemaState:write reorganization, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.256 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.277 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: add column, Schema ID: 105, Table ID: 577, Table Name: t1, Column ID: 2, Column Name: c"]
[2024/05/05 15:32:36.278 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=633] [neededSchemaVersion=634] ["start time"=167.668µs] [gotSchemaVersion=634] [phyTblIDs="[577]"] [actionTypes="[5]"] [diffTypes="[\"add column\"]"]
[2024/05/05 15:32:36.278 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=579] [version=634]
[2024/05/05 15:32:36.279 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=634] ["take time"=2.156657ms] [job="ID:579, Type:add column, State:done, SchemaState:public, SchemaID:105, TableID:577, RowCount:0, ArgLen:4, start time: 2024-05-05 15:32:36.256 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.282 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=579] [conn=2097160] [job="ID:579, Type:add column, State:synced, SchemaState:public, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.256 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.283 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=579]
[2024/05/05 15:32:36.283 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.285 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=634] [cur_db=client_test_db] [sql="drop table t1"] [user=root@%]
[2024/05/05 15:32:36.287 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:580, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:577, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.287 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:580, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:577, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table t1"]
[2024/05/05 15:32:36.292 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=580] [conn=2097160] [category=ddl] [job="ID:580, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.293 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=634] [neededSchemaVersion=635] ["start time"=38.173µs] [gotSchemaVersion=635] [phyTblIDs="[577]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.293 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=580] [version=635]
[2024/05/05 15:32:36.295 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=635] ["take time"=2.1359ms] [job="ID:580, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:577, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.297 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=580] [conn=2097160] [category=ddl] [job="ID:580, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.298 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=635] [neededSchemaVersion=636] ["start time"=31.49µs] [gotSchemaVersion=636] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.298 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=580] [version=636]
[2024/05/05 15:32:36.300 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=636] ["take time"=2.618249ms] [job="ID:580, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.302 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=580] [conn=2097160] [category=ddl] [job="ID:580, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:577, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.303 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 105, Old Table ID: 577, Old Table Name: t1"]
[2024/05/05 15:32:36.303 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=636] [neededSchemaVersion=637] ["start time"=26.987µs] [gotSchemaVersion=637] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.304 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=580] [version=637]
[2024/05/05 15:32:36.305 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=637] ["take time"=2.123559ms] [job="ID:580, Type:drop table, State:done, SchemaState:none, SchemaID:105, TableID:577, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.307 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=580] [tableIDs="[577]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.308 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=580] [jobType="drop table"]
[2024/05/05 15:32:36.308 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=580] [conn=2097160] [job="ID:580, Type:drop table, State:synced, SchemaState:none, SchemaID:105, TableID:577, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.286 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.309 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=580]
[2024/05/05 15:32:36.309 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.310 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=580] [elementID=1] [startKey=748000000000000241] [endKey=748000000000000242]
[2024/05/05 15:32:36.311 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:582, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.31 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.311 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:582, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.31 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1 (a INT)"]
[2024/05/05 15:32:36.315 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=582] [conn=2097160] [category=ddl] [job="ID:582, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.31 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.315 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 105, Table ID: 581, Table Name: t1"]
[2024/05/05 15:32:36.316 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=637] [neededSchemaVersion=638] ["start time"=98.353µs] [gotSchemaVersion=638] [phyTblIDs="[581]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.316 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=582] [version=638]
[2024/05/05 15:32:36.318 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=638] ["take time"=2.16314ms] [job="ID:582, Type:create table, State:done, SchemaState:public, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.31 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.320 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=582] [conn=2097160] [job="ID:582, Type:create table, State:synced, SchemaState:public, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.31 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.321 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=582]
[2024/05/05 15:32:36.321 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.321 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=446] ["first split key"=748000000000000245]
[2024/05/05 15:32:36.321 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=446] ["first at"=748000000000000245] ["first new region left"="{Id:446 StartKey:7480000000000002ff4100000000000000f8 EndKey:7480000000000002ff4500000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:447 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.321 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[446]"]
[2024/05/05 15:32:36.322 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=638] [cur_db=client_test_db] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.323 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:583, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.323 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:583, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE IF EXISTS t1"]
[2024/05/05 15:32:36.326 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=583] [conn=2097160] [category=ddl] [job="ID:583, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.327 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=638] [neededSchemaVersion=639] ["start time"=34.153µs] [gotSchemaVersion=639] [phyTblIDs="[581]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.328 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=583] [version=639]
[2024/05/05 15:32:36.329 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=639] ["take time"=2.143218ms] [job="ID:583, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:581, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.331 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=583] [conn=2097160] [category=ddl] [job="ID:583, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.332 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=639] [neededSchemaVersion=640] ["start time"=28.068µs] [gotSchemaVersion=640] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.333 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=583] [version=640]
[2024/05/05 15:32:36.334 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=640] ["take time"=2.135703ms] [job="ID:583, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.336 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=583] [conn=2097160] [category=ddl] [job="ID:583, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:581, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.337 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 105, Old Table ID: 581, Old Table Name: t1"]
[2024/05/05 15:32:36.337 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=640] [neededSchemaVersion=641] ["start time"=27.893µs] [gotSchemaVersion=641] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.338 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=583] [version=641]
[2024/05/05 15:32:36.339 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=641] ["take time"=2.273638ms] [job="ID:583, Type:drop table, State:done, SchemaState:none, SchemaID:105, TableID:581, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.341 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=583] [tableIDs="[581]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.342 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=583] [jobType="drop table"]
[2024/05/05 15:32:36.342 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=583] [conn=2097160] [job="ID:583, Type:drop table, State:synced, SchemaState:none, SchemaID:105, TableID:581, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.323 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.343 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=583]
[2024/05/05 15:32:36.343 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.343 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=641] [cur_db=client_test_db] [sql="CREATE TABLE t1(c1 DATETIME,                                           c2 DATE)"] [user=root@%]
[2024/05/05 15:32:36.344 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=583] [elementID=1] [startKey=748000000000000245] [endKey=748000000000000246]
[2024/05/05 15:32:36.345 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:585, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.344 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.345 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:585, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.344 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1(c1 DATETIME,                                           c2 DATE)"]
[2024/05/05 15:32:36.348 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=585] [conn=2097160] [category=ddl] [job="ID:585, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.344 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.349 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 105, Table ID: 584, Table Name: t1"]
[2024/05/05 15:32:36.350 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=641] [neededSchemaVersion=642] ["start time"=108.528µs] [gotSchemaVersion=642] [phyTblIDs="[584]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.350 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=585] [version=642]
[2024/05/05 15:32:36.352 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=642] ["take time"=2.164793ms] [job="ID:585, Type:create table, State:done, SchemaState:public, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.344 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.354 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=585] [conn=2097160] [job="ID:585, Type:create table, State:synced, SchemaState:public, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.344 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.355 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=585]
[2024/05/05 15:32:36.355 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.355 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=448] ["first split key"=748000000000000248]
[2024/05/05 15:32:36.355 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=448] ["first at"=748000000000000248] ["first new region left"="{Id:448 StartKey:7480000000000002ff4500000000000000f8 EndKey:7480000000000002ff4800000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:449 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.355 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[448]"]
[2024/05/05 15:32:36.357 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=642] [cur_db=client_test_db] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.358 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:586, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.358 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:586, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE IF EXISTS t1"]
[2024/05/05 15:32:36.361 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=586] [conn=2097160] [category=ddl] [job="ID:586, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.362 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=642] [neededSchemaVersion=643] ["start time"=32.001µs] [gotSchemaVersion=643] [phyTblIDs="[584]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.363 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=586] [version=643]
[2024/05/05 15:32:36.364 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=643] ["take time"=2.141491ms] [job="ID:586, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:584, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.366 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=586] [conn=2097160] [category=ddl] [job="ID:586, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.367 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=643] [neededSchemaVersion=644] ["start time"=32.731µs] [gotSchemaVersion=644] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.367 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=586] [version=644]
[2024/05/05 15:32:36.369 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=644] ["take time"=2.611615ms] [job="ID:586, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.371 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=586] [conn=2097160] [category=ddl] [job="ID:586, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:584, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.372 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 105, Old Table ID: 584, Old Table Name: t1"]
[2024/05/05 15:32:36.372 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=644] [neededSchemaVersion=645] ["start time"=27.728µs] [gotSchemaVersion=645] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.373 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=586] [version=645]
[2024/05/05 15:32:36.374 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=645] ["take time"=2.169425ms] [job="ID:586, Type:drop table, State:done, SchemaState:none, SchemaID:105, TableID:584, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.376 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=586] [tableIDs="[584]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.377 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=586] [jobType="drop table"]
[2024/05/05 15:32:36.377 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=586] [conn=2097160] [job="ID:586, Type:drop table, State:synced, SchemaState:none, SchemaID:105, TableID:584, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.358 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.378 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=586]
[2024/05/05 15:32:36.378 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.379 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=645] [cur_db=client_test_db] [sql="CREATE  TABLE t1 (a INTEGER)"] [user=root@%]
[2024/05/05 15:32:36.379 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=586] [elementID=1] [startKey=748000000000000248] [endKey=748000000000000249]
[2024/05/05 15:32:36.380 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:588, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.38 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.380 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:588, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.38 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE  TABLE t1 (a INTEGER)"]
[2024/05/05 15:32:36.384 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=588] [conn=2097160] [category=ddl] [job="ID:588, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.38 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.384 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 105, Table ID: 587, Table Name: t1"]
[2024/05/05 15:32:36.385 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=645] [neededSchemaVersion=646] ["start time"=128.499µs] [gotSchemaVersion=646] [phyTblIDs="[587]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.386 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=588] [version=646]
[2024/05/05 15:32:36.387 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=646] ["take time"=2.166991ms] [job="ID:588, Type:create table, State:done, SchemaState:public, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.38 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.389 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=588] [conn=2097160] [job="ID:588, Type:create table, State:synced, SchemaState:public, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.38 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.390 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=588]
[2024/05/05 15:32:36.390 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.390 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=450] ["first split key"=74800000000000024b]
[2024/05/05 15:32:36.390 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=450] ["first at"=74800000000000024b] ["first new region left"="{Id:450 StartKey:7480000000000002ff4800000000000000f8 EndKey:7480000000000002ff4b00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:451 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.390 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[450]"]
[2024/05/05 15:32:36.392 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=646] [cur_db=client_test_db] [sql="DROP TABLE t1"] [user=root@%]
[2024/05/05 15:32:36.393 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:589, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.393 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:589, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1"]
[2024/05/05 15:32:36.396 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=589] [conn=2097160] [category=ddl] [job="ID:589, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.397 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=646] [neededSchemaVersion=647] ["start time"=32.862µs] [gotSchemaVersion=647] [phyTblIDs="[587]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.398 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=589] [version=647]
[2024/05/05 15:32:36.399 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=647] ["take time"=2.184813ms] [job="ID:589, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:587, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.401 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=589] [conn=2097160] [category=ddl] [job="ID:589, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.402 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=647] [neededSchemaVersion=648] ["start time"=27.899µs] [gotSchemaVersion=648] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.403 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=589] [version=648]
[2024/05/05 15:32:36.404 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=648] ["take time"=2.110259ms] [job="ID:589, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.406 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=589] [conn=2097160] [category=ddl] [job="ID:589, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:587, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.407 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 105, Old Table ID: 587, Old Table Name: t1"]
[2024/05/05 15:32:36.407 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=648] [neededSchemaVersion=649] ["start time"=34.278µs] [gotSchemaVersion=649] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.408 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=589] [version=649]
[2024/05/05 15:32:36.410 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=649] ["take time"=2.430383ms] [job="ID:589, Type:drop table, State:done, SchemaState:none, SchemaID:105, TableID:587, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.412 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=589] [tableIDs="[587]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.412 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=589] [jobType="drop table"]
[2024/05/05 15:32:36.412 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=589] [conn=2097160] [job="ID:589, Type:drop table, State:synced, SchemaState:none, SchemaID:105, TableID:587, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.393 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.414 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=589]
[2024/05/05 15:32:36.414 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.414 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=589] [elementID=1] [startKey=74800000000000024b] [endKey=74800000000000024c]
[2024/05/05 15:32:36.416 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=649] [cur_db=test] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.416 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=649] [cur_db=test] [sql="CREATE TABLE t1 (a int)"] [user=root@%]
[2024/05/05 15:32:36.418 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:591, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.417 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.418 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:591, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.417 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1 (a int)"]
[2024/05/05 15:32:36.421 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=591] [conn=2097160] [category=ddl] [job="ID:591, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.417 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.421 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 590, Table Name: t1"]
[2024/05/05 15:32:36.422 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=649] [neededSchemaVersion=650] ["start time"=87.397µs] [gotSchemaVersion=650] [phyTblIDs="[590]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.422 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=591] [version=650]
[2024/05/05 15:32:36.424 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=650] ["take time"=2.211673ms] [job="ID:591, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.417 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.427 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=591] [conn=2097160] [job="ID:591, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.417 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.428 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=591]
[2024/05/05 15:32:36.428 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.428 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=452] ["first split key"=74800000000000024e]
[2024/05/05 15:32:36.428 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=452] ["first at"=74800000000000024e] ["first new region left"="{Id:452 StartKey:7480000000000002ff4b00000000000000f8 EndKey:7480000000000002ff4e00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:453 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.428 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[452]"]
[2024/05/05 15:32:36.429 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=650] [cur_db=client_test_db] [sql="CREATE TABLE t2 (a int NOT NULL PRIMARY KEY auto_increment)"] [user=root@%]
[2024/05/05 15:32:36.431 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:593, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.43 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.431 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:593, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.43 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t2 (a int NOT NULL PRIMARY KEY auto_increment)"]
[2024/05/05 15:32:36.436 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=593] [conn=2097160] [category=ddl] [job="ID:593, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.43 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.436 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 105, Table ID: 592, Table Name: t2"]
[2024/05/05 15:32:36.437 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=650] [neededSchemaVersion=651] ["start time"=92.105µs] [gotSchemaVersion=651] [phyTblIDs="[592]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.437 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=593] [version=651]
[2024/05/05 15:32:36.439 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=651] ["take time"=2.113136ms] [job="ID:593, Type:create table, State:done, SchemaState:public, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.43 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.441 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=593] [conn=2097160] [job="ID:593, Type:create table, State:synced, SchemaState:public, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.43 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.442 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=593]
[2024/05/05 15:32:36.442 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.442 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=454] ["first split key"=748000000000000250]
[2024/05/05 15:32:36.442 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=454] ["first at"=748000000000000250] ["first new region left"="{Id:454 StartKey:7480000000000002ff4e00000000000000f8 EndKey:7480000000000002ff5000000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:455 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.442 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[454]"]
[2024/05/05 15:32:36.444 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=651] [cur_db=client_test_db] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.444 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=651] [cur_db=client_test_db] [sql="DROP TABLE IF EXISTS t2"] [user=root@%]
[2024/05/05 15:32:36.445 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:594, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.445 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:594, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE IF EXISTS t2"]
[2024/05/05 15:32:36.448 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=594] [conn=2097160] [category=ddl] [job="ID:594, Type:drop table, State:queueing, SchemaState:public, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.449 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=651] [neededSchemaVersion=652] ["start time"=30.354µs] [gotSchemaVersion=652] [phyTblIDs="[592]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.450 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=594] [version=652]
[2024/05/05 15:32:36.451 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=652] ["take time"=2.164265ms] [job="ID:594, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:592, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.453 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=594] [conn=2097160] [category=ddl] [job="ID:594, Type:drop table, State:running, SchemaState:write only, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.454 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=652] [neededSchemaVersion=653] ["start time"=29.454µs] [gotSchemaVersion=653] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.455 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=594] [version=653]
[2024/05/05 15:32:36.456 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=653] ["take time"=2.208292ms] [job="ID:594, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.458 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=594] [conn=2097160] [category=ddl] [job="ID:594, Type:drop table, State:running, SchemaState:delete only, SchemaID:105, TableID:592, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.459 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 105, Old Table ID: 592, Old Table Name: t2"]
[2024/05/05 15:32:36.459 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=653] [neededSchemaVersion=654] ["start time"=36.332µs] [gotSchemaVersion=654] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.460 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=594] [version=654]
[2024/05/05 15:32:36.461 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=654] ["take time"=2.156648ms] [job="ID:594, Type:drop table, State:done, SchemaState:none, SchemaID:105, TableID:592, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.463 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=594] [tableIDs="[592]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.464 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=594] [jobType="drop table"]
[2024/05/05 15:32:36.464 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=594] [conn=2097160] [job="ID:594, Type:drop table, State:synced, SchemaState:none, SchemaID:105, TableID:592, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.445 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.465 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=594]
[2024/05/05 15:32:36.465 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.466 +00:00] [WARN] [session.go:1572] ["parse SQL failed"] [conn=2097160] [session_alias=] [error="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use near '/*+ ' at line 1"] [SQL="SELECT /*+ "]
[2024/05/05 15:32:36.466 +00:00] [INFO] [conn.go:1151] ["command dispatched failed"] [conn=2097160] [session_alias=] [connInfo="id:2097160, addr:127.0.0.1:44408 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT /*+ "] [txn_mode=PESSIMISTIC] [timestamp=449556815922855938] [err="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use near '/*+ ' at line 1"]
[2024/05/05 15:32:36.466 +00:00] [WARN] [session.go:1572] ["parse SQL failed"] [conn=2097160] [session_alias=] [error="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use near '/*+ ICP(`test' at line 1"] [SQL="SELECT /*+ ICP(`test"]
[2024/05/05 15:32:36.466 +00:00] [INFO] [conn.go:1151] ["command dispatched failed"] [conn=2097160] [session_alias=] [connInfo="id:2097160, addr:127.0.0.1:44408 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT /*+ ICP(`test"] [txn_mode=PESSIMISTIC] [timestamp=449556815922855938] [err="[parser:1064]You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use near '/*+ ICP(`test' at line 1"]
[2024/05/05 15:32:36.466 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=594] [elementID=1] [startKey=748000000000000250] [endKey=748000000000000251]
[2024/05/05 15:32:36.466 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=654] [cur_db=client_test_db] [sql="DROP TABLE IF EXISTS client_test_db.bug19894382;"] [user=root@%]
[2024/05/05 15:32:36.467 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=654] [cur_db=client_test_db] [sql="CREATE TABLE client_test_db.bug19894382(f1 CHAR(64), f2 TIME, f3 TIMESTAMP NULL, f4 DATETIME, f5 TIME(3), f6 TIMESTAMP(3) NULL, f7 DATETIME(3));"] [user=root@%]
[2024/05/05 15:32:36.468 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:596, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:595, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.467 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.468 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:596, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:595, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.467 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE client_test_db.bug19894382(f1 CHAR(64), f2 TIME, f3 TIMESTAMP NULL, f4 DATETIME, f5 TIME(3), f6 TIMESTAMP(3) NULL, f7 DATETIME(3));"]
[2024/05/05 15:32:36.472 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=596] [conn=2097160] [category=ddl] [job="ID:596, Type:create table, State:queueing, SchemaState:none, SchemaID:105, TableID:595, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.467 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.472 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 105, Table ID: 595, Table Name: bug19894382"]
[2024/05/05 15:32:36.474 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=654] [neededSchemaVersion=655] ["start time"=147.654µs] [gotSchemaVersion=655] [phyTblIDs="[595]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.474 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=596] [version=655]
[2024/05/05 15:32:36.476 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=655] ["take time"=2.128803ms] [job="ID:596, Type:create table, State:done, SchemaState:public, SchemaID:105, TableID:595, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.467 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.478 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=596] [conn=2097160] [job="ID:596, Type:create table, State:synced, SchemaState:public, SchemaID:105, TableID:595, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.467 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.479 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=596]
[2024/05/05 15:32:36.479 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.480 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=456] ["first split key"=748000000000000253]
[2024/05/05 15:32:36.480 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=456] ["first at"=748000000000000253] ["first new region left"="{Id:456 StartKey:7480000000000002ff5000000000000000f8 EndKey:7480000000000002ff5300000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:457 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.480 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[456]"]
[2024/05/05 15:32:36.482 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=655] [cur_db=test] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.483 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:597, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.483 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:597, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE IF EXISTS t1"]
[2024/05/05 15:32:36.486 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=597] [conn=2097160] [category=ddl] [job="ID:597, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.487 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=655] [neededSchemaVersion=656] ["start time"=29.888µs] [gotSchemaVersion=656] [phyTblIDs="[590]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.488 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=597] [version=656]
[2024/05/05 15:32:36.489 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=656] ["take time"=2.168928ms] [job="ID:597, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:590, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.491 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=597] [conn=2097160] [category=ddl] [job="ID:597, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.492 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=656] [neededSchemaVersion=657] ["start time"=21.407µs] [gotSchemaVersion=657] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.492 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=597] [version=657]
[2024/05/05 15:32:36.494 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=657] ["take time"=2.132112ms] [job="ID:597, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.496 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=597] [conn=2097160] [category=ddl] [job="ID:597, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:590, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.496 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 590, Old Table Name: t1"]
[2024/05/05 15:32:36.497 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=657] [neededSchemaVersion=658] ["start time"=23.484µs] [gotSchemaVersion=658] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.498 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=597] [version=658]
[2024/05/05 15:32:36.499 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=658] ["take time"=2.349445ms] [job="ID:597, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:590, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.501 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=597] [tableIDs="[590]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.502 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=597] [jobType="drop table"]
[2024/05/05 15:32:36.502 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=597] [conn=2097160] [job="ID:597, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:590, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.483 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.503 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=597]
[2024/05/05 15:32:36.503 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.503 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=658] [cur_db=test] [sql="CREATE TABLE t1 (f1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT,f2 VARCHAR(255))"] [user=root@%]
[2024/05/05 15:32:36.504 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=597] [elementID=1] [startKey=74800000000000024e] [endKey=74800000000000024f]
[2024/05/05 15:32:36.505 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:599, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.504 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.505 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:599, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.504 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1 (f1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT,f2 VARCHAR(255))"]
[2024/05/05 15:32:36.508 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=599] [conn=2097160] [category=ddl] [job="ID:599, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.504 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.508 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 598, Table Name: t1"]
[2024/05/05 15:32:36.509 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=658] [neededSchemaVersion=659] ["start time"=98.593µs] [gotSchemaVersion=659] [phyTblIDs="[598]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.510 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=599] [version=659]
[2024/05/05 15:32:36.511 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=659] ["take time"=2.101538ms] [job="ID:599, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.504 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.513 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=599] [conn=2097160] [job="ID:599, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.504 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.514 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=599]
[2024/05/05 15:32:36.514 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.514 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=458] ["first split key"=748000000000000256]
[2024/05/05 15:32:36.515 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=458] ["first at"=748000000000000256] ["first new region left"="{Id:458 StartKey:7480000000000002ff5300000000000000f8 EndKey:7480000000000002ff5600000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:459 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.515 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[458]"]
[2024/05/05 15:32:36.516 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=659] [cur_db=test] [sql="DROP TABLE IF EXISTS t2"] [user=root@%]
[2024/05/05 15:32:36.517 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=659] [cur_db=test] [sql="CREATE TABLE t2 (f1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT,f2 VARCHAR(255))"] [user=root@%]
[2024/05/05 15:32:36.518 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:601, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.517 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.518 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:601, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.517 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t2 (f1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT,f2 VARCHAR(255))"]
[2024/05/05 15:32:36.521 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=601] [conn=2097160] [category=ddl] [job="ID:601, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.517 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.521 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 600, Table Name: t2"]
[2024/05/05 15:32:36.522 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=659] [neededSchemaVersion=660] ["start time"=102.325µs] [gotSchemaVersion=660] [phyTblIDs="[600]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.523 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=601] [version=660]
[2024/05/05 15:32:36.524 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=660] ["take time"=2.14394ms] [job="ID:601, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.517 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.526 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=601] [conn=2097160] [job="ID:601, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.517 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.527 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=601]
[2024/05/05 15:32:36.527 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.527 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=460] ["first split key"=748000000000000258]
[2024/05/05 15:32:36.528 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=460] ["first at"=748000000000000258] ["first new region left"="{Id:460 StartKey:7480000000000002ff5600000000000000f8 EndKey:7480000000000002ff5800000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:461 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.528 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[460]"]
[2024/05/05 15:32:36.528 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=660] [cur_db=test] [sql="DROP TABLE t1,t2"] [user=root@%]
[2024/05/05 15:32:36.529 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:602, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.529 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:602, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1,t2"]
[2024/05/05 15:32:36.532 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=602] [conn=2097160] [category=ddl] [job="ID:602, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.533 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=660] [neededSchemaVersion=661] ["start time"=20.715µs] [gotSchemaVersion=661] [phyTblIDs="[598]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.534 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=602] [version=661]
[2024/05/05 15:32:36.535 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=661] ["take time"=2.146161ms] [job="ID:602, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:598, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.537 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=602] [conn=2097160] [category=ddl] [job="ID:602, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.538 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=661] [neededSchemaVersion=662] ["start time"=22.959µs] [gotSchemaVersion=662] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.539 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=602] [version=662]
[2024/05/05 15:32:36.540 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=662] ["take time"=2.209624ms] [job="ID:602, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.542 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=602] [conn=2097160] [category=ddl] [job="ID:602, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:598, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.543 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 598, Old Table Name: t1"]
[2024/05/05 15:32:36.543 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=662] [neededSchemaVersion=663] ["start time"=21.823µs] [gotSchemaVersion=663] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.544 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=602] [version=663]
[2024/05/05 15:32:36.545 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=663] ["take time"=2.1377ms] [job="ID:602, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:598, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.547 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=602] [tableIDs="[598]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.548 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=602] [jobType="drop table"]
[2024/05/05 15:32:36.548 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=602] [conn=2097160] [job="ID:602, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:598, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.529 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.550 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=602]
[2024/05/05 15:32:36.550 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.550 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=602] [elementID=1] [startKey=748000000000000256] [endKey=748000000000000257]
[2024/05/05 15:32:36.551 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:603, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.551 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:603, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1,t2"]
[2024/05/05 15:32:36.555 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=603] [conn=2097160] [category=ddl] [job="ID:603, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.556 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=663] [neededSchemaVersion=664] ["start time"=28.535µs] [gotSchemaVersion=664] [phyTblIDs="[600]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.557 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=603] [version=664]
[2024/05/05 15:32:36.558 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=664] ["take time"=2.16416ms] [job="ID:603, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:600, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.560 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=603] [conn=2097160] [category=ddl] [job="ID:603, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.561 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=664] [neededSchemaVersion=665] ["start time"=20.62µs] [gotSchemaVersion=665] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.561 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=603] [version=665]
[2024/05/05 15:32:36.563 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=665] ["take time"=2.176996ms] [job="ID:603, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.565 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=603] [conn=2097160] [category=ddl] [job="ID:603, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:600, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.565 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 600, Old Table Name: t2"]
[2024/05/05 15:32:36.566 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=665] [neededSchemaVersion=666] ["start time"=22.406µs] [gotSchemaVersion=666] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.566 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=603] [version=666]
[2024/05/05 15:32:36.568 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=666] ["take time"=2.136523ms] [job="ID:603, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:600, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.570 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=603] [tableIDs="[600]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.570 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=603] [jobType="drop table"]
[2024/05/05 15:32:36.570 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=603] [conn=2097160] [job="ID:603, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:600, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.55 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.572 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=603]
[2024/05/05 15:32:36.572 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.572 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=603] [elementID=1] [startKey=748000000000000258] [endKey=748000000000000259]
[2024/05/05 15:32:36.572 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=666] [cur_db=test] [sql="DROP TABLE IF EXISTS t1"] [user=root@%]
[2024/05/05 15:32:36.572 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=666] [cur_db=test] [sql="CREATE TABLE t1( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,serial CHAR(10) NOT NULL,pretty CHAR(20) DEFAULT NULL,CONSTRAINT UNIQUE KEY unique_serial (serial) USING HASH,INDEX pretty_index USING HASH (pretty)) ENGINE = InnoDB CHARSET = utf8mb3 COLLATE = utf8mb3_bin"] [user=root@%]
[2024/05/05 15:32:36.574 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:605, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.573 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.574 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:605, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.573 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,serial CHAR(10) NOT NULL,pretty CHAR(20) DEFAULT NULL,CONSTRAINT UNIQUE KEY unique_serial (serial) USING HASH,INDEX pretty_index USING HASH (pretty)) ENGINE = InnoDB CHARSET = utf8mb3 COLLATE = utf8mb3_bin"]
[2024/05/05 15:32:36.577 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=605] [conn=2097160] [category=ddl] [job="ID:605, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.573 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.577 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 604, Table Name: t1"]
[2024/05/05 15:32:36.578 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=666] [neededSchemaVersion=667] ["start time"=147.475µs] [gotSchemaVersion=667] [phyTblIDs="[604]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.579 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=605] [version=667]
[2024/05/05 15:32:36.580 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=667] ["take time"=2.178197ms] [job="ID:605, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.573 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.583 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=605] [conn=2097160] [job="ID:605, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.573 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.584 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=605]
[2024/05/05 15:32:36.584 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.584 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=462] ["first split key"=74800000000000025c]
[2024/05/05 15:32:36.585 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=462] ["first at"=74800000000000025c] ["first new region left"="{Id:462 StartKey:7480000000000002ff5800000000000000f8 EndKey:7480000000000002ff5c00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:463 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.585 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[462]"]
[2024/05/05 15:32:36.586 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=667] [cur_db=test] [sql="DROP TABLE t1"] [user=root@%]
[2024/05/05 15:32:36.587 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:606, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.587 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:606, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1"]
[2024/05/05 15:32:36.590 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=606] [conn=2097160] [category=ddl] [job="ID:606, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.591 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=667] [neededSchemaVersion=668] ["start time"=20.466µs] [gotSchemaVersion=668] [phyTblIDs="[604]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.592 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=606] [version=668]
[2024/05/05 15:32:36.593 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=668] ["take time"=2.197935ms] [job="ID:606, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:604, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.595 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=606] [conn=2097160] [category=ddl] [job="ID:606, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.596 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=668] [neededSchemaVersion=669] ["start time"=21.433µs] [gotSchemaVersion=669] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.597 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=606] [version=669]
[2024/05/05 15:32:36.598 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=669] ["take time"=2.383983ms] [job="ID:606, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.600 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=606] [conn=2097160] [category=ddl] [job="ID:606, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:604, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.601 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 604, Old Table Name: t1"]
[2024/05/05 15:32:36.601 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=669] [neededSchemaVersion=670] ["start time"=22.792µs] [gotSchemaVersion=670] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.602 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=606] [version=670]
[2024/05/05 15:32:36.603 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=670] ["take time"=2.089939ms] [job="ID:606, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:604, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.606 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=606] [tableIDs="[604]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.606 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=606] [jobType="drop table"]
[2024/05/05 15:32:36.607 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=606] [conn=2097160] [job="ID:606, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:604, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.586 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.608 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=606]
[2024/05/05 15:32:36.608 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.608 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=670] [cur_db=test] [sql="CREATE TABLE t1(i8 BIGINT, i8u BIGINT UNSIGNED)"] [user=root@%]
[2024/05/05 15:32:36.609 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=606] [elementID=1] [startKey=74800000000000025c] [endKey=74800000000000025d]
[2024/05/05 15:32:36.610 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:608, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.609 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.610 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:608, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.609 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1(i8 BIGINT, i8u BIGINT UNSIGNED)"]
[2024/05/05 15:32:36.613 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=608] [conn=2097160] [category=ddl] [job="ID:608, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.609 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.614 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 607, Table Name: t1"]
[2024/05/05 15:32:36.615 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=670] [neededSchemaVersion=671] ["start time"=90.522µs] [gotSchemaVersion=671] [phyTblIDs="[607]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.615 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=608] [version=671]
[2024/05/05 15:32:36.617 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=671] ["take time"=2.80245ms] [job="ID:608, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.609 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.619 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=608] [conn=2097160] [job="ID:608, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.609 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.621 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=608]
[2024/05/05 15:32:36.621 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.621 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=464] ["first split key"=74800000000000025f]
[2024/05/05 15:32:36.621 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=464] ["first at"=74800000000000025f] ["first new region left"="{Id:464 StartKey:7480000000000002ff5c00000000000000f8 EndKey:7480000000000002ff5f00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:465 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.621 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[464]"]
[2024/05/05 15:32:36.624 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=671] [cur_db=test] [sql="DROP TABLE t1"] [user=root@%]
[2024/05/05 15:32:36.626 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:609, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.626 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:609, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1"]
[2024/05/05 15:32:36.628 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=609] [conn=2097160] [category=ddl] [job="ID:609, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.629 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=671] [neededSchemaVersion=672] ["start time"=20.824µs] [gotSchemaVersion=672] [phyTblIDs="[607]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.630 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=672]
[2024/05/05 15:32:36.631 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=672] ["take time"=2.105021ms] [job="ID:609, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:607, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.633 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=609] [conn=2097160] [category=ddl] [job="ID:609, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.634 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=672] [neededSchemaVersion=673] ["start time"=21.65µs] [gotSchemaVersion=673] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.635 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=673]
[2024/05/05 15:32:36.636 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=673] ["take time"=2.228507ms] [job="ID:609, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.638 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=609] [conn=2097160] [category=ddl] [job="ID:609, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:607, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.639 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 607, Old Table Name: t1"]
[2024/05/05 15:32:36.639 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=673] [neededSchemaVersion=674] ["start time"=22.965µs] [gotSchemaVersion=674] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.640 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=674]
[2024/05/05 15:32:36.641 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=674] ["take time"=2.098328ms] [job="ID:609, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:607, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.643 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=609] [tableIDs="[607]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.644 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=609] [jobType="drop table"]
[2024/05/05 15:32:36.644 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=609] [conn=2097160] [job="ID:609, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:607, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.625 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.645 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=609]
[2024/05/05 15:32:36.645 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.646 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=609] [elementID=1] [startKey=74800000000000025f] [endKey=748000000000000260]
[2024/05/05 15:32:36.700 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=674] [cur_db=test] [sql="CREATE TABLE t1(a INTEGER)"] [user=root@%]
[2024/05/05 15:32:36.702 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:611, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.701 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.702 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:611, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.701 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t1(a INTEGER)"]
[2024/05/05 15:32:36.706 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=611] [conn=2097160] [category=ddl] [job="ID:611, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.701 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.707 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 610, Table Name: t1"]
[2024/05/05 15:32:36.708 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=674] [neededSchemaVersion=675] ["start time"=167.476µs] [gotSchemaVersion=675] [phyTblIDs="[610]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.710 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=611] [version=675]
[2024/05/05 15:32:36.710 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=675] ["take time"=2.188931ms] [job="ID:611, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.701 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.714 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=611] [conn=2097160] [job="ID:611, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.701 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.716 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=611]
[2024/05/05 15:32:36.716 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.716 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=466] ["first split key"=748000000000000262]
[2024/05/05 15:32:36.716 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=466] ["first at"=748000000000000262] ["first new region left"="{Id:466 StartKey:7480000000000002ff5f00000000000000f8 EndKey:7480000000000002ff6200000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:467 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.716 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[466]"]
[2024/05/05 15:32:36.716 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=675] [cur_db=test] [sql="CREATE TABLE t2(a INTEGER, b INTEGER)"] [user=root@%]
[2024/05/05 15:32:36.717 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:613, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.717 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.717 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:613, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.717 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE t2(a INTEGER, b INTEGER)"]
[2024/05/05 15:32:36.722 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=613] [conn=2097160] [category=ddl] [job="ID:613, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.717 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.723 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 612, Table Name: t2"]
[2024/05/05 15:32:36.724 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=675] [neededSchemaVersion=676] ["start time"=87.762µs] [gotSchemaVersion=676] [phyTblIDs="[612]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.725 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=613] [version=676]
[2024/05/05 15:32:36.726 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=676] ["take time"=2.137174ms] [job="ID:613, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.717 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.728 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=613] [conn=2097160] [job="ID:613, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.717 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.729 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=613]
[2024/05/05 15:32:36.729 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.729 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=466] ["first split key"=748000000000000264]
[2024/05/05 15:32:36.732 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=468] ["first at"=748000000000000264] ["first new region left"="{Id:468 StartKey:7480000000000002ff6200000000000000f8 EndKey:7480000000000002ff6400000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:469 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.732 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[468]"]
[2024/05/05 15:32:36.737 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=676] [cur_db=test] [sql="DROP TABLE t1, t2"] [user=root@%]
[2024/05/05 15:32:36.738 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:614, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.738 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:614, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1, t2"]
[2024/05/05 15:32:36.741 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=614] [conn=2097160] [category=ddl] [job="ID:614, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.742 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=676] [neededSchemaVersion=677] ["start time"=23.265µs] [gotSchemaVersion=677] [phyTblIDs="[610]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.742 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=614] [version=677]
[2024/05/05 15:32:36.744 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=677] ["take time"=2.140547ms] [job="ID:614, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:610, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.746 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=614] [conn=2097160] [category=ddl] [job="ID:614, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.746 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=677] [neededSchemaVersion=678] ["start time"=21.043µs] [gotSchemaVersion=678] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.747 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=614] [version=678]
[2024/05/05 15:32:36.749 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=678] ["take time"=2.600881ms] [job="ID:614, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.751 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=614] [conn=2097160] [category=ddl] [job="ID:614, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:610, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.751 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 610, Old Table Name: t1"]
[2024/05/05 15:32:36.752 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=678] [neededSchemaVersion=679] ["start time"=20.457µs] [gotSchemaVersion=679] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.753 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=614] [version=679]
[2024/05/05 15:32:36.754 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=679] ["take time"=2.17517ms] [job="ID:614, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:610, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.756 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=614] [tableIDs="[610]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.756 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=614] [jobType="drop table"]
[2024/05/05 15:32:36.757 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=614] [conn=2097160] [job="ID:614, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:610, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.737 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.758 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=614]
[2024/05/05 15:32:36.758 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.758 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=614] [elementID=1] [startKey=748000000000000262] [endKey=748000000000000263]
[2024/05/05 15:32:36.759 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:615, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.759 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:615, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE t1, t2"]
[2024/05/05 15:32:36.763 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=615] [conn=2097160] [category=ddl] [job="ID:615, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.764 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=679] [neededSchemaVersion=680] ["start time"=25.207µs] [gotSchemaVersion=680] [phyTblIDs="[612]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.764 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=615] [version=680]
[2024/05/05 15:32:36.766 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=680] ["take time"=2.275081ms] [job="ID:615, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.768 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=615] [conn=2097160] [category=ddl] [job="ID:615, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.769 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=680] [neededSchemaVersion=681] ["start time"=18.372µs] [gotSchemaVersion=681] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.770 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=615] [version=681]
[2024/05/05 15:32:36.771 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=681] ["take time"=2.169112ms] [job="ID:615, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.773 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=615] [conn=2097160] [category=ddl] [job="ID:615, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.773 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 612, Old Table Name: t2"]
[2024/05/05 15:32:36.774 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=681] [neededSchemaVersion=682] ["start time"=30.715µs] [gotSchemaVersion=682] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.775 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=615] [version=682]
[2024/05/05 15:32:36.776 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=682] ["take time"=2.175323ms] [job="ID:615, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:612, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.778 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=615] [tableIDs="[612]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.778 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=615] [jobType="drop table"]
[2024/05/05 15:32:36.779 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=615] [conn=2097160] [job="ID:615, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:612, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.780 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=615]
[2024/05/05 15:32:36.780 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.781 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=615] [elementID=1] [startKey=748000000000000264] [endKey=748000000000000265]
[2024/05/05 15:32:36.787 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=682] [cur_db=test] [sql="DROP TABLE IF EXISTS test_tab"] [user=root@%]
[2024/05/05 15:32:36.787 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=682] [cur_db=test] [sql="CREATE TABLE test_tab(col1 MEDIUMBLOB NOT NULL,col2 TINYINT DEFAULT NULL) Engine=InnoDB;"] [user=root@%]
[2024/05/05 15:32:36.788 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:617, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.788 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.788 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:617, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.788 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE TABLE test_tab(col1 MEDIUMBLOB NOT NULL,col2 TINYINT DEFAULT NULL) Engine=InnoDB;"]
[2024/05/05 15:32:36.791 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=617] [conn=2097160] [category=ddl] [job="ID:617, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.788 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.791 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 616, Table Name: test_tab"]
[2024/05/05 15:32:36.792 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=682] [neededSchemaVersion=683] ["start time"=105.481µs] [gotSchemaVersion=683] [phyTblIDs="[616]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.793 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=617] [version=683]
[2024/05/05 15:32:36.794 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=683] ["take time"=2.138632ms] [job="ID:617, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.788 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.796 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=617] [conn=2097160] [job="ID:617, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.788 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.798 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=617]
[2024/05/05 15:32:36.798 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.798 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=470] ["first split key"=748000000000000268]
[2024/05/05 15:32:36.798 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=470] ["first at"=748000000000000268] ["first new region left"="{Id:470 StartKey:7480000000000002ff6400000000000000f8 EndKey:7480000000000002ff6800000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:471 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.798 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[470]"]
[2024/05/05 15:32:36.799 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=683] [cur_db=test] [sql="DROP TABLE test_tab"] [user=root@%]
[2024/05/05 15:32:36.800 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:618, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.801 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:618, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP TABLE test_tab"]
[2024/05/05 15:32:36.803 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=618] [conn=2097160] [category=ddl] [job="ID:618, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.804 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=683] [neededSchemaVersion=684] ["start time"=20.687µs] [gotSchemaVersion=684] [phyTblIDs="[616]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.805 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=618] [version=684]
[2024/05/05 15:32:36.806 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=684] ["take time"=2.181564ms] [job="ID:618, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:616, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.808 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=618] [conn=2097160] [category=ddl] [job="ID:618, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.809 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=684] [neededSchemaVersion=685] ["start time"=18.815µs] [gotSchemaVersion=685] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.810 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=618] [version=685]
[2024/05/05 15:32:36.811 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=685] ["take time"=2.140148ms] [job="ID:618, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.813 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=618] [conn=2097160] [category=ddl] [job="ID:618, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:616, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.814 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 616, Old Table Name: test_tab"]
[2024/05/05 15:32:36.814 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=685] [neededSchemaVersion=686] ["start time"=27.095µs] [gotSchemaVersion=686] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.815 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=618] [version=686]
[2024/05/05 15:32:36.817 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=686] ["take time"=2.139193ms] [job="ID:618, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:616, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.819 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=618] [tableIDs="[616]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.819 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=618] [jobType="drop table"]
[2024/05/05 15:32:36.819 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=618] [conn=2097160] [job="ID:618, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:616, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.8 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.820 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=618]
[2024/05/05 15:32:36.820 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.821 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=686] [cur_db=test] [sql="create table t1 (id int primary key)"] [user=root@%]
[2024/05/05 15:32:36.821 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=618] [elementID=1] [startKey=748000000000000268] [endKey=748000000000000269]
[2024/05/05 15:32:36.822 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:620, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.822 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.822 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:620, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.822 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table t1 (id int primary key)"]
[2024/05/05 15:32:36.825 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=620] [conn=2097160] [category=ddl] [job="ID:620, Type:create table, State:queueing, SchemaState:none, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.822 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.826 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 107, Table ID: 619, Table Name: t1"]
[2024/05/05 15:32:36.826 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=686] [neededSchemaVersion=687] ["start time"=81.218µs] [gotSchemaVersion=687] [phyTblIDs="[619]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/05 15:32:36.827 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=620] [version=687]
[2024/05/05 15:32:36.828 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=687] ["take time"=2.144308ms] [job="ID:620, Type:create table, State:done, SchemaState:public, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.822 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.831 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=620] [conn=2097160] [job="ID:620, Type:create table, State:synced, SchemaState:public, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.822 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.832 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=620]
[2024/05/05 15:32:36.832 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.832 +00:00] [INFO] [split_region.go:85] ["split batch regions request"] ["split key count"=1] ["batch count"=1] ["first batch, region ID"=472] ["first split key"=74800000000000026b]
[2024/05/05 15:32:36.832 +00:00] [INFO] [split_region.go:187] ["batch split regions complete"] ["batch region ID"=472] ["first at"=74800000000000026b] ["first new region left"="{Id:472 StartKey:7480000000000002ff6800000000000000f8 EndKey:7480000000000002ff6b00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:473 store_id:1 ] EncryptionMeta:<nil> IsInFlashback:false FlashbackStartTs:0}"] ["new region count"=1]
[2024/05/05 15:32:36.832 +00:00] [INFO] [split_region.go:236] ["split regions complete"] ["region count"=1] ["region IDs"="[472]"]
[2024/05/05 15:32:36.834 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=687] [cur_db=test] [sql="drop table t1"] [user=root@%]
[2024/05/05 15:32:36.835 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:621, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.835 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:621, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="drop table t1"]
[2024/05/05 15:32:36.838 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=621] [conn=2097160] [category=ddl] [job="ID:621, Type:drop table, State:queueing, SchemaState:public, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.839 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=687] [neededSchemaVersion=688] ["start time"=21.555µs] [gotSchemaVersion=688] [phyTblIDs="[619]"] [actionTypes="[4]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.840 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=621] [version=688]
[2024/05/05 15:32:36.841 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=688] ["take time"=2.139761ms] [job="ID:621, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:619, RowCount:0, ArgLen:2, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.843 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=621] [conn=2097160] [category=ddl] [job="ID:621, Type:drop table, State:running, SchemaState:write only, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.844 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=688] [neededSchemaVersion=689] ["start time"=23.389µs] [gotSchemaVersion=689] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.845 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=621] [version=689]
[2024/05/05 15:32:36.846 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=689] ["take time"=2.277791ms] [job="ID:621, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.848 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=621] [conn=2097160] [category=ddl] [job="ID:621, Type:drop table, State:running, SchemaState:delete only, SchemaID:107, TableID:619, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.849 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: drop table, Schema ID: 107, Old Table ID: 619, Old Table Name: t1"]
[2024/05/05 15:32:36.849 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=689] [neededSchemaVersion=690] ["start time"=22.29µs] [gotSchemaVersion=690] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop table\"]"]
[2024/05/05 15:32:36.850 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=621] [version=690]
[2024/05/05 15:32:36.851 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=690] ["take time"=2.080594ms] [job="ID:621, Type:drop table, State:done, SchemaState:none, SchemaID:107, TableID:619, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.853 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=621] [tableIDs="[619]"] [comment="drop table: table ID"]
[2024/05/05 15:32:36.853 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=621] [jobType="drop table"]
[2024/05/05 15:32:36.854 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=621] [conn=2097160] [job="ID:621, Type:drop table, State:synced, SchemaState:none, SchemaID:107, TableID:619, RowCount:0, ArgLen:3, start time: 2024-05-05 15:32:36.835 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.855 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=621]
[2024/05/05 15:32:36.855 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.855 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2097160] [schemaVersion=690] [cur_db=test] [sql="DROP DATABASE IF EXISTS client_test_db"] [user=root@%]
[2024/05/05 15:32:36.856 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=621] [elementID=1] [startKey=74800000000000026b] [endKey=74800000000000026c]
[2024/05/05 15:32:36.856 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:622, Type:drop schema, State:queueing, SchemaState:public, SchemaID:105, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/05 15:32:36.856 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:622, Type:drop schema, State:queueing, SchemaState:public, SchemaID:105, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP DATABASE IF EXISTS client_test_db"]
[2024/05/05 15:32:36.860 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=622] [conn=2097160] [category=ddl] [job="ID:622, Type:drop schema, State:queueing, SchemaState:public, SchemaID:105, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.873 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=690] [neededSchemaVersion=691] ["start time"=313.899µs] [gotSchemaVersion=691] [phyTblIDs="[124,126,148,171,176,178,181,183,191,193,195,197,199,201,203,205,213,215,217,219,221,232,234,236,238,240,249,251,253,255,257,259,274,282,284,290,292,300,458,595]"] [actionTypes="[2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]"] [diffTypes="[\"drop schema\"]"]
[2024/05/05 15:32:36.873 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=622] [version=691]
[2024/05/05 15:32:36.874 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=691] ["take time"=2.161388ms] [job="ID:622, Type:drop schema, State:running, SchemaState:write only, SchemaID:105, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.876 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=622] [conn=2097160] [category=ddl] [job="ID:622, Type:drop schema, State:running, SchemaState:write only, SchemaID:105, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.877 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=691] [neededSchemaVersion=692] ["start time"=22.151µs] [gotSchemaVersion=692] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/05 15:32:36.878 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=622] [version=692]
[2024/05/05 15:32:36.879 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=692] ["take time"=2.230321ms] [job="ID:622, Type:drop schema, State:running, SchemaState:delete only, SchemaID:105, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.882 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=622] [conn=2097160] [category=ddl] [job="ID:622, Type:drop schema, State:running, SchemaState:delete only, SchemaID:105, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.895 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=692] [neededSchemaVersion=693] ["start time"=20.651µs] [gotSchemaVersion=693] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/05 15:32:36.895 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=622] [version=693]
[2024/05/05 15:32:36.897 +00:00] [INFO] [schema_version.go:379] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=693] ["take time"=2.114258ms] [job="ID:622, Type:drop schema, State:done, SchemaState:none, SchemaID:105, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.899 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=622] [tableIDs="[124,126,148,171,176,178,181,183,191,193,195,197,199,201,203,205,213,215,217,219,221,232,234,236,238,240,249,251,253,255,257,259,274,282,284,290,292,300,458,595]"] [comment="drop schema: table IDs"]
[2024/05/05 15:32:36.901 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=622] [jobType="drop schema"]
[2024/05/05 15:32:36.901 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 4, tp general"] [category=ddl] [jobID=622] [conn=2097160] [job="ID:622, Type:drop schema, State:synced, SchemaState:none, SchemaID:105, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-05 15:32:36.856 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/05 15:32:36.902 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=622]
[2024/05/05 15:32:36.902 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/05 15:32:36.903 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=1] [startKey=74800000000000007c] [endKey=74800000000000007d]
[2024/05/05 15:32:36.905 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=2] [startKey=74800000000000007e] [endKey=74800000000000007f]
[2024/05/05 15:32:36.906 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=3] [startKey=748000000000000094] [endKey=748000000000000095]
[2024/05/05 15:32:36.907 +00:00] [INFO] [signal_posix.go:54] ["got signal to exit"] [signal=terminated]
[2024/05/05 15:32:36.907 +00:00] [INFO] [server.go:584] ["setting tidb-server to report unhealthy (shutting-down)"]
[2024/05/05 15:32:36.907 +00:00] [ERROR] [http_status.go:531] ["start status/rpc server error"] [error="accept tcp [::]:10080: use of closed network connection"]
[2024/05/05 15:32:36.908 +00:00] [ERROR] [http_status.go:521] ["grpc server error"] [error="mux: server closed"]
[2024/05/05 15:32:36.908 +00:00] [ERROR] [http_status.go:526] ["http server error"] [error="http: Server closed"]
[2024/05/05 15:32:36.908 +00:00] [INFO] [server.go:978] ["start drain clients"]
[2024/05/05 15:32:36.908 +00:00] [INFO] [server.go:1007] ["all sessions quit in drain wait time"]
[2024/05/05 15:32:36.908 +00:00] [INFO] [server.go:959] ["kill all connections."] [category=server]
[2024/05/05 15:32:36.908 +00:00] [INFO] [mock.go:106] ["owner manager is canceled"] [category=ddl] [ID=05ea5e3f-1566-4b6d-b967-7a5e24a01917] [ownerKey=/tidb/ddl/fg/owner]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 5, tp add index"] [category=ddl] ["take time"=1.007µs]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 6, tp add index"] [category=ddl] ["take time"=1.174µs]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 4, tp general"] [category=ddl] ["take time"=558ns]
[2024/05/05 15:32:36.908 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/05 15:32:36.908 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl]
[2024/05/05 15:32:36.908 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=4] [startKey=7480000000000000ab] [endKey=7480000000000000ac]
[2024/05/05 15:32:36.909 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=5] [startKey=7480000000000000b0] [endKey=7480000000000000b1]
[2024/05/05 15:32:36.910 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=6] [startKey=7480000000000000b2] [endKey=7480000000000000b3]
[2024/05/05 15:32:36.912 +00:00] [INFO] [delete_range.go:259] ["delRange emulator complete task"] [category=ddl] [category=ddl] [jobID=622] [elementID=7] [startKey=7480000000000000b5] [endKey=7480000000000000b6]
+ echo ============= tidb log end   ==================
============= tidb log end   ==================
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
Finished: SUCCESS