Skip to content

Console Output

Skipping 15,616 KB.. Full Log
[2024/05/06 09:36:48.585 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:48.585 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=3] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=3] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:48.585 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:48.585 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:36:48.588 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 09:36:48.588 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:48.588 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:48.588 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=3] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:48.588 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:48.588 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=30077] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=1, Mem=630.2MiB]"] [takeTime=775.641757ms] []
[2024/05/06 09:36:48.599 +00:00] [INFO] [scheduler.go:291] ["move to post-process step "] [type=ImportInto] [task-id=30077] [curr-step=import] [next-step=post-process] [result="{\"LoadedRowCnt\":4,\"ColSizeMap\":{\"1\":4}}"]
[2024/05/06 09:36:48.601 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=30077] [curr-step=import] [next-step=post-process] [subtask-count=1]
[2024/05/06 09:36:48.601 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=30077] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=running] [step=post-process] [concurrency=1] [subtasks=1]
[2024/05/06 09:36:48.755 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=30077] [task-type=ImportInto] [server-id=:4000] [step=post-process] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=1, Mem=630.2MiB]"]
[2024/05/06 09:36:48.804 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149]
[2024/05/06 09:36:48.804 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149]
[2024/05/06 09:36:48.804 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149]
[2024/05/06 09:36:48.804 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [takeTime=9.944µs] []
[2024/05/06 09:36:48.804 +00:00] [INFO] [subtask_executor.go:133] ["kv group checksum"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [groupId=-1] [size=100] [kvs=4] [checksum=10068981574061626288]
[2024/05/06 09:36:48.804 +00:00] [INFO] [table_import.go:835] ["local checksum"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [checksum="{cksum=10068981574061626288,size=100,kvs=4}"]
[2024/05/06 09:36:48.804 +00:00] [INFO] [table_import.go:950] ["set backoff weight"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [weight=30]
[2024/05/06 09:36:48.804 +00:00] [INFO] [table_import.go:901] ["checksum with adjusted distsql scan concurrency"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [concurrency=15]
[2024/05/06 09:36:48.809 +00:00] [INFO] [checksum.go:79] ["got one checksum result"] [tableID=607] [physicalTableID=607] [indexID=-1] [checksum=10068981574061626288] [totalKvs=4] [totalBytes=100]
[2024/05/06 09:36:48.810 +00:00] [INFO] [table_import.go:861] ["checksum pass"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [local="{cksum=10068981574061626288,size=100,kvs=4}"]
[2024/05/06 09:36:48.810 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [takeTime=5.783723ms] []
[2024/05/06 09:36:48.810 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=30077] [step=post-process] [subtask-id=30149] [takeTime=5.966592ms] []
[2024/05/06 09:36:48.855 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=30077] [task-type=ImportInto] [server-id=:4000] [step=post-process] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=1, Mem=630.2MiB]"] [takeTime=99.921197ms] []
[2024/05/06 09:36:48.867 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=30077] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=post-process] [next-step=done]
[2024/05/06 09:36:48.867 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=30077] [step=post-process] [state=running] []
[2024/05/06 09:36:48.869 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=30077]
[2024/05/06 09:36:48.987 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=30077]
[2024/05/06 09:36:49.013 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:36:49.013 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=30077]
[2024/05/06 09:36:49.018 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=30077] [type=ImportInto]
[2024/05/06 09:36:49.090 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:36:49.166 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: test_show_job2[test_show_job2] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 2.247932602\n# Parse_time: 0.001041962\n# Compile_time: 0.002021347\n# Rewrite_time: 0.000335473\n# Optimize_time: 0.000172793\n# Wait_TS: 0\n# DB: test_show_job\n# Is_internal: false\n# Digest: 586c4129dde8bf07f2eb957d1c11bacb4d785c5ef8a5f7344704851e24d20537\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 1\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Plan: tidb_decode_plan('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6Mi4yNHMsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6Mi4yNHMsIGxvb3BzOjJw//8NAjQBeP///////////wEYAQ==')\n# Resource_group: default\nIMPORT INTO `test_show_job`.`t3` FROM 'gs://test-show-job/t*.csv?access-key=xxxxxx&endpoint=http%3A%2F%2F127.0.0.1%3A4443%2Fstorage%2Fv1%2F&secret-access-key=xxxxxx' WITH thread=1, __max_engine_size=_UTF8MB4'1';"]
=== RUN   TestImportInto/TestZeroDateTime
[2024/05/06 09:36:49.177 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=481] [cur_db=test_show_job] [sql="DROP DATABASE IF EXISTS import_into;"] [user=root@%]
[2024/05/06 09:36:49.204 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:609, Type:drop schema, State:queueing, SchemaState:public, SchemaID:464, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:36:49.204 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:609, Type:drop schema, State:queueing, SchemaState:public, SchemaID:464, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP DATABASE IF EXISTS import_into;"]
[2024/05/06 09:36:49.241 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=609] [conn=2] [category=ddl] [job="ID:609, Type:drop schema, State:queueing, SchemaState:public, SchemaID:464, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.272 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=481] [neededSchemaVersion=482] ["start time"=327.608µs] [gotSchemaVersion=482] [phyTblIDs="[470]"] [actionTypes="[2]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:36:49.285 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=482]
[2024/05/06 09:36:49.321 +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=482] ["take time"=53.556053ms] [job="ID:609, Type:drop schema, State:running, SchemaState:write only, SchemaID:464, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.419 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=609] [conn=2] [category=ddl] [job="ID:609, Type:drop schema, State:running, SchemaState:write only, SchemaID:464, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.452 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=482] [neededSchemaVersion=483] ["start time"=221.575µs] [gotSchemaVersion=483] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:36:49.465 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=483]
[2024/05/06 09:36:49.502 +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=483] ["take time"=54.111567ms] [job="ID:609, Type:drop schema, State:running, SchemaState:delete only, SchemaID:464, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.582 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=609] [conn=2] [category=ddl] [job="ID:609, Type:drop schema, State:running, SchemaState:delete only, SchemaID:464, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.632 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=483] [neededSchemaVersion=484] ["start time"=240.096µs] [gotSchemaVersion=484] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:36:49.644 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=609] [version=484]
[2024/05/06 09:36:49.680 +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=484] ["take time"=52.476967ms] [job="ID:609, Type:drop schema, State:done, SchemaState:none, SchemaID:464, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.714 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=609] [tableIDs="[470]"] [comment="drop schema: table IDs"]
[2024/05/06 09:36:49.723 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=609] [jobType="drop schema"]
[2024/05/06 09:36:49.727 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=609] [conn=2] [job="ID:609, Type:drop schema, State:synced, SchemaState:none, SchemaID:464, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.158 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.775 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=609]
[2024/05/06 09:36:49.775 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:36:49.778 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.601928702\n# Parse_time: 0.000443193\n# Compile_time: 0.000638344\n# Rewrite_time: 0.000046267\n# Optimize_time: 0.001415159\n# Wait_TS: 0.000392588\n# DB: test_show_job\n# Is_internal: false\n# Digest: 2bf6205fd312b0e6558e6060b915b47a10f35edac12a547b88c81cc4b6f4279f\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 0\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Resource_group: default\nDROP DATABASE IF EXISTS import_into;"]
[2024/05/06 09:36:49.780 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=484] [cur_db=test_show_job] [sql="CREATE DATABASE import_into;"] [user=root@%]
[2024/05/06 09:36:49.813 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:611, Type:create schema, State:queueing, SchemaState:none, SchemaID:610, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:36:49.813 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:611, Type:create schema, State:queueing, SchemaState:none, SchemaID:610, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE DATABASE import_into;"]
[2024/05/06 09:36:49.935 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=611] [conn=2] [category=ddl] [job="ID:611, Type:create schema, State:queueing, SchemaState:none, SchemaID:610, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:49.974 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=484] [neededSchemaVersion=485] ["start time"=961.134µs] [gotSchemaVersion=485] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/06 09:36:49.986 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=611] [version=485]
[2024/05/06 09:36:50.022 +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=485] ["take time"=52.989182ms] [job="ID:611, Type:create schema, State:done, SchemaState:public, SchemaID:610, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:36:49.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:50.095 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=611] [conn=2] [job="ID:611, Type:create schema, State:synced, SchemaState:public, SchemaID:610, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:49.758 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:50.126 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=611]
[2024/05/06 09:36:50.127 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:36:50.130 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.351282355\n# Parse_time: 0.000488079\n# Compile_time: 0.000862841\n# Rewrite_time: 0.000033128\n# Optimize_time: 0.001415159\n# Wait_TS: 0.000328088\n# DB: test_show_job\n# Is_internal: false\n# Digest: b2e644a98645255505b98c384516d33fe0a09aa33be2df92d2a39fa8f0a994ce\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 0\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Resource_group: default\nCREATE DATABASE import_into;"]
[2024/05/06 09:36:50.132 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=485] [cur_db=test_show_job] [sql="create table import_into.zero_time_table(t datetime)"] [user=root@%]
[2024/05/06 09:36:50.176 +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:610, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-06 09:36:50.107 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:36:50.176 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:613, Type:create table, State:queueing, SchemaState:none, SchemaID:610, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-06 09:36:50.107 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table import_into.zero_time_table(t datetime)"]
[2024/05/06 09:36:50.228 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=613] [conn=2] [category=ddl] [job="ID:613, Type:create table, State:queueing, SchemaState:none, SchemaID:610, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:50.107 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:50.236 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 610, Table ID: 612, Table Name: zero_time_table"]
[2024/05/06 09:36:50.286 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=485] [neededSchemaVersion=486] ["start time"=2.109405ms] [gotSchemaVersion=486] [phyTblIDs="[612]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 09:36:50.298 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=613] [version=486]
[2024/05/06 09:36:50.333 +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=486] ["take time"=52.963395ms] [job="ID:613, Type:create table, State:done, SchemaState:public, SchemaID:610, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-06 09:36:50.107 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:50.449 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=613] [conn=2] [job="ID:613, Type:create table, State:synced, SchemaState:public, SchemaID:610, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:50.107 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:50.486 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=613]
[2024/05/06 09:36:50.486 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:36:50.490 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.358624794\n# Parse_time: 0.000395823\n# Compile_time: 0.000815432\n# Rewrite_time: 0.000048347\n# Optimize_time: 0.001415159\n# Wait_TS: 0.000466155\n# DB: test_show_job\n# Is_internal: false\n# Digest: 6ffa3fb40f957702df0418164e10a164663f4ee378a9f45fa18805f7d5d9161f\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 0\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Resource_group: default\ncreate table import_into.zero_time_table(t datetime);"]
[2024/05/06 09:36:50.506 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:50.676 +00:00] [INFO] [import_into.go:174] ["get job importer"] [param="{\"file-location\":\"gs://test-load/zero_time.csv?endpoint=http://127.0.0.1:4443/storage/v1/\",\"format\":\"csv\"}"] [dist-task-enabled=true]
[2024/05/06 09:36:50.757 +00:00] [INFO] [job.go:110] ["job submitted to task queue"] [job-id=30078] [task-id=30078] [data-size=20B] [thread-cnt=8] [global-sort=false]
[2024/05/06 09:36:50.855 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=30078]
[2024/05/06 09:36:50.856 +00:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [concurrency=8]
[2024/05/06 09:36:50.961 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=init] [next-step=import]
[2024/05/06 09:36:50.962 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:36:50.963 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=30078] [curr-step=init] [next-step=import]
[2024/05/06 09:36:50.983 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:50.986 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 09:36:50.986 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 09:36:50.986 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=61.99µs]
[2024/05/06 09:36:50.986 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=175.01µs] []
[2024/05/06 09:36:50.986 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=30078] [curr-step=init] [next-step=import] [subtask-count=1]
[2024/05/06 09:36:50.986 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [step=import] [concurrency=8] [subtasks=1]
[2024/05/06 09:36:51.100 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=30078] [mode=Import]
[2024/05/06 09:36:51.119 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=30078]
[2024/05/06 09:36:51.143 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=30078] [type=ImportInto] [remaining-slots=44]
[2024/05/06 09:36:51.186 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=30078] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"]
[2024/05/06 09:36:51.187 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=30078] [step=import]
[2024/05/06 09:36:51.188 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:51.195 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2382] [old-leader=]
[2024/05/06 09:36:51.196 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365815644996921215]
[2024/05/06 09:36:51.196 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:36:51.196 +00:00] [INFO] [tso_client.go:293] ["[tso] switch dc tso global allocator serving url"] [dc-location=global] [new-url=http://127.0.0.1:2382]
[2024/05/06 09:36:51.197 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:51.197 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:36:51.197 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 09:36:51.197 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 09:36:51.197 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:51.211 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 09:36:51.212 +00:00] [INFO] [local.go:704] ["TiKV server side free space check is enabled, so lightning will turn it off"] [category=ddl-ingest]
[2024/05/06 09:36:51.212 +00:00] [INFO] [table_import.go:739] ["use 0.8 of the storage size as default disk quota"] [table=zero_time_table] [quota=374.2GB]
[2024/05/06 09:36:51.213 +00:00] [INFO] [task_executor.go:115] ["KV writer memory size limit per concurrency"] [type=ImportInto] [task-id=30078] [step=import] [data=315.1MiB] [per-index=105MiB]
[2024/05/06 09:36:51.213 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=30078] [disk-quota=348.5GiB]
[2024/05/06 09:36:51.257 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=30078] [step=import] [subtask-id=30150]
[2024/05/06 09:36:51.261 +00:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e]
[2024/05/06 09:36:51.265 +00:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 09:36:51.265 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=612]
[2024/05/06 09:36:51.273 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=612] [key=zero_time.csv:0]
[2024/05/06 09:36:51.276 +00:00] [INFO] [chunk_process.go:334] ["process chunk completed"] [type=ImportInto] [table-id=612] [key=zero_time.csv:0] [readDur=1.086942ms] [encodeDur=1.295682ms] [checksum="{cksum=6865382615934038243,size=36,kvs=1}"] [deliverDur=222.971µs] [type=file] [takeTime=2.933708ms] []
[2024/05/06 09:36:51.277 +00:00] [INFO] [task_executor.go:125] ["run subtask completed"] [type=ImportInto] [task-id=30078] [step=import] [subtask-id=30150] [takeTime=19.923336ms] []
[2024/05/06 09:36:51.277 +00:00] [INFO] [engine.go:867] ["write data to local DB"] [category=ddl-ingest] [size=36] [kvs=1] [files=1] [sstFileSize=934] [file=/tmp/tidb/import-4000/30078/b03a8272-790c-5766-99b7-2cad67f1945e.sst/13de8826-f106-4a6d-a5b7-c002fed622a7.sst] [firstKey=7480000000000002645F728000000000000001] [lastKey=7480000000000002645F728000000000000001]
[2024/05/06 09:36:51.277 +00:00] [INFO] [task_executor.go:199] ["on subtask finished"] [type=ImportInto] [task-id=30078] [step=import] [engine-id=0]
[2024/05/06 09:36:51.277 +00:00] [INFO] [task_executor.go:213] ["import data engine"] [type=ImportInto] [task-id=30078] [step=import] [engine-id=0]
[2024/05/06 09:36:51.277 +00:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e]
[2024/05/06 09:36:51.279 +00:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e] [takeTime=2.022102ms] []
[2024/05/06 09:36:51.279 +00:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e] [retryCnt=0]
[2024/05/06 09:36:51.342 +00:00] [INFO] [local.go:1279] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 09:36:51.364 +00:00] [INFO] [local.go:1317] ["start import engine"] [category=ddl-ingest] [uuid=b03a8272-790c-5766-99b7-2cad67f1945e] ["region ranges"=1] [count=1] [size=36]
[2024/05/06 09:36:51.364 +00:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 09:36:51.379 +00:00] [INFO] [local.go:1328] ["import engine success"] [category=ddl-ingest] [uuid=b03a8272-790c-5766-99b7-2cad67f1945e] [size=36] [kvs=1] [importedSize=36] [importedCount=1]
[2024/05/06 09:36:51.381 +00:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e] [retryCnt=0] [takeTime=102.048996ms] []
[2024/05/06 09:36:51.381 +00:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e]
[2024/05/06 09:36:51.383 +00:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e] [takeTime=1.273079ms] []
[2024/05/06 09:36:51.383 +00:00] [INFO] [task_executor.go:224] ["import index engine"] [type=ImportInto] [task-id=30078] [step=import] [engine-id=0]
[2024/05/06 09:36:51.383 +00:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 09:36:51.385 +00:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71] [takeTime=1.852513ms] []
[2024/05/06 09:36:51.385 +00:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71] [retryCnt=0]
[2024/05/06 09:36:51.385 +00:00] [INFO] [local.go:1257] ["engine contains no kv, skip import"] [category=ddl-ingest] [engine=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 09:36:51.385 +00:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71] [retryCnt=0] [takeTime=61.758µs] []
[2024/05/06 09:36:51.385 +00:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 09:36:51.386 +00:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71] [takeTime=973.329µs] []
[2024/05/06 09:36:51.445 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=30078] [step=import]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:51.449 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:51.449 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:51.449 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:36:51.451 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 09:36:51.451 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:51.452 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:51.452 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:51.452 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:51.452 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=30078] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"] [takeTime=265.626277ms] []
[2024/05/06 09:36:51.478 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=import] [next-step=post-process]
[2024/05/06 09:36:51.479 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:36:51.480 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=30078] [curr-step=import] [next-step=post-process]
[2024/05/06 09:36:51.480 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=30078] [curr-step=import] [next-step=post-process] [mode=Normal]
[2024/05/06 09:36:51.550 +00:00] [INFO] [scheduler.go:291] ["move to post-process step "] [type=ImportInto] [task-id=30078] [curr-step=import] [next-step=post-process] [result="{\"LoadedRowCnt\":1,\"ColSizeMap\":{\"1\":8}}"]
[2024/05/06 09:36:51.551 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=30078] [curr-step=import] [next-step=post-process] [subtask-count=1]
[2024/05/06 09:36:51.551 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=running] [step=post-process] [concurrency=8] [subtasks=1]
[2024/05/06 09:36:51.769 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=30078] [task-type=ImportInto] [server-id=:4000] [step=post-process] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"]
[2024/05/06 09:36:51.823 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151]
[2024/05/06 09:36:51.823 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151]
[2024/05/06 09:36:51.823 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151]
[2024/05/06 09:36:51.831 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [takeTime=8.208292ms] []
[2024/05/06 09:36:51.832 +00:00] [INFO] [subtask_executor.go:133] ["kv group checksum"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [groupId=-1] [size=36] [kvs=1] [checksum=6865382615934038243]
[2024/05/06 09:36:51.832 +00:00] [INFO] [table_import.go:835] ["local checksum"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [checksum="{cksum=6865382615934038243,size=36,kvs=1}"]
[2024/05/06 09:36:51.832 +00:00] [INFO] [table_import.go:950] ["set backoff weight"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [weight=30]
[2024/05/06 09:36:51.832 +00:00] [INFO] [table_import.go:901] ["checksum with adjusted distsql scan concurrency"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [concurrency=15]
[2024/05/06 09:36:51.836 +00:00] [INFO] [checksum.go:79] ["got one checksum result"] [tableID=612] [physicalTableID=612] [indexID=-1] [checksum=6865382615934038243] [totalKvs=1] [totalBytes=36]
[2024/05/06 09:36:51.836 +00:00] [INFO] [table_import.go:861] ["checksum pass"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [local="{cksum=6865382615934038243,size=36,kvs=1}"]
[2024/05/06 09:36:51.836 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [takeTime=13.236889ms] []
[2024/05/06 09:36:51.836 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=30078] [step=post-process] [subtask-id=30151] [takeTime=13.506869ms] []
[2024/05/06 09:36:51.884 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=30078] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=post-process] [next-step=done]
[2024/05/06 09:36:51.884 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=30078] [step=post-process] [state=running] []
[2024/05/06 09:36:51.887 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=30078]
[2024/05/06 09:36:51.888 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=30078] [task-type=ImportInto] [server-id=:4000] [step=post-process] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"] [takeTime=119.331978ms] []
[2024/05/06 09:36:51.949 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=30078] [type=ImportInto]
[2024/05/06 09:36:51.964 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=30078]
[2024/05/06 09:36:51.992 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:36:51.992 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=30078]
[2024/05/06 09:36:52.017 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 1.523519028\n# Parse_time: 0.000939903\n# Compile_time: 0.001372309\n# Rewrite_time: 0.00025445\n# Optimize_time: 0.001415159\n# Wait_TS: 0\n# DB: test_show_job\n# Is_internal: false\n# Digest: f60bcae7c8ecb0a2c7e6a9ff60da26b57eee81605f51317a44caada4faa681a8\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 1\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Plan: tidb_decode_plan('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6MS41MnMsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6MS41MnMsIGxvb3BzOjJw//8NAjQBeP///////////wEYAQ==')\n# Resource_group: default\nIMPORT INTO `import_into`.`zero_time_table` FROM 'gs://test-load/zero_time.csv?endpoint=http://127.0.0.1:4443/storage/v1/';"]
[2024/05/06 09:36:52.034 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=486] [cur_db=test_show_job] [sql="truncate table import_into.zero_time_table"] [user=root@%]
[2024/05/06 09:36:52.066 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:615, Type:truncate table, State:queueing, SchemaState:none, SchemaID:610, TableID:612, RowCount:0, ArgLen:3, start time: 2024-05-06 09:36:52.008 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:36:52.066 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:615, Type:truncate table, State:queueing, SchemaState:none, SchemaID:610, TableID:612, RowCount:0, ArgLen:3, start time: 2024-05-06 09:36:52.008 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="truncate table import_into.zero_time_table"]
[2024/05/06 09:36:52.082 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:36:52.191 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=615] [conn=2] [category=ddl] [job="ID:615, Type:truncate table, State:queueing, SchemaState:none, SchemaID:610, TableID:612, RowCount:0, ArgLen:0, start time: 2024-05-06 09:36:52.008 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:52.205 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: truncate table, Schema ID: 610, Table ID: 614, Table Name: zero_time_table, Old Table ID: 612, Old Table Name: zero_time_table"]
[2024/05/06 09:36:52.250 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=486] [neededSchemaVersion=487] ["start time"=2.521252ms] [gotSchemaVersion=487] [phyTblIDs="[612,614]"] [actionTypes="[11,11]"] [diffTypes="[\"truncate table\"]"]
[2024/05/06 09:36:52.261 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=615] [version=487]
[2024/05/06 09:36:52.298 +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=487] ["take time"=54.471135ms] [job="ID:615, Type:truncate table, State:done, SchemaState:public, SchemaID:610, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-06 09:36:52.008 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:52.365 +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/06 09:36:52.374 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=615] [jobType="truncate table"]
[2024/05/06 09:36:52.379 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=615] [conn=2] [job="ID:615, Type:truncate table, State:synced, SchemaState:public, SchemaID:610, TableID:612, RowCount:0, ArgLen:2, start time: 2024-05-06 09:36:52.008 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:36:52.437 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=615]
[2024/05/06 09:36:52.437 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:36:52.441 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.408530424\n# Parse_time: 0.000322153\n# Compile_time: 0.000903334\n# Rewrite_time: 0.000038152\n# Optimize_time: 0.001092834\n# Wait_TS: 0.000325954\n# DB: test_show_job\n# Is_internal: false\n# Digest: e7b6875866509e7173fa66f822e248d19716b73ff8fdcf9f19f29301bde74b33\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 0\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Resource_group: default\ntruncate table import_into.zero_time_table;"]
[2024/05/06 09:36:52.457 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:52.696 +00:00] [INFO] [import_into.go:174] ["get job importer"] [param="{\"file-location\":\"gs://test-load/zero_time.csv?endpoint=http://127.0.0.1:4443/storage/v1/\",\"format\":\"csv\"}"] [dist-task-enabled=true]
[2024/05/06 09:36:52.781 +00:00] [INFO] [job.go:110] ["job submitted to task queue"] [job-id=30079] [task-id=30079] [data-size=20B] [thread-cnt=8] [global-sort=false]
[2024/05/06 09:36:52.824 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=30079]
[2024/05/06 09:36:52.825 +00:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=30079] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [concurrency=8]
[2024/05/06 09:36:52.932 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=30079] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=init] [next-step=import]
[2024/05/06 09:36:52.932 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=30079] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:36:52.933 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=30079] [curr-step=init] [next-step=import]
[2024/05/06 09:36:52.951 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:52.954 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 09:36:52.954 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 09:36:52.954 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=81.549µs]
[2024/05/06 09:36:52.954 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=245.599µs] []
[2024/05/06 09:36:52.954 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=30079] [curr-step=init] [next-step=import] [subtask-count=1]
[2024/05/06 09:36:52.954 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=30079] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [step=import] [concurrency=8] [subtasks=1]
[2024/05/06 09:36:53.129 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=30079] [mode=Import]
[2024/05/06 09:36:53.148 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=30079]
[2024/05/06 09:36:53.161 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=30079] [type=ImportInto] [remaining-slots=44]
[2024/05/06 09:36:53.203 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"]
[2024/05/06 09:36:53.204 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=30079] [step=import]
[2024/05/06 09:36:53.206 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:36:53.215 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2382] [old-leader=]
[2024/05/06 09:36:53.215 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365815644996921215]
[2024/05/06 09:36:53.215 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:36:53.216 +00:00] [INFO] [tso_client.go:293] ["[tso] switch dc tso global allocator serving url"] [dc-location=global] [new-url=http://127.0.0.1:2382]
[2024/05/06 09:36:53.217 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:36:53.217 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 09:36:53.217 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:53.217 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 09:36:53.217 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:53.233 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 09:36:53.235 +00:00] [INFO] [local.go:704] ["TiKV server side free space check is enabled, so lightning will turn it off"] [category=ddl-ingest]
[2024/05/06 09:36:53.235 +00:00] [INFO] [table_import.go:739] ["use 0.8 of the storage size as default disk quota"] [table=zero_time_table] [quota=374.2GB]
[2024/05/06 09:36:53.235 +00:00] [INFO] [task_executor.go:115] ["KV writer memory size limit per concurrency"] [type=ImportInto] [task-id=30079] [step=import] [data=315.1MiB] [per-index=105MiB]
[2024/05/06 09:36:53.235 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=30079] [disk-quota=348.5GiB]
[2024/05/06 09:36:53.283 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=30079] [step=import] [subtask-id=30152]
[2024/05/06 09:36:53.288 +00:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:0] [engineUUID=b03a8272-790c-5766-99b7-2cad67f1945e]
[2024/05/06 09:36:53.292 +00:00] [INFO] [backend.go:253] ["open engine"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 09:36:53.293 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=614]
[2024/05/06 09:36:53.309 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=614] [key=zero_time.csv:0]
[2024/05/06 09:36:53.311 +00:00] [ERROR] [chunk_process.go:334] ["process chunk failed"] [type=ImportInto] [table-id=614] [key=zero_time.csv:0] [takeTime=1.990255ms] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [stack="github.com/pingcap/tidb/pkg/executor/importer.(*baseChunkProcessor).Process.func1\n\tpkg/executor/importer/chunk_process.go:334\ngithub.com/pingcap/tidb/pkg/executor/importer.(*baseChunkProcessor).Process\n\tpkg/executor/importer/chunk_process.go:354\ngithub.com/pingcap/tidb/pkg/executor/importer.ProcessChunkWithWriter\n\tpkg/executor/importer/engine_process.go:116\ngithub.com/pingcap/tidb/pkg/executor/importer.ProcessChunk\n\tpkg/executor/importer/engine_process.go:69\ngithub.com/pingcap/tidb/pkg/disttask/importinto.(*importMinimalTaskExecutor).Run\n\tpkg/disttask/importinto/subtask_executor.go:75\ngithub.com/pingcap/tidb/pkg/disttask/importinto.(*chunkWorker).HandleTask\n\tpkg/disttask/importinto/encode_and_sort_operator.go:197\ngithub.com/pingcap/tidb/pkg/resourcemanager/pool/workerpool.(*WorkerPool[...]).handleTaskWithRecover\n\tpkg/resourcemanager/pool/workerpool/workerpool.go:131\ngithub.com/pingcap/tidb/pkg/resourcemanager/pool/workerpool.(*WorkerPool[...]).runAWorker.func1\n\tpkg/resourcemanager/pool/workerpool/workerpool.go:147\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).Run.func1\n\tpkg/util/wait_group_wrapper.go:157"]
[2024/05/06 09:36:53.311 +00:00] [ERROR] [task_executor.go:125] ["run subtask failed"] [type=ImportInto] [task-id=30079] [step=import] [subtask-id=30152] [takeTime=28.271425ms] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [stack="github.com/pingcap/tidb/pkg/disttask/importinto.(*importStepExecutor).RunSubtask.func1\n\tpkg/disttask/importinto/task_executor.go:125\ngithub.com/pingcap/tidb/pkg/disttask/importinto.(*importStepExecutor).RunSubtask\n\tpkg/disttask/importinto/task_executor.go:187\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runSubtask.func1\n\tpkg/disttask/framework/taskexecutor/task_executor.go:413\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runSubtask\n\tpkg/disttask/framework/taskexecutor/task_executor.go:414\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:384\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).RunStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:266\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).Run\n\tpkg/disttask/framework/taskexecutor/task_executor.go:246\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).startTaskExecutor.func1\n\tpkg/disttask/framework/taskexecutor/manager.go:337\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).RunWithLog.func1\n\tpkg/util/wait_group_wrapper.go:171"]
[2024/05/06 09:36:53.311 +00:00] [ERROR] [task_executor.go:549] [onError] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [errorVerbose="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'\ngithub.com/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:178\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\texternal/com_github_pingcap_errors/normalize.go:175\ngithub.com/pingcap/tidb/pkg/executor/importer.(*chunkEncoder).encodeLoop\n\tpkg/executor/importer/chunk_process.go:286\ngithub.com/pingcap/tidb/pkg/executor/importer.(*baseChunkProcessor).Process.func3\n\tpkg/executor/importer/chunk_process.go:346\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\texternal/org_golang_x_sync/errgroup/errgroup.go:78\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).onError\n\tpkg/disttask/framework/taskexecutor/task_executor.go:549\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runSubtask\n\tpkg/disttask/framework/taskexecutor/task_executor.go:428\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:384\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).RunStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:266\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).Run\n\tpkg/disttask/framework/taskexecutor/task_executor.go:246\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).startTaskExecutor.func1\n\tpkg/disttask/framework/taskexecutor/manager.go:337\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).RunWithLog.func1\n\tpkg/util/wait_group_wrapper.go:171"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).onError\n\tpkg/disttask/framework/taskexecutor/task_executor.go:549\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runSubtask\n\tpkg/disttask/framework/taskexecutor/task_executor.go:428\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:384\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).RunStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:266\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).Run\n\tpkg/disttask/framework/taskexecutor/task_executor.go:246\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).startTaskExecutor.func1\n\tpkg/disttask/framework/taskexecutor/manager.go:337\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).RunWithLog.func1\n\tpkg/util/wait_group_wrapper.go:171"]
[2024/05/06 09:36:53.312 +00:00] [ERROR] [task_executor.go:555] ["taskExecutor met first error"] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [errorVerbose="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'\ngithub.com/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:178\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\texternal/com_github_pingcap_errors/normalize.go:175\ngithub.com/pingcap/tidb/pkg/executor/importer.(*chunkEncoder).encodeLoop\n\tpkg/executor/importer/chunk_process.go:286\ngithub.com/pingcap/tidb/pkg/executor/importer.(*baseChunkProcessor).Process.func3\n\tpkg/executor/importer/chunk_process.go:346\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\texternal/org_golang_x_sync/errgroup/errgroup.go:78\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).onError\n\tpkg/disttask/framework/taskexecutor/task_executor.go:555\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runSubtask\n\tpkg/disttask/framework/taskexecutor/task_executor.go:428\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).runStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:384\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).RunStep\n\tpkg/disttask/framework/taskexecutor/task_executor.go:266\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).Run\n\tpkg/disttask/framework/taskexecutor/task_executor.go:246\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).startTaskExecutor.func1\n\tpkg/disttask/framework/taskexecutor/manager.go:337\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).RunWithLog.func1\n\tpkg/util/wait_group_wrapper.go:171"]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:53.312 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:36:53.312 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:36:53.312 +00:00] [WARN] [task_executor.go:640] ["subtask failed"] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [error="[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:36:53.312 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:53.330 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=30079] [step=import]
[2024/05/06 09:36:53.334 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:53.334 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:53.334 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:53.334 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:53.335 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:36:53.337 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 09:36:53.337 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:53.337 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:53.337 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=5] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:53.337 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:53.337 +00:00] [INFO] [task_executor.go:309] ["execute task step failed"] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"] [takeTime=134.163967ms] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"]
[2024/05/06 09:36:53.338 +00:00] [ERROR] [task_executor.go:248] ["failed to handle task"] [task-id=30079] [task-type=ImportInto] [server-id=:4000] [error="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [errorVerbose="[Lightning:Restore:ErrEncodeKV]encode kv error in file zero_time.csv:0 at offset 20: [types:1292]Incorrect datetime value: '1990-01-00 00:00:00'\ngithub.com/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:178\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\texternal/com_github_pingcap_errors/normalize.go:175\ngithub.com/pingcap/tidb/pkg/executor/importer.(*chunkEncoder).encodeLoop\n\tpkg/executor/importer/chunk_process.go:286\ngithub.com/pingcap/tidb/pkg/executor/importer.(*baseChunkProcessor).Process.func3\n\tpkg/executor/importer/chunk_process.go:346\ngolang.org/x/sync/errgroup.(*Group).Go.func1\n\texternal/org_golang_x_sync/errgroup/errgroup.go:78\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*BaseTaskExecutor).Run\n\tpkg/disttask/framework/taskexecutor/task_executor.go:248\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).startTaskExecutor.func1\n\tpkg/disttask/framework/taskexecutor/manager.go:337\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).RunWithLog.func1\n\tpkg/util/wait_group_wrapper.go:171"]
[2024/05/06 09:36:53.357 +00:00] [WARN] [scheduler.go:399] ["subtasks encounter errors"] [task-id=30079] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [subtask-errs="[\"{error=\\\"[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'\\\"}\"]"]
[2024/05/06 09:36:53.396 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=30079] [type=ImportInto]
[2024/05/06 09:36:53.444 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=30079] [step=import] [state=reverting] [error="[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"]
[2024/05/06 09:36:53.445 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=30079] [step=import] [mode=Normal]
[2024/05/06 09:36:53.461 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=30079]
[2024/05/06 09:36:53.577 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=30079]
[2024/05/06 09:36:53.601 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:36:53.602 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=30079]
[2024/05/06 09:36:53.687 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:36:53.740 +00:00] [ERROR] [handle.go:109] ["task reverted"] [task-id=30079] [error="[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/handle.WaitTaskDoneOrPaused\n\tpkg/disttask/framework/handle/handle.go:109\ngithub.com/pingcap/tidb/pkg/executor.(*ImportIntoExec).waitTask\n\tpkg/executor/import_into.go:193\ngithub.com/pingcap/tidb/pkg/executor.(*ImportIntoExec).Next\n\tpkg/executor/import_into.go:140\ngithub.com/pingcap/tidb/pkg/executor/internal/exec.Next\n\tpkg/executor/internal/exec/executor.go:410\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).next\n\tpkg/executor/adapter.go:1211\ngithub.com/pingcap/tidb/pkg/executor.(*recordSet).Next\n\tpkg/executor/adapter.go:160\ngithub.com/pingcap/tidb/pkg/session.GetRows4Test\n\tpkg/session/tidb.go:346\ngithub.com/pingcap/tidb/pkg/testkit.(*TestKit).QueryToErr\n\tpkg/testkit/testkit.go:265\ntests/realtikvtest/importintotest/importintotest_test.(*mockGCSSuite).TestZeroDateTime\n\ttests/realtikvtest/importintotest/import_into_test.go:1190\nreflect.Value.call\n\tGOROOT/src/reflect/value.go:596\nreflect.Value.Call\n\tGOROOT/src/reflect/value.go:380\ngithub.com/stretchr/testify/suite.Run.func1\n\texternal/com_github_stretchr_testify/suite/suite.go:202\ntesting.tRunner\n\tGOROOT/src/testing/testing.go:1595"]
[2024/05/06 09:36:53.741 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 1.298345412\n# Parse_time: 0.000809761\n# Compile_time: 0.001572697\n# Rewrite_time: 0.000286953\n# Optimize_time: 0.001092834\n# Wait_TS: 0\n# DB: test_show_job\n# Is_internal: false\n# Digest: f60bcae7c8ecb0a2c7e6a9ff60da26b57eee81605f51317a44caada4faa681a8\n# Num_cop_tasks: 0\n# Prepared: false\n# Plan_from_cache: false\n# Plan_from_binding: false\n# Has_more_results: false\n# KV_total: 0\n# PD_total: 0\n# Backoff_total: 0\n# Write_sql_response_total: 0\n# Result_rows: 0\n# Succ: false\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Plan: tidb_decode_plan('LKwwCTU5XzIJMAkwCU4vQQkwCXRpbWU6MS4zcywgbG9vcHM6MQlOL0EJTi9BCg==')\n# Binary_plan: tidb_decode_binary_plan('RcAKQQoMSW1wb3J0SW50b18yOAFAAVIDTi9BWhJ0aW1lOjEuM3MsIGxvb3BzOjFw////CQI0AXj///////////8BGAE=')\n# Resource_group: default\nIMPORT INTO `import_into`.`zero_time_table` FROM 'gs://test-load/zero_time.csv?endpoint=http://127.0.0.1:4443/storage/v1/';"]
[2024/05/06 09:36:53.789 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.789 +00:00] [INFO] [manager.go:273] ["break campaign loop, context is done"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.790 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] []
[2024/05/06 09:36:53.791 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 5, tp add index"] [category=ddl] ["take time"=24.978µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 6, tp add index"] [category=ddl] ["take time"=14.007µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 7, tp add index"] [category=ddl] ["take time"=22.756µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 8, tp add index"] [category=ddl] ["take time"=17.284µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 9, tp add index"] [category=ddl] ["take time"=9.694µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 10, tp add index"] [category=ddl] ["take time"=20.474µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 11, tp add index"] [category=ddl] ["take time"=18.714µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 2, tp add index"] [category=ddl] ["take time"=4.619µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 3, tp add index"] [category=ddl] ["take time"=12.784µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 4, tp add index"] [category=ddl] ["take time"=14.324µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 1, tp general"] [category=ddl] ["take time"=5.25µs]
[2024/05/06 09:36:53.792 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:36:53.792 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl]
[2024/05/06 09:36:53.792 +00:00] [INFO] [session_pool.go:99] ["closing session pool"] [category=ddl]
[2024/05/06 09:36:53.829 +00:00] [INFO] [ddl.go:951] ["DDL closed"] [category=ddl] [ID=96f7714b-c86a-4bde-93a9-bce960eced09] ["take time"=78.286078ms]
[2024/05/06 09:36:53.830 +00:00] [INFO] [ddl.go:769] ["stop DDL"] [category=ddl] [ID=96f7714b-c86a-4bde-93a9-bce960eced09]
[2024/05/06 09:36:53.832 +00:00] [INFO] [domain.go:1026] ["stopping ttlJobManager"]
[2024/05/06 09:36:53.832 +00:00] [INFO] [notifier.go:142] ["etcd watcher exited to watch timer events"] [EtcdKey=/tidb/timer/cluster/1/notify/ff503b07-588c-4800-9b58-ee3e5932ec2e] [watcherID=444aef5b-92ba-4e9d-88ee-cda6fb7f3560]
[2024/05/06 09:36:53.832 +00:00] [INFO] [runtime.go:190] ["TimerGroupRuntime loop exit"] [groupID=ttl]
[2024/05/06 09:36:53.832 +00:00] [INFO] [notifier.go:227] ["etcd notify loop to watch timer events stopped"] [EtcdKey=/tidb/timer/cluster/1/notify/ff503b07-588c-4800-9b58-ee3e5932ec2e]
[2024/05/06 09:36:53.832 +00:00] [INFO] [task_manager.go:194] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=task-manager] [originalCount=4] [newCount=0]
[2024/05/06 09:36:53.832 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:36:53.832 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:36:53.832 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:36:53.832 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:36:53.833 +00:00] [INFO] [task_manager.go:194] ["shrink ttl worker"] [ttl-worker=job-manager] [ttl-worker=task-manager] [originalCount=4] [newCount=0]
[2024/05/06 09:36:53.833 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:36:53.833 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:36:53.833 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:36:53.833 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:36:53.840 +00:00] [INFO] [job_manager.go:174] ["ttlJobManager loop exited."] [ttl-worker=job-manager]
[2024/05/06 09:36:53.840 +00:00] [INFO] [domain.go:1037] ["ttlJobManager exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2817] ["releaseServerID succeed"] [serverID=921]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2881] ["serverIDKeeper exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2450] ["autoAnalyzeWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2020] ["PlanReplayerTaskCollectHandle exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=autoAnalyzeWorker]
[2024/05/06 09:36:53.841 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:1700] ["loadPrivilegeInLoop exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskCollectHandle]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=mdlCheckLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:761] ["topologySyncerKeeper exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:711] ["infoSyncerKeeper exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSigningCertLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2371] ["updateStatsWorker is going to exit, start to flush stats"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:1750] ["LoadSysVarCacheLoop exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topologySyncerKeeper]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2323] ["loadStatsWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2352] ["indexUsageWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2040] ["PlanReplayerTaskDumpHandle exited."]
[2024/05/06 09:36:53.841 +00:00] [INFO] [plan_replayer.go:413] ["planReplayerTaskDumpWorker exited."]
[2024/05/06 09:36:53.841 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=LoadSysVarCacheLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadStatsWorker]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskDumpHandle]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2074] ["dumpFileGcChecker exited."]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=indexUsageWorker]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[log-backup] ownerManager 899ef728-ceee-45be-a49c-c094bf262f76 watch owner key /tidb/br-stream/owner/6f188f4d39f56060"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:907] ["loadSchemaInLoop exited."]
[2024/05/06 09:36:53.842 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=dumpFileGcChecker]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadPrivilegeInLoop]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2492] ["analyzeJobsCleanupWorker exited."]
[2024/05/06 09:36:53.842 +00:00] [INFO] [advancer.go:397] ["Meet task event"] [category="log backup advancer"] [event="Err(, err = EOF)"]
[2024/05/06 09:36:53.842 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSchemaInLoop]
[2024/05/06 09:36:53.842 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 899ef728-ceee-45be-a49c-c094bf262f76"]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[stats] ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09 watch owner key /tidb/stats/owner/3eaa8f4d39f56143"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:1542] ["stopping dist task scheduler manager because the current node is not DDL owner anymore"] [id=96f7714b-c86a-4bde-93a9-bce960eced09]
[2024/05/06 09:36:53.842 +00:00] [ERROR] [advancer.go:400] ["listen task meet error, would reopen."] [error=EOF] [stack="github.com/pingcap/tidb/br/pkg/streamhelper.(*CheckpointAdvancer).StartTaskListener.func1\n\tbr/pkg/streamhelper/advancer.go:400"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:737] ["globalConfigSyncerKeeper exited."]
[2024/05/06 09:36:53.842 +00:00] [INFO] [scheduler_manager.go:206] ["schedule task loop exits"] [server-id=:4000]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] [error="context canceled"] [errorVerbose="context canceled\ngithub.com/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:178\ngithub.com/pingcap/errors.Trace\n\texternal/com_github_pingcap_errors/juju_adaptor.go:15\ngithub.com/pingcap/tidb/pkg/util.contextDone\n\tpkg/util/etcd.go:90\ngithub.com/pingcap/tidb/pkg/util.NewSession\n\tpkg/util/etcd.go:50\ngithub.com/pingcap/tidb/pkg/owner.(*ownerManager).campaignLoop\n\tpkg/owner/manager.go:259\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"]
[2024/05/06 09:36:53.841 +00:00] [INFO] [domain.go:2105] ["HistoricalStatsWorker exited."]
[2024/05/06 09:36:53.842 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[stats] /tidb/stats/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.842 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper]
[2024/05/06 09:36:53.842 +00:00] [INFO] [scheduler_manager.go:459] ["collect loop exits"] [server-id=:4000]
[2024/05/06 09:36:53.842 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=analyzeJobsCleanupWorker]
[2024/05/06 09:36:53.842 +00:00] [INFO] [scheduler_manager.go:318] ["subtask history table gc loop exits"] [server-id=:4000]
[2024/05/06 09:36:53.842 +00:00] [INFO] [advancer.go:403] ["Task watcher exits due to some error."] [category="log backup advancer"] [error=EOF]
[2024/05/06 09:36:53.842 +00:00] [INFO] [scheduler_manager.go:379] ["cleanup loop exits"] [server-id=:4000]
[2024/05/06 09:36:53.841 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=infoSyncerKeeper]
[2024/05/06 09:36:53.842 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=HistoricalStatsWorker]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[stats] /tidb/stats/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"]
[2024/05/06 09:36:53.842 +00:00] [INFO] [domain.go:1544] ["dist task scheduler manager stopped"] [id=96f7714b-c86a-4bde-93a9-bce960eced09]
[2024/05/06 09:36:53.842 +00:00] [INFO] [domain.go:1527] ["stopping dist task executor manager"]
[2024/05/06 09:36:53.842 +00:00] [INFO] [manager.go:280] ["recoverMetaLoop done"] [server-id=:4000]
[2024/05/06 09:36:53.844 +00:00] [INFO] [owner_daemon.go:87] ["daemon loop exits"] [id=899ef728-ceee-45be-a49c-c094bf262f76] [daemon-id=LogBackup::Advancer]
[2024/05/06 09:36:53.844 +00:00] [INFO] [domain.go:683] ["topNSlowQueryLoop exited."]
[2024/05/06 09:36:53.844 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=logBackupAdvancer]
[2024/05/06 09:36:53.844 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topNSlowQueryLoop]
[2024/05/06 09:36:53.844 +00:00] [INFO] [manager.go:292] ["failed to campaign"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 899ef728-ceee-45be-a49c-c094bf262f76"] [error="context canceled"]
[2024/05/06 09:36:53.844 +00:00] [INFO] [domain.go:1361] ["closestReplicaReadCheckLoop exited."]
[2024/05/06 09:36:53.844 +00:00] [INFO] [flush_subscriber.go:109] [Clearing.] [category="log backup flush subscriber"] [timeout=1m0s]
[2024/05/06 09:36:53.844 +00:00] [INFO] [manager.go:273] ["break campaign loop, context is done"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 899ef728-ceee-45be-a49c-c094bf262f76"]
[2024/05/06 09:36:53.844 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop]
[2024/05/06 09:36:53.846 +00:00] [INFO] [domain.go:2373] ["updateStatsWorker ready to release owner"]
[2024/05/06 09:36:53.846 +00:00] [WARN] [etcd.go:78] ["failed to new session to etcd"] [ownerInfo="[stats] /tidb/stats/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] [error="context canceled"]
[2024/05/06 09:36:53.862 +00:00] [ERROR] [txn.go:608] ["active transaction fail"] [error="context canceled"] [errorVerbose="context canceled\ngithub.com/tikv/pd/client.(*tsoRequest).Wait\n\texternal/com_github_tikv_pd_client/tso_request.go:79\ngithub.com/tikv/client-go/v2/util.interceptedTsFuture.Wait\n\texternal/com_github_tikv_client_go_v2/util/pd_interceptor.go:73\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:132\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:135\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).ExecuteSQLWithNewSession.func1\n\tpkg/disttask/framework/storage/task_table.go:183\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).WithNewSession\n\tpkg/disttask/framework/storage/task_table.go:147"] [stack="github.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:608\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).ExecuteSQLWithNewSession.func1\n\tpkg/disttask/framework/storage/task_table.go:183\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).WithNewSession\n\tpkg/disttask/framework/storage/task_table.go:147\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).ExecuteSQLWithNewSession\n\tpkg/disttask/framework/storage/task_table.go:182\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).GetTaskExecInfoByExecID\n\tpkg/disttask/framework/storage/task_table.go:270\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasks\n\tpkg/disttask/framework/taskexecutor/manager.go:193\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasksLoop\n\tpkg/disttask/framework/taskexecutor/manager.go:184\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).Run.func1\n\tpkg/util/wait_group_wrapper.go:157"]
[2024/05/06 09:36:53.863 +00:00] [INFO] [tidb.go:269] ["rollbackTxn called due to ddl/autocommit failure"]
[2024/05/06 09:36:53.863 +00:00] [WARN] [session.go:2153] ["run statement failed"] [schemaVersion=487] [error="context canceled"] [errorVerbose="context canceled\ngithub.com/tikv/pd/client.(*tsoRequest).Wait\n\texternal/com_github_tikv_pd_client/tso_request.go:79\ngithub.com/tikv/client-go/v2/util.interceptedTsFuture.Wait\n\texternal/com_github_tikv_client_go_v2/util/pd_interceptor.go:73\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:132\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:135\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).ExecuteSQLWithNewSession.func1\n\tpkg/disttask/framework/storage/task_table.go:183\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).WithNewSession\n\tpkg/disttask/framework/storage/task_table.go:147"] [session="{\n  \"currDBName\": \"\",\n  \"id\": 0,\n  \"status\": 2,\n  \"strictMode\": false,\n  \"user\": null\n}"]
[2024/05/06 09:36:53.864 +00:00] [ERROR] [manager.go:369] ["task manager met error"] [server-id=:4000] [error="context canceled"] [errorVerbose="context canceled\ngithub.com/tikv/pd/client.(*tsoRequest).Wait\n\texternal/com_github_tikv_pd_client/tso_request.go:79\ngithub.com/tikv/client-go/v2/util.interceptedTsFuture.Wait\n\texternal/com_github_tikv_client_go_v2/util/pd_interceptor.go:73\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:132\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/tikv/client-go/v2/oracle/oracles.(*tsFuture).Wait\n\texternal/com_github_tikv_client_go_v2/oracle/oracles/pd.go:135\ngithub.com/pingcap/tidb/pkg/session.(*txnFuture).wait\n\tpkg/session/txn.go:699\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).changePendingToValid\n\tpkg/session/txn.go:289\ngithub.com/pingcap/tidb/pkg/session.(*LazyTxn).Wait\n\tpkg/session/txn.go:607\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).ActivateTxn\n\tpkg/sessiontxn/isolation/base.go:290\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*baseTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/base.go:186\ngithub.com/pingcap/tidb/pkg/sessiontxn/isolation.(*OptimisticTxnContextProvider).GetStmtReadTS\n\tpkg/sessiontxn/isolation/optimistic.go:100\ngithub.com/pingcap/tidb/pkg/session.(*txnManager).GetStmtReadTS\n\tpkg/session/txnmanager.go:98\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).getSnapshotTS\n\tpkg/executor/builder.go:1817\ngithub.com/pingcap/tidb/pkg/executor.buildNoRangeIndexLookUpReader\n\tpkg/executor/builder.go:3731\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildIndexLookUpReader\n\tpkg/executor/builder.go:3787\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:292\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashJoin\n\tpkg/executor/builder.go:1471\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:258\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildHashAgg\n\tpkg/executor/builder.go:1630\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:270\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildProjection\n\tpkg/executor/builder.go:1766\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:274\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).buildSort\n\tpkg/executor/builder.go:2143\ngithub.com/pingcap/tidb/pkg/executor.(*executorBuilder).build\n\tpkg/executor/builder.go:248\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).buildExecutor\n\tpkg/executor/adapter.go:1172\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).Exec\n\tpkg/executor/adapter.go:522\ngithub.com/pingcap/tidb/pkg/session.runStmt\n\tpkg/session/session.go:2280\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteStmt\n\tpkg/session/session.go:2141\ngithub.com/pingcap/tidb/pkg/session.(*session).ExecuteInternal\n\tpkg/session/session.go:1518\ngithub.com/pingcap/tidb/pkg/util/sqlexec.ExecSQL\n\tpkg/util/sqlexec/restricted_sql_executor.go:236\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).ExecuteSQLWithNewSession.func1\n\tpkg/disttask/framework/storage/task_table.go:183\ngithub.com/pingcap/tidb/pkg/disttask/framework/storage.(*TaskManager).WithNewSession\n\tpkg/disttask/framework/storage/task_table.go:147"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).logErr\n\tpkg/disttask/framework/taskexecutor/manager.go:369\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasks\n\tpkg/disttask/framework/taskexecutor/manager.go:195\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasksLoop\n\tpkg/disttask/framework/taskexecutor/manager.go:184\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).Run.func1\n\tpkg/util/wait_group_wrapper.go:157"] [stack="github.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).logErr\n\tpkg/disttask/framework/taskexecutor/manager.go:369\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasks\n\tpkg/disttask/framework/taskexecutor/manager.go:195\ngithub.com/pingcap/tidb/pkg/disttask/framework/taskexecutor.(*Manager).handleTasksLoop\n\tpkg/disttask/framework/taskexecutor/manager.go:184\ngithub.com/pingcap/tidb/pkg/util.(*WaitGroupWrapper).Run.func1\n\tpkg/util/wait_group_wrapper.go:157"]
[2024/05/06 09:36:53.865 +00:00] [INFO] [manager.go:179] ["handle tasks loop done"] [server-id=:4000]
[2024/05/06 09:36:53.865 +00:00] [INFO] [domain.go:1529] ["dist task executor manager stopped"]
[2024/05/06 09:36:53.865 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=distTaskFrameworkLoop]
[2024/05/06 09:36:54.047 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[stats] /tidb/stats/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] [error="context canceled"] [errorVerbose="context canceled\ngithub.com/pingcap/errors.AddStack\n\texternal/com_github_pingcap_errors/errors.go:178\ngithub.com/pingcap/errors.Trace\n\texternal/com_github_pingcap_errors/juju_adaptor.go:15\ngithub.com/pingcap/tidb/pkg/util.contextDone\n\tpkg/util/etcd.go:90\ngithub.com/pingcap/tidb/pkg/util.NewSession\n\tpkg/util/etcd.go:50\ngithub.com/pingcap/tidb/pkg/owner.(*ownerManager).campaignLoop\n\tpkg/owner/manager.go:259\nruntime.goexit\n\tsrc/runtime/asm_amd64.s:1650"]
[2024/05/06 09:36:55.099 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 899ef728-ceee-45be-a49c-c094bf262f76"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:36:55.107 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:36:55.107 +00:00] [INFO] [domain.go:1889] ["globalBindHandleWorkerLoop exited."]
[2024/05/06 09:36:55.107 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalBindHandleWorkerLoop]
[2024/05/06 09:36:55.303 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[stats] /tidb/stats/owner ownerManager 96f7714b-c86a-4bde-93a9-bce960eced09"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:36:55.303 +00:00] [INFO] [domain.go:2379] ["updateStatsWorker exit preprocessing finished"]
[2024/05/06 09:36:55.303 +00:00] [INFO] [domain.go:2404] ["updateStatsWorker exited."]
[2024/05/06 09:36:55.303 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=updateStatsWorker]
[2024/05/06 09:36:55.312 +00:00] [INFO] [domain.go:1074] ["domain closed"] ["take time"=1.561023218s]
[2024/05/06 09:36:55.313 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=1] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_batch_controller.go:160] ["[pd] clear the tso batch controller"] [max-batch-size=10000] [best-batch-size=1] [collected-request-count=0] [pending-request-count=0]
[2024/05/06 09:36:55.313 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:36:55.313 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:36:55.315 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=tikv-driver]
--- PASS: TestImportInto (247.46s)
    --- SKIP: TestImportInto/TestAddIndexBySQL (0.00s)
    --- SKIP: TestImportInto/TestAnalyze (0.00s)
    --- PASS: TestImportInto/TestBasicImportInto (35.55s)
    --- PASS: TestImportInto/TestCancelJob (8.89s)
    --- PASS: TestImportInto/TestChecksumNotMatch (8.52s)
    --- PASS: TestImportInto/TestColumnsAndUserVars (3.19s)
    --- PASS: TestImportInto/TestDeliverBytesRows (4.93s)
    --- PASS: TestImportInto/TestDetachedLoadParquet (6.39s)
    --- PASS: TestImportInto/TestDiskQuota (9.48s)
    --- PASS: TestImportInto/TestGBK (8.20s)
    --- PASS: TestImportInto/TestGeneratedColumnsAndTSVFile (12.29s)
    --- PASS: TestImportInto/TestIgnoreNLines (7.77s)
    --- PASS: TestImportInto/TestImportIntoPrivilegePositiveCase (8.06s)
    --- PASS: TestImportInto/TestImportMode (19.34s)
    --- PASS: TestImportInto/TestInputCountMisMatchAndDefault (8.21s)
    --- PASS: TestImportInto/TestInputNull (6.98s)
    --- PASS: TestImportInto/TestJobFailWhenDispatchSubtask (2.94s)
    --- PASS: TestImportInto/TestKillBeforeFinish (3.72s)
    --- PASS: TestImportInto/TestLoadSQLDump (6.77s)
    --- PASS: TestImportInto/TestMaxWriteSpeed (15.22s)
    --- PASS: TestImportInto/TestMultiValueIndex (3.33s)
    --- PASS: TestImportInto/TestOtherCharset (14.08s)
    --- PASS: TestImportInto/TestPreCheckCDCPiTRTasks (4.42s)
    --- PASS: TestImportInto/TestPreCheckTableNotEmpty (1.47s)
    --- PASS: TestImportInto/TestPreCheckTotalFileSize0 (1.44s)
    --- PASS: TestImportInto/TestRegisterTask (10.24s)
    --- PASS: TestImportInto/TestSameBehaviourDetachedOrNot (12.27s)
    --- PASS: TestImportInto/TestShowDetachedJob (7.36s)
    --- PASS: TestImportInto/TestShowJob (9.44s)
    --- PASS: TestImportInto/TestZeroDateTime (4.57s)
PASS
coverage: 14.8% of statements
GCov does not exist at the given path: ''
May 06, 2024 9:37:01 AM com.google.devtools.coverageoutputgenerator.Main getTracefiles
INFO: No lcov file found.
May 06, 2024 9:37:01 AM com.google.devtools.coverageoutputgenerator.Main getGcovInfoFiles
INFO: No gcov info file found.
May 06, 2024 9:37:01 AM com.google.devtools.coverageoutputgenerator.Main getGcovJsonInfoFiles
INFO: No gcov json file found.
May 06, 2024 9:37:01 AM com.google.devtools.coverageoutputgenerator.Main getProfdataFileOrNull
INFO: No .profdata file found.
May 06, 2024 9:37:01 AM com.google.devtools.coverageoutputgenerator.Main runWithArgs
WARNING: There was no coverage found.
================================================================================
Target //tests/realtikvtest/importintotest:importintotest_test up-to-date:
  bazel-bin/tests/realtikvtest/importintotest/importintotest_test_/importintotest_test
INFO: Elapsed time: 569.085s, Critical Path: 551.39s
INFO: 1610 processes: 1584 remote cache hit, 19 internal, 7 linux-sandbox.
INFO: Build completed successfully, 1610 total actions
//tests/realtikvtest/importintotest:importintotest_test                   FLAKY, failed in 1 out of 2 in 265.3s
  Stats over 2 runs: max = 265.3s, min = 254.1s, avg = 259.7s, dev = 5.6s
  /home/jenkins/.tidb/tmp/903aa8c667333396b92cebbde26882dc/execroot/__main__/bazel-out/k8-fastbuild/testlogs/tests/realtikvtest/importintotest/importintotest_test/coverage.dat
Test cases: finished with 31 passing and 0 failing out of 31 test cases

Executed 1 out of 1 test: 1 test passes.
./build/jenkins_collect_coverage.sh
root: /home/jenkins/.tidb/tmp/903aa8c667333396b92cebbde26882dc/execroot/__main__/bazel-out/k8-fastbuild/testlogs
complete to collect bazel result.
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check2/tidb
[Pipeline] {
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // dir
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check2/tidb
[Pipeline] {
[Pipeline] script
[Pipeline] {
[Pipeline] sh
[2024-05-06T09:37:14.097Z] ['info'] 
     _____          _
    / ____|        | |
   | |     ___   __| | ___  ___ _____   __
   | |    / _ \ / _` |/ _ \/ __/ _ \ \ / /
   | |___| (_) | (_| |  __/ (_| (_) \ V /
    \_____\___/ \__,_|\___|\___\___/ \_/

  Codecov report uploader 0.5.0
[2024-05-06T09:37:14.099Z] ['info'] => Project root located at: .
[2024-05-06T09:37:14.102Z] ['info'] ->  Token found by environment variables
[2024-05-06T09:37:14.114Z] ['info'] Searching for coverage files...
[2024-05-06T09:37:14.679Z] ['info'] => Found 1 possible coverage files:
  ./coverage.dat
[2024-05-06T09:37:14.679Z] ['info'] Processing ./coverage.dat...
[2024-05-06T09:37:15.067Z] ['info'] Using manual override from args.
[2024-05-06T09:37:15.067Z] ['info'] Detected Jenkins CI as the CI provider.
[2024-05-06T09:37:15.077Z] ['info'] Pinging Codecov: https://codecov.io/upload/v4?package=uploader-0.5.0&token=*******&branch=origin%2Fpr%2F53031&build=8851&build_url=https%3A%2F%2Fdo.pingcap.net%2Fjenkins%2Fjob%2Fpingcap%2Fjob%2Ftidb%2Fjob%2Fghpr_check2%2F8851%2F&commit=d8e2c3792eea19c841a5a4f8bf66c5adcffa4a48&job=&pr=53031&service=jenkins&slug=pingcap%2Ftidb&name=&tag=&flags=integration&parent=
[2024-05-06T09:37:15.808Z] ['info'] https://app.codecov.io/github/pingcap/tidb/commit/d8e2c3792eea19c841a5a4f8bf66c5adcffa4a48
https://storage.googleapis.com/codecov/v4/raw/2024-05-06/F6B65B6EE70BEC6C6B5E073ED3BB1A79/d8e2c3792eea19c841a5a4f8bf66c5adcffa4a48/bd91984e-89f5-47c2-8b6b-ab1ae6ffe4c8.txt?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=GOOG1EJOGFN2JQ4OCTGA2MU5AEIT7OT5Z7HTFOAN2SPG4NWSN2UJYOY5U6LZQ%2F20240506%2Fus-west2%2Fs3%2Faws4_request&X-Amz-Date=20240506T093715Z&X-Amz-Expires=10&X-Amz-SignedHeaders=host&X-Amz-Signature=6dd3d3bcaa435d14d88c7cf6a1fa5efd75173c4b8e312662b57fc2dc7bb2a49b
[2024-05-06T09:37:15.809Z] ['info'] Uploading...
[2024-05-06T09:37:17.625Z] ['info'] {"status":"success","resultURL":"https://app.codecov.io/github/pingcap/tidb/commit/d8e2c3792eea19c841a5a4f8bf66c5adcffa4a48"}
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/executor/executor.test: ok! 2151 test cases passed, take time 61.790100515 s
./t/executor/executor_txn.test: ok! 121 test cases passed, take time 0.620093981 s
./t/executor/explain.test: ok! 120 test cases passed, take time 2.329793755 s
./t/executor/explainfor.test: ok! 378 test cases passed, take time 4.335360737 s
./t/executor/foreign_key.test: ok! 318 test cases passed, take time 15.911814289 s
./t/executor/grant.test: ok! 202 test cases passed, take time 2.394542066 s
./t/executor/import_into.test: ok! 88 test cases passed, take time 0.289335533 s
./t/executor/index_advise.test: ok! 30 test cases passed, take time 0.337888135 s
./t/executor/index_lookup_join.test: ok! 190 test cases passed, take time 6.049247933 s
./t/executor/index_lookup_merge_join.test: ok! 83 test cases passed, take time 3.086847489 s
./t/executor/index_merge_reader.test: ok! 244 test cases passed, take time 18.044901217 s
./t/executor/infoschema_reader.test: ok! 174 test cases passed, take time 8.604711211 s
./t/executor/insert.test: ok! 1224 test cases passed, take time 88.658643291 s
./t/executor/inspection_common.test: ok! 4 test cases passed, take time 0.001944799 s
./t/executor/issues.test: ok! 421 test cases passed, take time 15.596124283 s
./t/executor/jointest/hash_join.test: ok! 137 test cases passed, take time 9.098153327 s
./t/executor/jointest/join.test: ok! 866 test cases passed, take time 41.273495312 s
./t/executor/kv.test: ok! 16 test cases passed, take time 0.182410371 s
./t/executor/merge_join.test: ok! 259 test cases passed, take time 9.644280977 s
./t/executor/parallel_apply.test: ok! 96 test cases passed, take time 3.263078683 s
./t/executor/partition/global_index.test: ok! 94 test cases passed, take time 15.269695743 s
./t/executor/partition/issues.test: ok! 154 test cases passed, take time 7.826798066 s
./t/executor/partition/partition_boundaries.test: ok! 1035 test cases passed, take time 2.833168454 s
./t/executor/partition/partition_with_expression.test: ok! 298 test cases passed, take time 3.837664043 s
./t/executor/partition/table.test: ok! 224 test cases passed, take time 13.139194212 s
./t/executor/partition/write.test: ok! 355 test cases passed, take time 13.803597372 s
./t/executor/password_management.test: ok! 381 test cases passed, take time 3.524552798 s
./t/executor/point_get.test: ok! 273 test cases passed, take time 6.379169748 s
./t/executor/prepared.test: ok! 214 test cases passed, take time 3.622978626 s
./t/executor/revoke.test: ok! 65 test cases passed, take time 1.121214046 s
./t/executor/rowid.test: ok! 63 test cases passed, take time 1.040314297 s
./t/executor/sample.test: ok! 105 test cases passed, take time 14.900340093 s
./t/executor/set.test: ok! 228 test cases passed, take time 0.552537188 s
./t/executor/show.test: ok! 301 test cases passed, take time 18.142949118 s
./t/executor/simple.test: ok! 303 test cases passed, take time 3.196247323 s
./t/executor/split_table.test: ok! 60 test cases passed, take time 16.294842103 s
./t/executor/stale_txn.test: ok! 28 test cases passed, take time 1.6103269340000002 s
./t/executor/statement_context.test: ok! 63 test cases passed, take time 0.483056227 s
./t/executor/union_scan.test: ok! 231 test cases passed, take time 4.813903167 s
./t/executor/update.test: ok! 513 test cases passed, take time 13.225224426 s
./t/executor/window.test: ok! 22 test cases passed, take time 0.28828029 s
./t/executor/write.test: ok! 1079 test cases passed, take time 35.498932959 s
./t/explain-non-select-stmt.test: ok! 8 test cases passed, take time 0.088761546 s
./t/explain.test: ok! 21 test cases passed, take time 0.551828103 s
./t/explain_complex.test: ok! 41 test cases passed, take time 1.798228108 s
./t/explain_complex_stats.test: ok! 61 test cases passed, take time 5.058320257 s
./t/explain_cte.test: ok! 53 test cases passed, take time 1.522463075 s
./t/explain_easy.test: ok! 190 test cases passed, take time 7.473473252 s
./t/explain_easy_stats.test: ok! 50 test cases passed, take time 1.658995003 s
./t/explain_foreign_key.test: ok! 41 test cases passed, take time 2.209144264 s
./t/explain_generate_column_substitute.test: ok! 233 test cases passed, take time 33.79173232 s
./t/explain_indexmerge_stats.test: ok! 30 test cases passed, take time 5.732466227 s
./t/explain_join_stats.test: ok! 8 test cases passed, take time 0.404152007 s
./t/explain_shard_index.test: ok! 19 test cases passed, take time 0.447510591 s
./t/explain_stats.test: ok! 10 test cases passed, take time 0.180098048 s
./t/explain_union_scan.test: ok! 9 test cases passed, take time 0.267574817 s
./t/expression/builtin.test: ok! 1332 test cases passed, take time 27.443111169 s
./t/expression/cast.test: ok! 50 test cases passed, take time 0.821037684 s
Aborted by Jenkins Admin
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check2/tidb
[Pipeline] {
[Pipeline] junit
Recording test results
None of the test reports contained any result
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // dir
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/ghpr_check2/tidb
[Pipeline] {
[Pipeline] sh
+ str='integrationtest_with_tikv.sh y'
+ logs_dir=logs_integrationtest_with_tikv.sh_y
+ mkdir -p logs_integrationtest_with_tikv.sh_y
+ mv pd1.log pd2.log pd3.log logs_integrationtest_with_tikv.sh_y
+ mv tikv1.log tikv2.log tikv3.log logs_integrationtest_with_tikv.sh_y
+ mv tests/integrationtest/integration-test.out logs_integrationtest_with_tikv.sh_y
+ tar -czvf logs_integrationtest_with_tikv.sh_y.tar.gz logs_integrationtest_with_tikv.sh_y
logs_integrationtest_with_tikv.sh_y/
logs_integrationtest_with_tikv.sh_y/pd2.log
logs_integrationtest_with_tikv.sh_y/pd3.log
logs_integrationtest_with_tikv.sh_y/tikv1.log
No test report files were found. Configuration error?
logs_integrationtest_with_tikv.sh_y/integration-test.out
logs_integrationtest_with_tikv.sh_y/pd1.log
logs_integrationtest_with_tikv.sh_y/tikv2.log
logs_integrationtest_with_tikv.sh_y/tikv3.log
[Pipeline] archiveArtifacts
Archiving artifacts
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - SCRIPT_AND_ARGS = 'integrationtest_with_tikv.sh y'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh ABORTED result.json
http://fileserver.pingcap.net
--2024-05-06 09:47:04--  http://fileserver.pingcap.net/download/rd-atom-agent/agent_upload_verifyci_metadata.py
Resolving fileserver.pingcap.net (fileserver.pingcap.net)... 10.2.12.82
Connecting to fileserver.pingcap.net (fileserver.pingcap.net)|10.2.12.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4181 (4.1K) [application/octet-stream]
Saving to: ‘agent_upload_verifyci_metadata.py’

     0K ....                                                  100%  319M=0s

2024-05-06 09:47:05 (319 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
org.jenkinsci.plugins.workflow.actions.ErrorAction$ErrorId: 7c2a7e3c-65ed-4219-b999-ecc198eab361
Finished: ABORTED