执行 chown -R data/ nfsnobody.nfsnobody 后,
查询 SELECT * FROM oceanbase.CDB_OB_BACKUP_JOB_HISTORY\G 试下
权限有问题,很可能nfs sever端或者client端配置不正确,你参照这篇文章对比下
https://open.oceanbase.com/blog/1779241472
如果对比下来没问题在帖子回复下
属组改下试试,在nfs server上将要挂载的nfs一级目录设置为 nfsnobody.nfsnobody
这个改了之后我创建目录的时候会有问题,我前面遇到过,然后我还提了个帖子
ob主租户进行全量备份的时候提示状态提示BEGINNING不是DOING - #7,来自 胖乎乎 是这个,然后我才改成opsuser:nfsnobody的
难道需要将我的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
权限截图:
NFS参数截图
重启启动NFS截图
$ 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备的配置
3.挂载nfs操作命令的截图(两个备的截图)
现在备份报错的操作截图麻烦也发下