使用Local模式导入数据(sysbench 初始化的10张1千万表) 结束阶段报设置自增值报错，提示表不存在，Lightning 报错后退出，检查数据库内确实没有表. 看上去Local 导入后schema信息还没完整就执行ALTER TABLE AUTO_INCREMENT了
tidb-lightning -tidb-host 10.xxx -tidb-port 4001 -tidb-user root -tidb-password ‘xxxxx’ -d /data1/dump -pd-urls 10.xxx:23791 -backend local -f “sbtest.*” -sorted-kv-dir=/data/dm
[2023/12/22 14:57:16.104 +08:00] [INFO] [tidb.go:317] ["alter table auto_increment start"] [table=`sbtest`.`sbtest2`] [auto_increment=10132488]
[2023/12/22 14:57:16.105 +08:00] [WARN] [util.go:197] ["alter table auto_increment failed with no retry"] [table=`sbtest`.`sbtest2`] [auto_increment=10132488] [query="ALTER TABLE `sbtest`.`sbtest2` AUTO_INCREMENT=10132488"] [args=null] [retryCnt=0] [error="Error 1146 (42S02): Table 'sbtest.sbtest2' doesn't exist"]
[2023/12/22 14:57:16.105 +08:00] [ERROR] [tidb.go:320] ["alter table auto_increment failed"] [table=`sbtest`.`sbtest2`] [auto_increment=10132488] [takeTime=649.124µs] [error="alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest2' doesn't exist"]
[2023/12/22 14:57:16.105 +08:00] [ERROR] [tidb.go:322] ["alter table auto_increment failed, please perform the query manually (this is needed no matter the table has an auto-increment column or not)"] [table=`sbtest`.`sbtest2`] [auto_increment=10132488] [query="ALTER TABLE `sbtest`.`sbtest2` AUTO_INCREMENT=10132488"]
[2023/12/22 14:57:16.105 +08:00] [INFO] [tidb.go:317] ["alter table auto_increment start"] [table=`sbtest`.`sbtest1`] [auto_increment=10144716]
[2023/12/22 14:57:16.105 +08:00] [ERROR] [import.go:1672] ["failed to import table"] [table=`sbtest`.`sbtest2`] [error="ALTER TABLE `sbtest`.`sbtest2` AUTO_INCREMENT=10132488: alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest2' doesn't exist"] [errorVerbose="Error 1146 (42S02): Table 'sbtest.sbtest2' doesn't exist\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/juju_adaptor.go:15\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.Exec.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:290\ngithub.com/pingcap/tidb/br/pkg/lightning/common.Retry\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:186\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.perform\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:171\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.Exec\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:288\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.AlterAutoIncrement\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/tidb.go:319\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*TableImporter).postProcess\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/table_import.go:913\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*TableImporter).importTable\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/table_import.go:218\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*Controller).importTables.func6\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/import.go:1670\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_arm64.s:1172\nalter table auto_increment failed\nALTER TABLE `sbtest`.`sbtest2` AUTO_INCREMENT=10132488"]
[2023/12/22 14:57:16.106 +08:00] [ERROR] [import.go:1676] ["restore table failed"] [table=`sbtest`.`sbtest2`] [takeTime=47.586969605s] [error="[Lightning:Restore:ErrRestoreTable]restore table `sbtest`.`sbtest2` failed: ALTER TABLE `sbtest`.`sbtest2` AUTO_INCREMENT=10132488: alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest2' doesn't exist"]
[2023/12/22 14:57:16.106 +08:00] [WARN] [util.go:197] ["alter table auto_increment failed with no retry"] [table=`sbtest`.`sbtest1`] [auto_increment=10144716] [query="ALTER TABLE `sbtest`.`sbtest1` AUTO_INCREMENT=10144716"] [args=null] [retryCnt=0] [error="Error 1146 (42S02): Table 'sbtest.sbtest1' doesn't exist"]
[2023/12/22 14:57:16.106 +08:00] [ERROR] [tidb.go:320] ["alter table auto_increment failed"] [table=`sbtest`.`sbtest1`] [auto_increment=10144716] [takeTime=319.292µs] [error="alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest1' doesn't exist"]
[2023/12/22 14:57:16.106 +08:00] [ERROR] [tidb.go:322] ["alter table auto_increment failed, please perform the query manually (this is needed no matter the table has an auto-increment column or not)"] [table=`sbtest`.`sbtest1`] [auto_increment=10144716] [query="ALTER TABLE `sbtest`.`sbtest1` AUTO_INCREMENT=10144716"]
[2023/12/22 14:57:16.106 +08:00] [ERROR] [import.go:1672] ["failed to import table"] [table=`sbtest`.`sbtest1`] [error="ALTER TABLE `sbtest`.`sbtest1` AUTO_INCREMENT=10144716: alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest1' doesn't exist"] [errorVerbose="Error 1146 (42S02): Table 'sbtest.sbtest1' doesn't exist\ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/errors.go:174\ngithub.com/pingcap/errors.Trace\n\t/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20221009092201-b66cddb77c32/juju_adaptor.go:15\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.Exec.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:290\ngithub.com/pingcap/tidb/br/pkg/lightning/common.Retry\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:186\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.perform\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:171\ngithub.com/pingcap/tidb/br/pkg/lightning/common.SQLWithRetry.Exec\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/common/util.go:288\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.AlterAutoIncrement\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/tidb.go:319\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*TableImporter).postProcess\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/table_import.go:913\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*TableImporter).importTable\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/table_import.go:218\ngithub.com/pingcap/tidb/br/pkg/lightning/importer.(*Controller).importTables.func6\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/br/br/pkg/lightning/importer/import.go:1670\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_arm64.s:1172\nalter table auto_increment failed\nALTER TABLE `sbtest`.`sbtest1` AUTO_INCREMENT=10144716"]
[2023/12/22 14:57:16.106 +08:00] [ERROR] [import.go:1676] ["restore table failed"] [table=`sbtest`.`sbtest1`] [takeTime=47.586598214s] [error="[Lightning:Restore:ErrRestoreTable]restore table `sbtest`.`sbtest1` failed: ALTER TABLE `sbtest`.`sbtest1` AUTO_INCREMENT=10144716: alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest1' doesn't exist"]
[2023/12/22 14:57:16.106 +08:00] [INFO] [import.go:1385] ["cancel periodic actions"] [do=true]
[2023/12/22 14:57:16.106 +08:00] [INFO] [import.go:1990] ["switch import mode"] [mode=Normal]
[2023/12/22 14:57:16.373 +08:00] [ERROR] [import.go:1633] ["restore all tables data failed"] [takeTime=3m58.638539339s] [error="[Lightning:Restore:ErrRestoreTable]restore table `sbtest`.`sbtest4` failed: ALTER TABLE `sbtest`.`sbtest4` AUTO_INCREMENT=10104593: alter table auto_increment failed: Error 1146 (42S02): Table 'sbtest.sbtest4' doesn't exist"]
