fail to query session variable allow_auto_random_explicit_insert: [CDC:ErrMySQLQueryError]Error 1298: Unknown or incorrect time zone: ‘CST’
Error: run /home/tidb/.tiup/components/cdc/v4.0.8/cdc (wd:/home/tidb/.tiup/data/SFFWWef) failed: exit status 1
[tidb@bjgsyl059225 tidb-community-server-v4.0.6-linux-amd64]$ tiup cdc cli changefeed create --pd=http://10.18.59.225:2379 --sink-uri=“mysql://user:password@10.18.59.ip:3306/?time-zone=” --changefeed-id="simple-replication-task"
Starting component cdc: /home/tidb/.tiup/components/cdc/v4.0.8/cdc cli changefeed create --pd=http://10.18.59.225:2379 --sink-uri=mysql://user:password@10.18.59.ip:3306/?time-zone= --changefeed-id=simple-replication-task
Create changefeed successfully!
ID: simple-replication-task
Info: {“sink-uri”:“mysql://user:password@10.18.59.ip:3306/?time-zone=”,“opts”:{"_changefeed_id":“cli-verify”},“create-time”:“2020-11-03T12:33:13.807801491+08:00”,“start-ts”:420578064806707201,“target-ts”:0,“admin-job-type”:0,“sort-engine”:“memory”,“sort-dir”:".",“config”:{“case-sensitive”:true,“enable-old-value”:false,“force-replicate”:false,“filter”:{“rules”:["."],“ignore-txn-start-ts”:null,“ddl-allow-list”:null},“mounter”:{“worker-num”:16},“sink”:{“dispatchers”:null,“protocol”:“default”},“cyclic-replication”:{“enable”:false,“replica-id”:0,“filter-replica-ids”:null,“id-buckets”:0,“sync-ddl”:false},“scheduler”:{“type”:“table-number”,“polling-time”:-1}},“state”:“normal”,“history”:null,“error”:null,“sync-point-enabled”:false,“sync-point-interval”:600000000000}
**留空可以了! 感谢! **
好神奇 这是为啥呢?