tiup cdc:v6.5.7 cli changefeed query -s --server=http://xxx:8300/ --changefeed-id=onemirror-reptaskStarting component cdc: /home/tidb/.tiup/components/cdc/v6.5.7/cdc cli changefeed query -s --server=http://xxx:8300/ --changefeed-id=onemirror-reptask{  "upstream_id": 7429158424764920159,  "namespace": "default",  "id": "onemirror-reptask",  "state": "warning",  "checkpoint_tso": 454306087227359251,  "checkpoint_time": "2024-12-01 16:03:08.703",  "error": {    "time": "2024-12-01T16:26:23.185248266+08:00",    "addr": "xxx:8300",    "code": "CDC:ErrReachMaxTry",    "message": "[CDC:ErrReachMaxTry]reach maximum try: 20, error: Error 1067: Invalid default value for 'end_time': Error 1067: Invalid default value for 'end_time'"  }}

[2024/12/01 16:15:04.625 +08:00] [WARN] [mysql_ddl_sink.go:128] ["Execute DDL with error, retry later"] [startTs=454306087227359239] [ddl="CREATE TABLE `testtest` (`id` INT PRIMARY KEY,`end_time` TIMESTAMP NOT NULL DEFAULT _UTF8MB4'1970-01-01 00:00:01')"] [namespace=] [changefeed=] [error="Error 1067: Invalid default value for 'end_time'"][2024/12/01 16:15:04.625 +08:00] [ERROR] [ddl_sink.go:279] ["Execute DDL failed"] [namespace=default] [changefeed=onemirror-reptask] [DDL="{\"StartTs\":454306087227359239,\"CommitTs\":454306087227359251,\"Query\":\"CREATE TABLE `testtest` (`id` INT PRIMARY KEY,`end_time` TIMESTAMP NOT NULL DEFAULT _UTF8MB4'1970-01-01 00:00:01')\",\"TableInfo\":{\"id\":1189,\"name\":{\"O\":\"testtest\",\"L\":\"testtest\"},\"charset\":\"utf8mb4\",\"collate\":\"utf8mb4_bin\",\"cols\":[{\"id\":1,\"name\":{\"O\":\"id\",\"L\":\"id\"},\"offset\":0,\"origin_default\":null,\"origin_default_bit\":null,\"default\":null,\"default_bit\":null,\"default_is_expr\":false,\"generated_expr_string\":\"\",\"generated_stored\":false,\"dependences\":null,\"type\":{\"Tp\":3,\"Flag\":4099,\"Flen\":11,\"Decimal\":0,\"Charset\":\"binary\",\"Collate\":\"binary\",\"Elems\":null,\"ElemsIsBinaryLit\":null},\"state\":5,\"comment\":\"\",\"hidden\":false,\"change_state_info\":null,\"version\":2},{\"id\":2,\"name\":{\"O\":\"end_time\",\"L\":\"end_time\"},\"offset\":1,\"origin_default\":null,\"origin_default_bit\":null,\"default\":\"1970-01-01 00:00:01\",\"default_bit\":null,\"default_is_expr\":false,\"generated_expr_string\":\"\",\"generated_stored\":false,\"dependences\":null,\"type\":{\"Tp\":7,\"Flag\":129,\"Flen\":19,\"Decimal\":0,\"Charset\":\"binary\",\"Collate\":\"binary\",\"Elems\":null,\"ElemsIsBinaryLit\":null},\"state\":5,\"comment\":\"\",\"hidden\":false,\"change_state_info\":null,\"version\":2}],\"index_info\":[{\"id\":1,\"idx_name\":{\"O\":\"PRIMARY\",\"L\":\"primary\"},\"tbl_name\":{\"O\":\"\",\"L\":\"\"},\"idx_cols\":[{\"name\":{\"O\":\"id\",\"L\":\"id\"},\"offset\":0,\"length\":-1}],\"state\":5,\"backfill_state\":0,\"comment\":\"\",\"index_type\":1,\"is_unique\":true,\"is_primary\":true,\"is_invisible\":false,\"is_global\":false}],\"constraint_info\":null,\"fk_info\":null,\"state\":5,\"pk_is_handle\":false,\"is_common_handle\":false,\"common_handle_version\":0,\"comment\":\"\",\"auto_inc_id\":0,\"auto_id_cache\":0,\"auto_rand_id\":0,\"max_col_id\":2,\"max_idx_id\":1,\"max_fk_id\":0,\"max_cst_id\":0,\"update_timestamp\":454306087227359239,\"ShardRowIDBits\":0,\"max_shard_row_id_bits\":0,\"auto_random_bits\":0,\"auto_random_range_bits\":0,\"pre_split_regions\":0,\"partition\":null,\"compression\":\"\",\"view\":null,\"sequence\":null,\"Lock\":null,\"version\":5,\"tiflash_replica\":null,\"is_columnar\":false,\"temp_table_type\":0,\"cache_table_status\":0,\"policy_ref_info\":null,\"stats_options\":null,\"exchange_partition_info\":null,\"ttl_info\":null,\"SchemaID\":113,\"TableName\":{\"db-name\":\"test\",\"tbl-name\":\"testtest\",\"tbl-id\":1189,\"is-partition\":false},\"Version\":454306087227359251,\"RowColumnsOffset\":{\"1\":0,\"2\":1},\"ColumnsFlag\":{\"1\":27,\"2\":1},\"HandleIndexID\":1,\"IndexColumnsOffset\":[[0]]},\"PreTableInfo\":null,\"Type\":3,\"Done\":{},\"Charset\":\"\",\"Collate\":\"\"}"] [error="[CDC:ErrReachMaxTry]reach maximum try: 20, error: Error 1067: Invalid default value for 'end_time': Error 1067: Invalid default value for 'end_time'"] [errorVerbose="[CDC:ErrReachMaxTry]reach maximum try: 20, error: Error 1067: Invalid default value for 'end_time': Error 1067: Invalid default value for 'end_time'\ngithub.com/pingcap/errors.AddStack\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/errors.go:174\ngithub.com/pingcap/errors.(*Error).GenWithStackByArgs\n\tgithub.com/pingcap/errors@v0.11.5-0.20220729040631-518f63d66278/normalize.go:164\ngithub.com/pingcap/tiflow/pkg/retry.run\n\tgithub.com/pingcap/tiflow/pkg/retry/retry_with_opt.go:69\ngithub.com/pingcap/tiflow/pkg/retry.Do\n\tgithub.com/pingcap/tiflow/pkg/retry/retry_with_opt.go:34\ngithub.com/pingcap/tiflow/cdc/sinkv2/ddlsink/mysql.(*mysqlDDLSink).execDDLWithMaxRetries\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/ddlsink/mysql/mysql_ddl_sink.go:115\ngithub.com/pingcap/tiflow/cdc/sinkv2/ddlsink/mysql.(*mysqlDDLSink).WriteDDLEvent\n\tgithub.com/pingcap/tiflow/cdc/sinkv2/ddlsink/mysql/mysql_ddl_sink.go:111\ngithub.com/pingcap/tiflow/cdc/owner.(*ddlSinkImpl).writeDDLEvent.func1\n\tgithub.com/pingcap/tiflow/cdc/owner/ddl_sink.go:272\ngithub.com/pingcap/tiflow/cdc/owner.(*ddlSinkImpl).retrySinkAction\n\tgithub.com/pingcap/tiflow/cdc/owner/ddl_sink.go:184\ngithub.com/pingcap/tiflow/cdc/owner.(*ddlSinkImpl).observedRetrySinkAction.func1\n\tgithub.com/pingcap/tiflow/cdc/owner/ddl_sink.go:217\nruntime.goexit\n\truntime/asm_amd64.s:1594"]

2024-12-01 16:03:08 (UTC+08:00)TiDB xxx:4000[session.go:3807] ["CRUCIAL OPERATION"] [conn=5789377320984773157] [schemaVersion=452] [cur_db=test] [sql="/* ApplicationName=DBeaver 24.2.4 - SQLEditor <Script-4.sql> */ create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01')"] [user=root@%]2024-12-01 16:03:08 (UTC+08:00)TiDB xxx:4000[ddl.go:1029] ["[ddl] start DDL job"] [job="ID:1190, Type:create table, State:queueing, SchemaState:none, SchemaID:113, TableID:1189, RowCount:0, ArgLen:2, start time: 2024-12-01 16:03:08.653 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0"] [query="/* ApplicationName=DBeaver 24.2.4 - SQLEditor <Script-4.sql> */ create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01')"]

mysql> admin show ddl jobs where table_name='testtest';+--------+---------+------------+--------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+--------+| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE     | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME         | START_TIME          | END_TIME            | STATE  |+--------+---------+------------+--------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+--------+|   1190 | test    | testtest   | create table | public       |       113 |     1189 |         0 | 2024-12-01 16:03:08 | 2024-12-01 16:03:08 | 2024-12-01 16:03:08 | synced |+--------+---------+------------+--------------+--------------+-----------+----------+-----------+---------------------+---------------------+---------------------+--------+1 row in set (0.01 sec)
mysql> admin show ddl job queries 1190;+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+| QUERY                                                                                                                                                               |+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+| /* ApplicationName=DBeaver 24.2.4 - SQLEditor <Script-4.sql> */ create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01') |+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+1 row in set (0.01 sec)
mysql> 

mysql> use test1;Database changedmysql> create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01');ERROR 1067 (42000): Invalid default value for 'end_time'mysql> 

$ timedatectl      Local time: Sun 2024-12-01 16:55:49 CST  Universal time: Sun 2024-12-01 08:55:49 UTC        RTC time: Sun 2024-12-01 08:55:49       Time zone: Asia/Shanghai (CST, +0800)     NTP enabled: yesNTP synchronized: yes RTC in local TZ: no      DST active: n/a$ 

set time_zone='+00:00';create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01');

mysql> set time_zone='+00:00';Query OK, 0 rows affected (0.00 sec)
mysql> create table testtest(id int primary key,end_time timestamp not null default '1970-01-01 00:00:01');Query OK, 0 rows affected (0.55 sec)
mysql> show create table testtest\G*************************** 1. row ***************************       Table: testtestCreate Table: CREATE TABLE `testtest` (  `id` int(11) NOT NULL,  `end_time` timestamp NOT NULL DEFAULT '1970-01-01 00:00:01',  PRIMARY KEY (`id`) /*T![clustered_index] NONCLUSTERED */) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin1 row in set (0.00 sec)
mysql> mysql> set time_zone='+08:00';Query OK, 0 rows affected (0.00 sec)
mysql> show create table testtest\G*************************** 1. row ***************************       Table: testtestCreate Table: CREATE TABLE `testtest` (  `id` int(11) NOT NULL,  `end_time` timestamp NOT NULL DEFAULT '1970-01-01 08:00:01',  PRIMARY KEY (`id`) /*T![clustered_index] NONCLUSTERED */) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin1 row in set (0.00 sec)
mysql>