【 TiDB 使用环境】测试
【 TiDB 版本】v6.4.0
【复现路径】手动部署失败
【遇到的问题：问题现象及影响】使用tiup playground部署是成功的，但是手工deploy，tidb-server启动不来
【资源配置】
【附件：截图/日志/监控】
[2022/12/30 18:52:04.516 +08:00] [INFO] [ddl.go:1105] [“[ddl] DDL job is finished”] [jobID=37]
[2022/12/30 18:52:04.516 +08:00] [INFO] [callback.go:121] [“performing DDL change, must reload”]
[2022/12/30 18:52:04.516 +08:00] [INFO] [split_region.go:85] [“split batch regions request”] [“split key count”=1] [“batch count”=1] [“first batch, region ID”=10] [“first split key”=748000000000000024]
[2022/12/30 18:52:04.521 +08:00] [INFO] [split_region.go:187] [“batch split regions complete”] [“batch region ID”=10] [“first at”=748000000000000024] [“first new region left”=“{Id:44 StartKey:7480000000000000ff2200000000000000f8 EndKey:7480000000000000ff2400000000000000f8 RegionEpoch:{ConfVer:1 Version:22} Peers:[id:45 store_id:1 ] EncryptionMeta: IsInFlashback:false}”] [“new region count”=1]
[2022/12/30 18:52:04.521 +08:00] [INFO] [split_region.go:236] [“split regions complete”] [“region count”=1] [“region IDs”=“[44]”]
[2022/12/30 18:52:13.853 +08:00] [INFO] [global.go:34] [“daemon became owner”] [id=378d35a3-36d1-44ee-99e5-32a098f9e08a] [daemon-id=LogBackup::Advancer]
[2022/12/30 18:53:19.518 +08:00] [INFO] [region_request.go:794] [“mark store’s regions need be refill”] [id=1] [addr=192.168.1.187:20160] [error=“context deadline exceeded”]
[2022/12/30 18:53:19.519 +08:00] [WARN] [session.go:989] [“can not retry txn”] [label=internal] [error=“context deadline exceeded”] [IsBatchInsert=false] [IsPessimistic=false] [InRestrictedSQL=true] [tidb_retry_limit=10] [tidb_disable_txn_auto_retry=true]
[2022/12/30 18:53:19.519 +08:00] [WARN] [session.go:1005] [“commit failed”] [“finished txn”=“Txn{state=invalid}”] [error=“context deadline exceeded”]
[2022/12/30 18:53:19.520 +08:00] [WARN] [session.go:2191] [“run statement failed”] [schemaVersion=18] [error=“context deadline exceeded”] [session=“{\n "currDBName": "mysql",\n "id": 0,\n "status": 2,\n "strictMode": true,\n "user": null\n}”]
[2022/12/30 18:53:19.520 +08:00] [FATAL] [bootstrap.go:2192] [“mustExecute error”] [error=“context deadline exceeded”] [stack=“github.com/pingcap/tidb/session.mustExecute\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/bootstrap.go:2192\ngithub.com/pingcap/tidb/session.insertBuiltinBindInfoRow\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/bootstrap.go:1513\ngithub.com/pingcap/tidb/session.initBindInfoTable\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/bootstrap.go:1509\ngithub.com/pingcap/tidb/session.doDDLWorks\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/bootstrap.go:2044\ngithub.com/pingcap/tidb/session.bootstrap\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/bootstrap.go:455\ngithub.com/pingcap/tidb/session.runInBootstrapSession\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:3002\ngithub.com/pingcap/tidb/session.BootstrapSession\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:2875\nmain.createStoreAndDomain\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:310\nmain.main\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/tidb-server/main.go:211\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:250”]
[2022/12/30 18:53:34.796 +08:00] [INFO] [cpuprofile.go:113] [“parallel cpu profiler started”]
[2022/12/30 18:53:34.797 +08:00] [INFO] [printer.go:34] [“Welcome to TiDB.”] [“Release Version”=v6.4.0] [Edition=Community] [“Git Commit Hash”=cf36a9ce2fe1039db3cf3444d51930b887df18a1] [“Git Branch”=heads/refs/tags/v6.4.0] [“UTC Build Time”=“2022-11-13 05:25:30”] [GoVersion=go1.19.2] [“Race Enabled”=false] [“Check Table Before Drop”=false] [“TiKV Min Version”=6.2.0-alpha]
[2022/12/30 18:53:34.797 +08:00] [INFO] [printer.go:48] [“loaded config”] [config=“{"host":"0.0.0.0","advertise-address":"192.168.1.187","port":44000,"cors":"","store":"tikv","path":"192.168.1.187:2379","socket":"/tmp/tidb-44000.sock","lease":"45s","split-table":true,"token-limit":1000,"temp-dir":"/tmp/tidb","tmp-storage-path":"/tmp/1001_tidb/MC4wLjAuMDo0NDAwMC8wLjAuMC4wOjEwMDgw/tmp-storage","tmp-storage-quota":-1,"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":"/tidb-deploy/tidb-44000/log/tidb.log","max-size":300,"max-days":0,"max-backups":0},"slow-query-file":"/tidb-deploy/tidb-44000/log/tidb_slow_query.log","expensive-threshold":10000,"query-log-max-len":4096,"enable-slow-log":true,"slow-threshold":300,"record-plan-in-slow-log":1},"instance":{"tidb_general_log":false,"tidb_pprof_sql_cpu":false,"ddl_slow_threshold":300,"tidb_expensive_query_time_threshold":60,"tidb_enable_slow_log":true,"tidb_slow_log_threshold":300,"tidb_record_plan_in_slow_log":1,"tidb_check_mb4_value_in_utf8":true,"tidb_force_priority":"NO_PRIORITY","tidb_memory_usage_alarm_ratio":0.8,"tidb_enable_collect_execution_info":true,"plugin_dir":"/data/deploy/plugin","plugin_load":"","max_connections":0,"tidb_enable_ddl":true,"tidb_rc_read_check_ts":false},"security":{"skip-grant-table":false,"ssl-ca":"","ssl-cert":"","ssl-key":"","cluster-ssl-ca":"","cluster-ssl-cert":"","cluster-ssl-key":"","cluster-verify-cn":null,"session-token-signing-cert":"","session-token-signing-key":"","spilled-file-encryption-method":"plaintext","enable-sem":false,"auto-tls":false,"tls-version":"","rsa-key-size":4096,"secure-bootstrap":false,"auth-token-jwks":"","auth-token-refresh-interval":"1h0m0s"},"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":2147483647},"performance":{"max-procs":0,"max-memory":0,"server-memory-quota":0,"stats-lease":"3s","stmt-count-limit":5000,"pseudo-estimate-ratio":0.8,"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,"distinct-agg-push-down":false,"projection-push-down":false,"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,"analyze-partition-concurrency-quota":16,"enable-stats-cache-mem-quota":false,"committer-concurrency":128,"run-auto-analyze":true,"force-priority":"NO_PRIORITY","memory-usage-alarm-ratio":0.8,"enable-load-fmsketch":false},"prepared-plan-cache":{"enabled":true,"capacity":100,"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,"pessimistic-txn":{"max-retry-count":256,"deadlock-history-capacity":10,"deadlock-history-collect-retryable":false,"pessimistic-auto-commit":false,"constraint-check-in-place-pessimistic":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"]},"new_collations_enabled_on_first_bootstrap":true,"experimental":{"allow-expression-index":false},"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,"transaction-summary":{"transaction-summary-capacity":500,"transaction-id-digest-min-duration":2147483647},"enable-global-kill":true,"enable-batch-dml":false,"mem-quota-query":1073741824,"oom-action":"cancel","oom-use-tmp-storage":true,"check-mb4-value-in-utf8":true,"enable-collect-execution-info":true,"plugin":{"dir":"/data/deploy/plugin","load":""},"max-server-connections":0,"run-ddl":true,"tidb-max-reuse-chunk":64,"tidb-max-reuse-column":256}”]
[2022/12/30 18:53:34.797 +08:00] [INFO] [global.go:34] [“disable Prometheus push client”]
[2022/12/30 18:53:34.797 +08:00] [INFO] [store.go:75] [“new store”] [path=tikv://192.168.1.187:2379]
[2022/12/30 18:53:34.797 +08:00] [INFO] [global.go:34] [“[pd] create pd client with endpoints”] [pd-address=“[192.168.1.187:2379]”]
[2022/12/30 18:53:34.797 +08:00] [INFO] [systime_mon.go:26] [“start system time monitor”]
[2022/12/30 18:53:34.799 +08:00] [INFO] [global.go:34] [“[pd] switch leader”] [new-leader=http://192.168.1.187:2379] [old-leader=]
[2022/12/30 18:53:34.799 +08:00] [INFO] [global.go:34] [“[pd] init cluster id”] [cluster-id=7182892640331459658]
[2022/12/30 18:53:34.799 +08:00] [INFO] [global.go:34] [“[pd] tso dispatcher created”] [dc-location=global]
[2022/12/30 18:53:34.800 +08:00] [INFO] [store.go:81] [“new store with retry success”]
[2022/12/30 18:53:34.805 +08:00] [INFO] [tidb.go:77] [“new domain”] [store=tikv-7182892640331459658] [“ddl lease”=45s] [“stats lease”=3s] [“index usage sync lease”=0s]
[2022/12/30 18:53:34.811 +08:00] [INFO] [domain.go:2098] [acquireServerID] [serverID=486506] [“lease id”=10df8562a8e44e95]
[2022/12/30 18:53:34.818 +08:00] [WARN] [info.go:245] [“init TiFlashReplicaManager”] [“pd addrs”=“[192.168.1.187:2379]”]
[2022/12/30 18:53:34.828 +08:00] [INFO] [domain.go:214] [“full load InfoSchema success”] [currentSchemaVersion=0] [neededSchemaVersion=18] [“start time”=6.701988ms]
[2022/12/30 18:53:34.829 +08:00] [INFO] [domain.go:481] [“full load and reset schema validator”]
[2022/12/30 18:53:34.829 +08:00] [INFO] [ddl.go:701] [“[ddl] start DDL”] [ID=40f78b0a-56f9-4562-bcf3-cec25210a7e4] [runWorker=true]
[2022/12/30 18:53:34.829 +08:00] [INFO] [ddl.go:647] [“[ddl] start delRangeManager OK”] [“is a emulator”=false]
[2022/12/30 18:53:34.829 +08:00] [INFO] [manager.go:151] [“start campaign owner”] [ownerInfo=“[ddl] /tidb/ddl/fg/owner”]
[2022/12/30 18:53:34.829 +08:00] [INFO] [ddl_worker.go:171] [“[ddl] start DDL worker”] [worker=“worker 2, tp add index”]
[2022/12/30 18:53:34.829 +08:00] [INFO] [ddl_worker.go:171] [“[ddl] start DDL worker”] [worker=“worker 1, tp general”]
[2022/12/30 18:53:34.830 +08:00] [INFO] [env.go:101] [“[ddl-ingest] the lightning sorted dir”] [“data path:”=/tmp/tidb/tmp_ddl-44000]
[2022/12/30 18:53:34.830 +08:00] [INFO] [env.go:68] [“[ddl-ingest] init global lightning backend environment finished”] [“memory limitation”=2147483648] [“sort path disk quota”=21808488038] [“max open file number”=1000000] [“lightning is initialized”=true]
[2022/12/30 18:53:34.830 +08:00] [INFO] [global.go:34] [“begin advancer daemon”] [daemon-id=LogBackup::Advancer]
[2022/12/30 18:53:34.830 +08:00] [INFO] [manager.go:151] [“start campaign owner”] [ownerInfo=“[log-backup] /tidb/br-stream/owner”]
[2022/12/30 18:53:34.831 +08:00] [INFO] [global.go:34] [“begin running daemon”] [id=57b0f261-c3f9-49b1-8a44-97c903050500] [daemon-id=LogBackup::Advancer]
[2022/12/30 18:53:36.831 +08:00] [INFO] [info.go:1085] [SetTiFlashGroupConfig]
[2022/12/30 18:54:02.454 +08:00] [INFO] [manager.go:296] [“get owner”] [“owner info”=“[log-backup] /tidb/br-stream/owner ownerManager 57b0f261-c3f9-49b1-8a44-97c903050500”] [ownerID=57b0f261-c3f9-49b1-8a44-97c903050500]
[2022/12/30 18:54:02.455 +08:00] [INFO] [manager.go:296] [“get owner”] [“owner info”=“[ddl] /tidb/ddl/fg/owner ownerManager 40f78b0a-56f9-4562-bcf3-cec25210a7e4”] [ownerID=40f78b0a-56f9-4562-bcf3-cec25210a7e4]
[2022/12/30 18:54:02.627 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE DATABASE IF NOT EXISTS test”] [user=]
[2022/12/30 18:54:02.627 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE DATABASE IF NOT EXISTS mysql”] [user=]
[2022/12/30 18:54:02.628 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.user (\n\t\tHost\t\t\t\t\tCHAR(255),\n\t\tUser\t\t\t\t\tCHAR(32),\n\t\tauthentication_string\tTEXT,\n\t\tplugin\t\t\t\t\tCHAR(64),\n\t\tSelect_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tInsert_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tUpdate_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tDelete_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tDrop_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tProcess_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tGrant_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tReferences_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tAlter_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tShow_db_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tSuper_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_tmp_table_priv\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tLock_tables_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tExecute_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_view_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tShow_view_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_routine_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tAlter_routine_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tIndex_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_user_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tEvent_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tRepl_slave_priv\t \tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tRepl_client_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tTrigger_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_role_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tDrop_role_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tAccount_locked\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tShutdown_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tReload_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tFILE_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tConfig_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_Tablespace_Priv ENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tUser_attributes\t\t\tjson,\n\t\tToken_issuer\t\t\tVARCHAR(255),\n\t\tPRIMARY KEY (Host, User));”] [user=]
[2022/12/30 18:54:02.628 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.global_priv (Host CHAR(255) NOT NULL DEFAULT ‘’,User CHAR(80) NOT NULL DEFAULT ‘’,Priv LONGTEXT NOT NULL DEFAULT ‘’,PRIMARY KEY (Host, User))”] [user=]
[2022/12/30 18:54:02.629 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.db (\n\t\tHost\t\t\t\t\tCHAR(255),\n\t\tDB\t\t\t\t\t\tCHAR(64),\n\t\tUser\t\t\t\t\tCHAR(32),\n\t\tSelect_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tInsert_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tUpdate_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tDelete_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tDrop_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tGrant_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tReferences_priv \t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tIndex_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tAlter_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_tmp_table_priv\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tLock_tables_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_view_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tShow_view_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tCreate_routine_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tAlter_routine_priv\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tExecute_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tEvent_priv\t\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tTrigger_priv\t\t\tENUM(‘N’,‘Y’) NOT NULL DEFAULT ‘N’,\n\t\tPRIMARY KEY (Host, DB, User));”] [user=]
[2022/12/30 18:54:02.629 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.tables_priv (\n\t\tHost\t\tCHAR(255),\n\t\tDB\t\t\tCHAR(64),\n\t\tUser\t\tCHAR(32),\n\t\tTable_name\tCHAR(64),\n\t\tGrantor\t\tCHAR(77),\n\t\tTimestamp\tTIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n\t\tTable_priv\tSET(‘Select’,‘Insert’,‘Update’,‘Delete’,‘Create’,‘Drop’,‘Grant’,‘Index’,‘Alter’,‘Create View’,‘Show View’,‘Trigger’,‘References’),\n\t\tColumn_priv\tSET(‘Select’,‘Insert’,‘Update’,‘References’),\n\t\tPRIMARY KEY (Host, DB, User, Table_name));”] [user=]
[2022/12/30 18:54:02.629 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.columns_priv(\n\t\tHost\t\tCHAR(255),\n\t\tDB\t\t\tCHAR(64),\n\t\tUser\t\tCHAR(32),\n\t\tTable_name\tCHAR(64),\n\t\tColumn_name\tCHAR(64),\n\t\tTimestamp\tTIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n\t\tColumn_priv\tSET(‘Select’,‘Insert’,‘Update’,‘References’),\n\t\tPRIMARY KEY (Host, DB, User, Table_name, Column_name));”] [user=]
[2022/12/30 18:54:02.629 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.GLOBAL_VARIABLES(\n\t\tVARIABLE_NAME VARCHAR(64) NOT NULL PRIMARY KEY,\n\t\tVARIABLE_VALUE VARCHAR(1024) DEFAULT NULL);”] [user=]
[2022/12/30 18:54:02.630 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.tidb(\n\t\tVARIABLE_NAME \tVARCHAR(64) NOT NULL PRIMARY KEY,\n\t\tVARIABLE_VALUE \tVARCHAR(1024) DEFAULT NULL,\n\t\tCOMMENT \t\tVARCHAR(1024));”] [user=]
[2022/12/30 18:54:02.630 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.help_topic (\n \t\thelp_topic_id \t\tINT(10) UNSIGNED NOT NULL,\n \t\tname \t\t\t\tCHAR(64) NOT NULL,\n \t\thelp_category_id \tSMALLINT(5) UNSIGNED NOT NULL,\n \t\tdescription \t\tTEXT NOT NULL,\n \t\texample \t\t\tTEXT NOT NULL,\n \t\turl \t\t\t\tTEXT NOT NULL,\n \t\tPRIMARY KEY (help_topic_id) clustered,\n \t\tUNIQUE KEY name (name)\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT=‘help topics’;”] [user=]
[2022/12/30 18:54:02.630 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.stats_meta (\n\t\tversion \t\tBIGINT(64) UNSIGNED NOT NULL,\n\t\ttable_id \t\tBIGINT(64) NOT NULL,\n\t\tmodify_count\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\tcount \t\t\tBIGINT(64) UNSIGNED NOT NULL DEFAULT 0,\n\t\tsnapshot BIGINT(64) UNSIGNED NOT NULL DEFAULT 0,\n\t\tINDEX idx_ver(version),\n\t\tUNIQUE INDEX tbl(table_id)\n\t);”] [user=]
[2022/12/30 18:54:02.631 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.stats_histograms (\n\t\ttable_id \t\t\tBIGINT(64) NOT NULL,\n\t\tis_index \t\t\tTINYINT(2) NOT NULL,\n\t\thist_id \t\t\tBIGINT(64) NOT NULL,\n\t\tdistinct_count \t\tBIGINT(64) NOT NULL,\n\t\tnull_count \t\t\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\ttot_col_size \t\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\tmodify_count \t\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\tversion \t\t\tBIGINT(64) UNSIGNED NOT NULL DEFAULT 0,\n\t\tcm_sketch \t\t\tBLOB(6291456),\n\t\tstats_ver \t\t\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\tflag \t\t\t\tBIGINT(64) NOT NULL DEFAULT 0,\n\t\tcorrelation \t\tDOUBLE NOT NULL DEFAULT 0,\n\t\tlast_analyze_pos \tLONGBLOB DEFAULT NULL,\n\t\tUNIQUE INDEX tbl(table_id, is_index, hist_id)\n\t);”] [user=]
[2022/12/30 18:54:02.631 +08:00] [INFO] [ddl_api.go:1039] [“Automatically convert BLOB(6291456) to MEDIUMBLOB”]
[2022/12/30 18:54:02.631 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.stats_buckets (\n\t\ttable_id \tBIGINT(64) NOT NULL,\n\t\tis_index \tTINYINT(2) NOT NULL,\n\t\thist_id \tBIGINT(64) NOT NULL,\n\t\tbucket_id \tBIGINT(64) NOT NULL,\n\t\tcount \t\tBIGINT(64) NOT NULL,\n\t\trepeats \tBIGINT(64) NOT NULL,\n\t\tupper_bound LONGBLOB NOT NULL,\n\t\tlower_bound LONGBLOB ,\n\t\tndv BIGINT NOT NULL DEFAULT 0,\n\t\tUNIQUE INDEX tbl(table_id, is_index, hist_id, bucket_id)\n\t);”] [user=]
[2022/12/30 18:54:02.631 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.gc_delete_range (\n\t\tjob_id \t\tBIGINT NOT NULL COMMENT "the DDL job ID",\n\t\telement_id \tBIGINT NOT NULL COMMENT "the schema element ID",\n\t\tstart_key \tVARCHAR(255) NOT NULL COMMENT "encoded in hex",\n\t\tend_key \tVARCHAR(255) NOT NULL COMMENT "encoded in hex",\n\t\tts \t\t\tBIGINT NOT NULL COMMENT "timestamp in uint64",\n\t\tUNIQUE KEY delete_range_index (job_id, element_id)\n\t);”] [user=]
[2022/12/30 18:54:02.632 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.gc_delete_range_done (\n\t\tjob_id \t\tBIGINT NOT NULL COMMENT "the DDL job ID",\n\t\telement_id \tBIGINT NOT NULL COMMENT "the schema element ID",\n\t\tstart_key \tVARCHAR(255) NOT NULL COMMENT "encoded in hex",\n\t\tend_key \tVARCHAR(255) NOT NULL COMMENT "encoded in hex",\n\t\tts \t\t\tBIGINT NOT NULL COMMENT "timestamp in uint64",\n\t\tUNIQUE KEY delete_range_done_index (job_id, element_id)\n\t);”] [user=]
[2022/12/30 18:54:02.632 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.stats_feedback (\n\t\ttable_id \tBIGINT(64) NOT NULL,\n\t\tis_index \tTINYINT(2) NOT NULL,\n\t\thist_id \tBIGINT(64) NOT NULL,\n\t\tfeedback \tBLOB NOT NULL,\n\t\tINDEX hist(table_id, is_index, hist_id)\n\t);”] [user=]
[2022/12/30 18:54:02.632 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.role_edges (\n\t\tFROM_HOST \t\t\tCHAR(60) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tFROM_USER \t\t\tCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tTO_HOST \t\t\tCHAR(60) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tTO_USER \t\t\tCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tWITH_ADMIN_OPTION \tENUM(‘N’,‘Y’) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘N’,\n\t\tPRIMARY KEY (FROM_HOST,FROM_USER,TO_HOST,TO_USER)\n\t);”] [user=]
[2022/12/30 18:54:02.632 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.default_roles (\n\t\tHOST \t\t\t\tCHAR(60) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tUSER \t\t\t\tCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tDEFAULT_ROLE_HOST \tCHAR(60) COLLATE utf8_bin NOT NULL DEFAULT ‘%’,\n\t\tDEFAULT_ROLE_USER \tCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT ‘’,\n\t\tPRIMARY KEY (HOST,USER,DEFAULT_ROLE_HOST,DEFAULT_ROLE_USER)\n\t)”] [user=]
[2022/12/30 18:54:02.633 +08:00] [INFO] [session.go:3313] [“CRUCIAL OPERATION”] [conn=0] [schemaVersion=18] [cur_db=mysql] [sql=“CREATE TABLE IF NOT EXISTS mysql.bind_info (\n\t\toriginal_sql TEXT NOT NULL,\n\t\tbind_sql TEXT NOT NULL,\n\t\tdefault_db TEXT NOT NULL,\n\t\tstatus TEXT NOT NULL,\n\t\tcreate_time TIMESTAMP(3) NOT NULL,\n\t\tupdate_time TIMESTAMP(3) NOT NULL,\n\t\tcharset TEXT NOT NULL,\n\t\tcollation TEXT NOT NULL,\n\t\tsource VARCHAR(10) NOT NULL DEFAULT ‘unknown’,\n\t\tINDEX sql_index(original_sql(700),default_db(68)) COMMENT "accelerate the speed when add global binding query",\n\t\tINDEX time_index(update_time) COMMENT "accelerate the speed when querying with last update time"\n\t) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;”] [user=]