lightning导入数据失败，提示权限不足？

🪐 TiDB 技术问题 备份&数据迁移
1

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。

  • 【TiDB 版本】：4.0.5
  • 【问题描述】：
    用户是tidb下
    [2020/11/18 19:04:07.255 +08:00] [INFO] [checkpoints.go:876] [“open checkpoint file failed, going to create a new one”] [path=/tmp/tidb_lightning_checkpoint.pb] [error=“open /tmp/tidb_lightning_checkpoint.pb: no such file or directory”]
    [2020/11/18 19:04:07.262 +08:00] [INFO] [restore.go:283] [“the whole procedure start”]
    [2020/11/18 19:04:07.268 +08:00] [INFO] [restore.go:330] [“restore table schema start”] [db=cx_test_manager]
    [2020/11/18 19:04:07.336 +08:00] [INFO] [tidb.go:139] [“create tables start”] [db=cx_test_manager]
    [2020/11/18 19:04:07.411 +08:00] [INFO] [tidb.go:157] [“create tables completed”] [db=cx_test_manager] [takeTime=74.41494ms] []
    [2020/11/18 19:04:07.411 +08:00] [INFO] [restore.go:338] [“restore table schema completed”] [db=cx_test_manager] [takeTime=142.423865ms] []
    [2020/11/18 19:04:07.413 +08:00] [INFO] [restore.go:640] [“restore all tables data start”]
    [2020/11/18 19:04:07.415 +08:00] [INFO] [restore.go:653] [“removing PD leader&region schedulers”]
    [2020/11/18 19:04:07.430 +08:00] [INFO] [restore.go:689] [“restore table start”] [table=cx_test_manager.sy_system_operation]
    [2020/11/18 19:04:07.430 +08:00] [INFO] [restore.go:1451] [“load engines and files start”] [table=cx_test_manager.sy_system_operation]
    [2020/11/18 19:04:07.430 +08:00] [INFO] [restore.go:1489] [“load engines and files completed”] [table=cx_test_manager.sy_system_operation] [enginesCnt=2] [filesCnt=1] [takeTime=41.425µs] []
    [2020/11/18 19:04:07.431 +08:00] [ERROR] [restore.go:693] [“restore table failed”] [table=cx_test_manager.sy_system_operation] [takeTime=554.415µs] [error=“restore table cx_test_manager.sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”]
    [2020/11/18 19:04:07.431 +08:00] [ERROR] [restore.go:810] [“restore all tables data failed”] [takeTime=18.038687ms] [error=“restore table cx_test_manager.sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”]
    [2020/11/18 19:04:07.431 +08:00] [INFO] [restore.go:594] [“everything imported, stopping periodic actions”]
    [2020/11/18 19:04:07.439 +08:00] [INFO] [restore.go:661] [“add back PD leader&region schedulers”]
    [2020/11/18 19:04:07.439 +08:00] [ERROR] [restore.go:302] [“run failed”] [step=3] [error=“restore table cx_test_manager.sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”]
    [2020/11/18 19:04:07.439 +08:00] [ERROR] [restore.go:313] [“the whole procedure failed”] [takeTime=176.927548ms] [error=“restore table cx_test_manager.sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”]
    [2020/11/18 19:04:07.439 +08:00] [ERROR] [main.go:83] [“tidb lightning encountered error stack info”] [error=“restore table cx_test_manager.sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”] [errorVerbose=“mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20200917111840-a15ef68f753d/juju_adaptor.go:15\ github.com/pingcap/tidb-lightning/lightning/restore.(*TableRestore).restoreEngines\ \t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/restore/restore.go:888\ngithub.com/pingcap/tidb-lightning/lightning/restore.(*TableRestore).restoreTable\ \t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/restore/restore.go:859\ngithub.com/pingcap/tidb-lightning/lightning/restore.(*RestoreController).restoreTables.func2\ \t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.8/go/src/github.com/pingcap/tidb-lightning/lightning/restore/restore.go:691\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357\ restore table cx_test_manager.sy_system_operation failed”]
    [2020/11/18 19:04:07.439 +08:00] [ERROR] [main.go:84] [“tidb lightning encountered error”] [error=“restore table cx_test_manager.sy_system_operationfailed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied”]

怎么报权限的问题？目录我已经授权为TIDB了啊

2
  1. restore table cx_test_manager . sy_system_operation failed: mkdir /home/tidb/test-mnt/ddd2f6ae-0910-5a30-b6dc-5deecd39df40: permission denied ， 看起来导入的用户没有在这个目录创建的权限？
  2. 手工试着创建目录看看行不行，不行就检查下 owner 和 权限
3

后来权限解决了，谢谢了

4

:+1:

5

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。