search

pingcap / tidb

TiDB - the open-source, cloud-native, distributed SQL database designed for modern applications.
https://pingcap.com
Apache License 2.0
37.18k stars 5.84k forks source link

TiUP initial installation version 6.0.0 starts tidb and reports an error evaluation failed: unknown or incorrect time zone: Asia/Beijing"] Error #35807

Open bulibuqiyaoyao133 opened 2 years ago

bulibuqiyaoyao133 commented 2 years ago

问题：安装TIDB数据库启动报错，关闭已经防火墙，已经用 chronyc tracking 命令检查时区
系统是第一次安装，第一次安装tidb 单台物理服务器安装

Problem: The installation of the TIDB database starts with an error, the firewall has been turned off, and the chronyc tracking command has been used to check the time zone The system is the first installation, the first installation of tidb single physical server installation

系统版本(system version): Linux version 4.19.0-91.82.92.uelc20.x86_64 (mockbuild@localhost.localdomain) (gcc version 8.4.1 20200928 (UOS 8.4.1-1) (GCC)) #1 SMP Fri Mar 11 09:01:19 CST 2022

### TIDB启动过程中状态(Status during TIDB startup)： 启动命令(start command)： tiup cluster start bigbirdmeddb --init

[root@localhost /]# tiup cluster start bigbirdmeddb --init tiup is checking updates for component cluster ... Starting component cluster: /root/.tiup/components/cluster/v1.10.2/tiup-cluster start bigbirdmeddb --init Starting cluster bigbirdmeddb...

启动过程中4000端口报错信息（Error message on port 4000 during startup）： Error: failed to start tidb: failed to start: 10.0.1.145 tidb-4000.service, please check the instance's log(/mnt/data/tidb-deploy/tidb-4000/log) for more detail.: timed out waiting for port 4000 to be started after 2m0s

TIDB运行状态（TIDB running status）：

```

[root@localhost /]# tiup cluster display bigbirdmeddb tiup is checking updates for component cluster ... Starting component cluster: /root/.tiup/components/cluster/v1.10.2/tiup-cluster display bigbirdmeddb Cluster type: tidb Cluster name: bigbirdmeddb Cluster version: v6.0.0 Deploy user: tidb SSH type: builtin Dashboard URL: http://10.0.1.145:2379/dashboard ID Role Host Ports OS/Arch Status Data Dir Deploy Dir

10.0.1.145:2379 pd 10.0.1.145 2379/2380 linux/x86_64 Up|L|UI /mnt/data/tidb-data/pd-2379 /mnt/data/tidb-deploy/pd-2379 10.0.1.145:4000 tidb 10.0.1.145 4000/10080 linux/x86_64 Down - /mnt/data/tidb-deploy/tidb-4000 10.0.1.145:9000 tiflash 10.0.1.145 9000/8123/3930/20170/20292/8234 linux/x86_64 Up /mnt/data/tidb-data/tiflash-9000 /mnt/data/tidb-deploy/tiflash-9000 10.0.1.145:20160 tikv 10.0.1.145 20160/20180 linux/x86_64 Up /mnt/data/tidb-data/tikv-20160 /mnt/data/tidb-deploy/tikv-20160 Total nodes: 4



报错日志，日志路径（Error log, log path）：

[2022/06/28 17:06:34.561 +08:00] [FATAL] [terror.go:292] ["unexpected error"] [error="other error: [components/tidb_query_datatype/src/expr/ctx.rs:86]: evaluation failed: unknown or incorrect time zone: Asia/Beijing"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"]
[2022/06/28 17:06:49.767 +08:00] [INFO] [cpuprofile.go:115] ["parallel cpu profiler started"]
[2022/06/28 17:06:49.767 +08:00] [INFO] [printer.go:34] ["Welcome to TiDB."] ["Release Version"=v6.0.0] [Edition=Community] ["Git Commit Hash"=36a9810441ca0e496cbd22064af274b3be771081] ["Git Branch"=heads/refs/tags/v6.0.0] ["UTC Build Time"="2022-03-31 10:33:28"] [GoVersion=go1.18] ["Race Enabled"=false] ["Check Table Before Drop"=false] ["TiKV Min Version"=v3.0.0-60965b006877ca7234adaced7890d7b029ed1306]
[2022/06/28 17:06:49.768 +08:00] [INFO] [printer.go:48] ["loaded config"] [config="{\"host\":\"0.0.0.0\",\"advertise-address\":\"10.0.1.145\",\"port\":4000,\"cors\":\"\",\"store\":\"tikv\",\"path\":\"10.0.1.145:2379\",\"socket\":\"/tmp/tidb-4000.sock\",\"lease\":\"45s\",\"run-ddl\":true,\"split-table\":true,\"token-limit\":1000,\"oom-use-tmp-storage\":true,\"tmp-storage-path\":\"/tmp/1000_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage\",\"oom-action\":\"cancel\",\"mem-quota-query\":1073741824,\"tmp-storage-quota\":-1,\"enable-batch-dml\":false,\"lower-case-table-names\":2,\"server-version\":\"\",\"version-comment\":\"\",\"tidb-edition\":\"\",\"tidb-release-version\":\"\",\"log\":{\"level\":\"info\",\"format\":\"text\",\"disable-timestamp\":null,\"enable-timestamp\":null,\"disable-error-stack\":null,\"enable-error-stack\":null,\"file\":{\"filename\":\"/mnt/data/tidb-deploy/tidb-4000/log/tidb.log\",\"max-size\":300,\"max-days\":0,\"max-backups\":0},\"enable-slow-log\":true,\"slow-query-file\":\"/mnt/data/tidb-deploy/tidb-4000/log/tidb_slow_query.log\",\"slow-threshold\":300,\"expensive-threshold\":10000,\"query-log-max-len\":4096,\"record-plan-in-slow-log\":1},\"security\":{\"skip-grant-table\":false,\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\",\"require-secure-transport\":false,\"cluster-ssl-ca\":\"\",\"cluster-ssl-cert\":\"\",\"cluster-ssl-key\":\"\",\"cluster-verify-cn\":null,\"spilled-file-encryption-method\":\"plaintext\",\"enable-sem\":false,\"auto-tls\":false,\"tls-version\":\"\",\"rsa-key-size\":4096,\"secure-bootstrap\":false},\"status\":{\"status-host\":\"0.0.0.0\",\"metrics-addr\":\"\",\"status-port\":10080,\"metrics-interval\":15,\"report-status\":true,\"record-db-qps\":false,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-concurrent-streams\":1024,\"grpc-initial-window-size\":2097152,\"grpc-max-send-msg-size\":10485760},\"performance\":{\"max-procs\":0,\"max-memory\":0,\"server-memory-quota\":0,\"memory-usage-alarm-ratio\":0.8,\"stats-lease\":\"3s\",\"stmt-count-limit\":5000,\"feedback-probability\":0,\"query-feedback-limit\":512,\"pseudo-estimate-ratio\":0.8,\"force-priority\":\"NO_PRIORITY\",\"bind-info-lease\":\"3s\",\"txn-entry-size-limit\":6291456,\"txn-total-size-limit\":104857600,\"tcp-keep-alive\":true,\"tcp-no-delay\":true,\"cross-join\":true,\"run-auto-analyze\":true,\"distinct-agg-push-down\":false,\"committer-concurrency\":128,\"max-txn-ttl\":3600000,\"index-usage-sync-lease\":\"0s\",\"plan-replayer-gc-lease\":\"10m\",\"gogc\":100,\"enforce-mpp\":false,\"stats-load-concurrency\":5,\"stats-load-queue-size\":1000},\"prepared-plan-cache\":{\"enabled\":false,\"capacity\":1000,\"memory-guard-ratio\":0.1},\"opentracing\":{\"enable\":false,\"rpc-metrics\":false,\"sampler\":{\"type\":\"const\",\"param\":1,\"sampling-server-url\":\"\",\"max-operations\":0,\"sampling-refresh-interval\":0},\"reporter\":{\"queue-size\":0,\"buffer-flush-interval\":0,\"log-spans\":false,\"local-agent-host-port\":\"\"}},\"proxy-protocol\":{\"networks\":\"\",\"header-timeout\":5},\"pd-client\":{\"pd-server-timeout\":3},\"tikv-client\":{\"grpc-connection-count\":4,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-compression-type\":\"none\",\"commit-timeout\":\"41s\",\"async-commit\":{\"keys-limit\":256,\"total-key-size-limit\":4096,\"safe-window\":2000000000,\"allowed-clock-drift\":500000000},\"max-batch-size\":128,\"overload-threshold\":200,\"max-batch-wait-time\":0,\"batch-wait-size\":8,\"enable-chunk-rpc\":true,\"region-cache-ttl\":600,\"store-limit\":0,\"store-liveness-timeout\":\"1s\",\"copr-cache\":{\"capacity-mb\":1000},\"ttl-refreshed-txn-size\":33554432,\"resolve-lock-lite-threshold\":16},\"binlog\":{\"enable\":false,\"ignore-error\":false,\"write-timeout\":\"15s\",\"binlog-socket\":\"\",\"strategy\":\"range\"},\"compatible-kill-query\":false,\"plugin\":{\"dir\":\"/data/deploy/plugin\",\"load\":\"\"},\"pessimistic-txn\":{\"max-retry-count\":256,\"deadlock-history-capacity\":10,\"deadlock-history-collect-retryable\":false,\"pessimistic-auto-commit\":false},\"check-mb4-value-in-utf8\":true,\"max-index-length\":3072,\"index-limit\":64,\"table-column-count-limit\":1017,\"graceful-wait-before-shutdown\":0,\"alter-primary-key\":false,\"treat-old-version-utf8-as-utf8mb4\":true,\"enable-table-lock\":false,\"delay-clean-table-lock\":0,\"split-region-max-num\":1000,\"top-sql\":{\"receiver-address\":\"\"},\"repair-mode\":false,\"repair-table-list\":[],\"isolation-read\":{\"engines\":[\"tikv\",\"tiflash\",\"tidb\"]},\"max-server-connections\":0,\"new_collations_enabled_on_first_bootstrap\":true,\"experimental\":{\"allow-expression-index\":false},\"enable-collect-execution-info\":true,\"skip-register-to-dashboard\":false,\"enable-telemetry\":true,\"labels\":{},\"enable-global-index\":false,\"deprecate-integer-display-length\":false,\"enable-enum-length-limit\":true,\"stores-refresh-interval\":60,\"enable-tcp4-only\":false,\"enable-forwarding\":false,\"max-ballast-object-size\":0,\"ballast-object-size\":0}"]
[2022/06/28 17:06:49.768 +08:00] [INFO] [main.go:345] ["disable Prometheus push client"]
[2022/06/28 17:06:49.768 +08:00] [INFO] [store.go:74] ["new store"] [path=tikv://10.0.1.145:2379]
[2022/06/28 17:06:49.768 +08:00] [INFO] [client.go:392] ["[pd] create pd client with endpoints"] [pd-address="[10.0.1.145:2379]"]
[2022/06/28 17:06:49.768 +08:00] [INFO] [systime_mon.go:26] ["start system time monitor"]
[2022/06/28 17:06:49.771 +08:00] [INFO] [base_client.go:350] ["[pd] switch leader"] [new-leader=http://10.0.1.145:2379] [old-leader=]
[2022/06/28 17:06:49.771 +08:00] [INFO] [base_client.go:105] ["[pd] init cluster id"] [cluster-id=7110132895032081485]
[2022/06/28 17:06:49.771 +08:00] [INFO] [client.go:687] ["[pd] tso dispatcher created"] [dc-location=global]
[2022/06/28 17:06:49.775 +08:00] [INFO] [store.go:80] ["new store with retry success"]
[2022/06/28 17:06:49.780 +08:00] [INFO] [tidb.go:72] ["new domain"] [store=tikv-7110132895032081485] ["ddl lease"=45s] ["stats lease"=3s] ["index usage sync lease"=0s]
[2022/06/28 17:06:49.788 +08:00] [WARN] [info.go:240] ["init TiFlashPlacementManager"] ["pd addrs"="[10.0.1.145:2379]"]
[2022/06/28 17:06:49.802 +08:00] [INFO] [domain.go:171] ["full load InfoSchema success"] [currentSchemaVersion=0] [neededSchemaVersion=32] ["start time"=11.184712ms]
[2022/06/28 17:06:49.803 +08:00] [INFO] [domain.go:431] ["full load and reset schema validator"]
[2022/06/28 17:06:49.803 +08:00] [INFO] [ddl.go:378] ["[ddl] start DDL"] [ID=c3f5a8d2-5a19-481e-9461-e57e7fdb2d57] [runWorker=true]
[2022/06/28 17:06:49.803 +08:00] [INFO] [manager.go:189] ["start campaign owner"] [ownerInfo="[ddl] /tidb/ddl/fg/owner"]
[2022/06/28 17:06:49.803 +08:00] [INFO] [ddl.go:367] ["[ddl] start delRangeManager OK"] ["is a emulator"=false]
[2022/06/28 17:06:49.804 +08:00] [INFO] [ddl_worker.go:161] ["[ddl] start DDL worker"] [worker="worker 2, tp add index"]
[2022/06/28 17:06:49.804 +08:00] [INFO] [ddl_worker.go:161] ["[ddl] start DDL worker"] [worker="worker 1, tp general"]
[2022/06/28 17:06:49.812 +08:00] [WARN] [coprocessor.go:981] ["other error"] [txnStartTS=434217211607646211] [regionID=38] [storeAddr=10.0.1.145:20160] [error="other error: [components/tidb_query_datatype/src/expr/ctx.rs:86]: evaluation failed: unknown or incorrect time zone: Asia/Beijing"]
[2022/06/28 17:06:49.812 +08:00] [FATAL] [terror.go:292] ["unexpected error"] [error="other error: [components/tidb_query_datatype/src/expr/ctx.rs:86]: evaluation failed: unknown or incorrect time zone: Asia/Beijing"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"]
[2022/06/28 17:07:05.015 +08:00] [INFO] [cpuprofile.go:115] ["parallel cpu profiler started"]
[2022/06/28 17:07:05.016 +08:00] [INFO] [printer.go:34] ["Welcome to TiDB."] ["Release Version"=v6.0.0] [Edition=Community] ["Git Commit Hash"=36a9810441ca0e496cbd22064af274b3be771081] ["Git Branch"=heads/refs/tags/v6.0.0] ["UTC Build Time"="2022-03-31 10:33:28"] [GoVersion=go1.18] ["Race Enabled"=false] ["Check Table Before Drop"=false] ["TiKV Min Version"=v3.0.0-60965b006877ca7234adaced7890d7b029ed1306]
[2022/06/28 17:07:05.017 +08:00] [INFO] [printer.go:48] ["loaded config"] [config="{\"host\":\"0.0.0.0\",\"advertise-address\":\"10.0.1.145\",\"port\":4000,\"cors\":\"\",\"store\":\"tikv\",\"path\":\"10.0.1.145:2379\",\"socket\":\"/tmp/tidb-4000.sock\",\"lease\":\"45s\",\"run-ddl\":true,\"split-table\":true,\"token-limit\":1000,\"oom-use-tmp-storage\":true,\"tmp-storage-path\":\"/tmp/1000_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage\",\"oom-action\":\"cancel\",\"mem-quota-query\":1073741824,\"tmp-storage-quota\":-1,\"enable-batch-dml\":false,\"lower-case-table-names\":2,\"server-version\":\"\",\"version-comment\":\"\",\"tidb-edition\":\"\",\"tidb-release-version\":\"\",\"log\":{\"level\":\"info\",\"format\":\"text\",\"disable-timestamp\":null,\"enable-timestamp\":null,\"disable-error-stack\":null,\"enable-error-stack\":null,\"file\":{\"filename\":\"/mnt/data/tidb-deploy/tidb-4000/log/tidb.log\",\"max-size\":300,\"max-days\":0,\"max-backups\":0},\"enable-slow-log\":true,\"slow-query-file\":\"/mnt/data/tidb-deploy/tidb-4000/log/tidb_slow_query.log\",\"slow-threshold\":300,\"expensive-threshold\":10000,\"query-log-max-len\":4096,\"record-plan-in-slow-log\":1},\"security\":{\"skip-grant-table\":false,\"ssl-ca\":\"\",\"ssl-cert\":\"\",\"ssl-key\":\"\",\"require-secure-transport\":false,\"cluster-ssl-ca\":\"\",\"cluster-ssl-cert\":\"\",\"cluster-ssl-key\":\"\",\"cluster-verify-cn\":null,\"spilled-file-encryption-method\":\"plaintext\",\"enable-sem\":false,\"auto-tls\":false,\"tls-version\":\"\",\"rsa-key-size\":4096,\"secure-bootstrap\":false},\"status\":{\"status-host\":\"0.0.0.0\",\"metrics-addr\":\"\",\"status-port\":10080,\"metrics-interval\":15,\"report-status\":true,\"record-db-qps\":false,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-concurrent-streams\":1024,\"grpc-initial-window-size\":2097152,\"grpc-max-send-msg-size\":10485760},\"performance\":{\"max-procs\":0,\"max-memory\":0,\"server-memory-quota\":0,\"memory-usage-alarm-ratio\":0.8,\"stats-lease\":\"3s\",\"stmt-count-limit\":5000,\"feedback-probability\":0,\"query-feedback-limit\":512,\"pseudo-estimate-ratio\":0.8,\"force-priority\":\"NO_PRIORITY\",\"bind-info-lease\":\"3s\",\"txn-entry-size-limit\":6291456,\"txn-total-size-limit\":104857600,\"tcp-keep-alive\":true,\"tcp-no-delay\":true,\"cross-join\":true,\"run-auto-analyze\":true,\"distinct-agg-push-down\":false,\"committer-concurrency\":128,\"max-txn-ttl\":3600000,\"index-usage-sync-lease\":\"0s\",\"plan-replayer-gc-lease\":\"10m\",\"gogc\":100,\"enforce-mpp\":false,\"stats-load-concurrency\":5,\"stats-load-queue-size\":1000},\"prepared-plan-cache\":{\"enabled\":false,\"capacity\":1000,\"memory-guard-ratio\":0.1},\"opentracing\":{\"enable\":false,\"rpc-metrics\":false,\"sampler\":{\"type\":\"const\",\"param\":1,\"sampling-server-url\":\"\",\"max-operations\":0,\"sampling-refresh-interval\":0},\"reporter\":{\"queue-size\":0,\"buffer-flush-interval\":0,\"log-spans\":false,\"local-agent-host-port\":\"\"}},\"proxy-protocol\":{\"networks\":\"\",\"header-timeout\":5},\"pd-client\":{\"pd-server-timeout\":3},\"tikv-client\":{\"grpc-connection-count\":4,\"grpc-keepalive-time\":10,\"grpc-keepalive-timeout\":3,\"grpc-compression-type\":\"none\",\"commit-timeout\":\"41s\",\"async-commit\":{\"keys-limit\":256,\"total-key-size-limit\":4096,\"safe-window\":2000000000,\"allowed-clock-drift\":500000000},\"max-batch-size\":128,\"overload-threshold\":200,\"max-batch-wait-time\":0,\"batch-wait-size\":8,\"enable-chunk-rpc\":true,\"region-cache-ttl\":600,\"store-limit\":0,\"store-liveness-timeout\":\"1s\",\"copr-cache\":{\"capacity-mb\":1000},\"ttl-refreshed-txn-size\":33554432,\"resolve-lock-lite-threshold\":16},\"binlog\":{\"enable\":false,\"ignore-error\":false,\"write-timeout\":\"15s\",\"binlog-socket\":\"\",\"strategy\":\"range\"},\"compatible-kill-query\":false,\"plugin\":{\"dir\":\"/data/deploy/plugin\",\"load\":\"\"},\"pessimistic-txn\":{\"max-retry-count\":256,\"deadlock-history-capacity\":10,\"deadlock-history-collect-retryable\":false,\"pessimistic-auto-commit\":false},\"check-mb4-value-in-utf8\":true,\"max-index-length\":3072,\"index-limit\":64,\"table-column-count-limit\":1017,\"graceful-wait-before-shutdown\":0,\"alter-primary-key\":false,\"treat-old-version-utf8-as-utf8mb4\":true,\"enable-table-lock\":false,\"delay-clean-table-lock\":0,\"split-region-max-num\":1000,\"top-sql\":{\"receiver-address\":\"\"},\"repair-mode\":false,\"repair-table-list\":[],\"isolation-read\":{\"engines\":[\"tikv\",\"tiflash\",\"tidb\"]},\"max-server-connections\":0,\"new_collations_enabled_on_first_bootstrap\":true,\"experimental\":{\"allow-expression-index\":false},\"enable-collect-execution-info\":true,\"skip-register-to-dashboard\":false,\"enable-telemetry\":true,\"labels\":{},\"enable-global-index\":false,\"deprecate-integer-display-length\":false,\"enable-enum-length-limit\":true,\"stores-refresh-interval\":60,\"enable-tcp4-only\":false,\"enable-forwarding\":false,\"max-ballast-object-size\":0,\"ballast-object-size\":0}"]
[2022/06/28 17:07:05.017 +08:00] [INFO] [main.go:345] ["disable Prometheus push client"]
[2022/06/28 17:07:05.017 +08:00] [INFO] [store.go:74] ["new store"] [path=tikv://10.0.1.145:2379]
[2022/06/28 17:07:05.017 +08:00] [INFO] [client.go:392] ["[pd] create pd client with endpoints"] [pd-address="[10.0.1.145:2379]"]
[2022/06/28 17:07:05.017 +08:00] [INFO] [systime_mon.go:26] ["start system time monitor"]
[2022/06/28 17:07:05.020 +08:00] [INFO] [base_client.go:350] ["[pd] switch leader"] [new-leader=http://10.0.1.145:2379] [old-leader=]
[2022/06/28 17:07:05.020 +08:00] [INFO] [base_client.go:105] ["[pd] init cluster id"] [cluster-id=7110132895032081485]
[2022/06/28 17:07:05.020 +08:00] [INFO] [client.go:687] ["[pd] tso dispatcher created"] [dc-location=global]
[2022/06/28 17:07:05.025 +08:00] [INFO] [store.go:80] ["new store with retry success"]
[2022/06/28 17:07:05.029 +08:00] [INFO] [tidb.go:72] ["new domain"] [store=tikv-7110132895032081485] ["ddl lease"=45s] ["stats lease"=3s] ["index usage sync lease"=0s]
[2022/06/28 17:07:05.038 +08:00] [WARN] [info.go:240] ["init TiFlashPlacementManager"] ["pd addrs"="[10.0.1.145:2379]"]
[2022/06/28 17:07:05.053 +08:00] [INFO] [domain.go:171] ["full load InfoSchema success"] [currentSchemaVersion=0] [neededSchemaVersion=32] ["start time"=11.302092ms]
[2022/06/28 17:07:05.053 +08:00] [INFO] [domain.go:431] ["full load and reset schema validator"]
[2022/06/28 17:07:05.053 +08:00] [INFO] [ddl.go:378] ["[ddl] start DDL"] [ID=720c00da-386d-4650-9a19-55bbeb9293bf] [runWorker=true]
[2022/06/28 17:07:05.053 +08:00] [INFO] [manager.go:189] ["start campaign owner"] [ownerInfo="[ddl] /tidb/ddl/fg/owner"]
[2022/06/28 17:07:05.054 +08:00] [INFO] [ddl.go:367] ["[ddl] start delRangeManager OK"] ["is a emulator"=false]
[2022/06/28 17:07:05.054 +08:00] [INFO] [ddl_worker.go:161] ["[ddl] start DDL worker"] [worker="worker 2, tp add index"]
[2022/06/28 17:07:05.054 +08:00] [INFO] [ddl_worker.go:161] ["[ddl] start DDL worker"] [worker="worker 1, tp general"]
[2022/06/28 17:07:05.062 +08:00] [WARN] [coprocessor.go:981] ["other error"] [txnStartTS=434217215605342212] [regionID=38] [storeAddr=10.0.1.145:20160] [error="other error: [components/tidb_query_datatype/src/expr/ctx.rs:86]: evaluation failed: unknown or incorrect time zone: Asia/Beijing"]
[2022/06/28 17:07:05.062 +08:00] [FATAL] [terror.go:292] ["unexpected error"] [error="other error: [components/tidb_query_datatype/src/expr/ctx.rs:86]: evaluation failed: unknown or incorrect time zone: Asia/Beijing"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"] [stack="github.com/pingcap/tidb/parser/terror.MustNil\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/parser/terror/terror.go:292\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:299\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:204\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250"]
Defined2014 commented 2 years ago

I think no Asia/Beijing timezone in golang and most time zone databases. Perfer use Asia/Shanghai instead of it.

bulibuqiyaoyao133 commented 2 years ago

image

bulibuqiyaoyao133 commented 2 years ago

我认为golang和大多数时区数据库中没有时区。Perfer使用而不是它。Asia/Beijing``Asia/Shanghai

I have modified the time zone problem, but the same error is still reported, the problem has not been solved （时区问题我做过修改，但是还是报同样的错误 ，问题没有得到解决）

xihong08 commented 2 years ago

Is there a solution to this problem? I had the same problem