导入数据(load data infile)报没有权限

OceanBase 技术问题
#22

要看是不是这样，你换一个admin用户下的路径试试

#23

old的配置看起来也是默认配置，你们的磁盘配置呢，能否看看我前面说的，疯狂打了哪些日志呢？

#24

/opt是系统根目录
[root@ob2 log]# ll /
total 16
lrwxrwxrwx. 1 root root 7 Aug 16 15:51 bin → usr/bin
dr-xr-xr-x. 5 root root 4096 Aug 17 11:25 boot
drwxr-xr-x 5 admin admin 62 Aug 18 16:12 data
drwxr-xr-x 21 root root 3280 Aug 17 11:24 dev
drwxr-xr-x. 77 root root 8192 Aug 17 17:47 etc
drwxr-xr-x. 3 root root 19 Aug 17 11:03 home
lrwxrwxrwx. 1 root root 7 Aug 16 15:51 lib → usr/lib
lrwxrwxrwx. 1 root root 9 Aug 16 15:51 lib64 → usr/lib64
drwxr-xr-x. 2 root root 6 Apr 11 2018 media
drwxr-xr-x. 2 root root 6 Apr 11 2018 mnt
drwxrwxrwx. 2 root root 22 Aug 18 16:35 opt
dr-xr-xr-x 174 root root 0 Aug 17 11:24 proc
dr-xr-x—. 4 root root 213 Aug 19 15:43 root
drwxr-xr-x 25 root root 700 Aug 17 17:47 run
lrwxrwxrwx. 1 root root 8 Aug 16 15:51 sbin → usr/sbin
drwxr-xr-x. 2 root root 6 Apr 11 2018 srv
dr-xr-xr-x 13 root root 0 Aug 18 16:41 sys
drwxrwxrwt. 8 root root 211 Aug 19 11:44 tmp
drwxr-xr-x 4 root root 35 Aug 17 17:13 u01
drwxr-xr-x. 14 root root 166 Aug 17 17:08 usr
drwxr-xr-x. 19 root root 267 Aug 16 17:07 var

/opt下文件权限:
[root@ob2 opt]# ll
total 23572
-rwxrwxrwx 1 admin admin 24135125 Aug 18 16:27 part.tbl

#25

/opt 是root:root,但你的数据库user是admin:admin,所以自然不能stat(/opt)

#26

日志上面我专门贴了一段 感觉都是正常的server日志 看不出什么问题
数据也没有执行其他任何操作,只启动了服务而已

块引用
日志等级没有改过,使用obd部署的应该是默认的等级,也不知道怎么查
日志看起来都是正常的服务记录正常日志,刷新数据很快这里上传一段日志:

已改权限
chown admin:admin -R /opt
权限检查:
[root@ob2 /]# ll
total 16
lrwxrwxrwx. 1 root root 7 Aug 16 15:51 bin → usr/bin
dr-xr-xr-x. 5 root root 4096 Aug 17 11:25 boot
drwxr-xr-x 5 admin admin 62 Aug 18 16:12 data
drwxr-xr-x 21 root root 3280 Aug 17 11:24 dev
drwxr-xr-x. 77 root root 8192 Aug 17 17:47 etc
drwxr-xr-x. 3 root root 19 Aug 17 11:03 home
lrwxrwxrwx. 1 root root 7 Aug 16 15:51 lib → usr/lib
lrwxrwxrwx. 1 root root 9 Aug 16 15:51 lib64 → usr/lib64
drwxr-xr-x. 2 root root 6 Apr 11 2018 media
drwxr-xr-x. 2 root root 6 Apr 11 2018 mnt
drwxrwxrwx. 2 admin admin 22 Aug 18 16:35 opt
dr-xr-xr-x 177 root root 0 Aug 17 11:24 proc
dr-xr-x—. 4 root root 213 Aug 19 15:43 root
drwxr-xr-x 25 root root 700 Aug 17 17:47 run
lrwxrwxrwx. 1 root root 8 Aug 16 15:51 sbin → usr/sbin
drwxr-xr-x. 2 root root 6 Apr 11 2018 srv
dr-xr-xr-x 13 root root 0 Aug 18 16:41 sys
drwxrwxrwt. 8 root root 211 Aug 19 11:44 tmp
drwxr-xr-x 4 root root 35 Aug 17 17:13 u01
drwxr-xr-x. 14 root root 166 Aug 17 17:08 usr
drwxr-xr-x. 19 root root 267 Aug 16 17:07 var

Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221650793
Server version: 5.7.25 OceanBase 3.1.4 (r10000092022071511-b4bfa011ceaef428782dcb65ae89190c40b78c2f) (Built Jul 15 2022 11:45:14)

Copyright (c) 2000, 2022, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [(none)]> use ly;
ERROR 1049 (42000): Unknown database
obclient [(none)]> use tp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
obclient [tp]> load data infile ‘/opt/part.tbl’ into table PART fields terminated by “|”;
ERROR 4016 (HY000): Internal error
obclient [tp]>

这个跟之前改了secure后报错一样
obclient [tp]> set global secure_file_priv = ‘/opt’;
Query OK, 0 rows affected (0.211 sec)

obclient [tp]> load data infile ‘/opt/part.tbl’ into table PART fields terminated by “|”;
ERROR 4016 (HY000): Internal error

#27

set global一定要重启session吖， 另外你就别在系统路径下试了，就随便admin的主目录用个小case试下

#28

日志等级你用 show parameters like “%syslog_level%”;查看下等级，估计不是INFO，如果不是用alter system set syslog_level = ‘INFO’;改下，改高等级的日志的确是会一直输出各种内部运行的组件日志

1 个赞
#29

确实是info的,我另外开个帖子贴一下日志
obclient [(none)]> show parameters like ‘%syslog_level%’
→ ;
±------±---------±-------------±---------±-------------±----------±------±-----------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level |
±------±---------±-------------±---------±-------------±----------±------±-----------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------+
| zone1 | observer | 192.168.0.48 | 2882 | syslog_level | NULL | INFO | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone1 | observer | 192.168.0.49 | 2882 | syslog_level | NULL | INFO | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone1 | observer | 192.168.0.67 | 2882 | syslog_level | NULL | INFO | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
±------±---------±-------------±---------±-------------±----------±------±-----------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------+
3 rows in set (0.095 sec)