tidb icon indicating copy to clipboard operation
tidb copied to clipboard

Published 20 hours ago • verified publisher icon pingcap

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

Open bulibuqiyaoyao133 opened this issue 2 years ago • 4 comments

问题：安装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 ([email protected]) (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...

  • [ Serial ] - SSHKeySet: privateKey=/root/.tiup/storage/cluster/clusters/bigbirdmeddb/ssh/id_rsa, publicKey=/root/.tiup/storage/cluster/clusters/bigbi rdmeddb/ssh/id_rsa.pub
  • [Parallel] - UserSSH: user=tidb, host=10.0.1.145
  • [Parallel] - UserSSH: user=tidb, host=10.0.1.145
  • [Parallel] - UserSSH: user=tidb, host=10.0.1.145
  • [Parallel] - UserSSH: user=tidb, host=10.0.1.145
  • [ Serial ] - StartCluster Starting component pd Starting instance 10.0.1.145:2379 Start instance 10.0.1.145:2379 success Starting component tikv Starting instance 10.0.1.145:20160 Start instance 10.0.1.145:20160 success Starting component tidb Starting instance 10.0.1.145:4000

启动过程中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"]

bulibuqiyaoyao133 avatar Jun 29 '22 02:06 bulibuqiyaoyao133

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

Defined2014 avatar Jun 29 '22 02:06 Defined2014

image

bulibuqiyaoyao133 avatar Jun 29 '22 05:06 bulibuqiyaoyao133

我认为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 （时区问题我做过修改，但是还是报同样的错误 ，问题没有得到解决）

bulibuqiyaoyao133 avatar Jun 29 '22 06:06 bulibuqiyaoyao133

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

xihong08 avatar Sep 21 '22 00:09 xihong08