Skip to content

Console Output

Skipping 10,035 KB.. Full Log
[2024/05/06 02:36:58.815 +00:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:1] [engineUUID=69537677-8c9a-533f-9f7f-fb34aa20f14c] [retryCnt=0]
[2024/05/06 02:36:58.821 +00:00] [INFO] [local.go:1279] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 02:36:58.843 +00:00] [INFO] [local.go:1317] ["start import engine"] [category=ddl-ingest] [uuid=69537677-8c9a-533f-9f7f-fb34aa20f14c] ["region ranges"=1] [count=2] [size=50]
[2024/05/06 02:36:58.843 +00:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 02:36:58.863 +00:00] [INFO] [local.go:1328] ["import engine success"] [category=ddl-ingest] [uuid=69537677-8c9a-533f-9f7f-fb34aa20f14c] [size=50] [kvs=2] [importedSize=50] [importedCount=2]
[2024/05/06 02:36:58.865 +00:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:1] [engineUUID=69537677-8c9a-533f-9f7f-fb34aa20f14c] [retryCnt=0] [takeTime=50.03237ms] []
[2024/05/06 02:36:58.865 +00:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:1] [engineUUID=69537677-8c9a-533f-9f7f-fb34aa20f14c]
[2024/05/06 02:36:58.866 +00:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:1] [engineUUID=69537677-8c9a-533f-9f7f-fb34aa20f14c] [takeTime=1.084473ms] []
[2024/05/06 02:36:58.866 +00:00] [INFO] [task_executor.go:224] ["import index engine"] [type=ImportInto] [task-id=77] [step=import] [engine-id=1]
[2024/05/06 02:36:58.867 +00:00] [INFO] [backend.go:330] ["engine close start"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50]
[2024/05/06 02:36:58.868 +00:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50] [takeTime=1.600467ms] []
[2024/05/06 02:36:58.868 +00:00] [INFO] [backend.go:372] ["import start"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50] [retryCnt=0]
[2024/05/06 02:36:58.868 +00:00] [INFO] [local.go:1257] ["engine contains no kv, skip import"] [category=ddl-ingest] [engine=6a110035-0122-50d7-a258-9acbba47ee50]
[2024/05/06 02:36:58.868 +00:00] [INFO] [backend.go:378] ["import completed"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50] [retryCnt=0] [takeTime=90.261µs] []
[2024/05/06 02:36:58.868 +00:00] [INFO] [backend.go:391] ["cleanup start"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50]
[2024/05/06 02:36:58.870 +00:00] [INFO] [backend.go:393] ["cleanup completed"] [category=ddl-ingest] [engineTag=`test_show_job`.`t3`:-2] [engineUUID=6a110035-0122-50d7-a258-9acbba47ee50] [takeTime=1.04916ms] []
[2024/05/06 02:36:59.034 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=77] [step=import]
[2024/05/06 02:36:59.040 +00:00] [INFO] [scheduler.go:422] ["switch to next step"] [task-id=77] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [current-step=import] [next-step=post-process]
[2024/05/06 02:36:59.041 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 02:36:59.041 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 02:36:59.041 +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 02:36:59.041 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [scheduler.go:446] ["eligible instances"] [task-id=77] [task-type=ImportInto] [allocated-slots=true] [server-id=:4000] [num=1]
[2024/05/06 02:36:59.041 +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 02:36:59.041 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:36:59.041 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 02:36:59.042 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=77] [curr-step=import] [next-step=post-process]
[2024/05/06 02:36:59.042 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=77] [curr-step=import] [next-step=post-process] [mode=Normal]
[2024/05/06 02:36:59.043 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 02:36:59.043 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:36:59.043 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:36:59.043 +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 02:36:59.043 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:36:59.043 +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=690.642142ms] []
[2024/05/06 02:36:59.126 +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 02:36:59.127 +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 02:36:59.127 +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 02:36:59.237 +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 02:36:59.278 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 02:36:59.278 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 02:36:59.278 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149]
[2024/05/06 02:36:59.278 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=8.887µs] []
[2024/05/06 02:36:59.278 +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 02:36:59.278 +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 02:36:59.278 +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 02:36:59.278 +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 02:36:59.282 +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 02:36:59.283 +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 02:36:59.283 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=4.79513ms] []
[2024/05/06 02:36:59.283 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=77] [step=post-process] [subtask-id=149] [takeTime=4.975094ms] []
[2024/05/06 02:36:59.323 +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=85.747189ms] []
[2024/05/06 02:36:59.393 +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 02:36:59.394 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=77] [step=post-process] [state=running] []
[2024/05/06 02:36:59.396 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=77]
[2024/05/06 02:36:59.443 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=77] [type=ImportInto]
[2024/05/06 02:36:59.479 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=77]
[2024/05/06 02:36:59.489 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: test_show_job2[test_show_job2] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 1.854308914\n# Parse_time: 0.000639582\n# Compile_time: 0.001390262\n# Rewrite_time: 0.000302757\n# Optimize_time: 0.000129236\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('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6MS44NXMsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6MS44NXMsIGxvb3BzOjJw//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 02:36:59.499 +00:00] [INFO] [session.go:3889] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=245] [cur_db=test_show_job] [sql="DROP DATABASE IF EXISTS import_into;"] [user=root@%]
[2024/05/06 02:36:59.503 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 02:36:59.503 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=77]
[2024/05/06 02:36:59.528 +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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 02:36:59.528 +00:00] [INFO] [ddl.go:1181] ["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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="DROP DATABASE IF EXISTS import_into;"]
[2024/05/06 02:36:59.584 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 02:36:59.585 +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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:36:59.616 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=245] [neededSchemaVersion=246] ["start time"=255.669µs] [gotSchemaVersion=246] [phyTblIDs="[214]"] [actionTypes="[2]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 02:36:59.625 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=347] [version=246]
[2024/05/06 02:36:59.666 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=246] ["take time"=53.555951ms] [job="ID:347, Type:drop schema, State:running, SchemaState:write only, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:36:59.805 +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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:36:59.835 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=246] [neededSchemaVersion=247] ["start time"=237.711µs] [gotSchemaVersion=247] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 02:36:59.844 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=347] [version=247]
[2024/05/06 02:36:59.884 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=247] ["take time"=53.886878ms] [job="ID:347, Type:drop schema, State:running, SchemaState:delete only, SchemaID:208, TableID:0, RowCount:0, ArgLen:0, start time: 2024-05-06 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:36:59.917 +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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:36:59.949 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=247] [neededSchemaVersion=248] ["start time"=182.058µs] [gotSchemaVersion=248] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"drop schema\"]"]
[2024/05/06 02:36:59.959 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=347] [version=248]
[2024/05/06 02:36:59.998 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=248] ["take time"=52.719987ms] [job="ID:347, Type:drop schema, State:done, SchemaState:none, SchemaID:208, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.060 +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 02:37:00.070 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=347] [jobType="drop schema"]
[2024/05/06 02:37:00.073 +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 02:36:59.466 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.115 +00:00] [INFO] [ddl.go:1286] ["DDL job is finished"] [category=ddl] [jobID=347]
[2024/05/06 02:37:00.115 +00:00] [INFO] [callback.go:139] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 02:37:00.118 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.620299822\n# Parse_time: 0.000489892\n# Compile_time: 0.000610414\n# Rewrite_time: 0.000031441\n# Optimize_time: 0.001205141\n# Wait_TS: 0.000287092\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 02:37:00.120 +00:00] [INFO] [session.go:3889] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=248] [cur_db=test_show_job] [sql="CREATE DATABASE import_into;"] [user=root@%]
[2024/05/06 02:37:00.149 +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 02:37:00.116 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 02:37:00.149 +00:00] [INFO] [ddl.go:1181] ["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 02:37:00.116 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="CREATE DATABASE import_into;"]
[2024/05/06 02:37:00.203 +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 02:37:00.116 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.279 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=248] [neededSchemaVersion=249] ["start time"=1.431838ms] [gotSchemaVersion=249] [phyTblIDs="[]"] [actionTypes="[]"] [diffTypes="[\"create schema\"]"]
[2024/05/06 02:37:00.290 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=349] [version=249]
[2024/05/06 02:37:00.325 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=249] ["take time"=53.605711ms] [job="ID:349, Type:create schema, State:done, SchemaState:public, SchemaID:348, TableID:0, RowCount:0, ArgLen:1, start time: 2024-05-06 02:37:00.116 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.387 +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 02:37:00.116 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.411 +00:00] [INFO] [ddl.go:1286] ["DDL job is finished"] [category=ddl] [jobID=349]
[2024/05/06 02:37:00.412 +00:00] [INFO] [callback.go:139] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 02:37:00.417 +00:00] [INFO] [session.go:3889] ["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 02:37:00.457 +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 02:37:00.416 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 02:37:00.457 +00:00] [INFO] [ddl.go:1181] ["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 02:37:00.416 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="create table import_into.zero_time_table(t datetime)"]
[2024/05/06 02:37:00.496 +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 02:37:00.416 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.503 +00:00] [INFO] [ddl.go:73] ["Handle ddl event"] [category=stats] [event="(Event Type: create table, Schema ID: 348, Table ID: 350, Table Name: zero_time_table"]
[2024/05/06 02:37:00.547 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=249] [neededSchemaVersion=250] ["start time"=2.341601ms] [gotSchemaVersion=250] [phyTblIDs="[350]"] [actionTypes="[3]"] [diffTypes="[\"create table\"]"]
[2024/05/06 02:37:00.558 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=351] [version=250]
[2024/05/06 02:37:00.594 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=250] ["take time"=53.553473ms] [job="ID:351, Type:create table, State:done, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 02:37:00.416 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.710 +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 02:37:00.416 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:00.741 +00:00] [INFO] [ddl.go:1286] ["DDL job is finished"] [category=ddl] [jobID=351]
[2024/05/06 02:37:00.742 +00:00] [INFO] [callback.go:139] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 02:37:00.745 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.329864517\n# Parse_time: 0.00062968\n# Compile_time: 0.001086788\n# Rewrite_time: 0.00006468\n# Optimize_time: 0.001205141\n# Wait_TS: 0.000409921\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 02:37:00.761 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:00.931 +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 02:37:01.005 +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 02:37:01.101 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=78]
[2024/05/06 02:37:01.102 +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 02:37:01.210 +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 02:37:01.211 +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 02:37:01.212 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=78] [curr-step=init] [next-step=import]
[2024/05/06 02:37:01.233 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:01.237 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 02:37:01.238 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 02:37:01.238 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=85.203µs]
[2024/05/06 02:37:01.238 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=243.689µs] []
[2024/05/06 02:37:01.238 +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 02:37:01.238 +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 02:37:01.345 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=78] [mode=Import]
[2024/05/06 02:37:01.363 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=78] [type=ImportInto] [remaining-slots=44]
[2024/05/06 02:37:01.368 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=78]
[2024/05/06 02:37:01.401 +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 02:37:01.402 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=78] [step=import]
[2024/05/06 02:37:01.403 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:01.411 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/05/06 02:37:01.411 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365708630902872765]
[2024/05/06 02:37:01.411 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 02:37:01.412 +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:2379]
[2024/05/06 02:37:01.412 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 02:37:01.412 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 02:37:01.412 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 02:37:01.413 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 02:37:01.413 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:37:01.426 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 02:37:01.428 +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 02:37:01.428 +00:00] [INFO] [table_import.go:739] ["use 0.8 of the storage size as default disk quota"] [table=zero_time_table] [quota=373.8GB]
[2024/05/06 02:37:01.428 +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 02:37:01.429 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=78] [disk-quota=348.1GiB]
[2024/05/06 02:37:01.474 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=78] [step=import] [subtask-id=150]
[2024/05/06 02:37:01.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 02:37:01.483 +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 02:37:01.484 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=350]
[2024/05/06 02:37:01.533 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=350] [key=zero_time.csv:0]
[2024/05/06 02:37:01.537 +00:00] [INFO] [chunk_process.go:334] ["process chunk completed"] [type=ImportInto] [table-id=350] [key=zero_time.csv:0] [readDur=1.870825ms] [encodeDur=902.249µs] [checksum="{cksum=11665625846060223399,size=36,kvs=1}"] [deliverDur=359.463µs] [type=file] [takeTime=3.641867ms] []
[2024/05/06 02:37:01.538 +00:00] [INFO] [task_executor.go:125] ["run subtask completed"] [type=ImportInto] [task-id=78] [step=import] [subtask-id=150] [takeTime=63.700339ms] []
[2024/05/06 02:37:01.538 +00:00] [INFO] [engine.go:865] ["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/b30b9dab-130d-432e-8393-fc29c6d2493b.sst] [firstKey=74800000000000015E5F728000000000000001] [lastKey=74800000000000015E5F728000000000000001]
[2024/05/06 02:37:01.538 +00:00] [INFO] [task_executor.go:199] ["on subtask finished"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 02:37:01.538 +00:00] [INFO] [task_executor.go:213] ["import data engine"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 02:37:01.538 +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 02:37:01.542 +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.107385ms] []
[2024/05/06 02:37:01.542 +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 02:37:01.548 +00:00] [INFO] [local.go:1279] ["pause pd scheduler of table scope"] [category=ddl-ingest]
[2024/05/06 02:37:01.570 +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 02:37:01.570 +00:00] [INFO] [local.go:835] ["import engine ranges"] [category=ddl-ingest] [count=1]
[2024/05/06 02:37:01.589 +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 02:37:01.591 +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=49.203517ms] []
[2024/05/06 02:37:01.591 +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 02:37:01.592 +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.181825ms] []
[2024/05/06 02:37:01.592 +00:00] [INFO] [task_executor.go:224] ["import index engine"] [type=ImportInto] [task-id=78] [step=import] [engine-id=0]
[2024/05/06 02:37:01.592 +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 02:37:01.594 +00:00] [INFO] [backend.go:332] ["engine close completed"] [category=ddl-ingest] [engineTag=`import_into`.`zero_time_table`:-1] [engineUUID=bded5148-7505-502f-9c47-c93111ef3c71] [takeTime=1.859687ms] []
[2024/05/06 02:37:01.594 +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 02:37:01.594 +00:00] [INFO] [local.go:1257] ["engine contains no kv, skip import"] [category=ddl-ingest] [engine=bded5148-7505-502f-9c47-c93111ef3c71]
[2024/05/06 02:37:01.594 +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=60.186µs] []
[2024/05/06 02:37:01.595 +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 02:37:01.595 +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=886.99µs] []
[2024/05/06 02:37:01.651 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=78] [step=import]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:37:01.655 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 02:37:01.655 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 02:37:01.655 +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 02:37:01.655 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:37:01.655 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:37:01.655 +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 02:37:01.655 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:37:01.655 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 02:37:01.657 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 02:37:01.658 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:37:01.658 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:37:01.658 +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 02:37:01.658 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:37:01.658 +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=256.577426ms] []
[2024/05/06 02:37:01.727 +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 02:37:01.728 +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 02:37:01.729 +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 02:37:01.729 +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 02:37:01.799 +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 02:37:01.800 +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 02:37:01.801 +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 02:37:02.006 +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 02:37:02.047 +00:00] [INFO] [task_executor.go:486] ["run subtask start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 02:37:02.047 +00:00] [INFO] [subtask_executor.go:115] ["post process start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 02:37:02.048 +00:00] [INFO] [table_import.go:788] ["rebase allocators start"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151]
[2024/05/06 02:37:02.056 +00:00] [INFO] [table_import.go:790] ["rebase allocators completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=8.449882ms] []
[2024/05/06 02:37:02.056 +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 02:37:02.056 +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 02:37:02.056 +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 02:37:02.056 +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 02:37:02.060 +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 02:37:02.060 +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 02:37:02.060 +00:00] [INFO] [subtask_executor.go:117] ["post process completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=12.775752ms] []
[2024/05/06 02:37:02.060 +00:00] [INFO] [task_executor.go:488] ["run subtask completed"] [type=ImportInto] [task-id=78] [step=post-process] [subtask-id=151] [takeTime=12.99956ms] []
[2024/05/06 02:37:02.099 +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=93.467187ms] []
[2024/05/06 02:37:02.121 +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 02:37:02.121 +00:00] [INFO] [scheduler.go:329] ["task done"] [type=ImportInto] [task-id=78] [step=post-process] [state=running] []
[2024/05/06 02:37:02.124 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=78]
[2024/05/06 02:37:02.190 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=78] [type=ImportInto]
[2024/05/06 02:37:02.208 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=78]
[2024/05/06 02:37:02.237 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 02:37:02.237 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=78]
[2024/05/06 02:37:02.315 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 1.5665627199999999\n# Parse_time: 0.000390425\n# Compile_time: 0.001045355\n# Rewrite_time: 0.000245897\n# Optimize_time: 0.001205141\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('LbAwCTU5XzIJMAkwCU4vQQkxCXRpbWU6MS41NnMsIGxvb3BzOjIJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('SMgKRAoMSW1wb3J0SW50b18yMAE4AUABUgNOL0FaE3RpbWU6MS41NnMsIGxvb3BzOjJw//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 02:37:02.330 +00:00] [INFO] [session.go:3889] ["CRUCIAL OPERATION"] [conn=2] [schemaVersion=250] [cur_db=test_show_job] [sql="truncate table import_into.zero_time_table"] [user=root@%]
[2024/05/06 02:37:02.369 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 02:37:02.371 +00:00] [INFO] [ddl.go:1181] ["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 02:37:02.316 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [query="truncate table import_into.zero_time_table"]
[2024/05/06 02:37:02.371 +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 02:37:02.316 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false; "] [table=true]
[2024/05/06 02:37:02.420 +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 02:37:02.316 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:02.432 +00:00] [INFO] [ddl.go:73] ["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 02:37:02.469 +00:00] [INFO] [domain.go:280] ["diff load InfoSchema success"] [currentSchemaVersion=250] [neededSchemaVersion=251] ["start time"=2.139082ms] [gotSchemaVersion=251] [phyTblIDs="[350,352]"] [actionTypes="[11,11]"] [diffTypes="[\"truncate table\"]"]
[2024/05/06 02:37:02.480 +00:00] [INFO] [domain.go:886] ["mdl gets lock, update self version to owner"] [jobID=353] [version=251]
[2024/05/06 02:37:02.515 +00:00] [INFO] [ddl_worker.go:1433] ["wait latest schema version changed(get the metadata lock if tidb_enable_metadata_lock is true)"] [category=ddl] [ver=251] ["take time"=53.933209ms] [job="ID:353, Type:truncate table, State:done, SchemaState:public, SchemaID:348, TableID:350, RowCount:0, ArgLen:2, start time: 2024-05-06 02:37:02.316 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:02.567 +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 02:37:02.576 +00:00] [INFO] [delete_range.go:112] ["add job into delete-range table"] [category=ddl] [jobID=353] [jobType="truncate table"]
[2024/05/06 02:37:02.580 +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 02:37:02.316 +0000 UTC, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/06 02:37:02.630 +00:00] [INFO] [ddl.go:1286] ["DDL job is finished"] [category=ddl] [jobID=353]
[2024/05/06 02:37:02.630 +00:00] [INFO] [callback.go:139] ["performing DDL change, must reload"] [category=ddl]
[2024/05/06 02:37:02.634 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 0.304536405\n# Parse_time: 0.000217591\n# Compile_time: 0.000710939\n# Rewrite_time: 0.000032012\n# Optimize_time: 0.000967807\n# Wait_TS: 0.000372814\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 02:37:02.654 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:02.889 +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 02:37:02.968 +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 02:37:03.012 +00:00] [INFO] [scheduler_manager.go:355] ["task scheduler started"] [server-id=:4000] [task-id=79]
[2024/05/06 02:37:03.012 +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 02:37:03.118 +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 02:37:03.119 +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 02:37:03.120 +00:00] [INFO] [scheduler.go:230] ["on next subtasks batch"] [type=ImportInto] [task-id=79] [curr-step=init] [next-step=import]
[2024/05/06 02:37:03.141 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:03.143 +00:00] [INFO] [table_import.go:373] ["populate chunks start"] [table=zero_time_table]
[2024/05/06 02:37:03.144 +00:00] [INFO] [table_import.go:384] ["adjust max engine size"] [table=zero_time_table] [before=536870912000] [after=20]
[2024/05/06 02:37:03.144 +00:00] [INFO] [region.go:292] [makeTableRegions] [table=zero_time_table] [filesCount=1] [MaxChunkSize=268435456] [RegionsCount=1] [BatchSize=20] [cost=53.388µs]
[2024/05/06 02:37:03.144 +00:00] [INFO] [table_import.go:375] ["populate chunks completed"] [table=zero_time_table] [takeTime=169.878µs] []
[2024/05/06 02:37:03.144 +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 02:37:03.144 +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 02:37:03.292 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [task-id=79] [mode=Import]
[2024/05/06 02:37:03.318 +00:00] [INFO] [scheduler.go:98] ["register task to pd or refresh lease success"] [task-id=79]
[2024/05/06 02:37:03.341 +00:00] [INFO] [manager.go:328] ["task executor started"] [server-id=:4000] [task-id=79] [type=ImportInto] [remaining-slots=44]
[2024/05/06 02:37:03.378 +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 02:37:03.379 +00:00] [INFO] [task_executor.go:96] ["init subtask env"] [type=ImportInto] [task-id=79] [step=import]
[2024/05/06 02:37:03.380 +00:00] [INFO] [gcs.go:420] ["resetting gcs storage"]
[2024/05/06 02:37:03.388 +00:00] [INFO] [pd_service_discovery.go:1016] ["[pd] switch leader"] [new-leader=http://127.0.0.1:2379] [old-leader=]
[2024/05/06 02:37:03.388 +00:00] [INFO] [pd_service_discovery.go:498] ["[pd] init cluster id"] [cluster-id=7365708630902872765]
[2024/05/06 02:37:03.389 +00:00] [INFO] [client.go:613] ["[pd] changing service mode"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 02:37:03.389 +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:2379]
[2024/05/06 02:37:03.390 +00:00] [INFO] [client.go:619] ["[pd] service mode changed"] [old-mode=UNKNOWN_SVC_MODE] [new-mode=PD_SVC_MODE]
[2024/05/06 02:37:03.390 +00:00] [INFO] [tso_dispatcher.go:119] ["[tso] start tso deadline watcher"] [dc-location=global]
[2024/05/06 02:37:03.390 +00:00] [INFO] [tso_dispatcher.go:168] ["[tso] tso dispatcher created"] [dc-location=global]
[2024/05/06 02:37:03.390 +00:00] [INFO] [tso_client.go:130] ["[tso] start tso dispatcher check loop"]
[2024/05/06 02:37:03.390 +00:00] [INFO] [tso_dispatcher.go:336] ["[tso] start tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:37:03.403 +00:00] [INFO] [local.go:682] ["multi ingest support"] [category=ddl-ingest]
[2024/05/06 02:37:03.404 +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 02:37:03.404 +00:00] [INFO] [table_import.go:739] ["use 0.8 of the storage size as default disk quota"] [table=zero_time_table] [quota=373.8GB]
[2024/05/06 02:37:03.404 +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 02:37:03.405 +00:00] [INFO] [table_import.go:548] ["start checking disk quota"] [table=zero_time_table] [import-id=79] [disk-quota=348.1GiB]
[2024/05/06 02:37:03.452 +00:00] [INFO] [task_executor.go:123] ["run subtask start"] [type=ImportInto] [task-id=79] [step=import] [subtask-id=152]
[2024/05/06 02:37:03.457 +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 02:37:03.461 +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 02:37:03.461 +00:00] [INFO] [subtask_executor.go:60] ["execute chunk"] [type=ImportInto] [table-id=352]
[2024/05/06 02:37:03.478 +00:00] [INFO] [chunk_process.go:330] ["process chunk start"] [type=ImportInto] [table-id=352] [key=zero_time.csv:0]
[2024/05/06 02:37:03.479 +00:00] [ERROR] [chunk_process.go:334] ["process chunk failed"] [type=ImportInto] [table-id=352] [key=zero_time.csv:0] [takeTime=1.381158ms] [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 02:37:03.479 +00:00] [ERROR] [task_executor.go:125] ["run subtask failed"] [type=ImportInto] [task-id=79] [step=import] [subtask-id=152] [takeTime=27.812212ms] [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 02:37:03.480 +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 02:37:03.480 +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 02:37:03.480 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:37:03.480 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 02:37:03.480 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 02:37:03.480 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 02:37:03.480 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 02:37:03.480 +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 02:37:03.480 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 02:37:03.480 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 02:37:03.481 +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 02:37:03.497 +00:00] [INFO] [task_executor.go:265] ["cleanup subtask env"] [type=ImportInto] [task-id=79] [step=import]
[2024/05/06 02:37:03.500 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:37:03.500 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:37:03.500 +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 02:37:03.500 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:37:03.500 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 02:37:03.502 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=lightning]
[2024/05/06 02:37:03.502 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:37:03.502 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:37:03.502 +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 02:37:03.502 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:37:03.502 +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=123.602003ms] [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 02:37:03.502 +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 02:37:03.596 +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 02:37:03.636 +00:00] [INFO] [manager.go:332] ["task executor exit"] [server-id=:4000] [task-id=79] [type=ImportInto]
[2024/05/06 02:37:03.643 +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 02:37:03.645 +00:00] [INFO] [tikv_mode.go:61] ["switch tikv mode"] [type=ImportInto] [task-id=79] [step=import] [mode=Normal]
[2024/05/06 02:37:03.664 +00:00] [INFO] [scheduler.go:113] ["unregister task success"] [task-id=79]
[2024/05/06 02:37:03.718 +00:00] [INFO] [scheduler_manager.go:364] ["task scheduler exist"] [server-id=:4000] [task-id=79]
[2024/05/06 02:37:03.740 +00:00] [INFO] [scheduler_manager.go:410] ["cleanup routine start"] [server-id=:4000]
[2024/05/06 02:37:03.740 +00:00] [INFO] [scheduler_manager.go:426] ["cleanup task"] [server-id=:4000] [task-id=79]
[2024/05/06 02:37:03.817 +00:00] [INFO] [scheduler_manager.go:419] ["cleanup routine success"] [server-id=:4000]
[2024/05/06 02:37:03.916 +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:403\ngithub.com/pingcap/tidb/pkg/executor.(*ExecStmt).next\n\tpkg/executor/adapter.go:1209\ngithub.com/pingcap/tidb/pkg/executor.(*recordSet).Next\n\tpkg/executor/adapter.go:158\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:251\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 02:37:03.917 +00:00] [WARN] [adapter.go:1641] ["# Txn_start_ts: 0\n# User@Host: root[root] @ localhost [localhost]\n# Conn_ID: 2\n# Query_time: 1.281844955\n# Parse_time: 0.000845672\n# Compile_time: 0.00152072\n# Rewrite_time: 0.000259843\n# Optimize_time: 0.000967807\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('LbAwCTU5XzIJMAkwCU4vQQkwCXRpbWU6MS4yOHMsIGxvb3BzOjEJTi9BCU4vQQo=')\n# Binary_plan: tidb_decode_binary_plan('RsAKQgoMSW1wb3J0SW50b18yOAFAAVIDTi9BWhN0aW1lOjEuMjhzLCBsb29wczoxcP//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 02:37:03.939 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.939 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.939 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [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 02:37:03.941 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[ddl] /tidb/ddl/fg/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] []
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 14, tp add index"] [category=ddl] ["take time"=24.903µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 15, tp add index"] [category=ddl] ["take time"=20.709µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 16, tp add index"] [category=ddl] ["take time"=22.375µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 17, tp add index"] [category=ddl] ["take time"=22.359µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 18, tp add index"] [category=ddl] ["take time"=18.328µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 19, tp add index"] [category=ddl] ["take time"=14.797µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 20, tp add index"] [category=ddl] ["take time"=16.415µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 21, tp add index"] [category=ddl] ["take time"=53.469µs]
[2024/05/06 02:37:03.942 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 22, tp add index"] [category=ddl] ["take time"=9.579µs]
[2024/05/06 02:37:03.943 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 13, tp add index"] [category=ddl] ["take time"=14.097µs]
[2024/05/06 02:37:03.943 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 02:37:03.943 +00:00] [INFO] [ddl_worker.go:187] ["DDL worker closed"] [worker="worker 12, tp general"] [category=ddl] ["take time"=14.925µs]
[2024/05/06 02:37:03.943 +00:00] [INFO] [ddl_workerpool.go:82] ["closing workerPool"] [category=ddl]
[2024/05/06 02:37:03.943 +00:00] [INFO] [delete_range.go:162] ["closing delRange"] [category=ddl]
[2024/05/06 02:37:03.943 +00:00] [INFO] [session_pool.go:98] ["closing session pool"] [category=ddl]
[2024/05/06 02:37:03.977 +00:00] [INFO] [ddl.go:950] ["DDL closed"] [category=ddl] [ID=2e3ede95-4a94-4aac-9b27-46776502030a] ["take time"=50.862802ms]
[2024/05/06 02:37:03.977 +00:00] [INFO] [ddl.go:768] ["stop DDL"] [category=ddl] [ID=2e3ede95-4a94-4aac-9b27-46776502030a]
[2024/05/06 02:37:03.979 +00:00] [INFO] [domain.go:1025] ["stopping ttlJobManager"]
[2024/05/06 02:37:03.979 +00:00] [INFO] [runtime.go:190] ["TimerGroupRuntime loop exit"] [groupID=ttl]
[2024/05/06 02:37:03.979 +00:00] [INFO] [notifier.go:142] ["etcd watcher exited to watch timer events"] [EtcdKey=/tidb/timer/cluster/1/notify/2052d4d4-860a-4d88-9d70-8f0914e16d5d] [watcherID=adf82d7e-589f-4ee8-b242-ace129ec763a]
[2024/05/06 02:37:03.979 +00:00] [INFO] [notifier.go:227] ["etcd notify loop to watch timer events stopped"] [EtcdKey=/tidb/timer/cluster/1/notify/2052d4d4-860a-4d88-9d70-8f0914e16d5d]
[2024/05/06 02:37:03.979 +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 02:37:03.979 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 02:37:03.979 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 02:37:03.979 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 02:37:03.979 +00:00] [INFO] [scan.go:309] ["ttlScanWorker loop exited."]
[2024/05/06 02:37:03.980 +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 02:37:03.980 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 02:37:03.980 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 02:37:03.980 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 02:37:03.980 +00:00] [INFO] [del.go:261] ["ttlDeleteWorker loop exited."]
[2024/05/06 02:37:03.986 +00:00] [INFO] [job_manager.go:174] ["ttlJobManager loop exited."] [ttl-worker=job-manager]
[2024/05/06 02:37:03.986 +00:00] [INFO] [domain.go:1036] ["ttlJobManager exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2817] ["releaseServerID succeed"] [serverID=1672]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2881] ["serverIDKeeper exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2450] ["autoAnalyzeWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:1542] ["stopping dist task scheduler manager because the current node is not DDL owner anymore"] [id=2e3ede95-4a94-4aac-9b27-46776502030a]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:711] ["infoSyncerKeeper exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=mdlCheckLoop]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:906] ["loadSchemaInLoop exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=autoAnalyzeWorker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:737] ["globalConfigSyncerKeeper exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2020] ["PlanReplayerTaskCollectHandle exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2371] ["updateStatsWorker is going to exit, start to flush stats"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [scheduler_manager.go:206] ["schedule task loop exits"] [server-id=:4000]
[2024/05/06 02:37:03.987 +00:00] [INFO] [scheduler_manager.go:459] ["collect loop exits"] [server-id=:4000]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2323] ["loadStatsWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2074] ["dumpFileGcChecker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalConfigSyncerKeeper]
[2024/05/06 02:37:03.987 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2352] ["indexUsageWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayRecordFlushLoop]
[2024/05/06 02:37:03.987 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2492] ["analyzeJobsCleanupWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=dumpFileGcChecker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=indexUsageWorker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:761] ["topologySyncerKeeper exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [plan_replayer.go:413] ["planReplayerTaskDumpWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=analyzeJobsCleanupWorker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2105] ["HistoricalStatsWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topologySyncerKeeper]
[2024/05/06 02:37:03.987 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[log-backup] ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03 watch owner key /tidb/br-stream/owner/22318f4bbdcc7e12"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=HistoricalStatsWorker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSchemaInLoop]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=infoSyncerKeeper]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=runawayWatchSyncLoop]
[2024/05/06 02:37:03.987 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:1700] ["loadPrivilegeInLoop exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [manager.go:446] ["watcher is closed, no owner"] ["owner info"="[stats] ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a watch owner key /tidb/stats/owner/22318f4bbdcc7e18"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [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 02:37:03.988 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadPrivilegeInLoop]
[2024/05/06 02:37:03.988 +00:00] [WARN] [manager.go:306] ["is not the owner"] ["owner info"="[stats] /tidb/stats/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskCollectHandle]
[2024/05/06 02:37:03.987 +00:00] [INFO] [scheduler_manager.go:379] ["cleanup loop exits"] [server-id=:4000]
[2024/05/06 02:37:03.987 +00:00] [INFO] [scheduler_manager.go:318] ["subtask history table gc loop exits"] [server-id=:4000]
[2024/05/06 02:37:03.988 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[stats] /tidb/stats/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"]
[2024/05/06 02:37:03.987 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadStatsWorker]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:1750] ["LoadSysVarCacheLoop exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=loadSigningCertLoop]
[2024/05/06 02:37:03.987 +00:00] [INFO] [stats_syncload.go:202] ["SubLoadWorker exited."]
[2024/05/06 02:37:03.987 +00:00] [INFO] [domain.go:2040] ["PlanReplayerTaskDumpHandle exited."]
[2024/05/06 02:37:03.988 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=LoadSysVarCacheLoop]
[2024/05/06 02:37:03.987 +00:00] [INFO] [advancer.go:397] ["Meet task event"] [category="log backup advancer"] [event="Err(, err = EOF)"]
[2024/05/06 02:37:03.988 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=PlanReplayerTaskDumpHandle]
[2024/05/06 02:37:03.988 +00:00] [INFO] [domain.go:1544] ["dist task scheduler manager stopped"] [id=2e3ede95-4a94-4aac-9b27-46776502030a]
[2024/05/06 02:37:03.988 +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 02:37:03.988 +00:00] [INFO] [advancer.go:403] ["Task watcher exits due to some error."] [category="log backup advancer"] [error=EOF]
[2024/05/06 02:37:03.988 +00:00] [INFO] [domain.go:1527] ["stopping dist task executor manager"]
[2024/05/06 02:37:03.988 +00:00] [INFO] [manager.go:280] ["recoverMetaLoop done"] [server-id=:4000]
[2024/05/06 02:37:03.990 +00:00] [INFO] [manager.go:292] ["failed to campaign"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03"] [error="context canceled"]
[2024/05/06 02:37:03.990 +00:00] [INFO] [flush_subscriber.go:97] [Clearing.] [category="log backup flush subscriber"]
[2024/05/06 02:37:03.990 +00:00] [INFO] [owner_daemon.go:87] ["daemon loop exits"] [id=0f26d611-96c9-4e4c-b63c-70010124df03] [daemon-id=LogBackup::Advancer]
[2024/05/06 02:37:03.990 +00:00] [INFO] [domain.go:683] ["topNSlowQueryLoop exited."]
[2024/05/06 02:37:03.990 +00:00] [INFO] [domain.go:1361] ["closestReplicaReadCheckLoop exited."]
[2024/05/06 02:37:03.990 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=logBackupAdvancer]
[2024/05/06 02:37:03.990 +00:00] [INFO] [manager.go:257] ["etcd session is done, creates a new one"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03"]
[2024/05/06 02:37:03.990 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=closestReplicaReadCheckLoop]
[2024/05/06 02:37:03.990 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=topNSlowQueryLoop]
[2024/05/06 02:37:03.990 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03"] [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 02:37:03.990 +00:00] [INFO] [domain.go:2373] ["updateStatsWorker ready to release owner"]
[2024/05/06 02:37:03.990 +00:00] [WARN] [etcd.go:78] ["failed to new session to etcd"] [ownerInfo="[stats] /tidb/stats/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [error="context canceled"]
[2024/05/06 02:37:04.011 +00:00] [INFO] [manager.go:179] ["handle tasks loop done"] [server-id=:4000]
[2024/05/06 02:37:04.012 +00:00] [INFO] [domain.go:1529] ["dist task executor manager stopped"]
[2024/05/06 02:37:04.012 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=distTaskFrameworkLoop]
[2024/05/06 02:37:04.191 +00:00] [INFO] [manager.go:261] ["break campaign loop, NewSession failed"] ["owner info"="[stats] /tidb/stats/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [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 02:37:05.235 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[bindinfo] /tidb/bindinfo/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 02:37:05.235 +00:00] [INFO] [domain.go:1889] ["globalBindHandleWorkerLoop exited."]
[2024/05/06 02:37:05.235 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=globalBindHandleWorkerLoop]
[2024/05/06 02:37:05.256 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[log-backup] /tidb/br-stream/owner ownerManager 0f26d611-96c9-4e4c-b63c-70010124df03"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 02:37:05.446 +00:00] [INFO] [manager.go:317] ["revoke session"] ["owner info"="[stats] /tidb/stats/owner ownerManager 2e3ede95-4a94-4aac-9b27-46776502030a"] [error="rpc error: code = Canceled desc = grpc: the client connection is closing"]
[2024/05/06 02:37:05.446 +00:00] [INFO] [domain.go:2379] ["updateStatsWorker exit preprocessing finished"]
[2024/05/06 02:37:05.446 +00:00] [INFO] [domain.go:2404] ["updateStatsWorker exited."]
[2024/05/06 02:37:05.446 +00:00] [INFO] [wait_group_wrapper.go:140] ["background process exited"] [source=domain] [process=updateStatsWorker]
[2024/05/06 02:37:05.507 +00:00] [INFO] [domain.go:1073] ["domain closed"] ["take time"=1.581518389s]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_dispatcher.go:137] ["[tso] exit tso deadline watcher"] [dc-location=global]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_dispatcher.go:210] ["[tso] stop fetching the pending tso requests due to context canceled"] [dc-location=global]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_dispatcher.go:350] ["[tso] exit tso connection contexts updater"] [dc-location=global]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_client.go:145] ["[tso] exit tso dispatcher check loop"]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_dispatcher.go:171] ["[tso] exit tso dispatcher"] [dc-location=global]
[2024/05/06 02:37:05.508 +00:00] [INFO] [pd_service_discovery.go:550] ["[pd] exit member loop due to context canceled"]
[2024/05/06 02:37:05.508 +00:00] [INFO] [resource_manager_client.go:295] ["[resource manager] exit resource token dispatcher"]
[2024/05/06 02:37:05.508 +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 02:37:05.508 +00:00] [INFO] [tso_client.go:155] ["[tso] closing tso client"]
[2024/05/06 02:37:05.508 +00:00] [INFO] [tso_client.go:160] ["[tso] close tso client"]
[2024/05/06 02:37:05.509 +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 02:37:05.509 +00:00] [INFO] [tso_client.go:162] ["[tso] tso client is closed"]
[2024/05/06 02:37:05.509 +00:00] [INFO] [pd_service_discovery.go:637] ["[pd] close pd service discovery client"]
[2024/05/06 02:37:05.510 +00:00] [INFO] [client.go:329] ["[pd] http client closed"] [source=tikv-driver]
--- PASS: TestImportInto (236.88s)
    --- SKIP: TestImportInto/TestAddIndexBySQL (0.00s)
    --- SKIP: TestImportInto/TestAnalyze (0.00s)
    --- PASS: TestImportInto/TestBasicImportInto (32.26s)
    --- PASS: TestImportInto/TestCancelJob (8.42s)
    --- PASS: TestImportInto/TestChecksumNotMatch (7.44s)
    --- PASS: TestImportInto/TestColumnsAndUserVars (2.95s)
    --- PASS: TestImportInto/TestDeliverBytesRows (4.84s)
    --- PASS: TestImportInto/TestDetachedLoadParquet (5.95s)
    --- PASS: TestImportInto/TestDiskQuota (4.33s)
    --- PASS: TestImportInto/TestGBK (7.71s)
    --- PASS: TestImportInto/TestGeneratedColumnsAndTSVFile (11.01s)
    --- PASS: TestImportInto/TestIgnoreNLines (6.72s)
    --- PASS: TestImportInto/TestImportIntoPrivilegePositiveCase (7.86s)
    --- PASS: TestImportInto/TestImportMode (19.01s)
    --- PASS: TestImportInto/TestInputCountMisMatchAndDefault (7.97s)
    --- PASS: TestImportInto/TestInputNull (4.70s)
    --- PASS: TestImportInto/TestJobFailWhenDispatchSubtask (1.79s)
    --- PASS: TestImportInto/TestKillBeforeFinish (2.95s)
    --- PASS: TestImportInto/TestLoadSQLDump (4.68s)
    --- PASS: TestImportInto/TestMaxWriteSpeed (14.02s)
    --- PASS: TestImportInto/TestMultiValueIndex (3.12s)
    --- PASS: TestImportInto/TestOtherCharset (12.56s)
    --- PASS: TestImportInto/TestPreCheckCDCPiTRTasks (4.16s)
    --- PASS: TestImportInto/TestPreCheckTableNotEmpty (1.31s)
    --- PASS: TestImportInto/TestPreCheckTotalFileSize0 (1.40s)
    --- PASS: TestImportInto/TestRegisterTask (9.38s)
    --- PASS: TestImportInto/TestSameBehaviourDetachedOrNot (9.45s)
    --- PASS: TestImportInto/TestShowDetachedJob (6.40s)
    --- PASS: TestImportInto/TestShowJob (7.64s)
    --- PASS: TestImportInto/TestZeroDateTime (4.42s)
PASS
coverage: 14.9% of statements
GCov does not exist at the given path: ''
May 06, 2024 2:37:11 AM com.google.devtools.coverageoutputgenerator.Main getTracefiles
INFO: No lcov file found.
May 06, 2024 2:37:11 AM com.google.devtools.coverageoutputgenerator.Main getGcovInfoFiles
INFO: No gcov info file found.
May 06, 2024 2:37:11 AM com.google.devtools.coverageoutputgenerator.Main getGcovJsonInfoFiles
INFO: No gcov json file found.
May 06, 2024 2:37:11 AM com.google.devtools.coverageoutputgenerator.Main getProfdataFileOrNull
INFO: No .profdata file found.
May 06, 2024 2:37:11 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: 297.946s, Critical Path: 281.88s
INFO: 1567 processes: 1534 remote cache hit, 20 internal, 13 linux-sandbox.
INFO: Build completed successfully, 1567 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/2c0eb9a6f860c74ec846ad1207d5de23/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/release-8.1/ghpr_check2/tidb
[Pipeline] {
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[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/integration.test: ok! 87 test cases passed, take time 2.545715352 s
[1,506 / 1,507] Testing //tests/realtikvtest/addindextest:addindextest_test; 281s remote-cache, linux-sandbox
[1,510 / 1,511] Testing //tests/realtikvtest/txntest:txntest_test; 280s remote-cache, linux-sandbox
[1,510 / 1,511] 1 / 1 tests; Testing //tests/realtikvtest/txntest:txntest_test; 282s remote-cache, linux-sandbox
Target //tests/realtikvtest/txntest:txntest_test up-to-date:
  bazel-bin/tests/realtikvtest/txntest/txntest_test_/txntest_test
INFO: Elapsed time: 326.134s, Critical Path: 309.53s
INFO: 1508 processes: 1483 remote cache hit, 20 internal, 5 linux-sandbox.
INFO: Build completed successfully, 1508 total actions
Test cases: finished with 32 passing and 0 failing out of 32 test cases

Executed 1 out of 1 test: 1 test passes.
./build/jenkins_collect_coverage.sh
root: /home/jenkins/.tidb/tmp/2c0eb9a6f860c74ec846ad1207d5de23/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/release-8.1/ghpr_check2/tidb
[Pipeline] {
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[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/modify_column.test: ok! 672 test cases passed, take time 42.047202937 s
[1,506 / 1,507] Testing //tests/realtikvtest/addindextest:addindextest_test; 341s remote-cache, linux-sandbox
./t/ddl/multi_schema_change.test: ok! 298 test cases passed, take time 52.93590414 s
./t/ddl/partition.test: ok! 213 test cases passed, take time 11.309887474 s
./t/ddl/primary_key_handle.test: ok! 191 test cases passed, take time 14.454613005 s
[1,506 / 1,507] Testing //tests/realtikvtest/addindextest:addindextest_test; 401s remote-cache, linux-sandbox
./t/ddl/reorg_partition.test: ok! 205 test cases passed, take time 35.726940381 s
./t/ddl/resource_group.test: ok! 16 test cases passed, take time 0.186116667 s
./t/ddl/sequence.test: ok! 268 test cases passed, take time 7.71047202 s
./t/ddl/serial.test: ok! 77 test cases passed, take time 4.836531741 s
./t/ddl/table_modify.test: ok! 47 test cases passed, take time 1.19165004 s
./t/executor/adapter.test: ok! 6 test cases passed, take time 0.05638403 s
[1,506 / 1,507] Testing //tests/realtikvtest/addindextest:addindextest_test; 461s remote-cache, linux-sandbox
[1,506 / 1,507] Testing //tests/realtikvtest/addindextest:addindextest_test; 472s 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: 507.589s, Critical Path: 491.63s
INFO: 1495 processes: 1479 remote cache hit, 10 internal, 6 linux-sandbox.
INFO: Build completed successfully, 1495 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/2c0eb9a6f860c74ec846ad1207d5de23/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/release-8.1/ghpr_check2/tidb
[Pipeline] {
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[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 30.227431378 s
./t/executor/aggregate.test: ok! 886 test cases passed, take time 14.051611932 s
./t/executor/analyze.test: ok! 180 test cases passed, take time 17.999248789 s
./t/executor/autoid.test: ok! 422 test cases passed, take time 6.562005299 s
./t/executor/batch_point_get.test: ok! 85 test cases passed, take time 1.021962903 s
./t/executor/charset.test: ok! 57 test cases passed, take time 0.912232643 s
./t/executor/chunk_reuse.test: ok! 93 test cases passed, take time 0.261863302 s
./t/executor/cluster_table.test: ok! 36 test cases passed, take time 0.248785897 s
./t/executor/compact_table.test: ok! 19 test cases passed, take time 0.308485619 s
./t/executor/cte.test: ok! 133 test cases passed, take time 1.456918504 s
./t/executor/ddl.test: ok! 359 test cases passed, take time 22.431567225 s
./t/executor/delete.test: ok! 71 test cases passed, take time 1.137315656 s
./t/executor/distsql.test: ok! 61 test cases passed, take time 1.520568999 s
./t/executor/executor.test: ok! 2151 test cases passed, take time 60.589050896 s
./t/executor/executor_txn.test: ok! 121 test cases passed, take time 0.602827269 s
./t/executor/explain.test: ok! 120 test cases passed, take time 2.123454579 s
./t/executor/explainfor.test: ok! 378 test cases passed, take time 3.965993181 s
./t/executor/foreign_key.test: ok! 318 test cases passed, take time 12.906584602 s
./t/executor/grant.test: ok! 202 test cases passed, take time 1.8397397949999998 s
./t/executor/import_into.test: ok! 88 test cases passed, take time 0.215503185 s
./t/executor/index_advise.test: ok! 30 test cases passed, take time 0.230796819 s
./t/executor/index_lookup_join.test: ok! 190 test cases passed, take time 4.628636912 s
./t/executor/index_lookup_merge_join.test: ok! 83 test cases passed, take time 2.375434778 s
./t/executor/index_merge_reader.test: ok! 244 test cases passed, take time 16.459104098 s
./t/executor/infoschema_reader.test: ok! 174 test cases passed, take time 6.732519218 s
./t/executor/insert.test: ok! 1224 test cases passed, take time 80.912792825 s
./t/executor/inspection_common.test: ok! 4 test cases passed, take time 0.002143138 s
./t/executor/issues.test: ok! 421 test cases passed, take time 13.019552791 s
./t/executor/jointest/hash_join.test: ok! 137 test cases passed, take time 8.390492724 s
./t/executor/jointest/join.test: ok! 866 test cases passed, take time 37.202545073 s
./t/executor/kv.test: ok! 16 test cases passed, take time 0.191974541 s
./t/executor/merge_join.test: ok! 259 test cases passed, take time 10.731170029 s
./t/executor/parallel_apply.test: ok! 96 test cases passed, take time 3.647804508 s
./t/executor/partition/global_index.test: ok! 94 test cases passed, take time 15.446474125 s
./t/executor/partition/issues.test: ok! 154 test cases passed, take time 6.240262689 s
./t/executor/partition/partition_boundaries.test: ok! 1035 test cases passed, take time 2.615245062 s
./t/executor/partition/partition_with_expression.test: ok! 298 test cases passed, take time 3.578777876 s
./t/executor/partition/table.test: ok! 224 test cases passed, take time 12.419236223 s
./t/executor/partition/write.test: ok! 355 test cases passed, take time 12.903124003 s
./t/executor/password_management.test: ok! 381 test cases passed, take time 3.069030282 s
./t/executor/point_get.test: ok! 273 test cases passed, take time 5.663943622 s
./t/executor/prepared.test: ok! 214 test cases passed, take time 2.936970923 s
./t/executor/revoke.test: ok! 65 test cases passed, take time 1.128773597 s
./t/executor/rowid.test: ok! 63 test cases passed, take time 0.919019602 s
./t/executor/sample.test: ok! 105 test cases passed, take time 16.006592258 s
./t/executor/set.test: ok! 228 test cases passed, take time 0.512821103 s
./t/executor/show.test: ok! 301 test cases passed, take time 15.385989048 s
./t/executor/simple.test: ok! 303 test cases passed, take time 3.227585034 s
./t/executor/split_table.test: ok! 60 test cases passed, take time 14.831776967 s
./t/executor/stale_txn.test: ok! 28 test cases passed, take time 1.4019516140000001 s
./t/executor/statement_context.test: ok! 63 test cases passed, take time 0.427654966 s
./t/executor/union_scan.test: ok! 231 test cases passed, take time 4.008481975 s
./t/executor/update.test: ok! 513 test cases passed, take time 11.464667309 s
./t/executor/window.test: ok! 22 test cases passed, take time 0.242119329 s
./t/executor/write.test: ok! 1079 test cases passed, take time 35.248944928 s
./t/explain-non-select-stmt.test: ok! 8 test cases passed, take time 0.080453735 s
./t/explain.test: ok! 21 test cases passed, take time 1.294633272 s
./t/explain_complex.test: ok! 41 test cases passed, take time 1.670238537 s
./t/explain_complex_stats.test: ok! 61 test cases passed, take time 4.5558457919999995 s
./t/explain_cte.test: ok! 53 test cases passed, take time 1.381269735 s
./t/explain_easy.test: ok! 190 test cases passed, take time 6.472930523 s
./t/explain_easy_stats.test: ok! 50 test cases passed, take time 1.549943951 s
./t/explain_foreign_key.test: ok! 41 test cases passed, take time 2.270045335 s
./t/explain_generate_column_substitute.test: ok! 233 test cases passed, take time 37.383279545 s
./t/explain_indexmerge_stats.test: ok! 30 test cases passed, take time 5.63263276 s
./t/explain_join_stats.test: ok! 8 test cases passed, take time 0.373905677 s
./t/explain_shard_index.test: ok! 19 test cases passed, take time 0.386462387 s
./t/explain_stats.test: ok! 10 test cases passed, take time 0.163334229 s
./t/explain_union_scan.test: ok! 9 test cases passed, take time 0.247400033 s
./t/expression/builtin.test: ok! 1332 test cases passed, take time 25.156363339 s
./t/expression/cast.test: ok! 50 test cases passed, take time 0.811781624 s
./t/expression/charset_and_collation.test: ok! 706 test cases passed, take time 31.291019394 s
./t/expression/constant_fold.test: ok! 12 test cases passed, take time 0.166530192 s
./t/expression/enum_set.test: ok! 13 test cases passed, take time 0.277263501 s
./t/expression/explain.test: ok! 77 test cases passed, take time 0.663941509 s
./t/expression/issues.test: ok! 1502 test cases passed, take time 56.459824905 s
./t/expression/json.test: ok! 223 test cases passed, take time 2.552521487 s
./t/expression/misc.test: ok! 404 test cases passed, take time 12.900319623 s
./t/expression/multi_valued_index.test: ok! 314 test cases passed, take time 10.42060109 s
./t/expression/plan_cache.test: ok! 184 test cases passed, take time 2.62109303 s
./t/expression/time.test: ok! 279 test cases passed, take time 2.26158392 s
./t/expression/vitess_hash.test: ok! 17 test cases passed, take time 1.965864938 s
./t/generated_columns.test: ok! 70 test cases passed, take time 8.058593424 s
./t/globalindex/mem_index_lookup.test: ok! 15 test cases passed, take time 0.335697118 s
./t/imdbload.test: ok! 63 test cases passed, take time 11.275713389 s
./t/index_join.test: ok! 22 test cases passed, take time 1.129041589 s
./t/index_merge.test: ok! 145 test cases passed, take time 6.27737154 s
./t/infoschema/cluster_tables.test: ok! 9 test cases passed, take time 0.110755715 s
./t/infoschema/infoschema.test: ok! 49 test cases passed, take time 1.9131820290000001 s
./t/infoschema/tables.test: ok! 120 test cases passed, take time 2.56529914 s
./t/infoschema/v2.test: ok! 30 test cases passed, take time 1.580211593 s
./t/naaj.test: ok! 134 test cases passed, take time 0.758271598 s
./t/new_character_set.test: ok! 61 test cases passed, take time 1.439870119 s
./t/new_character_set_builtin.test: ok! 217 test cases passed, take time 3.866797471 s
./t/new_character_set_invalid.test: ok! 28 test cases passed, take time 0.995606909 s
./t/parser/integration.test: ok! 8 test cases passed, take time 0.340248109 s
./t/partition.test: ok! 3 test cases passed, take time 0.581353461 s
./t/planner/cardinality/selectivity.test: ok! 683 test cases passed, take time 3.360447309 s
./t/planner/cardinality/trace.test: ok! 5 test cases passed, take time 0.190331433 s
./t/planner/cascades/integration.test: ok! 246 test cases passed, take time 2.797440762 s
./t/planner/core/binary_plan.test: ok! 6 test cases passed, take time 0.000865612 s
./t/planner/core/casetest/expression_rewriter.test: ok! 23 test cases passed, take time 0.356892623 s
./t/planner/core/casetest/hint/hint.test: ok! 182 test cases passed, take time 6.232291871 s
./t/planner/core/casetest/index/index.test: ok! 225 test cases passed, take time 6.638388039 s
./t/planner/core/casetest/integration.test: ok! 459 test cases passed, take time 10.996254378 s
./t/planner/core/casetest/partition/integration_partition.test: ok! 138 test cases passed, take time 3.047453529 s
./t/planner/core/casetest/partition/partition_pruner.test: ok! 275 test cases passed, take time 3.555338024 s
./t/planner/core/casetest/physicalplantest/physical_plan.test: ok! 852 test cases passed, take time 10.96739764 s
./t/planner/core/casetest/point_get_plan.test: ok! 52 test cases passed, take time 0.595378152 s
./t/planner/core/casetest/predicate_simplification.test: ok! 29 test cases passed, take time 0.43052399 s
./t/planner/core/casetest/pushdown/push_down.test: ok! 35 test cases passed, take time 0.310490895 s
./t/planner/core/casetest/rule/rule_derive_topn_from_window.test: ok! 73 test cases passed, take time 1.736603076 s
./t/planner/core/casetest/rule/rule_join_reorder.test: ok! 481 test cases passed, take time 17.177218084 s
./t/planner/core/casetest/rule/rule_result_reorder.test: ok! 87 test cases passed, take time 2.211325046 s
./t/planner/core/cbo.test: ok! 34 test cases passed, take time 1.479318482 s
./t/planner/core/enforce_mpp.test: ok! 8 test cases passed, take time 0.001399552 s
./t/planner/core/expression_rewriter.test: ok! 206 test cases passed, take time 7.7141548669999995 s
./t/planner/core/indexjoin.test: ok! 16 test cases passed, take time 0.228334949 s
./t/planner/core/indexmerge_intersection.test: ok! 6 test cases passed, take time 0.11420808 s
./t/planner/core/indexmerge_path.test: ok! 231 test cases passed, take time 10.079928177 s
./t/planner/core/integration.test: ok! 1623 test cases passed, take time 47.056940114 s
./t/planner/core/integration_partition.test: ok! 498 test cases passed, take time 29.229477923 s
./t/planner/core/issuetest/planner_issue.test: ok! 89 test cases passed, take time 3.283413814 s
./t/planner/core/memtable_predicate_extractor.test: ok! 45 test cases passed, take time 0.338737482 s
./t/planner/core/partition_pruner.test: ok! 643 test cases passed, take time 6.109952074 s
./t/planner/core/physical_plan.test: ok! 43 test cases passed, take time 2.097335669 s
./t/planner/core/plan.test: ok! 157 test cases passed, take time 3.119940945 s
./t/planner/core/plan_cache.test: ok! 1243 test cases passed, take time 17.751782698 s
./t/planner/core/plan_cost_ver2.test: ok! 70 test cases passed, take time 0.943564383 s
./t/planner/core/point_get_plan.test: ok! 265 test cases passed, take time 5.596310727 s
./t/planner/core/preprocess.test: ok! 6 test cases passed, take time 0.149679187 s
./t/planner/core/range_scan_for_like.test: ok! 183 test cases passed, take time 1.009899007 s
./t/planner/core/rule_constant_propagation.test: ok! 31 test cases passed, take time 1.864034354 s
./t/planner/core/rule_join_reorder.test: ok! 52 test cases passed, take time 2.269498895 s
./t/planner/core/rule_result_reorder.test: ok! 29 test cases passed, take time 0.507915187 s
./t/planner/core/tests/prepare/issue.test: ok! 321 test cases passed, take time 6.322299754 s
./t/planner/core/tests/prepare/prepare.test: ok! 458 test cases passed, take time 7.756075883 s
./t/planner/funcdep/only_full_group_by.test: ok! 142 test cases passed, take time 7.158877019 s
./t/privilege/privileges.test: ok! 411 test cases passed, take time 6.867186075 s
./t/select.test: ok! 189 test cases passed, take time 3.873583953 s
./t/session/bootstrap_upgrade.test: ok! 29 test cases passed, take time 0.355613165 s
./t/session/clustered_index.test: ok! 385 test cases passed, take time 28.458474312 s
./t/session/common.test: ok! 203 test cases passed, take time 10.523829241 s
./t/session/nontransactional.test: ok! 1532 test cases passed, take time 22.028992606 s
./t/session/privileges.test: ok! 66 test cases passed, take time 1.863219227 s
./t/session/session.test: ok! 101 test cases passed, take time 6.244826152 s
./t/session/temporary_table.test: ok! 277 test cases passed, take time 0.760822731 s
./t/session/txn.test: ok! 14 test cases passed, take time 0.102268189 s
./t/session/variable.test: ok! 113 test cases passed, take time 0.482817066 s
./t/session/vars.test: ok! 127 test cases passed, take time 0.124555266 s
./t/sessionctx/setvar.test: ok! 681 test cases passed, take time 0.225107654 s
./t/sessiontxn/externals.test: ok! 56 test cases passed, take time 0.568839399 s
./t/statistics/handle.test: ok! 60 test cases passed, take time 6.570745231 s
./t/statistics/integration.test: ok! 19 test cases passed, take time 0.286741869 s
./t/statistics/lock_table_stats.test: ok! 47 test cases passed, take time 1.017140701 s
./t/subquery.test: ok! 32 test cases passed, take time 0.957193728 s
./t/table/cache.test: ok! 108 test cases passed, take time 9.337117367 s
./t/table/index.test: ok! 34 test cases passed, take time 3.854420845 s
./t/table/partition.test: ok! 229 test cases passed, take time 8.465007445 s
./t/table/tables.test: ok! 6 test cases passed, take time 0.067425261 s
./t/table/temptable.test: ok! 11 test cases passed, take time 0.142969366 s
./t/topn_push_down.test: ok! 20 test cases passed, take time 0.43395707 s
./t/topn_pushdown.test: ok! 2 test cases passed, take time 0.000542575 s
./t/tpch.test: ok! 41 test cases passed, take time 2.587399547 s
./t/types/const.test: ok! 143 test cases passed, take time 3.292614877 s
./t/util/admin.test: ok! 240 test cases passed, take time 30.699235112 s
./t/util/ranger.test: ok! 188 test cases passed, take time 4.346125301 s
./t/window_function.test: ok! 28 test cases passed, take time 0.224976155 s

Great, All tests passed
integrationtest passed!
./run-tests.sh: line 1: kill: (1704) - No such process
~/agent/workspace/pingcap/tidb/release-8.1/ghpr_check2/tidb
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] dir
Running in /home/jenkins/agent/workspace/pingcap/tidb/release-8.1/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] }
[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 03:00:23--  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%  692M=0s

2024-05-06 03:00:23 (692 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/release-8.1/ghpr_check2/f595d17b133b1c60b882ccb14308daf6a62d462a=@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   434  100   151  100   283   4390   8229 --:--:-- --:--:-- --:--:--  8323
{"msg":"success","url":"http://fileserver.pingcap.net/download/ci_check/pingcap/tidb/release-8.1/ghpr_check2/f595d17b133b1c60b882ccb14308daf6a62d462a"}
[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