Skipping 11,934 KB.. Full Log

[2024/05/06 09:44:11.176 +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:44:11.176 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:11.176 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=77] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=1, Mem=630.2MiB]"] [takeTime=1.102372445s] []
[2024/05/06 09:44:11.181 +00:00] [INFO] [scheduler.go:291] ["move to post-process step "] [type=ImportInto] [task-id=77] [curr-step=import] [next-step=post-process] [result="{\"LoadedRowCnt\":4,\"ColSizeMap\":{\"1\":4}}"]
[2024/05/06 09:44:11.183 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=77] [curr-step=import] [next-step=post-process] [subtask-count=1]
[2024/05/06 09:44:11.184 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=77] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=running] [step=post-process] [concurrency=1] [subtasks=1]
[2024/05/06 09:44:11.498 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=77] [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:44:11.581 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 09:44:11.582 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 09:44:11.582 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 09:44:11.582 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=12.862µs] []
[2024/05/06 09:44:11.582 +00:00] [INFO] [subtask_executor.go:133] ["kv group checksum"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [groupId=-1] [size=100] [kvs=4] [checksum=10068981574061626288]
[2024/05/06 09:44:11.582 +00:00] [INFO] [table_import.go:835] ["local checksum"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [checksum="{cksum=10068981574061626288,size=100,kvs=4}"]
[2024/05/06 09:44:11.582 +00:00] [INFO] [table_import.go:950] ["set backoff weight"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [weight=30]
[2024/05/06 09:44:11.582 +00:00] [INFO] [table_import.go:901] ["checksum with adjusted distsql scan concurrency"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [concurrency=15]
[2024/05/06 09:44:11.591 +00:00] [INFO] [checksum.go:79] ["got one checksum result"] [tableID=345] [physicalTableID=345] [indexID=-1] [checksum=10068981574061626288] [totalKvs=4] [totalBytes=100]
[2024/05/06 09:44:11.592 +00:00] [INFO] [table_import.go:861] ["checksum pass"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [local="{cksum=10068981574061626288,size=100,kvs=4}"]
[2024/05/06 09:44:11.592 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=10.779294ms] []
[2024/05/06 09:44:11.593 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=11.0632ms] []
[2024/05/06 09:44:11.662 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=77] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=post-process] [next-step=done]
[2024/05/06 09:44:11.662 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=77] [step=post-process] [state=running] []
[2024/05/06 09:44:11.666 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=77]
[2024/05/06 09:44:11.669 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=77] [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=170.800956ms] []
[2024/05/06 09:44:11.740 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=77] [type=ImportInto]
[2024/05/06 09:44:11.748 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=77]
[2024/05/06 09:44:11.790 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:44:11.791 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=77]
[2024/05/06 09:44:11.928 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:44:11.947 +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: 3.023306133\n# Parse_time: 0.001142045\n# Compile_time: 0.002418004\n# Rewrite_time: 0.000513374\n# Optimize_time: 0.000267602\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('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6My4wMnMsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6My4wMnMsIGxvb3BzOjJw//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:44:11.967 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=245] [cur_db=test_show_job] [sql="DROP DATABASE IF EXISTS import_into;"] [user=root@%]
[2024/05/06 09:44:12.090 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:347, Type:drop schema, State:queueing, SchemaState:public, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:44:12.091 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:347, Type:drop schema, State:queueing, SchemaState:public, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP DATABASE IF EXISTS import_into;"]
[2024/05/06 09:44:12.203 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=347] [conn=2] [category=ddl] [job="ID:347, Type:drop schema, State:queueing, SchemaState:public, SchemaID:208, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.273 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=245] [neededSchemaVersion=246] ["start time"=519.744µs] [gotSchemaVersion=246] [phyTblIDs="[214]"] [actionTypes="[2]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:44:12.295 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=347] [version=246]
[2024/05/06 09:44:12.320 +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=246] ["take time"=56.570357ms] [job="ID:347, Type:drop schema, State:running, SchemaState:write only, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.404 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=347] [conn=2] [category=ddl] [job="ID:347, Type:drop schema, State:running, SchemaState:write only, SchemaID:208, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.460 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=246] [neededSchemaVersion=247] ["start time"=362.68µs] [gotSchemaVersion=247] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:44:12.484 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=347] [version=247]
[2024/05/06 09:44:12.516 +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=247] ["take time"=63.092846ms] [job="ID:347, Type:drop schema, State:running, SchemaState:delete only, SchemaID:208, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.604 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=347] [conn=2] [category=ddl] [job="ID:347, Type:drop schema, State:running, SchemaState:delete only, SchemaID:208, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.668 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=247] [neededSchemaVersion=248] ["start time"=476.512µs] [gotSchemaVersion=248] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 09:44:12.691 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=347] [version=248]
[2024/05/06 09:44:12.718 +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=248] ["take time"=57.548534ms] [job="ID:347, Type:drop schema, State:done, SchemaState:none, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.879 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=347] [tableIDs="[214]"] [comment="drop schema: table IDs"]
[2024/05/06 09:44:12.897 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=347] [jobType="drop schema"]
[2024/05/06 09:44:12.905 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=347] [conn=2] [job="ID:347, Type:drop schema, State:synced, SchemaState:none, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:11.948 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:12.994 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=347]
[2024/05/06 09:44:12.994 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:44:13.001 +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.035225243\n# Parse_time: 0.000738382\n# Compile_time: 0.001435369\n# Rewrite_time: 0.000059756\n# Optimize_time: 0.002468096\n# Wait_TS: 0.000866833\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:44:13.004 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=248] [cur_db=test_show_job] [sql="CREATE DATABASE import_into;"] [user=root@%]
[2024/05/06 09:44:13.058 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:349, Type:create schema, State:queueing, SchemaState:none, SchemaID:348, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:12.999 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:44:13.058 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:349, Type:create schema, State:queueing, SchemaState:none, SchemaID:348, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:12.999 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE DATABASE import_into;"]
[2024/05/06 09:44:13.174 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=349] [conn=2] [category=ddl] [job="ID:349, Type:create schema, State:queueing, SchemaState:none, SchemaID:348, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:12.999 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:13.256 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=248] [neededSchemaVersion=249] ["start time"=2.119159ms] [gotSchemaVersion=249] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/06 09:44:13.274 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=349] [version=249]
[2024/05/06 09:44:13.292 +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=249] ["take time"=55.906772ms] [job="ID:349, Type:create schema, State:done, SchemaState:public, SchemaID:348, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 09:44:12.999 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:13.375 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=349] [conn=2] [job="ID:349, Type:create schema, State:synced, SchemaState:public, SchemaID:348, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:12.999 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:13.426 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=349]
[2024/05/06 09:44:13.426 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:44:13.435 +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.432870079\n# Parse_time: 0.000740473\n# Compile_time: 0.001595583\n# Rewrite_time: 0.000057463\n# Optimize_time: 0.002468096\n# Wait_TS: 0.00081192\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:44:13.438 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=249] [cur_db=test_show_job] [sql="create table import_into.zero_time_table(t datetime)"] [user=root@%]
[2024/05/06 09:44:13.603 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:351, Type:create table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 09:44:13.448 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:44:13.603 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:351, Type:create table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 09:44:13.448 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table import_into.zero_time_table(t datetime)"]
[2024/05/06 09:44:13.758 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=351] [conn=2] [category=ddl] [job="ID:351, Type:create table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:13.448 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:13.778 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 348, Table ID: 350, Table Name: zero_time_table"]
[2024/05/06 09:44:13.868 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=249] [neededSchemaVersion=250] ["start time"=4.399007ms] [gotSchemaVersion=250] [phyTblIDs="[350]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 09:44:13.887 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=351] [version=250]
[2024/05/06 09:44:13.921 +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=250] ["take time"=65.423665ms] [job="ID:351, Type:create table, State:done, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 09:44:13.448 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:14.017 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=351] [conn=2] [job="ID:351, Type:create table, State:synced, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:13.448 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:14.079 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=351]
[2024/05/06 09:44:14.079 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:44:14.088 +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.652416503\n# Parse_time: 0.000689547\n# Compile_time: 0.001377524\n# Rewrite_time: 0.000077054\n# Optimize_time: 0.002468096\n# Wait_TS: 0.001468644\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:44:14.124 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:14.452 +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:44:14.612 +00:00] [INFO] [job.go:110] ["job submitted to task queue"] [job-id=78] [task-id=78] [data-size=20B] [thread-cnt=8] [global-sort=false]
[2024/05/06 09:44:14.676 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=78]
[2024/05/06 09:44:14.676 +00:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [concurrency=8]
[2024/05/06 09:44:14.787 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=init] [next-step=import]
[2024/05/06 09:44:14.788 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:44:14.790 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=78] [curr-step=init] [next-step=import]
[2024/05/06 09:44:14.828 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:14.833 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 09:44:14.833 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 09:44:14.833 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=85.398µs]
[2024/05/06 09:44:14.833 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=277.109µs] []
[2024/05/06 09:44:14.834 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=78] [curr-step=init] [next-step=import] [subtask-count=1]
[2024/05/06 09:44:14.834 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [step=import] [concurrency=8] [subtasks=1]
[2024/05/06 09:44:15.094 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=78] [mode=Import]
[2024/05/06 09:44:15.129 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=78]
[2024/05/06 09:44:15.138 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=78] [type=ImportInto] [remaining-slots=44]
[2024/05/06 09:44:15.206 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=78] [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:44:15.207 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=78] [step=import]
[2024/05/06 09:44:15.209 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:15.227 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2384] [old-leader=]
[2024/05/06 09:44:15.227 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365818487622903632]
[2024/05/06 09:44:15.228 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:44:15.229 +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:2384]
[2024/05/06 09:44:15.230 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:44:15.233 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 09:44:15.233 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 09:44:15.234 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 09:44:15.234 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:44:15.261 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 09:44:15.263 +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:44:15.263 +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:44:15.264 +00:00] [INFO] [task_executor.go:115] ["KV writer memory size limit per concurrency"] [type=ImportInto] [task-id=78] [step=import] [data=315.1MiB] [per-index=105MiB]
[2024/05/06 09:44:15.266 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=78] [disk-quota=348.5GiB]
[2024/05/06 09:44:15.347 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=78] [step=import] [subtask-id=150]
[2024/05/06 09:44:15.353 +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:44:15.364 +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:44:15.364 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=350]
[2024/05/06 09:44:15.379 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=350] [key=zero_time.csv:0]
[2024/05/06 09:44:15.383 +00:00] [INFO] [chunk_process.go:334] ["process chunk completed"] [type=ImportInto] [table-id=350] [key=zero_time.csv:0] [readDur=2.019246ms] [encodeDur=1.186033ms] [checksum="{cksum=11665625846060223399,size=36,kvs=1}"] [deliverDur=467.488µs] [type=file] [takeTime=4.346409ms] []
[2024/05/06 09:44:15.384 +00:00] [INFO] [task_executor.go:125] ["run subtask completed"] [type=ImportInto] [task-id=78] [step=import] [subtask-id=150] [takeTime=37.631579ms] []
[2024/05/06 09:44:15.384 +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/78/b03a8272-790c-5766-99b7-2cad67f1945e.sst/f99ef7ef-ada5-4d6b-ab64-f13006eceac6.sst] [firstKey=74800000000000015E5F728000000000000001] [lastKey=74800000000000015E5F728000000000000001]
[2024/05/06 09:44:15.385 +00:00] [INFO] [task_executor.go:199] ["on subtask finished"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 09:44:15.385 +00:00] [INFO] [task_executor.go:213] ["import data engine"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 09:44:15.385 +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:44:15.388 +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=3.437362ms] []
[2024/05/06 09:44:15.388 +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:44:15.396 +00:00] [INFO] [local.go:1279] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 09:44:15.419 +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:44:15.420 +00:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 09:44:15.447 +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:44:15.450 +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=61.670341ms] []
[2024/05/06 09:44:15.450 +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:44:15.453 +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.844596ms] []
[2024/05/06 09:44:15.453 +00:00] [INFO] [task_executor.go:224] ["import index engine"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 09:44:15.453 +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:44:15.456 +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=2.592013ms] []
[2024/05/06 09:44:15.456 +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:44:15.456 +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:44:15.456 +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=134.551µs] []
[2024/05/06 09:44:15.456 +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:44:15.458 +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=1.393959ms] []
[2024/05/06 09:44:15.586 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=import] [next-step=post-process]
[2024/05/06 09:44:15.588 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:44:15.589 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=78] [curr-step=import] [next-step=post-process]
[2024/05/06 09:44:15.590 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=78] [curr-step=import] [next-step=post-process] [mode=Normal]
[2024/05/06 09:44:15.617 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=78] [step=import]
[2024/05/06 09:44:15.624 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:44:15.624 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:44:15.624 +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:44:15.624 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:44:15.624 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:44:15.624 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:44:15.624 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:44:15.624 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:44:15.624 +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:44:15.625 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:44:15.625 +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:44:15.625 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:15.625 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:44:15.628 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 09:44:15.628 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:44:15.629 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:44:15.629 +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:44:15.629 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:15.629 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=78] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"] [takeTime=422.554886ms] []
[2024/05/06 09:44:15.719 +00:00] [INFO] [scheduler.go:291] ["move to post-process step "] [type=ImportInto] [task-id=78] [curr-step=import] [next-step=post-process] [result="{\"LoadedRowCnt\":1,\"ColSizeMap\":{\"1\":8}}"]
[2024/05/06 09:44:15.721 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=78] [curr-step=import] [next-step=post-process] [subtask-count=1]
[2024/05/06 09:44:15.721 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=running] [step=post-process] [concurrency=8] [subtasks=1]
[2024/05/06 09:44:15.947 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=78] [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:44:16.036 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 09:44:16.036 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 09:44:16.036 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 09:44:16.054 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=17.348555ms] []
[2024/05/06 09:44:16.054 +00:00] [INFO] [subtask_executor.go:133] ["kv group checksum"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [groupId=-1] [size=36] [kvs=1] [checksum=11665625846060223399]
[2024/05/06 09:44:16.054 +00:00] [INFO] [table_import.go:835] ["local checksum"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [checksum="{cksum=11665625846060223399,size=36,kvs=1}"]
[2024/05/06 09:44:16.054 +00:00] [INFO] [table_import.go:950] ["set backoff weight"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [weight=30]
[2024/05/06 09:44:16.055 +00:00] [INFO] [table_import.go:901] ["checksum with adjusted distsql scan concurrency"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [concurrency=15]
[2024/05/06 09:44:16.063 +00:00] [INFO] [checksum.go:79] ["got one checksum result"] [tableID=350] [physicalTableID=350] [indexID=-1] [checksum=11665625846060223399] [totalKvs=1] [totalBytes=36]
[2024/05/06 09:44:16.064 +00:00] [INFO] [table_import.go:861] ["checksum pass"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [local="{cksum=11665625846060223399,size=36,kvs=1}"]
[2024/05/06 09:44:16.064 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=27.732106ms] []
[2024/05/06 09:44:16.064 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=28.021419ms] []
[2024/05/06 09:44:16.225 +00:00] [INFO] [task_executor.go:309] ["execute task step completed"] [task-id=78] [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=278.266046ms] []
[2024/05/06 09:44:16.245 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=78] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=post-process] [next-step=done]
[2024/05/06 09:44:16.246 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=78] [step=post-process] [state=running] []
[2024/05/06 09:44:16.250 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=78]
[2024/05/06 09:44:16.357 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=78]
[2024/05/06 09:44:16.385 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=78] [type=ImportInto]
[2024/05/06 09:44:16.398 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:44:16.398 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=78]
[2024/05/06 09:44:16.530 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 2.43630713\n# Parse_time: 0.000606101\n# Compile_time: 0.001603722\n# Rewrite_time: 0.000318674\n# Optimize_time: 0.002468096\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('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6Mi40M3MsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6Mi40M3MsIGxvb3BzOjJw//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:44:16.549 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:44:16.553 +00:00] [INFO] [session.go:3945] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=250] [cur_db=test_show_job] [sql="truncate table import_into.zero_time_table"] [user=root@%]
[2024/05/06 09:44:16.615 +00:00] [INFO] [ddl_worker.go:259] ["add DDL jobs"] [category=ddl] ["batch count"=1] [jobs="ID:353, Type:truncate table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:3, start time: 2024-05-06 09:44:16.548 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 09:44:16.615 +00:00] [INFO] [ddl.go:1182] ["start DDL job"] [category=ddl] [job="ID:353, Type:truncate table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:3, start time: 2024-05-06 09:44:16.548 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="truncate table import_into.zero_time_table"]
[2024/05/06 09:44:16.725 +00:00] [INFO] [ddl_worker.go:1185] ["run DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=353] [conn=2] [category=ddl] [job="ID:353, Type:truncate table, State:queueing, SchemaState:none, SchemaID:348, TableID:350, RowCount:0, ArgLen:0, start time: 2024-05-06 09:44:16.548 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:16.814 +00:00] [INFO] [ddl.go:78] ["Handle ddl event"] [category=stats] [event="(Event Type: truncate table, Schema ID: 348, Table ID: 352, Table Name: zero_time_table, Old Table ID: 350, Old Table Name: zero_time_table"]
[2024/05/06 09:44:16.892 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=250] [neededSchemaVersion=251] ["start time"=3.735562ms] [gotSchemaVersion=251] [phyTblIDs="[350,352]"] [actionTypes="[11,11]"] [diffTypes="[\"truncate table\"]"]
[2024/05/06 09:44:16.911 +00:00] [INFO] [domain.go:887] ["mdl gets lock, update self version to owner"] [jobID=353] [version=251]
[2024/05/06 09:44:16.937 +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=251] ["take time"=56.043496ms] [job="ID:353, Type:truncate table, State:done, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 09:44:16.548 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:17.033 +00:00] [INFO] [delete_range.go:447] ["insert into delete-range table"] [category=ddl] [jobID=353] [tableIDs="[350]"] [comment="drop table: table ID"]
[2024/05/06 09:44:17.051 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=353] [jobType="truncate table"]
[2024/05/06 09:44:17.057 +00:00] [INFO] [ddl_worker.go:743] ["finish DDL job"] [worker="worker 12, tp general"] [category=ddl] [jobID=353] [conn=2] [job="ID:353, Type:truncate table, State:synced, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 09:44:16.548 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 09:44:17.155 +00:00] [INFO] [ddl.go:1287] ["DDL job is finished"] [category=ddl] [jobID=353]
[2024/05/06 09:44:17.155 +00:00] [INFO] [callback.go:140] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 09:44:17.162 +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.611041011\n# Parse_time: 0.000562541\n# Compile_time: 0.001397729\n# Rewrite_time: 0.000054549\n# Optimize_time: 0.001819941\n# Wait_TS: 0.000800467\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:44:17.189 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:17.565 +00:00] [WARN] [adapter.go:1647] ["# Txn_start_ts: 0\n# Query_time: 0.316804141\n# Parse_time: 0\n# Compile_time: 0.004960047\n# Rewrite_time: 0.001022355\n# Optimize_time: 0.000948099\n# Wait_TS: 0\n# Is_internal: false\n# Digest: 9effb8e73ddb4addd727fcdab2ed4d7f312c611e9709931aec18b081eb7b81e6\n# Num_cop_tasks: 0\n# Mem_max: 225756\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: 3\n# Succ: true\n# IsExplicitTxn: false\n# IsSyncStatsFailed: false\n# Plan: tidb_decode_plan('9gHwTzAJM180CTAJODAwMAlDb2x1bW4jNAkzCXRpbWU6MzA5LjltcywgbG9vcHM6MiwgQ29uY3VycmVuY3k6NQkxNS41IEtCCU4vQQoxCTFfNQkwCUkIZXEoDUxMMywgInN0b3JhZ2UuZW5naW5lIikuXwAEMW0ZXyAJMjA0LjkgS0IFUSgyCTExXzYJMAkxMAGcuHRhYmxlOkNMVVNURVJfQ09ORklHLCBub2RlX3R5cGVzOlsidGlrdiJdCTIxMzYJBcAQMjgyLjgZYSQzCU4vQQlOL0EK')\n# Plan_digest: a5f0c0e455a8cac65b6a9db45b21993c76e17be51ff1d76d4ae8c4df44742533\n# Binary_plan: tidb_decode_binary_plan('5AJgCt8CCgxQcm9qZWN0aW9uXzQS+AEKC1NlbA0QVDUSigEKDk1lbVRhYmxlU2Nhbl82KQABAViIw0Aw2BA4AUABSiYKJAoSaW5mb3JtYQVG8EZzY2hlbWESDkNMVVNURVJfQ09ORklHUhNub2RlX3R5cGVzOlsidGlrdiJdWhV0aW1lOjI4Mi44bXMsIGxvb3BzOjNw/////wUDBAF4BQcBASQBIQAAAADgdB5BCYMQQL9AMAMBgnxSHmVxKENvbHVtbiMzLCAic3RvcmFnZS5lbmdpbmUiKQ1lEDMwOS4xGWUQMnDA5wwuXgAUmpmZmVmBRl4AAAgNWwA0HUgAOR1IeGINQ29uY3VycmVuY3k6NXCcfHj///////////8BGAE=')\n# Resource_group: default\nselect `value` from information_schema.cluster_config where type = 'tikv' and `key` = 'storage.engine';"]
[2024/05/06 09:44:17.565 +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:44:17.703 +00:00] [INFO] [job.go:110] ["job submitted to task queue"] [job-id=79] [task-id=79] [data-size=20B] [thread-cnt=8] [global-sort=false]
[2024/05/06 09:44:17.779 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=79]
[2024/05/06 09:44:17.780 +00:00] [INFO] [scheduler.go:120] ["schedule task"] [task-id=79] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [concurrency=8]
[2024/05/06 09:44:17.890 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=79] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=init] [next-step=import]
[2024/05/06 09:44:17.892 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=79] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 09:44:17.893 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=79] [curr-step=init] [next-step=import]
[2024/05/06 09:44:17.928 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:17.935 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 09:44:17.935 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 09:44:17.935 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=92.471µs]
[2024/05/06 09:44:17.935 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=296.713µs] []
[2024/05/06 09:44:17.935 +00:00] [INFO] [scheduler.go:318] ["generate subtasks"] [type=ImportInto] [task-id=79] [curr-step=init] [next-step=import] [subtask-count=1]
[2024/05/06 09:44:17.936 +00:00] [INFO] [scheduler.go:472] ["schedule subtasks"] [task-id=79] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [state=pending] [step=import] [concurrency=8] [subtasks=1]
[2024/05/06 09:44:18.191 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=79] [mode=Import]
[2024/05/06 09:44:18.229 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=79]
[2024/05/06 09:44:18.262 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=79] [type=ImportInto] [remaining-slots=44]
[2024/05/06 09:44:18.344 +00:00] [INFO] [task_executor.go:301] ["execute task step start"] [task-id=79] [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:44:18.345 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=79] [step=import]
[2024/05/06 09:44:18.347 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 09:44:18.363 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2384] [old-leader=]
[2024/05/06 09:44:18.363 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365818487622903632]
[2024/05/06 09:44:18.365 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:44:18.365 +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:2384]
[2024/05/06 09:44:18.367 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 09:44:18.367 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 09:44:18.367 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 09:44:18.367 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:44:18.367 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 09:44:18.392 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 09:44:18.394 +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:44:18.395 +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:44:18.395 +00:00] [INFO] [task_executor.go:115] ["KV writer memory size limit per concurrency"] [type=ImportInto] [task-id=79] [step=import] [data=315.1MiB] [per-index=105MiB]
[2024/05/06 09:44:18.396 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=79] [disk-quota=348.5GiB]
[2024/05/06 09:44:18.473 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=79] [step=import] [subtask-id=152]
[2024/05/06 09:44:18.479 +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:44:18.485 +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:44:18.485 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=352]
[2024/05/06 09:44:18.508 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=352] [key=zero_time.csv:0]
[2024/05/06 09:44:18.511 +00:00] [ERROR] [chunk_process.go:334] ["process chunk failed"] [type=ImportInto] [table-id=352] [key=zero_time.csv:0] [takeTime=3.256908ms] [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:44:18.512 +00:00] [ERROR] [task_executor.go:125] ["run subtask failed"] [type=ImportInto] [task-id=79] [step=import] [subtask-id=152] [takeTime=38.171934ms] [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:44:18.512 +00:00] [ERROR] [task_executor.go:549] [onError] [task-id=79] [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:44:18.513 +00:00] [ERROR] [task_executor.go:555] ["taskExecutor met first error"] [task-id=79] [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:44:18.513 +00:00] [WARN] [task_executor.go:640] ["subtask failed"] [task-id=79] [task-type=ImportInto] [server-id=:4000] [error="[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"]
[2024/05/06 09:44:18.514 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:44:18.514 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:44:18.514 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:44:18.514 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:44:18.514 +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:44:18.514 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:44:18.515 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:44:18.515 +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:44:18.553 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=79] [step=import]
[2024/05/06 09:44:18.559 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:44:18.559 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:44:18.559 +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:44:18.559 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:18.559 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:44:18.563 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 09:44:18.563 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:44:18.564 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:44:18.564 +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:44:18.564 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:18.564 +00:00] [INFO] [task_executor.go:309] ["execute task step failed"] [task-id=79] [task-type=ImportInto] [server-id=:4000] [step=import] [mem-limit-percent=0.7] [server-mem-limit=80%] [resource="[CPU=8, Mem=4.923GiB]"] [takeTime=219.944098ms] [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:44:18.564 +00:00] [ERROR] [task_executor.go:248] ["failed to handle task"] [task-id=79] [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:44:18.650 +00:00] [WARN] [scheduler.go:399] ["subtasks encounter errors"] [task-id=79] [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:44:18.709 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=79] [type=ImportInto]
[2024/05/06 09:44:18.724 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=79] [step=import] [state=reverting] [error="[types:1292]Incorrect datetime value: '1990-01-00 00:00:00'"]
[2024/05/06 09:44:18.725 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=79] [step=import] [mode=Normal]
[2024/05/06 09:44:18.816 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=79]
[2024/05/06 09:44:18.896 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=79]
[2024/05/06 09:44:18.943 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 09:44:18.943 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=79]
[2024/05/06 09:44:19.001 +00:00] [ERROR] [handle.go:109] ["task reverted"] [task-id=79] [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:44:19.003 +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.838953567\n# Parse_time: 0.000755667\n# Compile_time: 0.002316431\n# Rewrite_time: 0.000476384\n# Optimize_time: 0.001819941\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('LbAwCTU5XzIJMAkwCU4vQQkwCXRpbWU6MS44M3MsIGxvb3BzOjEJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('RsAKQgoMSW1wb3J0SW50b18yOAFAAVIDTi9BWhN0aW1lOjEuODNzLCBsb29wczoxcP//DQI0AXj///////////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:44:19.061 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.062 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.062 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [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:44:19.065 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] []
[2024/05/06 09:44:19.068 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:44:19.068 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 17, tp add index"] [category=ddl] ["take time"=42.611µs]
[2024/05/06 09:44:19.068 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 18, tp add index"] [category=ddl] ["take time"=29.637µs]
[2024/05/06 09:44:19.068 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 19, tp add index"] [category=ddl] ["take time"=18.326µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 20, tp add index"] [category=ddl] ["take time"=20.711µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 21, tp add index"] [category=ddl] ["take time"=18.895µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 22, tp add index"] [category=ddl] ["take time"=24.899µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 13, tp add index"] [category=ddl] ["take time"=26.106µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 14, tp add index"] [category=ddl] ["take time"=25.678µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 15, tp add index"] [category=ddl] ["take time"=20.531µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 16, tp add index"] [category=ddl] ["take time"=24.77µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_worker.go:186] ["DDL worker closed"] [worker="worker 12, tp general"] [category=ddl] ["take time"=17.172µs]
[2024/05/06 09:44:19.069 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 09:44:19.070 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl]
[2024/05/06 09:44:19.070 +00:00] [INFO] [session_pool.go:99] ["closing session pool"] [category=ddl]
[2024/05/06 09:44:19.073 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 09:44:19.121 +00:00] [INFO] [ddl.go:951] ["DDL closed"] [category=ddl] [ID=df405647-bac7-4c98-97b3-73d6582a77a7] ["take time"=105.865653ms]
[2024/05/06 09:44:19.121 +00:00] [INFO] [ddl.go:769] ["stop DDL"] [category=ddl] [ID=df405647-bac7-4c98-97b3-73d6582a77a7]
[2024/05/06 09:44:19.125 +00:00] [INFO] [domain.go:1026] ["stopping ttlJobManager"]
[2024/05/06 09:44:19.125 +00:00] [INFO] [runtime.go:190] ["TimerGroupRuntime loop exit"] [groupID=ttl]
[2024/05/06 09:44:19.125 +00:00] [INFO] [notifier.go:142] ["etcd watcher exited to watch timer events"] [EtcdKey=/tidb/timer/cluster/1/notify/ce090997-5a3e-4afc-b4fc-1092885753bc] [watcherID=5e078dfe-1397-4ff1-a60a-0801b0f37c0c]
[2024/05/06 09:44:19.125 +00:00] [INFO] [notifier.go:227] ["etcd notify loop to watch timer events stopped"] [EtcdKey=/tidb/timer/cluster/1/notify/ce090997-5a3e-4afc-b4fc-1092885753bc]
[2024/05/06 09:44:19.125 +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:44:19.126 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:44:19.126 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:44:19.126 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:44:19.126 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 09:44:19.126 +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:44:19.127 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:44:19.127 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:44:19.127 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:44:19.127 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 09:44:19.134 +00:00] [INFO] [job_manager.go:174] ["ttlJobManager loop exited."] [ttl-worker=job-manager]
[2024/05/06 09:44:19.134 +00:00] [INFO] [domain.go:1037] ["ttlJobManager exited."]
[2024/05/06 09:44:19.136 +00:00] [INFO] [domain.go:2817] ["releaseServerID succeed"] [serverID=1284]
[2024/05/06 09:44:19.136 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=mdlCheckLoop]
[2024/05/06 09:44:19.136 +00:00] [INFO] [domain.go:2492] ["analyzeJobsCleanupWorker exited."]
[2024/05/06 09:44:19.136 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSigningCertLoop]
[2024/05/06 09:44:19.136 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=analyzeJobsCleanupWorker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2352] ["indexUsageWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:907] ["loadSchemaInLoop exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=indexUsageWorker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSchemaInLoop]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:1542] ["stopping dist task scheduler manager because the current node is not DDL owner anymore"] [id=df405647-bac7-4c98-97b3-73d6582a77a7]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2105] ["HistoricalStatsWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=HistoricalStatsWorker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [scheduler_manager.go:318] ["subtask history table gc loop exits"] [server-id=:4000]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2040] ["PlanReplayerTaskDumpHandle exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskDumpHandle]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2323] ["loadStatsWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadStatsWorker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2074] ["dumpFileGcChecker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=dumpFileGcChecker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2450] ["autoAnalyzeWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=autoAnalyzeWorker]
[2024/05/06 09:44:19.137 +00:00] [INFO] [plan_replayer.go:413] ["planReplayerTaskDumpWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:737] ["globalConfigSyncerKeeper exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:44:19.137 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper]
[2024/05/06 09:44:19.137 +00:00] [INFO] [domain.go:2020] ["PlanReplayerTaskCollectHandle exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [domain.go:1700] ["loadPrivilegeInLoop exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskCollectHandle]
[2024/05/06 09:44:19.138 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadPrivilegeInLoop]
[2024/05/06 09:44:19.138 +00:00] [INFO] [domain.go:1750] ["LoadSysVarCacheLoop exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=LoadSysVarCacheLoop]
[2024/05/06 09:44:19.138 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [domain.go:2881] ["serverIDKeeper exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[log-backup] ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca watch owner key /tidb/br-stream/owner/22318f4d44151ebe"]
[2024/05/06 09:44:19.138 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[stats] ownerManager df405647-bac7-4c98-97b3-73d6582a77a7 watch owner key /tidb/stats/owner/3eaa8f4d44151ed0"]
[2024/05/06 09:44:19.138 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca"]
[2024/05/06 09:44:19.138 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 09:44:19.138 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop]
[2024/05/06 09:44:19.138 +00:00] [INFO] [domain.go:711] ["infoSyncerKeeper exited."]
[2024/05/06 09:44:19.139 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=infoSyncerKeeper]
[2024/05/06 09:44:19.138 +00:00] [INFO] [domain.go:761] ["topologySyncerKeeper exited."]
[2024/05/06 09:44:19.139 +00:00] [INFO] [scheduler_manager.go:379] ["cleanup loop exits"] [server-id=:4000]
[2024/05/06 09:44:19.139 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topologySyncerKeeper]
[2024/05/06 09:44:19.139 +00:00] [INFO] [scheduler_manager.go:459] ["collect loop exits"] [server-id=:4000]
[2024/05/06 09:44:19.138 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[stats] /tidb/stats/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.139 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.140 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[stats] /tidb/stats/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.140 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"]
[2024/05/06 09:44:19.139 +00:00] [INFO] [domain.go:2371] ["updateStatsWorker is going to exit, start to flush stats"]
[2024/05/06 09:44:19.140 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [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:44:19.139 +00:00] [INFO] [advancer.go:397] ["Meet task event"] [category="log backup advancer"] [event="Err(, err = EOF)"]
[2024/05/06 09:44:19.140 +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:44:19.140 +00:00] [INFO] [advancer.go:403] ["Task watcher exits due to some error."] [category="log backup advancer"] [error=EOF]
[2024/05/06 09:44:19.139 +00:00] [INFO] [scheduler_manager.go:206] ["schedule task loop exits"] [server-id=:4000]
[2024/05/06 09:44:19.141 +00:00] [INFO] [domain.go:1544] ["dist task scheduler manager stopped"] [id=df405647-bac7-4c98-97b3-73d6582a77a7]
[2024/05/06 09:44:19.141 +00:00] [INFO] [domain.go:1527] ["stopping dist task executor manager"]
[2024/05/06 09:44:19.141 +00:00] [INFO] [manager.go:280] ["recoverMetaLoop done"] [server-id=:4000]
[2024/05/06 09:44:19.142 +00:00] [INFO] [owner_daemon.go:87] ["daemon loop exits"] [id=b6736e39-15d6-426d-9dcb-4fcf268458ca] [daemon-id=LogBackup::Advancer]
[2024/05/06 09:44:19.142 +00:00] [INFO] [manager.go:292] ["failed to campaign"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca"] [error="context canceled"]
[2024/05/06 09:44:19.142 +00:00] [INFO] [flush_subscriber.go:109] [Clearing.] [category="log backup flush subscriber"] [timeout=1m0s]
[2024/05/06 09:44:19.143 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca"]
[2024/05/06 09:44:19.143 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca"] [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:44:19.142 +00:00] [INFO] [domain.go:683] ["topNSlowQueryLoop exited."]
[2024/05/06 09:44:19.142 +00:00] [INFO] [manager.go:179] ["handle tasks loop done"] [server-id=:4000]
[2024/05/06 09:44:19.143 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=logBackupAdvancer]
[2024/05/06 09:44:19.142 +00:00] [INFO] [domain.go:1361] ["closestReplicaReadCheckLoop exited."]
[2024/05/06 09:44:19.143 +00:00] [INFO] [domain.go:1529] ["dist task executor manager stopped"]
[2024/05/06 09:44:19.143 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop]
[2024/05/06 09:44:19.143 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topNSlowQueryLoop]
[2024/05/06 09:44:19.143 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=distTaskFrameworkLoop]
[2024/05/06 09:44:19.145 +00:00] [INFO] [domain.go:2373] ["updateStatsWorker ready to release owner"]
[2024/05/06 09:44:19.145 +00:00] [WARN] [etcd.go:78] ["failed to new session to etcd"] [ownerInfo="[stats] /tidb/stats/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [error="context canceled"]
[2024/05/06 09:44:19.346 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[stats] /tidb/stats/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [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:44:20.400 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager b6736e39-15d6-426d-9dcb-4fcf268458ca"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:44:20.411 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:44:20.411 +00:00] [INFO] [domain.go:1889] ["globalBindHandleWorkerLoop exited."]
[2024/05/06 09:44:20.412 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalBindHandleWorkerLoop]
[2024/05/06 09:44:20.621 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[stats] /tidb/stats/owner ownerManager df405647-bac7-4c98-97b3-73d6582a77a7"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 09:44:20.622 +00:00] [INFO] [domain.go:2379] ["updateStatsWorker exit preprocessing finished"]
[2024/05/06 09:44:20.622 +00:00] [INFO] [domain.go:2404] ["updateStatsWorker exited."]
[2024/05/06 09:44:20.622 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=updateStatsWorker]
[2024/05/06 09:44:20.635 +00:00] [INFO] [domain.go:1074] ["domain closed"] ["take time"=1.619571513s]
[2024/05/06 09:44:20.636 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 09:44:20.636 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 09:44:20.636 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 09:44:20.636 +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:44:20.636 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 09:44:20.636 +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:44:20.636 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 09:44:20.637 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 09:44:20.637 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 09:44:20.637 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 09:44:20.637 +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:44:20.637 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 09:44:20.637 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 09:44:20.639 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=tikv-driver]
--- PASS: TestImportInto (289.23s)
    --- SKIP: TestImportInto/TestAddIndexBySQL (0.00s)
    --- SKIP: TestImportInto/TestAnalyze (0.00s)
    --- PASS: TestImportInto/TestBasicImportInto (33.39s)
    --- PASS: TestImportInto/TestCancelJob (8.24s)
    --- PASS: TestImportInto/TestChecksumNotMatch (8.74s)
    --- PASS: TestImportInto/TestColumnsAndUserVars (3.21s)
    --- PASS: TestImportInto/TestDeliverBytesRows (5.64s)
    --- PASS: TestImportInto/TestDetachedLoadParquet (6.18s)
    --- PASS: TestImportInto/TestDiskQuota (9.77s)
    --- PASS: TestImportInto/TestGBK (9.70s)
    --- PASS: TestImportInto/TestGeneratedColumnsAndTSVFile (12.41s)
    --- PASS: TestImportInto/TestIgnoreNLines (9.90s)
    --- PASS: TestImportInto/TestImportIntoPrivilegePositiveCase (8.97s)
    --- PASS: TestImportInto/TestImportMode (19.91s)
    --- PASS: TestImportInto/TestInputCountMisMatchAndDefault (9.24s)
    --- PASS: TestImportInto/TestInputNull (5.24s)
    --- PASS: TestImportInto/TestJobFailWhenDispatchSubtask (2.25s)
    --- PASS: TestImportInto/TestKillBeforeFinish (3.13s)
    --- PASS: TestImportInto/TestLoadSQLDump (5.67s)
    --- PASS: TestImportInto/TestMaxWriteSpeed (15.37s)
    --- PASS: TestImportInto/TestMultiValueIndex (3.89s)
    --- PASS: TestImportInto/TestOtherCharset (17.43s)
    --- PASS: TestImportInto/TestPreCheckCDCPiTRTasks (5.84s)
    --- PASS: TestImportInto/TestPreCheckTableNotEmpty (2.07s)
    --- PASS: TestImportInto/TestPreCheckTotalFileSize0 (1.98s)
    --- PASS: TestImportInto/TestRegisterTask (12.70s)
    --- PASS: TestImportInto/TestSameBehaviourDetachedOrNot (14.03s)
    --- PASS: TestImportInto/TestShowDetachedJob (8.29s)
    --- PASS: TestImportInto/TestShowJob (12.23s)
    --- PASS: TestImportInto/TestZeroDateTime (7.04s)
PASS
coverage: 15.1% of statements
GCov does not exist at the given path: ''
May 06, 2024 9:44:28 AM com.google.devtools.coverageoutputgenerator.Main getTracefiles
INFO: No lcov file found.
May 06, 2024 9:44:28 AM com.google.devtools.coverageoutputgenerator.Main getGcovInfoFiles
INFO: No gcov info file found.
May 06, 2024 9:44:28 AM com.google.devtools.coverageoutputgenerator.Main getGcovJsonInfoFiles
INFO: No gcov json file found.
May 06, 2024 9:44:28 AM com.google.devtools.coverageoutputgenerator.Main getProfdataFileOrNull
INFO: No .profdata file found.
May 06, 2024 9:44:28 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: 353.767s, Critical Path: 332.60s
INFO: 1610 processes: 1584 remote cache hit, 20 internal, 6 linux-sandbox.
INFO: Build completed successfully, 1610 total actions
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
[1,549 / 1,550] Testing //tests/realtikvtest/addindextest:addindextest_test; 281s remote-cache, linux-sandbox
[2024-05-06T09:44:33.480Z] ['info'] 
     _____          _
    / ____|        | |
   | |     ___   __| | ___  ___ _____   __
   | |    / _ \ / _` |/ _ \/ __/ _ \ \ / /
   | |___| (_) | (_| |  __/ (_| (_) \ V /
    \_____\___/ \__,_|\___|\___\___/ \_/

  Codecov report uploader 0.5.0
[2024-05-06T09:44:33.482Z] ['info'] => Project root located at: .
[2024-05-06T09:44:33.486Z] ['info'] ->  Token found by environment variables
[2024-05-06T09:44:33.508Z] ['info'] Searching for coverage files...
[2024-05-06T09:44:34.542Z] ['info'] => Found 1 possible coverage files:
  ./coverage.dat
[2024-05-06T09:44:34.543Z] ['info'] Processing ./coverage.dat...
[2024-05-06T09:44:35.053Z] ['info'] Using manual override from args.
[2024-05-06T09:44:35.054Z] ['info'] Detected Jenkins CI as the CI provider.
[2024-05-06T09:44:35.073Z] ['info'] Pinging Codecov: https://codecov.io/upload/v4?package=uploader-0.5.0&token=*******&branch=origin%2Fpr%2F52663&build=8855&build_url=https%3A%2F%2Fdo.pingcap.net%2Fjenkins%2Fjob%2Fpingcap%2Fjob%2Ftidb%2Fjob%2Fghpr_check2%2F8855%2F&commit=764c03c5659efaf4dbc9b48d197d7ef1a765c4eb&job=&pr=52663&service=jenkins&slug=pingcap%2Ftidb&name=&tag=&flags=integration&parent=
[2024-05-06T09:44:36.084Z] ['info'] https://app.codecov.io/github/pingcap/tidb/commit/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb
https://storage.googleapis.com/codecov/v4/raw/2024-05-06/F6B65B6EE70BEC6C6B5E073ED3BB1A79/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb/561491ce-9404-4867-ad26-50a65b97f53b.txt?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=GOOG1EJOGFN2JQ4OCTGA2MU5AEIT7OT5Z7HTFOAN2SPG4NWSN2UJYOY5U6LZQ%2F20240506%2Fus-west2%2Fs3%2Faws4_request&X-Amz-Date=20240506T094435Z&X-Amz-Expires=10&X-Amz-SignedHeaders=host&X-Amz-Signature=f3a11e9b4978e98abf22614ae0b500f976f3baee30f7064118652bb35cdb49aa
[2024-05-06T09:44:36.085Z] ['info'] Uploading...
[2024-05-06T09:44:38.082Z] ['info'] {"status":"success","resultURL":"https://app.codecov.io/github/pingcap/tidb/commit/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb"}
[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/ddl/multi_schema_change.test: ok! 298 test cases passed, take time 63.156025919 s
./t/ddl/partition.test: ok! 213 test cases passed, take time 16.308642004 s
[1,549 / 1,550] Testing //tests/realtikvtest/addindextest:addindextest_test; 341s remote-cache, linux-sandbox
./t/ddl/primary_key_handle.test: ok! 191 test cases passed, take time 23.35251839 s
[1,549 / 1,550] Testing //tests/realtikvtest/addindextest:addindextest_test; 401s remote-cache, linux-sandbox
./t/ddl/reorg_partition.test: ok! 205 test cases passed, take time 58.147099574 s
./t/ddl/resource_group.test: ok! 16 test cases passed, take time 0.484154862 s
./t/ddl/sequence.test: ok! 268 test cases passed, take time 23.001254275 s
./t/ddl/serial.test: ok! 77 test cases passed, take time 8.052200808 s
[1,549 / 1,550] Testing //tests/realtikvtest/addindextest:addindextest_test; 458s remote-cache, linux-sandbox
Target //tests/realtikvtest/addindextest:addindextest_test up-to-date:
  bazel-bin/tests/realtikvtest/addindextest/addindextest_test_/addindextest_test
INFO: Elapsed time: 573.104s, Critical Path: 541.44s
INFO: 1538 processes: 1483 remote cache hit, 10 internal, 45 linux-sandbox.
INFO: Build completed successfully, 1538 total actions
Test cases: finished with 29 passing and 0 failing out of 29 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:47:22.815Z] ['info'] 
     _____          _
    / ____|        | |
   | |     ___   __| | ___  ___ _____   __
   | |    / _ \ / _` |/ _ \/ __/ _ \ \ / /
   | |___| (_) | (_| |  __/ (_| (_) \ V /
    \_____\___/ \__,_|\___|\___\___/ \_/

  Codecov report uploader 0.5.0
[2024-05-06T09:47:22.816Z] ['info'] => Project root located at: .
[2024-05-06T09:47:22.819Z] ['info'] ->  Token found by environment variables
[2024-05-06T09:47:22.831Z] ['info'] Searching for coverage files...
./t/ddl/table_modify.test: ok! 47 test cases passed, take time 2.884482285 s
[2024-05-06T09:47:23.352Z] ['info'] => Found 1 possible coverage files:
  ./coverage.dat
[2024-05-06T09:47:23.353Z] ['info'] Processing ./coverage.dat...
./t/executor/adapter.test: ok! 6 test cases passed, take time 0.158272075 s
[2024-05-06T09:47:23.726Z] ['info'] Using manual override from args.
[2024-05-06T09:47:23.727Z] ['info'] Detected Jenkins CI as the CI provider.
[2024-05-06T09:47:23.740Z] ['info'] Pinging Codecov: https://codecov.io/upload/v4?package=uploader-0.5.0&token=*******&branch=origin%2Fpr%2F52663&build=8855&build_url=https%3A%2F%2Fdo.pingcap.net%2Fjenkins%2Fjob%2Fpingcap%2Fjob%2Ftidb%2Fjob%2Fghpr_check2%2F8855%2F&commit=764c03c5659efaf4dbc9b48d197d7ef1a765c4eb&job=&pr=52663&service=jenkins&slug=pingcap%2Ftidb&name=&tag=&flags=integration&parent=
[2024-05-06T09:47:24.545Z] ['info'] https://app.codecov.io/github/pingcap/tidb/commit/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb
https://storage.googleapis.com/codecov/v4/raw/2024-05-06/F6B65B6EE70BEC6C6B5E073ED3BB1A79/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb/04b26012-9286-481d-bfde-4b72f1c8cba1.txt?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=GOOG1EJOGFN2JQ4OCTGA2MU5AEIT7OT5Z7HTFOAN2SPG4NWSN2UJYOY5U6LZQ%2F20240506%2Fus-west2%2Fs3%2Faws4_request&X-Amz-Date=20240506T094724Z&X-Amz-Expires=10&X-Amz-SignedHeaders=host&X-Amz-Signature=d85eeea100df62aa7c702522dc013b4da0cc392bce1b731270004e0a04fd433c
[2024-05-06T09:47:24.546Z] ['info'] Uploading...
[2024-05-06T09:47:26.276Z] ['info'] {"status":"success","resultURL":"https://app.codecov.io/github/pingcap/tidb/commit/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb"}
[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/admin.test: ok! 171 test cases passed, take time 54.431160007 s
./t/executor/aggregate.test: ok! 886 test cases passed, take time 33.484165985 s
./t/executor/analyze.test: ok! 180 test cases passed, take time 37.970379503 s
./t/executor/autoid.test: ok! 442 test cases passed, take time 18.828790669 s
./t/executor/batch_point_get.test: ok! 85 test cases passed, take time 3.311417736 s
./t/executor/charset.test: ok! 57 test cases passed, take time 2.501153204 s
./t/executor/chunk_reuse.test: ok! 93 test cases passed, take time 0.795299078 s
./t/executor/cluster_table.test: ok! 36 test cases passed, take time 0.639629455 s
./t/executor/compact_table.test: ok! 19 test cases passed, take time 0.788522528 s
./t/executor/cte.test: ok! 133 test cases passed, take time 3.603186068 s
./t/executor/ddl.test: ok! 359 test cases passed, take time 47.430442872 s
./t/executor/delete.test: ok! 71 test cases passed, take time 3.013887996 s
./t/executor/distsql.test: ok! 61 test cases passed, take time 4.686409688 s
./t/executor/executor.test: ok! 2151 test cases passed, take time 112.60456843 s
./t/executor/executor_txn.test: ok! 121 test cases passed, take time 1.311816304 s
./t/executor/explain.test: ok! 120 test cases passed, take time 4.176077142 s
./t/executor/explainfor.test: ok! 378 test cases passed, take time 7.364252665 s
./t/executor/foreign_key.test: ok! 318 test cases passed, take time 25.856058684 s
./t/executor/grant.test: ok! 202 test cases passed, take time 3.436000625 s
./t/executor/import_into.test: ok! 88 test cases passed, take time 0.391139811 s
./t/executor/index_advise.test: ok! 30 test cases passed, take time 0.439963089 s
./t/executor/index_lookup_join.test: ok! 190 test cases passed, take time 9.725939395 s
./t/executor/index_lookup_merge_join.test: ok! 83 test cases passed, take time 5.385047766 s
./t/executor/index_merge_reader.test: ok! 244 test cases passed, take time 24.001900824 s
./t/executor/infoschema_reader.test: ok! 174 test cases passed, take time 12.085713354 s
./t/executor/insert.test: ok! 1224 test cases passed, take time 117.06654335 s
./t/executor/inspection_common.test: ok! 4 test cases passed, take time 0.003004993 s
./t/executor/issues.test: ok! 421 test cases passed, take time 23.218952698 s
./t/executor/jointest/hash_join.test: ok! 137 test cases passed, take time 12.118763297 s
./t/executor/jointest/join.test: ok! 866 test cases passed, take time 37.615147093 s
./t/executor/kv.test: ok! 16 test cases passed, take time 0.166569434 s
./t/executor/merge_join.test: ok! 259 test cases passed, take time 9.007128479 s
./t/executor/parallel_apply.test: ok! 96 test cases passed, take time 3.099390721 s
./t/executor/partition/global_index.test: ok! 94 test cases passed, take time 14.940192584 s
./t/executor/partition/issues.test: ok! 154 test cases passed, take time 6.05637495 s
./t/executor/partition/partition_boundaries.test: ok! 1035 test cases passed, take time 2.650547194 s
./t/executor/partition/partition_with_expression.test: ok! 298 test cases passed, take time 3.794581759 s
./t/executor/partition/table.test: ok! 224 test cases passed, take time 12.909515435 s
./t/executor/partition/write.test: ok! 355 test cases passed, take time 13.228226437 s
./t/executor/password_management.test: ok! 381 test cases passed, take time 3.264140179 s
./t/executor/point_get.test: ok! 273 test cases passed, take time 6.014266139 s
./t/executor/prepared.test: ok! 214 test cases passed, take time 3.167809297 s
./t/executor/revoke.test: ok! 65 test cases passed, take time 1.066573342 s
./t/executor/rowid.test: ok! 63 test cases passed, take time 0.959925645 s
./t/executor/sample.test: ok! 105 test cases passed, take time 14.459045763 s
./t/executor/set.test: ok! 228 test cases passed, take time 0.504975461 s
./t/executor/show.test: ok! 301 test cases passed, take time 16.278247477 s
./t/executor/simple.test: ok! 303 test cases passed, take time 2.990415173 s
./t/executor/split_table.test: ok! 60 test cases passed, take time 14.732665318 s
./t/executor/stale_txn.test: ok! 28 test cases passed, take time 1.442327165 s
./t/executor/statement_context.test: ok! 63 test cases passed, take time 0.435687763 s
./t/executor/union_scan.test: ok! 231 test cases passed, take time 4.157810538 s
./t/executor/update.test: ok! 513 test cases passed, take time 12.188603359 s
./t/executor/window.test: ok! 22 test cases passed, take time 0.288254234 s
./t/executor/write.test: ok! 1079 test cases passed, take time 34.053759502 s
./t/explain-non-select-stmt.test: ok! 8 test cases passed, take time 0.083316127 s
./t/explain.test: ok! 21 test cases passed, take time 0.57030934 s
./t/explain_complex.test: ok! 41 test cases passed, take time 1.81762749 s
./t/explain_complex_stats.test: ok! 61 test cases passed, take time 4.6104881970000005 s
./t/explain_cte.test: ok! 53 test cases passed, take time 1.246909505 s
./t/explain_easy.test: ok! 190 test cases passed, take time 6.158334622 s
./t/explain_easy_stats.test: ok! 50 test cases passed, take time 1.496559827 s
./t/explain_foreign_key.test: ok! 41 test cases passed, take time 2.089630484 s
./t/explain_generate_column_substitute.test: ok! 233 test cases passed, take time 30.962683957 s
./t/explain_indexmerge_stats.test: ok! 30 test cases passed, take time 5.536977956 s
./t/explain_join_stats.test: ok! 8 test cases passed, take time 0.374379081 s
./t/explain_shard_index.test: ok! 19 test cases passed, take time 0.398083956 s
./t/explain_stats.test: ok! 10 test cases passed, take time 0.166291097 s
./t/explain_union_scan.test: ok! 9 test cases passed, take time 0.251328748 s
./t/expression/builtin.test: ok! 1332 test cases passed, take time 23.982145946 s
./t/expression/cast.test: ok! 50 test cases passed, take time 0.811372724 s
./t/expression/charset_and_collation.test: ok! 706 test cases passed, take time 32.123724176 s
./t/expression/constant_fold.test: ok! 12 test cases passed, take time 0.187259369 s
./t/expression/enum_set.test: ok! 13 test cases passed, take time 0.264308688 s
./t/expression/explain.test: ok! 77 test cases passed, take time 0.682698771 s
./t/expression/issues.test: ok! 1502 test cases passed, take time 58.183422526 s
./t/expression/json.test: ok! 223 test cases passed, take time 2.586164774 s
./t/expression/misc.test: ok! 404 test cases passed, take time 13.809210253 s
./t/expression/multi_valued_index.test: ok! 314 test cases passed, take time 10.969550648 s
./t/expression/plan_cache.test: ok! 184 test cases passed, take time 2.049033973 s
./t/expression/time.test: ok! 279 test cases passed, take time 2.458334271 s
./t/expression/vitess_hash.test: ok! 17 test cases passed, take time 2.063323901 s
./t/generated_columns.test: ok! 70 test cases passed, take time 6.895627241 s
./t/globalindex/mem_index_lookup.test: ok! 29 test cases passed, take time 0.356643099 s
./t/globalindex/mem_index_reader.test: ok! 25 test cases passed, take time 0.363109291 s
./t/globalindex/update.test: ok! 14 test cases passed, take time 0.35125145 s
./t/imdbload.test: ok! 63 test cases passed, take time 11.429863597 s
./t/index_join.test: ok! 22 test cases passed, take time 1.119675617 s
./t/index_merge.test: ok! 145 test cases passed, take time 4.301092623 s
./t/infoschema/cluster_tables.test: ok! 9 test cases passed, take time 0.103708778 s
./t/infoschema/infoschema.test: ok! 49 test cases passed, take time 1.8366762620000001 s
./t/infoschema/tables.test: ok! 120 test cases passed, take time 2.564584654 s
./t/infoschema/v2.test: ok! 30 test cases passed, take time 1.612024768 s
./t/naaj.test: ok! 134 test cases passed, take time 0.718343514 s
./t/new_character_set.test: ok! 61 test cases passed, take time 1.227480909 s
./t/new_character_set_builtin.test: ok! 217 test cases passed, take time 3.622265075 s
./t/new_character_set_invalid.test: ok! 28 test cases passed, take time 0.934529075 s
./t/parser/integration.test: ok! 8 test cases passed, take time 0.301268571 s
./t/partition.test: ok! 3 test cases passed, take time 0.812674017 s
./t/planner/cardinality/selectivity.test: ok! 683 test cases passed, take time 3.173195814 s
./t/planner/cardinality/trace.test: ok! 5 test cases passed, take time 0.2092376 s
./t/planner/cascades/integration.test: ok! 246 test cases passed, take time 2.545401151 s
./t/planner/core/binary_plan.test: ok! 6 test cases passed, take time 0.000907768 s
./t/planner/core/casetest/expression_rewriter.test: ok! 23 test cases passed, take time 0.354858646 s
./t/planner/core/casetest/hint/hint.test: ok! 182 test cases passed, take time 5.972043347 s
./t/planner/core/casetest/index/index.test: ok! 225 test cases passed, take time 6.383750431 s
./t/planner/core/casetest/integration.test: ok! 459 test cases passed, take time 10.317581078 s
./t/planner/core/casetest/partition/integration_partition.test: ok! 138 test cases passed, take time 2.9072657360000003 s
./t/planner/core/casetest/partition/partition_pruner.test: ok! 275 test cases passed, take time 3.325668751 s
./t/planner/core/casetest/physicalplantest/physical_plan.test: ok! 852 test cases passed, take time 8.897333062 s
./t/planner/core/casetest/point_get_plan.test: ok! 52 test cases passed, take time 0.393961082 s
./t/planner/core/casetest/predicate_simplification.test: ok! 29 test cases passed, take time 0.280261424 s
./t/planner/core/casetest/pushdown/push_down.test: ok! 35 test cases passed, take time 0.242154763 s
./t/planner/core/casetest/rule/rule_derive_topn_from_window.test: ok! 73 test cases passed, take time 1.087977205 s
./t/planner/core/casetest/rule/rule_join_reorder.test: ok! 481 test cases passed, take time 10.425875411 s
./t/planner/core/casetest/rule/rule_result_reorder.test: ok! 87 test cases passed, take time 1.513308025 s
./t/planner/core/cbo.test: ok! 34 test cases passed, take time 0.923209314 s
./t/planner/core/enforce_mpp.test: ok! 8 test cases passed, take time 0.001323126 s
./t/planner/core/expression_rewriter.test: ok! 206 test cases passed, take time 4.972634234 s
./t/planner/core/indexjoin.test: ok! 41 test cases passed, take time 0.282067353 s
./t/planner/core/indexmerge_intersection.test: ok! 6 test cases passed, take time 0.07321161 s
./t/planner/core/indexmerge_path.test: ok! 231 test cases passed, take time 6.097352443 s
./t/planner/core/integration.test: ok! 1623 test cases passed, take time 46.642328142 s
./t/planner/core/integration_partition.test: ok! 498 test cases passed, take time 28.559635431 s
./t/planner/core/issuetest/planner_issue.test: ok! 89 test cases passed, take time 3.049412502 s
./t/planner/core/memtable_predicate_extractor.test: ok! 45 test cases passed, take time 0.314522135 s
./t/planner/core/partition_pruner.test: ok! 643 test cases passed, take time 5.468923617 s
./t/planner/core/physical_plan.test: ok! 43 test cases passed, take time 1.100883973 s
./t/planner/core/plan.test: ok! 157 test cases passed, take time 3.022635321 s
./t/planner/core/plan_cache.test: ok! 1243 test cases passed, take time 17.288030427 s
./t/planner/core/plan_cost_ver2.test: ok! 70 test cases passed, take time 0.833817266 s
./t/planner/core/point_get_plan.test: ok! 265 test cases passed, take time 4.036303712 s
./t/planner/core/preprocess.test: ok! 6 test cases passed, take time 0.122561457 s
./t/planner/core/range_scan_for_like.test: ok! 183 test cases passed, take time 0.838840314 s
./t/planner/core/rule_constant_propagation.test: ok! 31 test cases passed, take time 1.471289952 s
./t/planner/core/rule_join_reorder.test: ok! 52 test cases passed, take time 1.8577346399999999 s
./t/planner/core/rule_result_reorder.test: ok! 29 test cases passed, take time 0.398854049 s
./t/planner/core/tests/prepare/issue.test: ok! 321 test cases passed, take time 3.605024625 s
./t/planner/core/tests/prepare/prepare.test: ok! 458 test cases passed, take time 5.4251043899999996 s
./t/planner/funcdep/only_full_group_by.test: ok! 142 test cases passed, take time 5.798295347 s
./t/privilege/privileges.test: ok! 411 test cases passed, take time 6.544903467 s
./t/select.test: ok! 189 test cases passed, take time 3.544911088 s
./t/session/bootstrap_upgrade.test: ok! 29 test cases passed, take time 0.344924211 s
./t/session/clustered_index.test: ok! 385 test cases passed, take time 24.575729347 s
./t/session/common.test: ok! 203 test cases passed, take time 8.12914897 s
./t/session/nontransactional.test: ok! 1532 test cases passed, take time 19.12802082 s
./t/session/privileges.test: ok! 66 test cases passed, take time 1.350437592 s
./t/session/session.test: ok! 101 test cases passed, take time 5.465155491 s
./t/session/temporary_table.test: ok! 277 test cases passed, take time 0.575916051 s
./t/session/txn.test: ok! 14 test cases passed, take time 0.068508454 s
./t/session/variable.test: ok! 113 test cases passed, take time 0.38620317 s
./t/session/vars.test: ok! 127 test cases passed, take time 0.12548385 s
./t/sessionctx/setvar.test: ok! 681 test cases passed, take time 0.196158545 s
./t/sessiontxn/externals.test: ok! 56 test cases passed, take time 0.431014959 s
./t/statistics/handle.test: ok! 60 test cases passed, take time 6.302046692 s
./t/statistics/integration.test: ok! 19 test cases passed, take time 0.260906187 s
./t/statistics/lock_table_stats.test: ok! 47 test cases passed, take time 1.178565642 s
./t/subquery.test: ok! 32 test cases passed, take time 0.86422621 s
./t/table/cache.test: ok! 108 test cases passed, take time 9.277418813 s
./t/table/index.test: ok! 34 test cases passed, take time 3.988030084 s
./t/table/partition.test: ok! 229 test cases passed, take time 8.807471028 s
./t/table/tables.test: ok! 6 test cases passed, take time 0.067607146 s
./t/table/temptable.test: ok! 11 test cases passed, take time 0.129146283 s
./t/topn_push_down.test: ok! 20 test cases passed, take time 0.414437881 s
./t/topn_pushdown.test: ok! 2 test cases passed, take time 0.000538305 s
./t/tpch.test: ok! 41 test cases passed, take time 2.444901606 s
./t/types/const.test: ok! 143 test cases passed, take time 3.047885839 s
./t/util/admin.test: ok! 240 test cases passed, take time 30.363214282 s
./t/util/ranger.test: ok! 188 test cases passed, take time 4.097879596 s
./t/window_function.test: ok! 28 test cases passed, take time 0.196677711 s

Great, All tests passed
integrationtest passed!
./run-tests.sh: line 1: kill: (1608) - No such process
~/agent/workspace/pingcap/tidb/ghpr_check2/tidb
[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] script
[Pipeline] {
[Pipeline] sh
No test report files were found. Configuration error?
[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] }
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh SUCCESS result.json
http://fileserver.pingcap.net
--2024-05-06 10:11:03--  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% 78.8M=0s

2024-05-06 10:11:03 (78.8 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] sh
+ echo done
+ curl -F ci_check/pingcap/tidb/ghpr_check2/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb=@done http://fileserver.pingcap.net/upload
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed

  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100   410  100   139  100   271   4471   8718 --:--:-- --:--:-- --:--:--  8741
{"msg":"success","url":"http://fileserver.pingcap.net/download/ci_check/pingcap/tidb/ghpr_check2/764c03c5659efaf4dbc9b48d197d7ef1a765c4eb"}
[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
Finished: SUCCESS