【 TiDB 使用环境】-测试
【 TiDB 版本】v6.5.0
[root@iZbp1iiabbh23090k1z3xsZ package]# tail -f /tidblightning1/package/tidb-lightning.log
[2023/02/08 16:16:06.130 +08:00] [WARN] [config.go:483] [“currently only per-task configuration can be applied, global configuration changes can only be made on startup”] [“global config changes”=“[lightning.level,lightning.file]”]
[2023/02/08 16:16:06.130 +08:00] [INFO] [info.go:40] [“Welcome to TiDB-Lightning”] [release-version=v5.0.1] [git-hash=b3bd5495369244cfb1d3f2c49763a7fdb55d4ecd] [git-branch=heads/refs/tags/v5.0.1] [go-version=go1.13] [utc-build-time=“2021-04-23 06:02:57”] [race-enabled=false]
[2023/02/08 16:16:06.130 +08:00] [INFO] [lightning.go:218] [cfg] [cfg=“{"id":1675844166130411410,"lightning":{"table-concurrency":6,"index-concurrency":2,"region-concurrency":1,"io-concurrency":5,"check-requirements":false},"tidb":{"host":"127.0.0.1","port":4000,"user":"root","status-port":10080,"pd-addr":"10.246.51.222:2379","sql-mode":"ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER","tls":"false","security":{"ca-path":"","cert-path":"","key-path":"","redact-info-log":false},"max-allowed-packet":67108864,"distsql-scan-concurrency":15,"build-stats-concurrency":20,"index-serial-scan-concurrency":20,"checksum-table-concurrency":2},"checkpoint":{"schema":"tidb_lightning_checkpoint","driver":"file","enable":false,"keep-after-success":false},"mydumper":{"read-block-size":65536,"batch-size":107374182400,"batch-import-ratio":0,"data-source-dir":"file:///tidblightning2/csv","character-set":"auto","csv":{"separator":"|@|","delimiter":"","null":"","header":false,"trim-last-separator":false,"not-null":false,"backslash-escape":false},"max-region-size":268435456,"filter":[".","!mysql.","!sys.","!INFORMATION_SCHEMA.","!PERFORMANCE_SCHEMA.","!METRICS_SCHEMA.","!INSPECTION_SCHEMA."],"files":null,"no-schema":false,"case-sensitive":false,"strict-format":false,"default-file-rules":true},"tikv-importer":{"addr":"","backend":"local","on-duplicate":"replace","max-kv-pairs":4096,"send-kv-pairs":32768,"region-split-size":100663296,"sorted-kv-dir":"/tidblightning1/data_sort","disk-quota":17553166336,"range-concurrency":16,"engine-mem-cache-size":536870912,"local-writer-mem-cache-size":134217728},"post-restore":{"checksum":"off","analyze":"required","level-1-compact":false,"post-process-at-last":true,"compact":false},"cron":{"switch-mode":"5m0s","log-progress":"5m0s","check-disk-quota":"0s"},"routes":null,"security":{"ca-path":"","cert-path":"","key-path":"","redact-info-log":false},"black-white-list":{"do-tables":null,"do-dbs":null,"ignore-tables":null,"ignore-dbs":null}}”]
[2023/02/08 16:16:06.150 +08:00] [INFO] [lightning.go:285] [“load data source start”]
[2023/02/08 16:16:06.150 +08:00] [ERROR] [lightning.go:288] [“load data source failed”] [takeTime=241.58µs] [error=“no schema create sql files found. Please either set mydumper.no-schema to true or add schema sql file for each database”]
[2023/02/08 16:16:06.150 +08:00] [ERROR] [main.go:90] [“tidb lightning encountered error stack info”] [error=“no schema create sql files found. Please either set mydumper.no-schema to true or add schema sql file for each database”] [errorVerbose=“no schema create sql files found. Please either set mydumper.no-schema to true or add schema sql file for each database\ngithub.com/pingcap/br/pkg/lightning/mydump.(*mdLoaderSetup).setup\n\tgithub.com/pingcap/br@/pkg/lightning/mydump/loader.go:222\ngithub.com/pingcap/br/pkg/lightning/mydump.NewMyDumpLoaderWithStore\n\tgithub.com/pingcap/br@/pkg/lightning/mydump/loader.go:158\ngithub.com/pingcap/br/pkg/lightning.(*Lightning).run\n\tgithub.com/pingcap/br@/pkg/lightning/lightning.go:287\ngithub.com/pingcap/br/pkg/lightning.(*Lightning).RunOnce\n\tgithub.com/pingcap/br@/pkg/lightning/lightning.go:191\nmain.main.func2\n\tgithub.com/pingcap/br@/cmd/tidb-lightning/main.go:86\nmain.main\n\tgithub.com/pingcap/br@/cmd/tidb-lightning/main.go:87\nruntime.main\n\truntime/proc.go:203\nruntime.goexit\n\truntime/asm_amd64.s:1357”]
[2023/02/08 16:16:06.150 +08:00] [ERROR] [main.go:91] [“tidb lightning encountered error”] [error=“no schema create sql files found. Please either set mydumper.no-schema to true or add schema sql file for each database”]