Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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 this issue Jun 29, 2022 · 4 comments
Labels
type/question The issue belongs to a question.

Comments

@bulibuqiyaoyao133
Copy link

bulibuqiyaoyao133 commented Jun 29, 2022

问题:安装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...

  • [ 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 bulibuqiyaoyao133 added the type/question The issue belongs to a question. label Jun 29, 2022
@bulibuqiyaoyao133 bulibuqiyaoyao133 changed the title TiUP 初次安装版本6.0.0启动tidb 报错evaluation failed: unknown or incorrect time zone: Asia/Beijing"] 错误 TiUP initial installation version 6.0.0 starts tidb and reports an error evaluation failed: unknown or incorrect time zone: Asia/Beijing"] Error Jun 29, 2022
@Defined2014
Copy link
Contributor

Defined2014 commented Jun 29, 2022

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

@bulibuqiyaoyao133
Copy link
Author

image

@bulibuqiyaoyao133
Copy link
Author

我认为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
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/question The issue belongs to a question.
Projects
None yet
Development

No branches or pull requests

3 participants