查看备份数据任务历史提示(ROOTSERVICE)addr: 10.0.4.7:2890, result: -9071(no I/O operation permission at the backup destination)

执行 chown -R data/ nfsnobody.nfsnobody 后,
查询 SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\G 试下

1 个赞


查看之前的还是不行

这个是我修改权限后备份的还是不行

1 个赞

权限有问题,很可能nfs sever端或者client端配置不正确,你参照这篇文章对比下
https://open.oceanbase.com/blog/1779241472

如果对比下来没问题在帖子回复下

老师,除了这个地方的权限不对,其它的都是正确的。

1 个赞

属组改下试试,在nfs server上将要挂载的nfs一级目录设置为 nfsnobody.nfsnobody

这个改了之后我创建目录的时候会有问题,我前面遇到过,然后我还提了个帖子
ob主租户进行全量备份的时候提示状态提示BEGINNING不是DOING - #7,来自 胖乎乎 是这个,然后我才改成opsuser:nfsnobody的

1 个赞

难道需要将我的opsuser的用户组加入到 nfsnobody这个的用户中才可以么?

没看出来这个问题和文件权限有关,按说nfsnobody.nfsnobody是可以的,将opsuser的用户加入到 nfsnobody组试下

那我把用户权限都改成nfsnobody然后在重新操作一下?

可以的,有问题继续在这里提就可以



老师如上截图所示,我将opsuser的用户加入到nfsnobody的组下都不可以.
然后我将nfs server上挂载nfs的一级目录

然后我设置备份的路径是不行的。所以后面才改成opsuser:nfnobody的但是改成opsuser:nfnobody备份后通过那个命令查看又查看不到

我联系相关老师分析下

好的,麻烦老师了,如果可以我这可以提供远程

环境麻烦暂时保存下,相关老师在分析

你好,请按照如下文档重新配置下,然后发下如下截图:
1./etc/exports 内容截图
2./etc/sysctl.conf 内容截图
3.挂载 NFS的操作命令截图

https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001049949

1.截图1/etc/exports


权限截图:
image
NFS参数截图
image
重启启动NFS截图
image

$ cat /etc/sysctl.conf

sysctl settings are defined through files in

/usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.

Vendors settings live in /usr/lib/sysctl.d/.

To override a whole file, create a new file with the same in

/etc/sysctl.d/ and put new settings there. To override

only specific settings, add a file with a lexically later

name in /etc/sysctl.d/ and put new settings there.

For more information, see sysctl.conf(5) and sysctl.d(5).

#for oceanbase
##修改内核异步 I/O 限制
fs.aio-max-nr=1048576

##网络优化
net.core.somaxconn = 2048
net.core.netdev_max_backlog = 10000
net.core.rmem_default = 16777216
net.core.wmem_default = 16777216
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.tcp_max_syn_backlog = 16384
net.ipv4.tcp_fin_timeout = 15
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_slow_start_after_idle=0

vm.swappiness = 0
vm.min_free_kbytes = 2097152
vm.overcommit_memory = 0

fs.file-max = 6573688

##修改进程可以拥有的虚拟内存区域数量
vm.max_map_count = 655360

vm.overcommit_memory = 0
vm.min_free_kbytes = 2097152

##此处为 OceanBase 数据库的 data 目录
kernel.core_pattern = /mnt/myoceanbase/oceanbase/data/core-%e-%p-%t
fs.pipe-user-pages-soft = 0
sunrpc.tcp_max_slot_table_entries=128

[opsuser@4-7-OB1 mnt]$ tail -n 3 /etc/sysctl.conf
fs.pipe-user-pages-soft = 0
sunrpc.tcp_max_slot_table_entries=128
2. cat /etc/sysctl.conf //systcl.conf的配置
#for oceanbase
##修改内核异步 I/O 限制
fs.aio-max-nr=1048576
##网络优化
net.core.somaxconn = 2048
net.core.netdev_max_backlog = 10000
net.core.rmem_default = 16777216
net.core.wmem_default = 16777216
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.ipv4.tcp_max_syn_backlog = 16384
net.ipv4.tcp_fin_timeout = 15
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_slow_start_after_idle=0
vm.swappiness = 0
vm.min_free_kbytes = 2097152
vm.overcommit_memory = 0
fs.file-max = 6573688
##修改进程可以拥有的虚拟内存区域数量
vm.max_map_count = 655360
vm.overcommit_memory = 0
vm.min_free_kbytes = 2097152
##此处为 OceanBase 数据库的 data 目录
kernel.core_pattern = /mnt/myoceanbase/oceanbase/data/core-%e-%p-%t
fs.pipe-user-pages-soft = 0
sunrpc.tcp_max_slot_table_entries=128
10.0.4.8备的配置


10.0.4.9备的配置
image
3.挂载nfs操作命令的截图(两个备的截图)

现在备份报错的操作截图麻烦也发下

如下截图是登录bddb的租户进行备份


图二是在root租户中进行查询,还是报错

图三是增加路径也是会报错(当权限是nfsnobody的时候)

这里权限 加下写权限再试试

image


还是不行的啊